1Z0-058 - Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration
Go back to Oracle
The database administrator is tasked with creating an ASM disk group. Exadata is not being used. If failure groups are not specified when creating an ASM disk group containing 10 disks, how many failure groups are automatically created?
The Oracle 11g Release 2 (version 184.108.40.206) ASM instance has a new diskgroup named data that Is currently not mounted You log in to a cluster node as the Grid Infrastructure software, and set the environment variables to point to the ASM instance on that node. Using SQL*plus, you issue the commands: CONNECT / AS SYSDBA ALTER DISKGROUP DATA MOUNT; The system response is: ERROR at line 1: ORA-15032: not all alterations performed ORA-1S260: permission denied on ASM disk group How do you diagnose this error?
Check the connect string for the privileged role.
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 recommendation would you make to reduce this problem?
using hash partitioned global indexes
You are managing a single-instance database and your company wants to convert the single instance database to an Oracle RAC database. You plan to use the rconfig utility to accomplish this task. What are the prerequisites for converting the single-instance database to an Oracle RAC database?
The database being converted has been backed up successfully.
The Oracle Grid Infrastructure administrator runs ocrconfig -backupioc <new_location> after completing the installation of the Grid Infrastructure. What are the two reasons for doing this
The master node may change if the node running the master CRS daemon shuts down causing another node to become the master. Because the default location is a nonshared storage, and only the master node performs backups, the backups could be spread around on many nodes making management or recovery more difficult.
If for any reason CRS must be stopped on all nodes for a time spanning a scheduled backup, then on restart, the backup timer will be reset. This could result in longer time duration between automatic backups than the standard four-hour interval.
You have an ASM cluster and you want to terminate all the ASM instances. Assume that the database Instances supported by the ASM are already shut down. What must you know to select the appropriate command for this operation?
Are the OCR and voting disk files stored In ASM diskgroups?
Your cluster is subject to a service-level agreement that allows for little scheduled down time You want to use patching and maintenance methods that permit the Oracle Grid Infrastructure and Oracle RAT Databases to be available as much as possible. Which two techniques will work some or all of the time to provide you with minimum down time?
rolling upgradeable and out of place patch sets
rolling upgradeable and in place patch bundles
What are the default connect strings used by SQL*Plus and ASMCMD when connecting to ASM instances?
"/ as sysasm" for ASMCMD' "/" for SQL*Plus
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 Group by storing only one copy of the volume file extents in the disk group.
SQL>alter diskgroup ACFSDG add volume TESTVOL size 500M unprotected;
ASMCMD>volcreate -G ACFSDG -s 500M --redundancy unprotected TESTVOL
Your four-node cluster was originally purchased, installed, and configured three years ago. You recently added another four nodes to the cluster. Now you want to remove two of the older nodes that are still accessible to be redeployed elsewhere in the data center. Which two are true regarding the procedure for removing one or more cluster nodes?
The procedure requires that some commands be invoked on the node or nodes to be removed and that some be invoked from one surviving cluster node.
Some commands require that the name of the node or nodes to be removed are passed arguments, and some commands require the name of existing nodes to be passed
You have created four top-level server pools called OLTP, BATCH, DSS, and support for a policy- managed, eight-node cluster. The OLTP pool has two child pools called OLTP_CHILD1 and OLTP_CHILD2. Which two statements are true about sharing servers among the various server pools on your cluster?
Servers are never shared and are always mutually exclusive between top-level server pools.
Use the exclusive_pools attribute to prevent servers being shared between OLTP_CHILD1 and OLTP_CHILD2 .
You are in the planning stages for upgrading your Oracle RAC database from Oracle Database 10g Release 2 to Oracle Database 11g Release 2 to run under the Oracle Grid Infrastructure. You decide to use an administrator-managed configuration because the cluster is fairly small. Which statement is correct about this configuration?
A subpool of the GENERIC server pool will be used.
Which two statements are true regarding the Active Session History (ASH) reports for RAC?
They provide details about Oracle databases for all current sessions, and history of past session all RAC nodes.
They report on data captured for active sessions. The volume of data is directly related to the number of sessions on the system.
After Oracle Grid Infrastructure has been installed, you should take a few moments to verify the installation. Which two actions would be useful in verifying the installation?
Run the crsctl status resource t command to confirm that all necessary cluster resources are online.
Run the cluvfy comp nodecon –n all –verbose command to verify the entire Grid Infrastructure installation.
You want to reorganize the DATA diskgroup while continuing database operations. The DATA diskgroup was created using normal redundancy having one disk per failure group. The two disks used are /dev/sdal and /dev/sda2. You plan to drop the existing disks and add the /dev/sdb1 and /dev/sdb2 disks to failure group FG_C and the /dev/sdcl and /dev/sdc2 disks to failure group FG_D. Which procedure would you use to minimize the effect of the I/Os of this reorganization on ongoing database operations?
Set rebalance power to 0 for diskgroup DATA. Add failure group FG_C with all the /dev/sdb disks. Add failure group FG_D with all the /dev/sdc disks. Drop disks/dev/sda1 and /dev/sda2 Set rebalance power to 1 for diskgroup DATA.
You enter the following command: crsctl status resource MyApp You get this output: NAME=MyApp TYPE=cluster_resource TARGET=ONLINE STATE=ONLINE on RACNODE4 MyApp is a policy-managed resource using a server pool with two nodes called RACNODE3 and RACNODE4 and has a cardinality of 1. What are the meanings of the target and state status values?
MyApp is meant to be active, is currently active on RACNODE4, but the Grid Infrastructure may start MyApp on RACNODE3 due to failovers.
Which three statements are true about the management of Oracle Services?
To manage workloads or a group of applications, you can define services for a particular application or a subset of an application's operations.
Similar work can be categorized under services to ease workload management.
Oracle Enterprise Manager or srvctl should be used to control cluster-managed services, not DBMS SERVICE.
In your two-instance RAC database, you find that fast_start_mttr_target is set to 300 on both the nodes. The estd_cluster_available_time column in the v$instance_recovery view shows the value 100. What is the correct interpretation?
In the event of an instance failure, the database will become partially availableIn 100seconds.
In the event of an instance failure, the failed instance will become available In 300 seconds.
A policy-managed RAC database that hosts the ACCOUNTS service has only three instances running rather than the usual four on a six-node cluster. Five of the six cluster nodes are active and the sixth (RACNODE6) is down for maintenance. You decide to check the state of the servers In the server pools to see if there are problems with the OLTP pool to which the ACCOUNTS service has been assigned. You used the crsct1 status server -f command and see that the RACNODE3 node has STATE=VISIBLE. What is true about this situation?
The Cluster Synchronization Services Daemon (cssd) is running and RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (crsd) is currently not running.
You need to set up a three-Instance RAC database. The data files and fast recovery area will be stored in ASM diskgroups called +data and +fra, respectively. The ASM disk groups will be mounted on all ASM Instances. Which are the two best location options for archivelogs so that they can be accessed during recovery without DBA intervention?
Cluster File System with each instance writing to a shared location
the ASM diskgroup +fra with the db_recovery_file_dest parameter set to the same value on all instances
Examine the following output: [[email protected]~]$srvctl add service -d RACDB -s erp -g pool1 -c uniform -y manual [oracle0gr5153~]$srvctl start service -d RACDB -s ERP [[email protected]~]$crsctl stat res ora.racdb.erp.svc NAME=ora.racdb.erp.svc TYPE=ora.service.type TARGET=ONLINE, ONLINE, ONLINE STATE=ONLINE on gr5118, ONLINE on gr5152, ONLINE on gr5153 [[email protected]~]$ srvctl config database -d RACDB Database unique name: RACDB Database name: RACDB Oracle home:/u01/app/oracle/product/11.2.0/dbhome_1 Oracle user:oracle Spfile:+DATA/RACDB/spfileRACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: POOL 1 Database instances: Disk Groups: DATA, FRA Services: ERP Database is policy managed $srvctl stop database -d RACDB -o immediate Which two statements are true regarding the srvctl stop command?
It will shut down all the instances of the RACDB database.
It will stop the ERP service related to the RACDB database on all the nodes.
You are managing a three-instance policy-managed RAC database PROD. You created a service called GL for the PROD database by using the following command: [[email protected]~]$srvctl add service –d PROD -s GL –g SP1 -c singleton -y manual Examine the following output: [[email protected]~]$srvctl config database -d PROD -a Database unique name: PROD base name: PROD Oracle home: /u0l/app/oracle/product/11.2.0/dbhome_l cle user: oracle Spfile: +DATA/PROD/spfil6RACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: SPl Database instances: Disk Groups: DATA, FRA Services: Database is enabled Database is policy managed [[email protected]~]$crsctl stat res ora.PROD.db NAME=ora.PROD.db TYPE=cluster__resource TARGET=ONLlNE STATE=ONLINE on gr7597 ONLINE on gr7602 ONLINE on gr7633 [[email protected]~]$crsctl stat serverpool ora.SPl NAME=ora.SPl ACTIVE_SERVERS=gr7S97 gr7 602 gr7633 [[email protected]~]$crsctl NAME=ora.prod.gl.svc TYPE=ora.service - type TARGET=ONLINE STATE=ONLlNE on gr7597 Which three steps are required to enable ODP.NET clients that connect to the GL services to receive FAN High Availability Events?
Enable Advanced Queuing notifications by using SRVCTL as shown in the following command: srvctl modify service -d prod —s gl —q TRUE -j LONG
Execute the following statement for the users that will be connecting by way of the -Net Application, where user_name is the user name: EXECUTE DBMS_AQADM.GRANT_QUEUE_PRIVILEGE('DEQUEUE','SYS.SYSSSERVICE_METRICS' user_name);
Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN High Availability events. Do this by setting the HA events connection string attribute to true at connection time.
On the OUI Grid Plug and Play information page, you can configure GRID Naming Service (GNS). What will be the SCAN Name field default to if you enter cluster01 in the cluster Name field and cluster01.example.com in the GNS Sub Domain field?
Which two statements are true regarding undo management in the RAC environment?
In a policy-managed RAC database, Oracle automatically allocates the undo tablespace if the database is OMF enabled.
You can dynamically switch undo tablespace assignments by executing the undo tablespace statement from any instance in a administrator managed database.
The DBA has executed the command: srvctl add service -d PROD -s BATCH -g SP2 -c singleton -y manual What is the result of this command?
Creates a singleton service, which is only used for batch workloads for the prod database by using only server pool SP2 with a manual service management policy.
Choose three correct statements about ASM disk group attributes set from the ASMCA Create Disk Group
The field labeled ASM Compatibility sets the compatible.asm attribute.
The Database Compatibility field (compatible.rdbms) sets the minimum version level for any database instance that Is allowed to mount the disk group.
To use ADVM volumes, ADVM Compatibility (compatible.advm) must be set to 11.2.0 01 later ASM Compatibility must be 11.2.0 or later.
You want to install a database patch on your eight-node cluster by using Opatch with, the minimum amount of down time to your cluster nodes. You have already been prompted for the first set of nodes and you replied with node names RACNODE1, RACNODE2 and RACNODE3. Which two statements are true about the procedure for minimizing down time?
The instances must be started on the first set of nodes and then stopped on the remaining set to make certain that some nodes are always available.
When the first set of nodes has been patched, the administrator is prompted to shut down the instances on the remaining nodes.
You are managing RAC database with policy managed services. The database is started by using an SPFILE. Which two statements are true regarding initialization parameters In a RAC environment?
All instances in the cluster database use the same SPFILE.
To change values for initialization parameters for an instance, you must log in to that instance.
You are managing a policy-managed Real Application Cluster (RAC) database, RACDB with Oracle Managed Files (OMF) enabled. Examine the following outputs: [[email protected]]$srvctl config database -d RACDB Database unique name: RACDB Database name: RACDB Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracle Spfile: +DATA/RACDB/spfileRACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: POOL1 Database instances: Disk Groups: DATA, FRA Services: Database is policy managed SQL>SELECT * FROM v$active instances; INST NUMBER INST NAME 1 gr5118:RACDB_1 2 gr5l52:RACDB_2 3 gr5l53:RACDB_3 [[email protected]]$crsctl stat serverpool ora.POOL1 NAME_ora.POOL1 ACTIVE_SERVERS=gr5118 gr5152 gr5153 [[email protected]]$srvctl config srvpool -g POOL1 Server pool name: POOL1 Importance: 0, Min: 0, Max: 3 Candidate server names: You added a new server to the server pool using the following command: [[email protected]]$srvctl modify srvpool -cf POOL1 -i 0 -1 2 -u 4 -n gr5119 The instance on the newly added node is started by the Oracle Clusterware. Automatic Storage Management (ASM) is used as the storage option. Which statement is true regarding the redo log files for the instance?
Oracle Clusterware automatically creates and enables a new thread of red log
Which three statements are true about the logging or tracing of Java-based Oracle tools?
By default, Oracle logs actions for DBCA and DBUA.
For tools such as SRVCTL and CLUVFY, tracing can be enabled by setting srvm_trace=true your shell environment before executing the commands.
To disable tracing for Java-based tools, unset the srvmtrace variable:export srvm_trace=
You installed the Oracle Grid Infrastructure on a four-node cluster before discussing the network requirements with the network administrator who was on holiday. You created a single scan named mydb-scan.myclust.example.com by adding this name to the /etc/hosts file. As a result, the Grid Infrastructure has four node listeners and node VIP but only a single SCAN listener and SCAN VIP. The network administrator has returned and modified the corporate DNS server to associate three IP addresses with the mydb-scan.myclust.example.com scan name. The SCAN VIPs are on the same network as the node VIPs. You now must replace the single SCAN VIP and listener with three of each for high availability purposes and make certain that the SCANs and listeners are active. Which procedure will do this properly if run as the root user?
srvctl stop scan_listener srvctl stop scan srvctl remove scan srvctl add scan -n MYDB-SCAN.MYCLUST.EXAMPLE.COM
Which three statements are true about cluster (OCR) and local registries (OLR)?
The ocrdump command can be used to dump the contents of either the cluster registry (OCR) or the local registry (OLR).
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.
The ocrdump command can be used to dump information for a single OCR key.
Which two statements are true regarding the Automatic Workload Repository (AWR) In a rap environment ?
The AWR includes time model statistics based on time usage for activities displayed In the V$SYS_TIME_MODEL and V$SESS_TIHE_HODEL Views.
The MMON process gathers statistics from its' own instance and kicks off statistics collection form other instances every hour from other instances and creates an AWR snapshot which is written to the sysaux tablespace.
Some new non-ASM shared storage has been made available by the storage administrator and the Oracle Grid Infrastructure Administrator decides to move the voting disks, which do not reside in ASM, to this new non-ASM location. How can this be done?
by running crsctl replace css votedisk <path_to_old_location/path_to_new_location>
Which two statements are true about instance recovery in a RAC environment?
Increasing the size of the default buffer cache can speed up instance recovery because instance recovery may use as much as 50 percent of the default buffer cache for recovery buffers.
The fast_start_mttr_target initialization parameter specifies only the instance recovery time.
A policy-managed RAC database that hosts the ACCOUNTS service has only three instances running rather than the usual four on a six-node cluster. Five of the six cluster nodes are active and the sixth (RACNODE6) is down for maintenance. You decide to check the state of the servers in the server pools to see if there are problems with the OLTP pool to which the ACCOUNTS service has been assigned. You used the crsctl status server-f command and see that the RACNODE3 node has STATE=VISIBLE. What is true about this situation?
The Cluster Synchronization Services Daemon (cssd) is running and RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (crsd) is currently not running.
You are managing a policy-managed three-instance RAC database. You ran database ADDM for the database and noticed gc current block congested and gc cr block congested waits. What are two possible reasons for these wait events?
The wait events indicate a delay in processing has occurred in the Global Cache Services (GCS),which isusually caused by high load.
The wait times indicate that the blocks must wait after initiating a gc block request, for the round trip from the start of the wait until the blocks arrive.
Which two Cluster ware stack administration actions must be performed as the root user?
starting the Clusterware manually on one node
disabling the Clusterware from automatic start at node reboot
When creating an Oracle Cluster database using DBCA the "Memory size (SGA and PGA)" field is supplied on value of 2000 MB. Identify the default Block Size used for the database.
You are allocating space from the ASM disk group for an ADVM volume. What will be the volume extent and Volume Allocation Unit (VAU) if the stripe column is 4 and AU is 1 MB? which are the default values?
The volume extent is 64 MB and the VAU will be 256 MB.
Identify the three valid storage options for Grid Infrastructure voting disk and Install.
a certified Cluster File System (CFS)
Automatic Storage Management (ASM)
shared disk slices (block or raw devices)
Under which account(s) can the Oracle Clusterware processes run for the Linux platform?
some under the Grid Infrastructure owner account and some under the root account
Which two network addresses are required to be static, non-dhcp addresses when using the Grid Naming?
GNS VIP Address
Node Public Address
You have a four-node cluster with four node VIPS and three scan VIPS already In use after Oracle Grid Infrastructure installation. You plan to manage a customer-developed, web-based application with the Oracle Grid Infrastructure to provide high availability. Which two statements are true about the vip application resource that must be created?
The vip application must be active on the same subnet and ethernet adaptor as the public ip Address.
The vip application must be enabled to run as the root user.
Which two statements are true regarding the Average Active Sessions chart on the performance page
It shows active aggregate wait class statistics across all the instances In the cluster database.
If the Average Active Sessions chart displays a large number of sessions waiting, indicating internal contention, but the throughput is high, then the situation may be acceptable.
What does a high gc current block busy event value indicate?
Access to cached data blocks was delayed because they were busy either in the remote or the local cache.
Assume that you want to make a connection to the ERP service associated with a newly created RAC database called PROD on a cluster called cluster01 that consists of three nodes: node1, node2 and node3. Which two connect settings are correctly configured to connect to the ERP service?
ERP=(DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ERP)))
url=”jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=Cluster01-scanl)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ERP))”
Which three statements ate true about services and Transparent Application Failover (TAF)?
TAF has been configured for a service, sessions using that service fail over to a surviving instance when an outage occurs.
TAF can restart a query after failover has completed but for other statements, such as insert, update, or delete, the application must resubmit the transaction.
Services simplify the deployment of TAF because by defining a TAF policy for a service, all connections using this service will automatically have TAF enabled.
Which three statements define a cluster?
is a group of independent, but interconnected computers that act as a single system
can be deployed to increase availability and performance
can be deployed to balance a dynamically changing workload
Your two-instance RAC database is running in ARCHVELOG. The instance running on node1., fails and this failure Is ejected by the instance running on node2,which indicates the recovery process for node1. Which, process will read the redo log of the failed instance to identify the database blocks that need to be recovered during the recovery process, after the configuration of enqueue and cache part of Global resource Directory (GRD)?