1Z0-048 - Oracle Database 10g R2: Real Application Clusters for Administrators
Go back to Oracle
You are considering issues involving backup and recovery of the voting disk. Select four correct statements. (Choose four.)
Backup can be performed online.
Use symbolic links to simplify recovery of the voting disk.
If you lose your voting disk and do not have a backup, you must reinstall Oracle Clusterware.
You can determine the voting disks currently used by CSS with the command crsctl query css votedisk.
Which three statements regarding backup of the voting disk are true? (Choose three.)
On UNIX platforms, the voting disk can be backed up with the dd command.
A backup of the voting disk should be taken whenever a new node is added to the cluster.
A backup of the voting disk should be taken whenever an existing node is removed from the cluster.
After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk. Which are the two ways in which you can accomplish this task? (Choose two.)
You can add additional voting disks online.
You may use the command: crsctl add css votedisk <new voting disk path>
When do you get the first notification after you execute the following command on instance RDBA1? exec DBMS_SERVER_ALERT.SET_THRESHOLD(- METRICS_ID => dbms_server_alert.elapsed_time_per_call, WARNING_OPERATOR => dbms_server_alert.operator_ge, WARNING_VALUE => '500000', CRITICAL_OPERATOR => dbms_server_alert.operator_ge, CRITICAL_VALUE => '750000', OBSERVATION_PERIOD => 15, CONSECUTIVE_OCCURRENCES => 3, INSTANCE_NAME => 'RDBA1', OBJECT_TYPE => dbms_server_alert.object_type_service, OBJECT_NAME => 'ERP');
when the average elapsed time per call for the ERP service over a 15-minute period exceeds 0.5 seconds three consecutive times
After the cluster database has been successfully created, several postinstallation tasks should be completed. Identify three of them. (Choose three.)
Back up the root.sh script.
Set up additional required user accounts.
Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config database -d db_name.
You are working as a DBA in a RAC environment that is available for testing. The RAC environment has all the database files stored in the OCFS file system. You plan to install ASM and move all the database files to ASM to achieve better performance. During the installation, you selected redundancy level as normal for the disk group being added. What is the reason for selecting this redundancy level?
You have two failure groups defined, so you want to use two-way mirroring.
Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize the access to available listeners?
Oracle Cluster Registry (OCR) can be recovered on a UNIX platform using which two commands? (Choose two.)
ocrconfig -import /u01/logical_ocr/yesterday.ocr_exp where yesterday.ocr_exp is a logical backup created using the ocrconfig -export command
ocrconfig -restore /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr where day.ocr is an automatically generated OCR backup
You are asked to investigate a problem regarding client connectivity between the HR service and a database, which is on a four-node RAC cluster. The HR service has four preferred instances on the RAC cluster. This cluster also supports five other services. Occasionally, a client-connect request for the HR service takes several minutes to connect, whereas the other five services connect within a second or two. Client-side and server-side connection load balancing are used for all the services. Which combination of network settings would explain these symptoms? (Choose two.)
The TNSNAMES.ORA file has an entry for the five other services that use the hostnames for the Virtual IP addresses and all the listeners listen on both the Public and Virtual IP addresses.
The TNSNAMES.ORA file has an entry for the HR service that uses only the host name for the public IP address, and all the listeners listen on both the Public and Virtual IP addresses.
Which three storage types are suitable as a flash recovery area for an Oracle 10g RAC database? (Choose three.)
ASM disk group
Cluster file system
Shared NFS directory
Which initialization parameter would you use for each RAC instance to make sure that each listener on each RAC node is aware of the load of all the others?
You are creating a database in your RAC implementation. You are using the DBCA to create the database, and you selected the Raw Devices Mapping file on one of the screens of the DBCA. What is the reason for selecting this file?
You want to set the appropriate raw partition for each database file.
Several steps must be followed to successfully add a new node to your cluster database. Assuming that a UNIX platform is used, which of the three steps below are correct? (Choose three.)
Reconfigure listeners for the new node with netca.
Configure the OS and hardware for the new node.
Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME.
In a RAC environment, you see a steep increase for enq:HW - contention and gc current grant wait events. What would you do to fix this issue?
Use larger uniform extent sizes for objects.