we provide Practical Oracle 1Z0-058 exam engine which are the best for clearing 1Z0-058 test, and to get certified by Oracle Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure. The 1Z0-058 Questions & Answers covers all the knowledge points of the real 1Z0-058 exam. Crack your Oracle 1Z0-058 Exam with latest dumps, guaranteed!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-058 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q1. Your production environment cluster is running Oracle Enterprise Linux and currently has four nodes. You are asked to plan for extending the cluster to six nodes. Which three methods are available to add the new nodes?
A. silent cloning using crsctl clone cluster and ssh
B. a GUI interface from Enterprise Manager
C. with the Oracle Universal Installer using runInstaller –clone <nodename>
D. silent cloning using perl clone.pl–silent either with parameters in a file or in line
E. using addNode.sh
Login to the Enterprise Manager Grid Control Console. Click on the "Deployments" tab. Under the "Deployments" --> "General" --> "Cloning" section, click on "Clone Oracle Home". "Clone Oracle Home: Source Home".page allows us to select the Oracle Home we want to clone. Once the selection has been made, click on "Next" to proceed. You can also use cloning to add nodes to a cluster. Prepare Node 2. Run the clone.pl script located in the Grid_home/clone/bin directory on Node 2. To set up the new Oracle Clusterware environment, the clone.pl script requires you to provide several setup values for the script. You can provide the variable values by either supplying input on the command line when you run the clone.pl script, or by creating a file in which you can assign values to the cloning variables.
. To extend the Grid Infrastructure home to the node3, navigate to the Grid_home/oui/bin directory on node1 and run the addNode.sh script
Q2. Which three steps must be completed to configure Fast Connection Failover for the CRM service with an Oracle Call Interface client?
A. Ensure that the CRM service has Advanced Queuing notifications enabled by setting the services values of AQ_HA_NOTIFICATIONS to TRUE.
$ srvctl modify service -d crm -s gl.us.oracle. com \
-q TRUE -P BASIC -e SELECT -z 180 -w 5 -j LONG
B. Enable OCI_EVEINTS on the client at environment creation time by using the
C. Use Oracle Call Interface to configure UP events for the service.
D. Client applications must be linked with the client thread or operating system library.
Configuring FCF for OCI Clients OCI applications must connect to an Oracle RAC instance to enable HA event notification. Furthermore, these applications must perform the following steps to configure FCF for an OCI client: Configure the service for your OCI connection pool to enable connection load balancing and runtime connection load balancing. Also configure the service to have Advanced Queuing notifications enabled, as shown in the following example: $ srvctl modify service -d crm -s ociapp.example.com -q TRUE -B THROUGHPUT -j LONG Set the context of the environment for OCI calls on the client to enable subscriptions by using the OCIEnvCreate() call, setting the MODE parameter value to OCI_EVENTS, as follows: (void) OCIEnvCreate(&myenvhp, OCI_EVENTS|OCI_OBJECT, ...); Link the application with a thread library. After linking with the thread library, the applications can register a callback that is invoked whenever a FAN event occurs.
Oracle. Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)
Q3. Which two conditions are required by the ASM fast mirror resynchronization to track block changes for a set period of time before dropping the disk from the disk group?
A. Redundancy is normal or high.
B. compatibility. rdbms is set to a value of at least 11. l.
C. disk_repair_time is set to a nondefault value.
D. block_change_tracking IS enabled.
E. db_block_checking is enabled.
F. resumable_timeout is set to a nondefault value.
ASM Fast Mirror Resync Enabled when COMPATIBLE.RDBMS >= 11.1 Whenever ASM is unable to write an extent, ASM takes the associated disk offline. If the corresponding disk group uses ASM mirroring (NORMAL or HIGH redundancy), at least one mirror copy of the same extent exists on another disk in the disk group. Before Oracle Database 11g, ASM assumed that an offline disk contains only stale data and no longer reads from such disks. Shortly after a disk is put offline, ASM drops it from the disk group by re-creating the extents allocated to the disk on the remaining disks in the disk group using mirrored extent copies. This process is quite resource intensive and can take hours to complete. If the disk is replaced or the failure is repaired, the disk must be added again and another rebalance operation must take place.
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 8 - 32
Q4. Which command will resize an ACFS file system on the DATA diskgroup?
-The ADVM volume is named VOL1.
-The mount point is >/u01/app/oracle/afsmounts/vol1.
-The new, larger size is 20G.
A. ASMCMD [+] > volsize -G data -s 20G VOL1
B. /sbin/acfsutil size 20G /u01/app/oracle/afsmounts/vol1
C. SQL> ALTER DISKGROUP data RESIZE VOLUME vol1 SIZE 20G;
D. None, an ACFS file system cannot be resized.
E. fsadm /u0l/app/orlacle/afsmounts/vol1 20G
acfsutil size Purpose Resizes an Oracle ACFS file system. Syntax and Description acfsutil size -h acfsutil size [+|-]n[K|M|G|T|P ] [device] mount_point acfsutil size -h displays help text and exits. Oracle. Automatic Storage Management Administrator's Guide 11g Release 2 (11.2) ALTER DISKGROUP RESIZE VOLUME Clause Use this clause to change the size of an existing Oracle ADVM volume. In an Oracle ASM cluster, the new size is propagated to all nodes. If an Oracle Automatic Storage Management File System (ACFS) exists on the volume, then you must use the acfsutil size command instead of the ALTER DISKGROUP statement.
Oracle. Database SQL Language Reference 11g Release 2 (11.2)
Q5. You are creating a resource definition called WEBAPP for a web-based application that requires an application called WEBVIP.
Both WEBVIP and WEBAPP are normally active on a single node, but may fail over if required to another cluster node in your eight-node cluster.
A second VIP application resource called appsvip exists, used by a second application resource called secapp. webvip and webapp must start In the correct sequence.
Which two start dependencies would you use for the WEBAPP application resource definition?
C. pullup (WEBVIP)
F. weak (WEBVIP)
Start Dependencies hard Define a hard start dependency for a resource if another resource must be running before the dependent resource can start. For example, if resource A has a hard start dependency on resource B, then resource B must be running before resource A can start. Note: Oracle recommends that resources with hard start dependencies also have pullup start dependencies. weak If resource A has a weak start dependency on resource B, then an attempt to start resource A attempts to start resource B, if resource B is not running. The result of the attempt to start resource B is, however, of no consequence to the result of starting resource A. attraction If resource A has an attraction dependency on resource B, then Oracle Clusterware prefers to place resource A on servers hosting resource B. Dependent resources, such as resource A in this case, are more likely to run on servers on which resources to which they have attraction dependencies are running. Oracle Clusterware places dependent resources on servers with resources to which they are attracted. pullup Use the pullup start dependency if resource A must automatically start whenever resource B starts. This dependency only affects resource A if it is not running. As is the case for other dependencies, pullup may cause the dependent resource to start on any server. Use the pullup dependency whenever there is a hard stop dependency, so that if resource A depends on resource B and resource B fails and then recovers, then resource A is restarted. dispersion If you specify the dispersion start dependency for a resource, then Oracle Clusterware starts this resource on a server that has the fewest number of resources to which this resource has dispersion. Resources with dispersion may still end up running on the same server if there are not enough servers to disperse them to. Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q6. You have configured your eight-node cluster to use GNS. The network administrator has established delegated subdomain for the Custer which is MYCLUSTER.EXAMPLE.COM.
DHCP has been configured so that the cluster now manages IP addresses within the cluster.
Select three responses that describe the VIPs that will exist in this configuration.
A. 3 GNS VIPs
B. 8 Node VIPs
C. 3 SCAN VIPs
D. 1 GNS VIP
E. 3 Node VIPs
Explanation: Implementing GNS
If you use GNS, then you must specify a static IP address for the GNS VIP address, and delegate a subdomain to be delegated to that static GNS VIP address.
Dynamic IP address assignment using Oracle Grid Naming Service (GNS)
If you select this option, then network administrators assign static IP address for the physical host name and dynamically allocated IPs for the Oracle Clusterware managed VIP addresses. In this case, IP addresses for the VIPs are assigned by a DHCP and resolved using a multicast domain name server configured as part of Oracle Clusterware within the cluster. If you plan to use GNS, then you must have the following:
. A DHCP service running on the public network for the cluster
. Enough addresses on the DHCP to provide 1 IP address for each node's virtual IP, and 3 IP addresses for the cluster used by the Single Client Access Name (SCAN) for the cluster Oracle Grid Infrastructure Installation Guide
Q7. You are managing a three-instance Oracle RAC database which uses a Cluster File System for shared storage.
Which two options can you use to ensure that the redo logs from all the instances are available during RMAN recovery from any instance?
A. Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for each of the three instances and leave the LOG_ARCHIVE_FORMAT parameter with the default value.
B. Set only the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for any one of the three instances and leave the LOG_ARCHIVE_FORMAT parameter with the default value.
C. Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for each of the three instances, and the LOG_ARCHIVE_FORMAT parameter for each instance, to the same format including the thread number.
D. Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System, and set LOG_ARCHIVE_FORMAT parameter on only one instance.
Initialization Parameter Settings for the Cluster File System Archiving Scheme In the cluster file system scheme, each node archives to a directory that is identified with the same name on all instances within the cluster database (/arc_dest, in the following example). To configure this directory, set values for the LOG_ARCH_DEST_1 parameter, as shown in the following example:
*.LOG_ARCHIVE_DEST_1="LOCATION=/arc_dest" Archived Redo Log File Conventions in Oracle RAC For any archived redo log configuration, uniquely identify the archived redo logs with the LOG_ARCHIVE_FORMAT parameter. The format of this parameter is operating system-specific and it can include text strings, one or more variables, and a filename extension. Use the %R or %r parameters to include the resetlogs identifier to avoid overwriting the logs from a previous incarnation. If you do not specify a log format, then the default is operating system-specific and includes %t, % s, and %r.
Oracle. Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)
Q8. The Instance Initialization parameters are set to:
DB_CREATE_FILE_DEST = +DATA
DB_CREATE_ONLlNE_LOG_DEST_l = +LOGS
DB_CREATE_ONLlNE_LOG_DEST_2 = + FRA
The SQL* Plus command “ALTER DATABASE ADD LOGFILE;” will create:
A. a new log file in the +DATA disk group, or a log file in the + FRA disk group, if +DATA is not available
B. a new log file in the +DATA disk group and a log file in the + FRA disk group
C. a new log file in the +LOGS disk group and a log file in the + FRA disk group
D. a new log file in the +LOGS disk group, or a log file in the +FRA dls* available
E. a new log file in the +DATA disk group, a log file in the +LOGS disk group, and a log file in the +FRA disk group
F. a new log file in the +LOGS disk group, or a log file in the +FRA disk group, if +LOGS is not available
Explanation: The following table lists the initialization parameters that enable the use of Oracle Managed Files.
Initialization Parameter DB_CREATE_FILE_DEST
Defines the location of the default file system directory or Oracle ASM disk group where the database creates datafiles or tempfiles when no file specification is given in the create operation. Also used as the default location for redo log and control files if DB_CREATE_ONLINE_LOG_DEST_n are not specified.
Defines the location of the default file system directory or Oracle ASM disk group for redo log files and control file creation when no file specification is given in the create operation. By changing n, you can use this initialization parameter multiple times, where n specifies a multiplexed copy of the redo log or control file. You can specify up to five multiplexed copies.
Defines the location of the Fast Recovery Area, which is the default file system directory or Oracle ASM disk group where the database creates RMAN backups when no format option is used, archived logs when no other local destination is configured, and flashback logs. Also used as the default location for redo log and control files or multiplexed copies of redo log and control files if DB_CREATE_ONLINE_LOG_DEST_n are not specified.
Oracle. Database Administrator's Guide
Q9. Which three statements are true about cluster (OCR) and local registries (OLR)?
A. The ocrdump command can be used to dump the contents of either the cluster registry (OCR) or the local registry (OLR).
B. Information in the OCR is organized by keys that are associated with privileges. Therefore, the root user will see more information when using ocrdump than the grid user.
C. After the cluster is created, the size of the OCR is static unless the Clusterware software Is upgraded.
D. The ocrdump command can be used to dump information for a single OCR key.
. This section explains how to use the OCRDUMP utility to view OCR and Oracle Local Registry (OLR) content for troubleshooting. The OCRDUMP utility enables you to view OCR and OLR contents by writing the content to a file or stdout in a readable format.
You can use several options for OCRDUMP. For example, you can limit the output to a key and its descendents. You can also write the contents to an XML file that you can view using a browser. OCRDUMP writes the OCR keys as ASCII strings and values in a data type format. OCRDUMP retrieves header information based on a best effort basis. Displays OCR content in the terminal window in XML format ocrdump -stdout -backupfile Grid_home/cdata/cluster_name/file_name Displays the content of the in the Grid_home/cdata/ cluster_name/ file_ name directory. You must run this command as root to be able to view all of the keys.
Oracle Clusterware Administration and Deployment Guide
Q10. You have two administrator-defined server pools on your eight-node cluster called OLTP and DSS.
Hosts RACNODE3, RACNODE4, and RACNODE5 are currently assigned to the DSS Pool. Hosts RACNODE6, RACNODE7, and RACNODE8 are assigned to the OLTP Pool.
Hosts RACNODE1 and RACNODE2 are assigned to the Generic pool.
You are patching the Oracle Grid Infrastructure in a rolling fashion for your cluster and you have completed patching nodes RACNODE3, RACNODE4, RACNODE5, and RACNODE6, but you have not patched nodes RACNODE1 and RACNODE2.
While examining the status of RACNODE2 software, you get this output:
$ crsctl query crs softwareversion
Oracle Cluster-ware version on node [RACNODE2] is [22.214.171.124.0]
$ crsctl query crs activeversion
Oracle Clusterware active version on node [RACNODE2] is [126.96.36.199.0]
Which two statements describe the reasons for the active versions on the nodes of the cluster?
A. The active version is 188.8.131.52.0 on RACNODE3, RACNODE4, and RACNODE5 because all the nodes in the DSS server pool have the same installed version.
B. The active version is 184.108.40.206.0 on RACNODE6, RACNODE7, and RACNODE8 because some nodes in the cluster still have version 220.127.116.11.0 installed.
C. The active version is 18.104.22.168.0 on RACNODE6, RACNODE7, and RACNODE8 because some nodes in the OLTP Pool still have version 22.214.171.124.0 installed.
D. The active version is 126.96.36.199.0 on RACNODE3, RACNODE4, and RACNODE5 because some nodes in the cluster still have version 188.8.131.52.0 installed.
crsctl query crs softwareversion Use the crsctl query crs softwareversion command to display latest version of the software that has been successfully started on the specified node. crsctl query crs activeversion Use the crsctl query crs activeversion command to display the active version of the Oracle Clusterware software running in the cluster. During a rolling upgrade, however, the active version is not advanced until the upgrade is finished across the cluster, until which time the cluster operates at the pre-upgrade version.
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)