Oracle Real Application Clusters 11g Essentials
Question No: 31
Which two answers are correct with respect to Oracle cluslerware configuration files and their purpose?
OCR records the cluster configuration.
OCR records the number of instances.
OCR records the number of databases.
A voting disk records the node membership information.
A voting disk records the cluster configuration.
A voting disk records the number of instances.
Explanation: Oracle Clusterware requires two configuration files: a voting disk to record node membership information and the OCR to record cluster configuration information.
Reference: Oracle Clusterware Administration and Deployment Guide
Question No: 32
Which three types of files can be stored in Oracle ASM without extending it with ACFS?
Oracle clusterware binaries
Operating system files
Explanation: * ASM supports most file types required by the database. However, you cannot store some administrative file types on ASM disk groups. These include trace files (not E) , audit files, alert logs, export files, tar files, operating system files (not F), and core files (not C).
File Types Supported by Automatic Storage Management: Control files
Datafiles Redo log files
Archive log files emporary files
Datafile backup pieces
Datafile incremental backup pieces Archive log backup piece
Persistent initialization parameter file (SPFILE) Disaster recovery configurations
Change tracking file Data Pump dumpset
Automatically generated control file backup Cross-platform transportable datafiles
Question No: 33
Is not a valid option for configuring redundancy for ASM disk groups?
Explanation: There are three types of disk groups based on the ASM redundancy level. he redundancy levels are:
ASM does not provide mirroring redundancy and relies on the storage system to provide RAID functionality. Any write error cause a forced dismount of the disk group. All disks must be located to successfully mount the disk group.
ASM provides two-way mirroring. By default all files are mirrored so that there are two copies of every data extent. A loss of one ASM disk is tolerated.
ASM provides triple mirroring by default. A loss of two ASM disks in different failure groups is tolerated.
Reference: Oracle Database Storage Administrator#39;s Guide, ASM Mirroring and Disk Group Redundancy
Question No: 34
Which command lists all the service-related information for the specified service? (crmdb is the cluster database name and crms is the service name)
#crsctl config services -d cmdb -s crms
#srvctl config service -d cmdb -s crms
#srvctl getenv service -d crmdb -s crms
#crsctl status service -d crm -s crm -v
Answer: B Explanation:
The srvctl config command displays the Oracle Restart configuration of the specified component or set of components.
srvctl config service
For the specified database, displays the Oracle Restart configuration information for the specified database service or for all database services
Incorrect: Not C: getenv
Gets and displays environment variables and their values from the Oracle Restart configuration for a database, listener, or Oracle ASM instance.
srvctl getenv Summary CommandDescription
srvctl getenv asm
Displays the configured environment variables for the Oracle ASM instance
srvctl getenv database
Displays the configured environment variables for the specified database instance
srvctl getenv listener
Displays the configured environment variables for the specified listener Reference: SRVCTL Command Reference for Oracle Restart
Question No: 35
What command would you use to write- the OCR content from the subtree of the key SYSTEM to stdout?
ocrdump SYSTEM -stdout
ocrdump -stdout SYSTEM
ocrdump -stdout -keyname SYSTEM
ocrdump -stdout -xml
Explanation: Run the ocrdump command with the following syntax where filename is the name of a target file to which you want Oracle Database to write the OCR output and where keyname is the name of a key from which you want Oracle Database to write OCR subtree content:
ocrdump [file_name|-stdout] [-backupfile backup_file_name] [-keyname keyname] [-xml] [- noheader]
Reference: OCRDUMP Utility Syntax and Options
Question No: 36
Which two options are true regarding Grid Naming Service (GNS)?
GNS daemon runs only on one node in the cluster at a time
GNS replaces DNS
GNS replaces all VIPs
GNS requires DHCP
GNS is not managed by Clusterware
Answer: A,D Explanation:
A: Oracle Clusterware Daemon (CRSD)
CRS daemon (Oracle Cluster Ready Services Daemon) internode connection. The port
number is assigned automatically during installation. You cannot view or modify it afterward.
This port is used exclusively with the cluster interconnect.
D: To set up an Oracle 11g R2 RAC installation using Oracle Grid Naming Services (GNS) the following requirements need to be met:
At least two interfaces configured on each node, one for the private IP address and one for the public IP address.
A Domain Naming Server (DNS) running in the network for the address resolution of the GNS virtual IP address and hostname.
The DNS entry to configure the GNS sub-domain delegation
A DHCP server running on the same public network as your Oracle RAC cluster.
Within the subdomain, the GNS uses multicast Domain Name Service (mDNS) (not B), included with Oracle Clusterware (not E), to enable the cluster to map host names and IP addresses dynamically as nodes are added and removed from the cluster, without requiring additional host configuration in the DNS.
Question No: 37
You are setting up IP addresses for your Oracle Clusterware-based cluster. Which two types of IP addresses should be registered with DNS?
Public IP address
Private IP address
Storage IP address
Explanation: In an Oracle Clusterware configuration, there must be a minimum of two network connections. One connection is for the public network interface on which users and application servers connect to access data on the database server, and the other connection is for the private network interface between the nodes in the cluster.
Reference: Oracle Clusterware Administration and Deployment Guide
Question No: 38
Which statement about RAC services is correct?
SYS$BACKGROUND and SYS$USERS are external services.
Internal services can be deleted.
Services are logical abstractions for managing workloads in Oracle Database.
Every service has N-2 cluster resources (where N is the number of RAC instances).
Explanation: A service is a logical grouping of sessions performing similar kind of work. They enable you to group database workloads and route work to the optimal instances that are assigned to offer the service.It is recommended that all the users who connect using a service have the same service-level requirements. We can use services to manage workloads or a group of applications. For example , all on-line users can use one service whereas batch users can use another service and reporting can use yet another service.
Question No: 39
Which two statements are true regarding the functionality of the remap command in ASMCMD?
It repairs blocks by always reading them from the mirror copy and writing them to the original location.
It repairs blocks that have read disk I/O errors.
It checks whether the alias metadata directory and the- file directory are linked correctly.
It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Answer: B,D Explanation: * remap
Marks a range of blocks as unusable on the disk and relocates any data allocated in that range.
* remap Command
The remap command only relocates blocks. It does not correct or repair blocks that contain corrupted contents. The command uses a physical block size based on the SECTOR_SIZE disk group attribute.
Repairs a range of physical blocks on a disk. The remap command only repairs blocks that have read disk I/O errors. It does not repair blocks that contain corrupted contents, whether or not those blocks can be read. The command assumes a physical block size of 512 bytes and supports all allocation unit sizes (1 to 64 MB).
Question No: 40
Which three statements are correct about the Oracle local Registry?
OLR is Installed and configured when Oracle Clusterware Installs OCR.
OLR was introduced in Oracle Database 11g Release 1.
OLR is located at Grid _home/cdata/hostname.olr on each node.
OLR can reside on a maximum of three nodes in the cluster.
You can manage OLR using the ocrcheck, ocrdump, and ocrconfig utilities with the
Explanation: C: The olr.loc file consist of the OLR config file location and the crs_home location.
So, by default the location is , olrconfig_loc =lt;GRID_HOMEgt;/cdata/lt;hostnamegt;.olr. E: Examples:
To manually back up OLR:
# ocrconfig -local -manualbackup
To view the contents of the OLR backup file: ocrdump -local -backupfile olr_backup_file_name To change the OLR backup location:
ocrconfig -local -backuploc new_olr_backup_path To restore OLR:
# crsctl stop crs
# ocrconfig -local -restore file_name
# ocrcheck -local
# crsctl start crs
$ cluvfy comp olr
Not B: From 11gR2 Oracle introduced “Oracle Local Registry(OLR)”, something new as part of Oracle Clusterware
Reference: Oracle Local Registry (OLR) – 11gR2
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|