1. Home
  2. Flashcards
  3. Preview

Oracle OCP 9i to 11g Backup and Recovery Enhancements

  1. What can be stored in the FLASH RECOVERY AREA?
    • Control File backups
    • Control File copies
    • Archive Logs
    • Flashback Logs
    • Datafile Copies
    • RMAN Files
  2. Which two init parameter are mandatory for Flash Recovery?
    • DB_RECOVERY_FILE_DEST
    • DB_RECOVERY_DEST_SIZE
  3. At what percentage full of Flash Recovery are Warning and Critical warnings issued?
    • Warning 85%
    • Critical Warning 97%
  4. Where are warning about space in the Flash Recovery area written?
    DBA_OUTSTANDING_ALERTS
  5. Which view contains information about Flash Recovery area?
    V$RECOVERY_FILE_DEST
  6. What does RMAN BACKUP RECOVERY AREA command to?
    • Allows for a backup of Flash Recovery to a specified destination
    • backup recovery area to destination '/u04/FRAbackup/'
  7. What does RMAN BACKUP RECOVERY FILES command to?
    Files on disk that have not previously been backed up will be backed up
  8. Which RMAN command allows for database files in the Flash Recovery area to be used in a failure senario?
    RMAN SWITCH DATABASE TO COPY
  9. What type of backup does RMAN SWITCH DATABASE TO COPY use?
    Image copies
  10. What happens if ALTER DATABASE ADD LOGFILE is run alone and DB_CREATE_ONLINE_LOG_DEST_n is not set?
    The logfile is created in the Flash Recovery Area with OMF filename
  11. In which views is IS_RECOVERY_DEST_FILES found?
    • V$CONTROLFILE
    • V$LOGFILE
    • V$ARCHIVED_LOG
    • V$DATAFILE_COPY
    • V$DATAFILE
    • V$BACKUP_PIECE
    • RMAN Tables
  12. What command applies an incremental backup to an image copy?
    RECOVER COPY OF DATAFILE {n|’filename’}
  13. If there is more than one image copy and RECOVER COPY OF DATAFILE is run, what happens?
    Only the latest copy is updated.
  14. What is SIMPLIFIED RECOVERY THROUGH RESETLOGS?
    • Use of logs prior to a RESETLOGS to enable recovery.
    • Therefore backup is not manatory following an open database resetlogs
  15. What is %r in LOG_ARCHIVE_FORMAT?
    • The database incarnation when the log was generated.
    • Part of the default format LOG_ARCHIVE_FORMAT
  16. Which views are nolonger cleared down when RESETLOGS is performed?
    V$LOG_HISTORY and V$OFFLINE RANGE
  17. What does the Change Tracking Writer (CTW) do?
    Monitors the blocks that have changed and writes to the change tracking file.
  18. How the blocks that have been altered monitored?
    Using block change tracking
  19. How is block change tracking implemented?
    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
  20. Which view show status for BLOCK CHANGE TRACKING?
    V$BLOCK_CHANGE_TRACKING
  21. What RMAN parameter controls throttling speed and in turn IO load?
    DURATION
  22. What is the syntax for the RMAN parameter DURATION?
    DURATION HH:MI [PARTIAL] [MINIMIZE <time|load>]
  23. What does the PARTIAL directive of the DURATION parameter in RMAN?
    • If backup does not complete errors are not reported
    • Partial backups set are aborted and made unusable.
  24. What does the MINIMIZE TIME directive of the DURATION parameter in RMAN?
    Backup runs at full speed and may complete under the alloted time.
  25. What does the MINIMIZE LOAD directive of the DURATION parameter in RMAN?
    Will reduce load if complete is before DURATION time.
  26. How are backups compressed?
    COMPRESSED
  27. What type of backup can be compressed?
    Backup sets NOT image copies
  28. What is VIRTUAL PRIVATE CATALOG?
    • A subset of the base recovery catalog
    • Catalog users can be granted accesses to a subset of databases in the catalog
  29. What does IMPORT CATALOG do?
    Allows recovery catalogs to ve merged or moved.
  30. What is the syntax for enabling BLOCK CHANGE TRACKING?
    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING [USING FILE /PATHTOFILE/FILE]
  31. What is the default location for the BLOCK CHANGE TRACKING file?
    An OMF in DB_CREATE_FILE_DEST?
  32. What RMAN command will ensure that archivelog policy is also true on standy databases?
    CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY
  33. How can RMAN in 11g backup archived logs when the flash recovery area is not available?
    Will backup from a secondary archive log destination.
  34. Which process tracks block changes in Block Change Tracking?
    Change Tracking Writer (CTW)
  35. What is the command to backup DB_RECOVERY_AREA in RMAN?
    BACKUP RECOVERY AREA TO DESTINATION '/.../.../'
  36. Which archive log parameter cannot be used with Flash Recovery Area?
    • LOG_ARCHIVE_DEST
    • LOG_ARCHIVE_DUPLEX_DEST
  37. How are space issues resolved in Flash Recovery Area?
    • Increase size of FRA
    • Backup files to tertiary source and delete
    • RMAN CROSSCHECK/RMAN EXPIRED
    • Delete unnecessary restore points
    • Review backup retention policy
  38. How is block level tracking disabled?
    ALTER DATABASE DISABLE BLOCK LEVEL TRACKING
  39. Which parameter specifies the default location for Oracle Managed datafiles?
    DB_CREATE_FILE_DEST
  40. Which parameter specifies the default location for Oracle Managed logfiles?
    DB_CREATE_ONLINE_LOG_DEST_n
  41. Can SECTION SIZE and MAXPIECESIZE be used together?
    No
  42. If a backup has been created with KEEP option, how is it obsoleted?
    With NOKEEP
  43. In IMPORT CATALOG, to which catalog does the DBA make the initial connection?
    To the catalog which will own the new catalog
  44. What is the command to import a database not the entire catalog in IMPORT CATALOG?
    IMPORT CATALOG rman@db11g DBID=1423241, 1423242;IMPORT CATALOG rman@db11g DB_NAME=prod3, prod4;
  45. How can a Virtual Private Catalog owner be permitted to register new databases?
    GRANT REGISTER DATABASE TO <VPC_USER>
  46. How is VIRTUAL PRIVATE CATALOG granted?
    • SQL> GRANT recovery_catalog_owner TO vpc1
    • RMAN> CONNECT CATALOG rman/rman@rmandb
    • RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1
    • RMAN> CONNECT CATALOG vpc1/password@rmandb
    • RMAN> CREATE VIRTUAL CATALOG
  47. How can a Virtual Private Catalog owner be stopped from registing new databases?
    REVOKE REGISTER DATABASE FROM <VPC_USER>
  48. You want to keep a database backup and for it to never expire. How?
    KEEP FOREVER
  49. You want to keep a database backup for 50 days before it expires. What is the clause?
    KEEP UNTIL TIME 'SYSDATE+50'
  50. Which parameter allows for the tracing of the archival of redo logs?
    LOG_ARCHIVE_TRACE
  51. What is the PL/SQL run to create a Virtual Catalog for databases prior to 11g?
    DBMS_RCVCAT.CREATE_VIRTUAL_CATALOG
  52. Which two commands can apply incremental backups to image copies of datafiles?
    • RECOVER COPY OF DATABASE
    • RECOVER DATAFILECOPY
  53. In what state must the source database be in to duplicate it?
    OPEN or MOUNTED
  54. What are the potential disadvantages of tuning MINIMIZE LOAD with tape?
    • Tape streaming may not be optimal
    • The tape resource will be held for the entire duration of DURATION parameter
  55. In which table are block corruptions listed?
    V$DATABASE_BLOCK_CORRUPTION
  56. How can block be recovered in a datafile?
    BLOCKRECOVER DATAFILE n BLOCK n DATAFILE nn BLOCK nn
  57. What command is used to duplicate a database?
    DUPLICATE DATABASE
  58. What command is used to duplicate a and active database?
    • DUPLICATE DATABASE
    • FROM ACTIVE DATABASE
  59. Which databases are visible to a virtual catalog owner?
    Only the databases for which the owner has been granted access
  60. In IMPORT CATALOG how is unregistering of the source catalog prevented?
    NO UNREGISTER
Author
Tralala
ID
192064
Card Set
Oracle OCP 9i to 11g Backup and Recovery Enhancements
Description
Oracle OCP 9i to 11g Backup and Recovery Enhancements
Updated

  1. Home
  2. Flashcards
  3. Preview