Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 71:

  What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)

  A. RECOVERY_CATALOG_OWNER

  B. DBA

  C. RESOURCE

  D. SELECT ANY DICTIONARY

  E. CONNECT

  Correct Answer: AC

• Question 72:

  Which command do you use to create a recovery-catalog schema?

  A. create recovery catalog

  B. create catalog

  C. build catalog

  D. catalog create

  E. mount catalog

  Correct Answer: B

  Use the CREATE CATALOG command to create a recovery catalog.

  The recovery catalog can be a base recovery catalog or a virtual private catalog.

  A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases.

  A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog.

  

• Question 73:

  If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)

  A. The next time you back up the database when you are also connected to the recovery catalog and the target database

  B. The next time you are connected to the target database and the recovery catalog database and issue the resync command

  C. The next time you connect RMAN to just the recovery catalog

  D. The next time you connect to the recovery catalog and the target database with RMAN

  E. Connecting to the recovery catalog and issuing the resync all databases command

  Correct Answer: AB

  Deciding When to Resynchronize the Recovery Catalog RMAN automatically resynchronizes the recovery catalog when

  RMAN is connected to a target database and recovery catalog And you have executed RMAN commands. Thus, you should not need to manually run the RESYNC CATALOG command very often.

• Question 74:

  What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

  A. It must be used because all RMAN-related backup and recovery metadata information is contained in it.

  B. It provides a convenient, optional, repository of backup- and recovery-related metadata.

  C. It provides the ability to store RMAN scripts for global use by any database that has access to the repository.

  D. It provides a means of storing all RMAN backup sets physically in an Oracle database server.

  E. It provides the ability to store backup records for more than a year.

  Correct Answer: BCE

  A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. Typically, you store the catalog in a dedicated database. A recovery catalog provides the following benefits:

  A recovery catalog creates redundancy for the RMAN repository stored in the control file of each target database. The recovery catalog serves as a secondary metadata repository. If the target control file and all backups are lost, then the RMAN metadata still exists in the recovery catalog.

  A recovery catalog centralizes metadata for all your target databases. Storing the metadata in a single place makes reporting and administration tasks easier to perform.

  A recovery catalog can store metadata history much longer than the control file. This capability is useful if you must do a recovery that goes further back in time than the history in the control file. The added complexity of managing a recovery catalog database can be offset by the convenience of having the extended backup history available.

  Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.

  A recovery catalog is required when you use RMAN in a Data Guard environment. By storing backup metadata for all primary and standby databases, the catalog enables you to offload backup tasks to one standby database while enabling you to restore backups on other databases in the environment.

• Question 75:

  The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this:

  1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG;

  What is the correct sequence in which the commands have to be executed?

  A. 1, 4, 5, 2, 3

  B. 1, 4, 3, 2, 5

  C. 4, 5, 2, 3, 1

  D. 2, 3, 4, 5, 1

  E. 1, 4, 2, 3, 5

  Correct Answer: B

  Refer to here

  The basic steps for creating a virtual private catalog are as follows:

  1. Create the database user who will own the virtual private catalog (if this user does not exist) and grant this user access privileges.

  1.1 Start SQL*Plus and connect to the recovery catalog database with administrator privileges. 1.2 If the user that will own the virtual private catalog does not exist, then create the user. SQL> CREATE USER vpc1 IDENTIFIED BY password DEFAULT TABLESPACE vpcusers QUOTA UNLIMITED ON vpcusers;

  1.3 Grant the RECOVERY_CATALOG_OWNER role to the database user that will own the virtual private catalog, and then exit SQL*Plus. SQL> GRANT recovery_catalog_owner TO vpc1;

  1.4 Start RMAN and connect to the recovery catalog database as the base recovery catalog owner (not the virtual private catalog owner). RMAN> CONNECT CATALOG catowner@catdb;

  1.5 Grant desired privileges to the virtual private catalog owner. RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;

  You can also use a DBID rather than a database name. The virtual private catalog user does not have access to the metadata for any other databases registered in the recovery catalog. You can also grant the user the ability to register new

  target databases in the recovery catalog.

  For example:

  RMAN> GRANT REGISTER DATABASE TO vpc1;

  2. Create the virtual private catalog.

  2.1 Start RMAN and connect to the recovery catalog database as the virtual private catalog owner (not the base recovery catalog owner).

  RMAN> CONNECT CATALOG vpc1@catdb;

  2.2 Create the virtual private catalog.

  RMAN> CREATE VIRTUAL CATALOG;

  If you intend to use a 10.2 or earlier release of RMAN with this virtual private catalog, then execute the following PL/SQL procedure (where base_catalog_owner is the database user who owns the base recovery catalog):

  SQL> EXECUTE base_catalog_owner.DBMS_RCVCAT.CREATE_VIRTUAL_CATALOG;

• Question 76:

  You can back up the RMAN recovery catalog with RMAN.

  A. True

  B. False

  Correct Answer: A

  When backing up the recovery catalog database, you can use RMAN to make the backups.

  Refer to here.

• Question 77:

  What RMAN command must you use before you can back up a database using the recovery catalog?

  A. create catalog

  B. install database

  C. catalog database

  D. merge Catalog with database

  E. register database

  Correct Answer: E

• Question 78:

  Which statement about using RMAN stored scripts is true?

  A. To create and execute an RMAN stored script, you must use a recovery catalog.

  B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.

  C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.

  D. When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

  Correct Answer: A

  About Stored Scripts

  You can use a stored script as an alternative to a command file for managing frequently used sequences of RMAN commands. The script is stored in the recovery catalog rather than on the file system.

  Stored scripts can be local or global. A local script is associated with the target database to which RMAN is connected when the script is created, and can only be executed when you are connected to that target database. A global stored

  script can be run against any database registered in the recovery catalog, if the RMAN client is connected to the recovery catalog and a target database.

  The commands allowable within the brackets of the CREATE SCRIPT command are the same commands supported within a RUN block. Any command that is legal within a RUN command is permitted in the stored script. The following

  commands are not legal within stored scripts:

  RUN, @, and @@.

  When specifying a script name, RMAN permits but generally does not require that you use quotes around the name of a stored script. If the name begins with a digit or is an RMAN reserved word, however, then you must put quotes around

  the name to use it as a stored script name. Consider avoiding stored script names that begin with nonalphabetic characters or that are the same as RMAN reserved words.

• Question 79:

  RMAN provides more granular catalog security through which feature?

  A. Virtual private database

  B. Virtual private catalog

  C. RMAN virtual database

  D. RMAN secure catalog

  E. Oracle Database Vault

  Correct Answer: B

  About Virtual Private Catalogs By default, all of the users of an RMAN recovery catalog have full privileges to insert, update, and delete any metadata in the catalog. For example, if the administrators of two unrelated databases share the same recovery catalog, each administrator could, whether inadvertently or maliciously, destroy catalog data for the other's database. In many enterprises, this situation is tolerated because the same people manage many different databases and also manage the recovery catalog. But in other enterprises where clear separation of duty exists between administrators of various databases, and between the DBA and the administrator of the recovery catalog, you may desire to restrict each database administrator to modify only backup metadata belonging to those databases that they are responsible for, while still keeping the benefits of a single, centrallymanaged, RMAN recovery catalog. This goal can be achieved by implementing virtual private catalogs.

• Question 80:

  You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

  You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.

  You executed the following commands to achieve this:

  RMAN> CONNECT CATALOG rco11/password@catdb

  RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;

  What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?

  A. The scripts in the RCO11 catalog are overwritten.

  B. RMAN renames the local stored scripts in the RCO11 catalog.

  C. The RMAN session in which the command is executed aborts.

  D. RMAN renames the global scripts that are imported from the RCAT10 catalog.

  Correct Answer: D