Exam Code: 1Z0-058 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-058 Exam.
2021 May 1Z0-058 Study Guide Questions:
Q1. The disk groups on the current ASM instance at version 11.2 were configured to support a version 10.2 database instance. The 10.2 instance has the COMPATIBLE parameter defined as 10.2.0. The compatible.asm attribute is set to 11.2 for each disk group. The database has been upgraded to 11.2. Which statement indicates the proper time to change the compatible.rdbms disk group attribute to 11.2?
A. Change the disk group attribute after the database instance COMPATIBLE parameter is upgraded to 11.2.
B. Change the disk group attribute after the database instance is started with the 11.2 software.
C. Change the disk group attribute after the database instance optimizer_features_enabled parameter is set to 11.2.
D. Change each disk group after the 11.2 features are required for use on the disk group.
E. Never, upgrading the attribute is not reversible.
Answer: A
Explanation:
COMPATIBLE.RDBMS The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
Oracle. Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)
Q2. 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?
A. hard(SECAPP)
B. pullup(SECAPP)
C. pullup (WEBVIP)
D. hard(WEBVlP)
E. dispersion(WEBVIP)
F. weak (WEBVIP)
Answer: C,D
Explanation:
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)
Q3. 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?
A. The volume extent is 64 MB and the VAU will be 512 MB.
B. The volume extent is 64 MB and the VAU will be 256 MB.
C. The volume extent is 32 MB and the VAU will be 256 MB.
D. It is not possible to calculate these values with the given information.
Answer: B
Explanation: Stripe column and stripe width are two important attributes that can be.specified for a volume determining how space is allocated.for a volume and how space is allocated.within a volume after ACFS.or third party.file system is created.on a volume and a file is created.or extended on the file system built on that volume. Both attributes are specified.at volume creation time and cannot be changed later. If there is no value a default value is used.
. Stripe column – specifies the number of stripes a value from 1 to 8. The default is 4.
. Stripe width – specifies the size of the stripe can vary from 4K,8K,
16K,32K,64K,128K, 256K, 512K, 1M. Default is 128K. Volume Allocation Unit (VAU) is the smallest allocation for a volume. Whenever a volume is created or extended space is allocated.in multiple of VAU. VAU size is determined by the Volume Extent (VE) and the stripe column. VAU is the product of VE and the stripe column. Volume Extent is based.on the Allocation Unit (AU) specified on a disk group and for AU with size of 1MB the VE is 64MB. Whenever a VAU is allocated VE are allocated.in a round robin fashion across the disks in a disk group. Volume size is always multiple of the VAU. For example if a volume is requested.with size 200MB and stripe column is 4 and AU is 1MB one VAU with size 256MB will be allocated and the volume size will be 256MB
Down to date 1Z0-058 vce:
Q4. 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. A parent pool of the GENERIC server pool will be used.
B. You must define a new server pool called MANUAL.
C. A subpool of the GENERIC server pool will be used.
D. A subpool of the FREE server pool will be used.
Answer: C
Explanation: With Oracle RAC 11g Release 2, there is only a database resource define to Oracle Clusterware. This resource will contain the Oracle Home, the spfile, the server pool(s) and the ASM diskgroup(s) required for the database. The database resource will have a weak start dependency on the VIP which means it will try to start the VIP for the node when the instance starts however if the VIP does not start successfully, the instance will still be started. When reviewing the database resource for an administrator Managed database, you will see a server pool defined with the same name as the Oracle database. This pool will be part of a special Oracle defined server pool called Generic. The Generic server pool is managed by Oracle to support Administrator Managed databases. The server pools that are part of Generic will be automatically created or removed when you add or remove an Administrator Managed database.
Oracle Database 11gR2 Upgrade Companion (Version 2.70)
Q5. 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?
A. one
B. two
C. five
D. ten
Answer: D
Explanation: There are always failure groups even if they are not explicitly created. If you do not specify a failure group for a disk, then Oracle automatically creates a new failure group containing just that disk, except for disk groups containing disks on Oracle Exadata cells.
Oracle. Automatic Storage Management Administrator's Guide
Q6. Directory structure in ASM has a default of +<diskgroup>/<database>/<filetype>/<filename>.
The EXAMPLE tablespace was created with:
CREATE TABLESPACE EXAMPLE DATAFILE '+DATA/ORCL/oradata/example_01.dbf'
The asmcmd ls command shows:
ASMCMD>ls -l +DATA/ORCL/oradata/*
Type Redund Striped Type Sys Name
N example_01.dbf => +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623
Which three statements can be verified by from the information provided?
A. The ASM file +DATA/ORCL/oradata/example_01.dbf has an alias of +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623.
B. The ASM system file +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 has an alias of +DATA/ORCL/oradata/example_01.dbf.
C. The default path indicates that the file is an oradata file belonging to the ORCL database.
D. The default path indicates that the file is a data file belonging to the ORCL database.
E. +DATA/ORCL/oradata/example_01.dbf is the name of the file in V$DBFILE in the database instance.
F. +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 is the name of the file in V$DBFILE in the database instance.
Answer: B,D,F
Explanation:
Fully Qualified ASM File Names Every file created in ASM gets a system-generated file name, known as the fully qualified file name.
– You cannot set the fully qualified file name.
– ASM guarantees uniqueness within the ASM environment.
– The fully qualified file name is used in database views that display Oracle Database file names. D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 9 - 11
Validated 1Z0-058 braindump:
Q7. 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?
A. by running crsctl add css votedisk <path_to_new_location> followed by crsctl delete css –votedisk <path_to_old_location>
B. by running crsctl replace css votedisk <path_to_old_location,path_to_new_location>
C. by running srvctl replace css votedisk <path_to_old_location, path_to_new_location>
D. by running srvctl add css votedisk <path_to_new_location> followed by srvctl delete css votedisk <path_to_old_location>
Answer: A
Explanation:
Adding, Deleting, or Migrating Voting Disks
Modifying voting disks that are stored in Oracle ASM To migrate voting disks from Oracle ASM to an alternative storage device, specify the path to the non-Oracle ASM storage device with which you want to replace the Oracle ASM disk group using the following command: $ crsctl replace votedisk path_to_voting_disk You can run this command on any node in the cluster.
To replace all voting disks not stored in Oracle ASM with voting disks managed by Oracle ASM in an Oracle ASM disk group, run the following command: $ crsctl replace votedisk +asm_disk_group
Modifying voting disks that are not stored on Oracle ASM: To add one or more voting disks, run the following command, replacing the path_to_voting_disk variable with one or more space-delimited, complete paths to the voting disks you want to add: $ crsctl add css votedisk path_to_voting_disk [...] To replace voting disk A with voting disk B, you must add voting disk B, and then delete voting disk A. To add a new disk and remove the existing disk, run the following command, replacing the path_to_voting_diskB variable with the fully qualified path name of voting disk
B:
$ crsctl add css votedisk path_to_voting_diskB -purge
The -purge option deletes existing voting disks.
To remove a voting disk, run the following command, specifying one or more space-
delimited, voting disk FUIDs or comma-delimited directory paths to the voting disks you
want to remove:
$ crsctl delete css votedisk {FUID | path_to_voting_disk[...]}
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q8. 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.
volcreate
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.
Q9. Examine the following output:
[oracIe@gr5153 ~]$ sudo crsctl config crs CRS-4622: Oracle High Availability Services autostart is enabled. [oracIe@gr5153 ~]$ srvctl config database -d RACDB -a Database unique name: RACDB Database name: RACDB Oracle home : /u01/app/oracle/product/l11.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 enabled Database is policy managed
Oracle Clusterware is started automatically after the system boot. Which two statements are true regarding the attributes of RACDB?
A. Oracle Clusterware automatically starts RACDB.
B. You must manually start RACDB.
C. Database resource is managed by crsd for high availability and may be automatically restarted in place if it fails.
D. Database resource Is not managed by crsd for high availability and needs to be restarted manually if it fails.
Answer: A,C
Explanation:
Switch Between the Automatic and Manual Policies By default, Oracle Clusterware is configured to start the VIP, listener, instance, ASM, database services, and other resources during system boot. It is possible to modify some resources to have their profile parameter AUTO_START set to the value 2. This means that after node reboot, or when Oracle Clusterware is started, resources with AUTO_START=2 need to be started manually via srvctl. This is designed to assist in troubleshooting and system maintenance. When changing resource profiles through srvctl, the command tool automatically modifies the profile attributes of other dependent resources given the current prebuilt dependencies. The command to accomplish this is: srvctl modify database -d <dbname> -y AUTOMATIC|MANUAL
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 – 3
3.4.1 Benefits of Using Oracle Clusterware
Oracle Clusterware provides the following benefits:
Tolerates and quickly recovers from computer and instance failures.
Simplifies management and support by means of using Oracle Clusterware together with
Oracle Database.
By using fewer vendors and an all Oracle stack you gain better integration compared to using third-party clusterware.
Performs rolling upgrades for system and hardware changes. For example, you can apply
Oracle
Clusterware upgrades, patch sets, and interim patches in a rolling fashion, as follows:
Upgrade Oracle Clusterware from Oracle Database 10g to Oracle Database 11g
Upgrade Oracle Clusterware from Oracle Database release 11.1 to release 11.2
Patch Oracle Clusterware from Oracle Database 11.1.0.6 to 11.1.0.7
Patch Oracle Clusterware from Oracle Database 10.2.0.2 Bundle 1 to Oracle Database
10.2.0.2 Bundle 2
Automatically restarts failed Oracle processes.
Automatically manages the virtual IP (VIP) address so when a node fails then the node's
VIP address fails over to another node on which the VIP address can accept connections.
Automatically restarts resources from failed nodes on surviving nodes.
Controls Oracle processes as follows:
For Oracle RAC databases, Oracle Clusterware controls all Oracle processes by default.
For Oracle single-instance databases, Oracle Clusterware allows you to configure the
Oracle processes into a resource group that is under the control of Oracle Clusterware.
Provides an application programming interface (API) for Oracle and non-Oracle applications that enables you to control other Oracle processes with Oracle Clusterware, such as restart or react to failures and certain rules.
Manages node membership and prevents split-brain syndrome in which two or more instances attempt to control the database.
Provides the ability to perform rolling release upgrades of Oracle Clusterware, with no downtime for applications.
Oracle. Database High Availability Overview 11g Release 2 (11.2)
Q10. orcl1, orcl2, and orcl3 are tnsnames that connect to predefined instances of a three-instance RAC database which uses ASM for shared storage.
The database is in archivelog mode.
Examine the Exhibit for the tnsnames.ora entries for orcl1, orcl2, and orcl3.
You plan to execute the following RMAN commands to back up the database:
RUN{
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK CONNECT 'user1/pwd1@orcl1'
ALLOCATE CHANNEL CH2 DEVICE TYPE DISK CONNECT 'user2/pwd2@orcl2'
ALLOCATE CHANNEL CH3 DEVICE TYPE DISK CONNECT 'user3/pwd3@orcl3'
BACKUP DATABASE PLUS ARCHIVELOG; }
What should be the database mode on each of the three instances for this backup to succeed?
A. The database can be either mounted or open on all three instances.
B. The database must be open on all three instances.
C. The database must be open on any one instance and mounted on the other two instances.
D. The database must be mounted on any one of the instances and the other instances will be mounted automatically.
Answer: A
Explanation:
connectStringSpec Purpose Use the connectStringSpec subclause to specify the user name, password, and net service name for connecting to a target, recovery catalog, or auxiliary database. The connection is necessary to authenticate the user and identify the database. Prerequisites You must have SYSDBA privileges to CONNECT to a target or auxiliary database. Do not connect to the recovery catalog database as user SYS. Usage Notes RMAN connections to a database are specified and authenticated in the same way as SQL*Plus connections to a database. The only difference is that RMAN connections to a target or auxiliary database require the SYSDBA privilege. The AS SYSDBA keywords are implied and cannot be explicitly specified. See Oracle Database Administrator's Guide to learn about database connection options when using SQL*Plus.
Oracle. Database Backup and Recovery Reference 11g Release 2 (11.2)