ITPub博客

（336）You want to make sure that your database backup does not exceed 10 hours in length.What command would you issue that would meet this condition?A. backup database plus archivelog;B. backup database plus archC. backup database plus archivelog timeout 10:00;D. backup database ...

（335）You have backed up your database twice without connecting to the recovery catalog.What command do you issue to transfer the control-file metadata to the recovery catalog?A. synch catalogB. resync catalogC. replicate catalogD. update catalogE. restore catalog答案...

（334）What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?A. crosscheckB. list backupC. confirmD. resyncE. backup validate答案：（A）

（333）Which command would you use to determine what database backups are currently available for restore?A. list database backup;B. report database backup;C. list backup of database;D. list summary backup;E. report backup of database;答案：（C）...

（332）David managed to accidentally delete the datafiles for database called DSL.He called Heber and Heber tried to help but he managed to delete the control files of the database.Heber called Bill and Bill saved the day. They are using a recovery catalog for this database.What steps did...

（331）Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?A. shutdown restore datafile 4; recover datafile 4; alter database open;B. Sql 'alter database datafile 4 offline'; restore datafile 4; recover ...

（330）What will be the end result of this set of RMAN commands?shutdown abort;startup mount;restore datafile 4 until time '09/30/2008:15:00:00';recover datafile 4 until time '09/29/2008:15:00:00';alter database open resetlogs;A. Datafile 4 will be recovered until 9/30/2008 at...

（329）If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?A. recover lost blocks;B. recover corrupt blocks;C. recover media corrupt blocks from list;D. recover corrupt blocks from list;E...

（328）You have backed up your database using image copies.You have lost the SYSTEM tablespace and need to restart your database as quickly as possible.What is the correct solution?A. Restore the SYSTEM tablespace from the last backup set and then recover the database.B. Restore the S...

（327）You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP.You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task? (Ch...

（326）Which of the following does the recover command not do?A. Restore archived redo logs.B. Apply archived redo logs.C. Restore incremental backups.D. Apply incremental backups.E. Restore datafile images.答案：（A）解析：个人认为为E...

（325）Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.)A. until timeB. until changeC. until sequenceD. until SCNE. until commit答案：（A、C、D）解析：B（X），until change是SQL语句,只...

（324）Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:RESTORE CONTROLFILE FROM AUTOBACKUP;Which of the following statements is true? (Choose all that apply.)A. The command restores only the missing c...

（323）What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?a. sql 'alter database datafile 4 online';b. restore datafile 4;c. recover datafile 4;d. sql 'alter database datafile 4 offline';e. s...

（322）You need to restore your database back to 9/30/2008 at 18:00.In what order would you run the following commands to compete this task?a. restore controlfile until time '09/30/2008:18:00:00';b. restore database until time '09/30/2008:18:00:00';c. restore spfile until time '09/30/...

（321）True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.A. TrueB. False答案：（B）

（320）You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups.Which files are not backed up during the RMAN backup?A. Database DatafilesB. Database Control FilesC. Online redo logsD. Archived redo logsE. The database SPFILEF. ...

（319）What is the end result of these commands if they are successful?RMAN> show retention policy;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultBackup database tag=gold_copy plus archivelog tag=gold_copy d...

（318）Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?A. restore datafiles until time '09/28/2008:21:03:11';B. restore database files until time '09/28/2008:18:00:00';C. restore database until time '09/28/2008:18:00:00';D. recover database until time '09...