Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 141:

  You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)

  A. You are backing up to tape and your tape device performs its own compression.

  B. You are making image copies, and you have not enabled tablespace compression.

  C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk- based backup destinations are limited.

  D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.

  E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.

  Correct Answer: CDE

• Question 142:

  You executed the following command:

  RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';

  Which statement regarding the above command is correct?

  A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.

  B. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup.

  C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.

  D. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails.

  Correct Answer: C

• Question 143:

  You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.)

  A. Reregistering the target database in recovery catalog

  B. Transporting the new tablespaces to the recovery catalog database

  C. Syncronizing the recovery catalog with the target database control file

  D. Performing a fresh backup of the target database to include the new data files in the catalog database

  Correct Answer: CD

• Question 144:

  You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

  A. Data Pump Export and Import

  B. conventional export and import

  C. the CONVERT command of RMAN

  D. the BACKUP AS COPY command of RMAN

  Correct Answer: D

  If you have enough disk space that you can have both your entire non-ASM database and your ASM disk group on disk at the same time, you can do the migration directly without using tapes.

  1. Back up your database files as copies to the ASM disk group.

  BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE FORMAT `+DISK' TAG `ORA_ASM_MIGRATION';

  REF: Oracle(r) 10g Backup and Recovery Advance User's Guide, 16-2

• Question 145:

  Consider the following scenario for your database:

  Backup optimization is enabled in RMAN.

  The recovery window is set to 7 days in RMAN.

  The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.

  The TOOLS tablespace is read-only since November 4, 2007.

  On November 23, 2007, you issue the RMAN command to back up the database to disk.

  Which statement is true regarding the backup of the TOOLS tablespace?

  A. The RMAN backup fails because the TOOLS tablespace is read-only

  B. The RMAN skips the backup of the tablespace because backup optimization is enabled

  C. The RMAN makes backup because optimization can be enabled only for backups to disk

  D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

  Correct Answer: D

• Question 146:

  You issue the following command on the RMAN prompt.

  REPORT NEED BACKUP DAYS 5;

  Which statement is true about executing this command?

  A. It will display a list of files that need incremental backup

  B. It will display a list of files that need backup after five days

  C. It will display a list of files that were backed up in the last five days

  D. It will display a list of files that have not been backed up in the last five days

  E. It will apply the current retention policy to determine the files that need to be backed up

  Correct Answer: D

• Question 147:

  Examine the following RMAN command: BACKUP DATABASE

  TAG TESTDB

  KEEP UNTIL 'SYSDATE+1'

  RESTORE POINT TESTDB06;

  Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

  A. Only data files and the control file are backed up.

  B. Archived redo logs are backed up only if the database is open during the backup.

  C. The backup is deleted after one day, regardless of the default retention policy settings.

  D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

  Correct Answer: BD

  Refer to here.

  KeepOption

  Overrides any configured retention policy for this backup so that the backup is not considered obsolete, as shown in Example 2-26.

  You can use the KEEP syntax to generate archival database backups that satisfy business or legal requirements. The KEEP setting is an attribute of the backup set (not individual backup piece) or image copy.

  Note: You cannot use KEEP with BACKUP BACKUPSET.

  With the KEEP syntax, you can keep the backups so that they are considered obsolete after a specified time (KEEP UNTIL), or make them never obsolete (KEEP FOREVER). As shown in Example 2-27, you must be connected to a recovery

  catalog when you specify KEEP FOREVER.

  Note: You can use CHANGE to alter the status of a backup generated with KEEP. See Also: keepOption for more information about backups made with the KEEP option.

  Creating a Consistent Database Backup for Archival Purposes:

  This example uses a keepOption to create an archival backup set that cannot be considered obsolete for one year. The example backs up the database, archives the redo in the current online logs to ensure that this new backup is consistent,

  and backs up only those archived redo log files needed to restore the data file backup to a consistent state. The BACKUP command also creates a restore point to match the SCN at which this backup is consistent.

  The FORMAT parameter must be capable of creating multiple backup pieces in multiple backup sets.

  BACKUP DATABASE

  FORMAT '/disk1/archival_backups/db_%U.bck'

  TAG quarterly

  KEEP UNTIL TIME 'SYSDATE + 365'

  RESTORE POINT Q1FY06;

• Question 148:

  A database has three online redo log groups with one member each. A redo log member with the status ACTIVE is damages while the database is running. What is the first step you should take to solve this problem?

  A. Attempt to Issue a checkpoint.

  B. Restart the database using the RESETLOGS option.

  C. Drop the redo log number and create it in a different location.

  D. Perform and incomplete recovery up to the most recent available redo log.

  Correct Answer: A

  Recovering After Losing All Members of an Online Redo Log Group If a media failure damages all members of an online redo log group, then different scenarios can occur depending on the type of online redo log group affected by the failure

  and the archiving mode of the database. If the damaged online redo log group is current and active, then it is needed for crash recovery; otherwise, it is not.

  Recovering After the Loss of an Online Redo Log Group Inactive It is not needed for crash recovery Clear the archived or unarchived group.

  Active

  It is needed for crash recovery Attempt to issue a checkpoint and clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.

  Current

  It is the redo log that the database is currently writing to Attempt to clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.

• Question 149:

  Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)

  A. Database datafiles

  B. Control files

  C. Archived redo logs

  D. Online redo logs

  E. Flashback logs

  Correct Answer: ABD

  Recovering a Database in NOARCHIVELOG Mode

  1.

  Restore all the data files and control files

  2.

  (optional) if the media failure is not fixed, you need to modify the control file to the new location of data files and redo log files.

  SQL> STARTUP MOUNT;

  SQL> ALTER DATABASE RENAME FILE '' TO '';

  3.

  SQL> RECOVER DATABASE UNTIL CANCEL Because online redo logs are never backed up, you cannot restore them with the data files and control files. To enable the database to reset the online redo logs, you must first mimic

  incomplete recovery:

  4.

  SQL> ALTER DATABASE OPEN RESETLOGS;

• Question 150:

  You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?

  a.

  Shut down the database.

  b.

  Restore a control-file copy from backup media.

  c.

  Use the create control file command to create a new control file.

  d.

  Copy the backup control file into place.

  e.

  Create a new copy of the control file from one of the surviving control files.

  f.

  Recover the database using the recover database using BACKUP CONTROLFILE command.

  g.

  Start up the database.

  A.

  a, b, f, g

  B.

  c, f, g

  C.

  a, d, f, g

  D.

  a, f, g

  E.

  a, e, g

  Correct Answer: E