单选题When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()AUntil SCNBUntil timeCUntil cancelDRecover using backup control file.
单选题
When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()
A
Until SCN
B
Until time
C
Until cancel
D
Recover using backup control file.
参考解析
解析:
暂无解析
相关考题:
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?()A. Mount the container database (CDB) and restore the control file from the control file auto backup.B. Recover and open the CDB in NORMAL mode.C. Mount the CDB and then recover and open the database, with the RESETLOGS option.D. Open all the pluggable databases.E. Recover each pluggable database.F. Start the database instance in the nomount stage and restore the control file from control file auto backup.
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?() A、 Restore and recover the datafile.B、 Restore and recover the tablespace.C、 Restore and recover the database.D、 Restore and recover the control file.E、 Restore and recover the parameter file.
When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()A、Until SCNB、Until timeC、Until cancelD、Recover using backup control file.
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 control file command. g. Start up the database. A、a, b, f, gB、c, f, gC、a, d, f, gD、a, f, gE、a, e, g
Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database?()A、Until last commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION
You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL RECOVER DATABASE 2 UNTIL TIME ’2004-08-05:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()A、 A user table was lost at the specified time.B、 A redo log file was lost at the specified time.C、 The backup control file is on a faster disk than the current one.D、 The current control file has a different path compared with the intended time of recovery.E、 The current control file does not match the physical structure of the database at the intended time of recovery.
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()A、Restore and recover the datafile. B、Restore and recover the tablespace. C、Restore and recover the database. D、Restore and recover the control file. E、Restore and recover the parameter file.
Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database?()A、Until last commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()A、 UNTIL CANCELB、 UNTIL SCNC、 UNTIL SEQUENCED、 UNTIL TIME
The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()A、until SCNB、until timeC、until cancelD、using backup control file
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8:00 P.M. Your database is running in ARCHIVELOG mode. On Monday, at 9:00 A.M., a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command?()A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
You lost the PRODSTD tablespace, which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace?()A、restore the tablespace from the backup; there is no need to apply the redo information B、restore the full database to recover the data up to the point when you performed the backup C、restore the tablespace from the backup, and then perform a recovery using the backup control fileD、restore the tablespace from the backup, and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?()A、 restore the tablespace from the backup; there is no need to apply the redo informationB、 restore the full database to recover the data up to the point when you performed the backupC、 restore the tablespace from the backup and then perform a recovery using the backup control fileD、 restore the tablespace from the backup and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
In which scenario will you issue the following command?() SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING BACKUP CONTROLFILE;A、 when all the control files are missing and only a binary backup of the current control file existsB、 when a multiplexed copy of the current control file is missingC、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD、 when the SPFILE is missing
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 blocksB、 recover corrupt blocksC、 recover media corrupt blocks from listD、 recover corrupt blocks from listE、 recover corruption list
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?() A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
单选题You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()A UNTIL CANCELB UNTIL SCNC UNTIL SEQUENCED UNTIL TIME
单选题In which scenario will you issue the following command?() SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING BACKUP CONTROLFILE;A when all the control files are missing and only a binary backup of the current control file existsB when a multiplexed copy of the current control file is missingCwhen all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD when the SPFILE is missing
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()ARestore and recover the datafile. BRestore and recover the tablespace. CRestore and recover the database. DRestore and recover the control file. ERestore and recover the parameter file.
单选题You lost the PRODSTD tablespace, which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace?()Arestore the tablespace from the backup; there is no need to apply the redo information Brestore the full database to recover the data up to the point when you performed the backup Crestore the tablespace from the backup, and then perform a recovery using the backup control fileDrestore the tablespace from the backup, and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()A Restore and recover the datafile.B Restore and recover the tablespace.C Restore and recover the database.D Restore and recover the control file.E Restore and recover the parameter file.
单选题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 control file command. g. Start up the database.Aa, b, f, gBc, f, gCa, d, f, gDa, f, gEa, e, g
单选题You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?()A restore the tablespace from the backup; there is no need to apply the redo informationB restore the full database to recover the data up to the point when you performed the backupC restore the tablespace from the backup and then perform a recovery using the backup control fileD restore the tablespace from the backup and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
单选题You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code?() RMANRUN { SET UNTIL SEQUENCE THREAD ; RESTORE DATABASE; RECOVER DATABASE; }A NOMOUNTB MOUNTC OPEND RESTRICTED
单选题When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()AUntil SCNBUntil timeCUntil cancelDRecover using backup control file.
单选题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 blocksB recover corrupt blocksC recover media corrupt blocks from listD recover corrupt blocks from listE recover corruption list
单选题You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()A You will need to open the database with the resetlogs command.B All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C You will use the resetlogs version of the create controlfile command.D You will use the noresetlogs version of the create controlfile command.E You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command