It is more faster and easier to pass the Oracle 1Z0-058 exam by using 100% Correct Oracle Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure questuins and answers. Immediate access to the Refresh 1Z0-058 Exam and find the same core area 1Z0-058 questions with professionally verified answers, then PASS your exam with a high score now.

♥♥ 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

Free Instant Download NEW 1Z0-058 Exam Dumps (PDF & VCE):
Available on:

Q11. Which two statements are true regarding the Active Session History (ASH) reports for RAC? 

A. They provide details about Oracle databases for all current sessions, and history of past session all RAC nodes. 

B. They provide statistics about Oracle databases for the active sessions on all the RAC nodes. 

C. They report on data captured for active sessions. The volume of data is directly related to the work being performed by sessions. 

D. They report on data captured for active sessions. The volume of data is directly related to the number of sessions on the system. 

Answer: A,C 

Explanation: ASH report statistics provide details about Oracle Database session activity. Oracle Database records information about active sessions for all active Oracle RAC instances and stores this data in the System Global Area (SGA). Any session that is connected to the database and using CPU is considered an active session. The exception to this is sessions that are waiting for an event that belongs to the idle wait class. ASH reports present a manageable set of data by capturing only information about active sessions. The amount of the data is directly related to the work being performed, rather than the number of sessions allowed on the system. 

Oracle Real Application Clusters Administration and Deployment Guide 

Q12. Which three predefined database-type templates already include the data files when creating an Oracle Cluster database? 

A. General Purpose 

B. Transaction Processing 

C. Custom Database 

D. Data Warehouse 

E. OLAP Database 

Answer: A,B,D 


Creating an Oracle RAC Database with DBCA Oracle ships templates for the following two workload types: General purpose or transaction processing Data warehouse For more complex environments, you can select the Custom Database option. This option does not use templates and results in a more extensive interview, which means that it takes longer to create your database. 

Oracle. Real Application Clusters Installation Guide 11g Release 2 (11.2) for Linux and UNIX 

Q13. In an ASM instance, there are several parameters that have meanings specific to the ASM. Which parameter is mandatory? 








Explanation: Oracle ASM Parameter Setting Recommendations 


Oracle. Automatic Storage Management Administrator's Guide 

Q14. From a command line, you can create an ASM volume with the same properties by using either SQL or ASMCMD. Which two commands will create a 500 MB volume called TESTVOL in the ACFSDG ACFS diskgroup by storing only one copy of the volume file extents in the diskgroup 

A. SQL> alter diskgroup ACFSDG add volume TESTVOL size 500M unprotected; 

B. ASMCMD> volcreate -G ASMFS -s 500M 

C. SQL> alter diskgroup ACFS add volume TESTVOL size 500M; 

D. ASMCMD> volcreate -G ACFSDG -s 500M --redundancy unprotected TESTVOL 

E. SQL> create volume TESTVOL diskgroup ACFSDG size 500M unprotected; 

Answer: A,D 

Explanation: The ALTER DISKGROUP VOLUME SQL statements enable you to manage 

Oracle ADVM volumes, including the functionality to add, modify, resize, disable, enable, and drop volumes. 

You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an 

Oracle ACFS file system. 

If the volume is hosting an Oracle ACFS file system, then you cannot resize that volume with the SQL ALTER DISKGROUP statement. Instead you must use the acfsutil size command. 


Creates an Oracle ADVM volume in the specified disk group. 

Syntax and Description 

volcreate -G diskgroup -s size [ --column number ] [ --width stripe_width ] 

[--redundancy {high|mirror|unprotected} ] 

Redundancy of the Oracle ADVM volume which can be specified for normal redundancy disk groups. The range of values is as follows: unprotected for non-mirrored redundancy, mirror for double-mirrored redundancy, or high for triple-mirrored redundancy. If redundancy is not specified, the setting defaults to the redundancy level of the disk group. 

Q15. Which three describe how often OCR backups are taken and how many are retained, according to the default backup schedule? 

A. every 12 hours and the Clusterware keeps the last four copies 

B. every 4 hours and the Clusterware keeps the last three copies 

C. every day and the Clusterware keeps the last two copies 

D. every day and the Clusterware keeps the last three copies 

E. every week and the Clusterware keeps the last two copies 

Answer: B,C,E 


Locating the OCR Automatic Backups 

The OCR is backed up automatically. 

Only one node performs the backup. 

To determine the node and location of the backup: 

$ ocrconfig -showbackup auto 

host02 2009/07/28 12:20:42 /u01/app/.../cdata/cluster01/backup00.ocr 

host02 2009/07/28 08:20:41 /u01/app/.../cdata/cluster01/backup01.ocr 

host02 2009/07/28 04:20:40 /u01/app/.../cdata/cluster01/backup02.ocr 

host02 2009/07/27 16:20:37 /u01/app/.../cdata/cluster01/day.ocr 

host02 2009/07/28 00:20:39 /u01/app/.../cdata/cluster01/week.ocr 

Files could be spread across nodes due to outages. 

The backup frequency and retention policies are: 

– Every four hours: CRS keeps the last three copies. 

– At the end of every day: CRS keeps the last two copies. 

– At the end of every week: CRS keeps the last two copies. 

D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 3 - 11 

Q16. Your cluster was originally created with nodes RACNODE1 and RACNODE2 three years ago. Last year, nodes RACNODE3 and RACNODE4 were added. 

These nodes have faster processors and more local storage than the original nodes making performance management and tuning more difficult. 

Two more nodes with the same processor speed have been added to the cluster last week as RACNODE5 and RACNODE6 and you must remove RACNODE1 and RACNODE2 for redeployment. 

The Oracle Grid Infrastructure is using GNS and the databases are all 11g Release 2, all running from the same home. The Grid home is /fs01/home/grid. 

Which three steps must be performed to remove the nodes from the cluster? 

A. Run /fs01/home/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/fs01/home/grid "CLUSTER_NODES= {RACNODE3 , RACNODE4 , 



as the grid software owner on any remaining node. 

B. Run /fs01/home/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/fs01/home/grid " CLUSTER_NODES={RACNODE1} as the grid software owner on RACNODE1 and run /fs01/home/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/ fs01/home/grid " CLUSTER_NODES={RACNODE 2} as the grid software owner on RACNODE2. 

C. Run /fs01/home/grid/oui/bin/runInstaller -detachHome ORACLE_HOME=/fs01/home/grid as the grid software owner on RACNODE1 and RACNODE2. 

D. Run the /fs01/home/grid/crs/install/ script as root on each node to be deleted. 

E. Run crsctl delete node -n RACNODE1 and crsctl delete node -n RACNODE2 as root from any node remaining in the cluster. 

Answer: A,D,E 


Deleting a Cluster Node on Linux and UNIX Systems 

1. Ensure that Grid_home correctly specifies the full directory path for the Oracle Clusterware home on each node, where Grid_home is the location of the installed Oracle Clusterware software. 

2. Run the following command as either root or the user that installed Oracle Clusterware to determine whether the node you want to delete is active and whether it is pinned: $ olsnodes -s -t If the node is pinned, then run the crsctl unpin css command. Otherwise, proceed to the next step. 

3. Disable the Oracle Clusterware applications and daemons running on the node. Run the script as root from the Grid_home/crs/install directory on the node to be deleted, as follows: # ./ -deconfig -deinstall -force If you are deleting multiple nodes, then run the script on each node that you are deleting. If you are deleting all nodes from a cluster, then append the -lastnode option to the preceding command to clear OCR and the voting disks, as follows: # ./ -deconfig -deinstall -force -lastnode 

4. From any node that you are not deleting, run the following command from the 

Grid_home/bin directory as root to delete the node from the cluster: 

# crsctl delete node -n node_to_be_deleted 

Then if you run a dynamic Grid Plug and Play cluster using DHCP and GNS, skip to step 7. 

5. On the node you want to delete, run the following command as the user that installed 

Oracle Clusterware from the Grid_home/oui/bin directory where node_to_be_deleted is the 

name of the node that you are deleting: 

$ ./runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES= 

{node_to_be_deleted}" CRS=TRUE -silent -local 

6. On the node that you are deleting, depending on whether you have a shared or local 

Oracle home, complete one of the following procedures as the user that installed Oracle 


If you have a shared home, then run the following command from the Grid_home/oui/bin directory on the node you want to delete: 

$ ./runInstaller -detachHome ORACLE_HOME=Grid_home -silent -local 

For a local home, deinstall the Oracle Clusterware home from the node that you want to delete, as follows, by running the following command, where Grid_home is the path defined for the Oracle Clusterware home: 

$ Grid_home/deinstall/deinstall –local 

7. On any node other than the node you are deleting, run the following command from the 

Grid_home/oui/bin directory where remaining_nodes_list is a comma-delimited list of the 

nodes that are going to remain part of your cluster: 

$ ./runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES= 

{remaining_nodes_list}" CRS=TRUE -silent 

8. Run the following CVU command to verify that the specified nodes have been 

successfully deleted from the cluster: 

$ cluvfy stage -post nodedel -n node_list [-verbose] 

Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2) 

Q17. Under which account(s) can the Oracle Clusterware processes run for the Linux platform? 

A. only the root account 

B. only the Grid Infrastructure owner account 

C. only the database software owner account 

D. some under the Grid Infrastructure owner account and some under the root account 

E. some under the database software owner account and some under the root account 


Explanation: Because Oracle Clusterware works closely with the operating system, system administrator privileges are required for some installation tasks. In addition, some Oracle Clusterware processes must run as the special operating system user, root. 

Oracle Database 2 Day + Real Application Clusters Guide 

Q18. You notice that there is a very high percentage of wait time for the gc current split event in your RAC database that has frequent insert operations. 

Which two recommendation would you make to reduce this problem? 

A. shorter transactions 

B. using hash partitioned global indexes 

C. uniform and large extent sizes 

D. automatic segment space management 

E. smaller extent sizes 

F. increasing sequence cache sizes 

Answer: D,F 

Q19. A Grid Plug and Play (GPnP) software image must contain at least three items. Which three items are required? 

A. operating system software 

B. Oracle Database software 

C. GPnP software 

D. security certificate of the provisioning authority 

E. application software 

Answer: A,C,D 


GPnP Components 

Software image 

A software image is a read-only collection of software to berun on nodes of the same type. 

At a minimum, the image must contain: 

-An operating system 

-The GPnP software 

-A security certificate from the provisioning authority 

-Other software required to configure the node when it starts up 

D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration 

Q20. Which are the key factors that you should consider before converting a single-Instance database Oracle Real Application Cluster (RAC) database to guarantee a successful media recovery? 

A. If the database is in archive log mode, the archive file format requires a thread number. 

B. The archive logs from all nodes must be accessible to all nodes in the cluster database. 

C. The storage option must be Automatic Storage Management (ASM). 

D. All database files must be migrated to Oracle Managed Files (OMF). 

Answer: A,B 


Issues for Converting Single Instance Databases to Oracle RAC 

Backup procedures should be available before conversion takes place. 

Archiving in Oracle RAC environments requires a thread number in the archive file format. 

The archived logs from all instances of an Oracle RAC database are required for media recovery. 

By default, all database files are migrated to Oracle Managed Files (OMF). 


Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 11 - 24