OCP 13 Backup and Recovery Enhancements

Card Set Information

Author:
Tralala
ID:
213633
Filename:
OCP 13 Backup and Recovery Enhancements
Updated:
2013-04-19 09:48:19
Tags:
OCP 13 Backup Recovery Enhancements
Folders:

Description:
OCP 13 Backup and Recovery Enhancements
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. 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
  2. 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
  3. Which clause of the RMAN DUPLICATE command should you specify to indicate that the duplication should be performed online?
    The FROM ACTIVE DATABASE clause
  4. Which databases are visible to a virtual catalog owner?
    Only the databases for which the owner has been granted access
  5. 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;
  6. 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
  7. 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
  8. 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
  9. 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
  10. When importing metadata from a recovery catalog, to which recovery catalog must you be connected?
    The destination recovery catalog
  11. 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
  12. 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
  13. To perform most RMAN functions, which privilege should the owner of a virtual catalog have on the target database?
    The SYSDBA or SYSOPER privilege
  14. 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
  15. 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
  16. 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.
  17. 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
  18. Which clause of the BACKUP command provided by RMAN will create a compressed backup?
    The AS COMPRESSED clause
  19. 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
  20. 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.
  21. 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
  22. 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.
  23. Which RMAN command can you use to import the metadata from another recovery catalog?
    The IMPORT CATALOG command
  24. 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.
  25. 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
  26. 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
  27. 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
  28. When performing an active database duplication on an open source database, the source database must be in which archive log mode?
    ARCHIVELOG
  29. Which type of backup should you perform if you are backing up to disk and have limited space on the backup destination?
    Compressed backup
  30. Which RMAN command can you use to create a virtual private catalog for an Oracle 11g database?
    The CREATE VIRTUAL CATALOG command
  31. 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
  32. To what does the term intrafile parallel backup refer?
    A multisection backup performed in parallel
  33. 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
  34. 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

What would you like to do?

Home > Flashcards > Print Preview