-
What is the prerequisite for performing an active database duplication on a source database that is in a mounted state?
That the source database was shut down cleanly
-
When performing an active database duplication, for what purpose would you use the DB_FILE_NAME_CONVERT clause of the RMAN DUPLICATE command?
To specify how to convert source datafile names to new datafile names
-
Which clause of the RMAN DUPLICATE command should you specify to indicate that the duplication should be performed online?
The FROM ACTIVE DATABASE clause
-
Which databases are visible to a virtual catalog owner?
Only the databases for which the owner has been granted access
-
Which RMAN command should you issue to indicate that all archived logs that have been backed up more than five times should be eligible for deletion?
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 5 TIMES TO devicetype;
-
When performing an RMAN backup, does the configured retention policy or the KEEP clause of the BACKUP command take precedence?
The KEEP clause of the BACKUP command
-
If autobackup is disabled, what will be backed up when you specify the KEEP option when performing an RMAN backup?
The control file, the current SPFILE file, datafiles, and archived redo logs
-
When multiple archive destinations are used, which feature allows you to perform an archived redo log backup, even if one of the archived redo log files is missing or corrupt?
The archived redo log failover feature
-
Which privilege should be granted to a user to indicate that the user is the owner of a virtual private catalog?
The RECOVERY_CATALOG_OWNER privilege
-
When importing metadata from a recovery catalog, to which recovery catalog must you be connected?
The destination recovery catalog
-
Which action must you take to create a virtual private catalog for an Oracle 10g database?
From SQL*Plus, execute the base_catalog_owner.DBMS_RCVCAT.CREATE_VIRTUAL_CATALOG procedure
-
Which statement should you use to grant access to the PROD2 and PROD3 registered databases to the virtual private catalog owner VPOWNER1?
The GRANT CATALOG FOR DATABASE prod2, prod3 TO vpowner1; statement
-
To perform most RMAN functions, which privilege should the owner of a virtual catalog have on the target database?
The SYSDBA or SYSOPER privilege
-
What metadata is imported with the IMPORT CATALOG command if you do not specify either a DBID or DB_NAME?
All metadata for all registered databases in the catalog
-
When performing an active database duplication, which clause of the RMAN DUPLICATE command should you specify to indicate that the duplicate database filenames should be the same as the source database filenames?
The NOFILENAMECHECK clause
-
What is the result on registered databases if you issue an IMPORT CATALOG command and do not specify the NO UNREGISTER clause?
The databases registered in the source recovery catalog are registered in the destination recovery catalog and unregistered in the source recovery catalog.
-
Which RMAN command should you use to update image copies with all changes up to a specific incremental backup?
The RECOVER COPY OF DATAFILE command
-
Which clause of the BACKUP command provided by RMAN will create a compressed backup?
The AS COMPRESSED clause
-
If you are using RMAN to back up files over a network and CPU performance is of lesser importance, which clause should you use with the RMAN BACKUP command to reduce the size of the backups and minimize network traffic?
The AS COMPRESSED clause
-
What is the result if you issue an IMPORT CATALOG command and global stored scripts in the source and destination catalogs have identical names?
The global scripts in the source catalog are renamed.
-
Which clause should you specify when performing an RMAN backup to indicate that the backup be kept until it is explicitly deleted by the DBA?
The KEEP FOREVER clause
-
What happens if you specify a section size in your RMAN BACKUP command that is larger than the size of the entire file?
The backup will not be performed as a multisection backup.
-
Which RMAN command can you use to import the metadata from another recovery catalog?
The IMPORT CATALOG command
-
When performing active database duplication, what must be true regarding the password file of the auxiliary instance?
It must exist and have the same SYSDBA password as the source database.
-
Which clause should you use with the RMAN BACKUP command to back up a very large datafile in sections rather than at the file level?
The SECTION SIZE clause
-
Which clause of the RMAN BACKUP command can you specify with the KEEP clause to create a restore point, identifying the SCN at which the database backup is consistent?
The RESTORE POINT clause
-
If you are using RMAN to back up files to a CD, which clause might you use with the RMAN BACKUP command to minimize the cost of your backup media?
The AS COMPRESSED clause
-
When performing an active database duplication on an open source database, the source database must be in which archive log mode?
ARCHIVELOG
-
Which type of backup should you perform if you are backing up to disk and have limited space on the backup destination?
Compressed backup
-
Which RMAN command can you use to create a virtual private catalog for an Oracle 11g database?
The CREATE VIRTUAL CATALOG command
-
When performing an active database duplication, which clause of the RMAN DUPLICATE command should you specify to indicate that the password file for the auxiliary instance should be overwritten with the source database password file?
The PASSWORD FILE clause
-
To what does the term intrafile parallel backup refer?
A multisection backup performed in parallel
-
As the base catalog owner, which RMAN command should you issue to allow the virtual catalog owner VOWNER1 to register a target database in the virtual private catalog?
The GRANT REGISTER DATABASE TO vowner1; command
-
Which three actions must you take to perform a multisection backup in parallel?
- Configure the SBT channels
- Set the parallelism for the SBT device
- Issue the BACKUP command with the SECTION SIZE clause
|
|
