Switch to Image Copies for Fast Recovery in Software

Generating Code 39 Full ASCII in Software Switch to Image Copies for Fast Recovery

Image copies are immediately usable; there is no need to restore them The SET NEWNAME command informs RMAN that the copy is to be used; the SWITCH command updates the target database controlfile accordingly

A backup controlfile must be used if an incomplete recovery is to a time when the physical structure was different from that at present If all copies of the controlfile are lost, the controlfile can be restored, in nomount mode, from an autobackup If no datafiles or online log files are damaged, complete recovery using a backup controlfile is possible but an OPEN RESETLOGS will be necessary

A backup operation will fail if it encounters a corrupt block, unless SET MAXCORRUPT has been specified BMR can be accomplished with the database open and the datafile online Corrupted blocks detected by RMAN will be visible in the V$DATABASE_ BLOCK_CORRUPTION view The BLOCK RECOVER command can recover a nominated list of blocks, or all blocks listed the V$DATABASE_BLOCK_CORRUPTION view

1 Loss of which of these files will cause an open database to crash (Choose all correct answers) A A multiplexed controlfile B A multiplexed online log file C A multiplexed archive log file D An active undo tablespace datafile E An active temporary tablespace tempfile F A datafile from the SYSAUX tablespace G A datafile from the SYSTEM tablespace H A datafile containing critical user data 2 You issue the command ALTER DATABASE CLEAR LOGFILE GROUP 2, and it fails with the message ORA-01624: log 2 needed for crash recovery of instance orcl11g (thread 1) What could be an explanation for this (Choose the best answer) A Log file group 2 is active B Log file group 2 is being used for recovery C The database has not been checkpointed D The group is not multiplexed 3 Your database is in noarchivelog mode, and you lose a noncritical datafile What can you do to minimize loss of data (Choose the best answer) A Restore the one damaged file, and leave the rest of the database up-to-date B Restore all the datafiles, but leave the controlfile up-to-date C Restore the whole database, and clear the online redo logs D Restore the one damaged file, and apply the online redo logs

4 What sequence will allow you to add a multiplexed controlfile copy (Choose the best answer) 1 Adjust the CONTROL_FILES parameter 2 Copy the controlfile 3 Mount the database 4 Open the database 5 Recover the controlfile 6 Recover the database 7 Shut down the database A 7, 2, 1, 3, 4 (5 and 6 not necessary) B 7, 1, 3, 2, 6, 4 (5 not necessary) C 2, 1, 5 (3, 4, 6 and 7 not necessary) D 7, 1, 6, 3, 4 (2 and 5 not necessary) 5 These are three DRA commands: ADVISE FAILURE; LIST FAILURE; REPAIR FAILURE; In what order must they be run to fix a problem (Choose the best answer) A ADVISE, LIST, REPAIR B LIST, ADVISE, REPAIR C LIST, REPAIR (ADVISE is not necessary) D ADVISE, REPAIR (LIST is not necessary) 6 On what type or state of database can the DRA not be used (Choose all correct answers) A A single-instance database that is shut down B A single-instance database in nomount mode C A single-instance database in mount mode D An open RAC database E A mounted standby database 7 Where is the Automatic Diagnostic Repository stored (Choose the best answer) A In the Automatic Workload Repository B In the SYSAUX tablespace C In the data dictionary D In operating system files E In the Enterprise Manager repository

8 If you issue the LIST FAILURE command with the DRA and then another failure occurs, when you run ADVISE FAILURE for what will you receive advice (Choose the best answer) A For the original failures only B For the new failure only C For all the failures D For none of the failures until you run a new LIST FAILURES 9 Which file types can be repaired while the database is open (Choose the best answer) A A damaged multiplexed controlfile copy B A current multiplexed online log file C A damaged noncritical datafile, if the database is in archivelog mode D All of the above, if the DRA is used and server-managed backups are available 10 It is now 15:00, on Tuesday A bad transaction was committed in your database at about 14:30 Investigation shows that the tables and indexes affected were in just two tablespaces: the rest of the database is fine The two tablespaces and several others were backed up last night, but some tablespaces are backed up only on the weekend Your database is in archivelog mode, with log switches about every 10 minutes Which of the following statements is correct (Choose the best answer) A You can do an incomplete restore and recovery to 14:29, of just the two tablespaces The loss of data will be about 30 minutes of work in those tablespaces B You must restore the whole database from the weekend backup and recover to 14:29 You will lose about 30 minutes of work C You must restore the whole database and do an incomplete recovery canceling the application of the archive log that was active at 14:30 You will lose about 10 minutes of work D You can restore some tablespaces from last night, the others from the weekend, and recover to 14:29 You will lose about 30 minutes of work 11 Under which of the following circumstances is an incomplete recovery necessary (Choose two answers) A You lose all copies of your current online log file group B You lose a critical tablespace: SYSTEM, and/or the currently active UNDO tablespace C A user makes a bad transaction, and the instance crashes before he can issue the ROLLBACK statement D A datafile is created, used, and destroyed before it gets backed up E You back up a tablespace, drop it, and then want to get to the objects that were in it PART III