Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3： Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）A、only case 1B、only case 2C、only case 3D、case 1 and 2E、case 2 and 3F、case 1 and 3G、all cases： case 1， case 2 and case 3
Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3： Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）
- A、only case 1
- B、only case 2
- C、only case 3
- D、case 1 and 2
- E、case 2 and 3
- F、case 1 and 3
- G、all cases： case 1， case 2 and case 3
相关考题：
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）A、 import the database from the last exportB、 restore all the members in the group from the last backupC、 drop the lost member from the database and then add a new member to the groupD、 restore all the database files from the backup and then perform a complete recoveryE、 restore all the database files from the backup and then perform an incomplete recovery
Which two statements are true regarding the database in ARCHIVELOG mode？（）A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL ALTER DATABASE OPEN； Which two statements are true（）A、The online redo log files and online data files are opened.B、All the online data file headers are checked for consistency.C、Instance recovery is performed before opening the database.D、The path and existence of all the log file members are checked
After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL ALTER DATABASE OPEN； Which two statements are true（）A、The online redo log files and online data files are opened.B、All the online data file headers are checked for consistency.C、Instance recovery is performed before opening the database.D、The path and existence of all the log file members are checked
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A、Restore all the data files and open the databaseB、Create the data file and performtablespacerecoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）A、Open the database in NORMAL modeB、Open the database in read-only modeC、Open the database in RESTRICTED modeD、Open the database with the RESETLOGS option
Case 1： 1. Shut down the database and perform a backup. 2. Restore all the data files. 3. Mount the database. 4. Recover the database. 5. Without applying all the redo log files， open the database using the RESETLOGS option. 6. Back up the database. Case 2： 1. Shut down the database and perform a backup. 2. Restore only the data files of the tablespace where user error damaged the data. 3. Mount the database. 4. Recover the database. 5. Open the database with the RESETLOGS option. 6. Back up the database. Case 3： 1. Shut down the database. 2. Restore the data files. 3. Open the database. 4. Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）A、 Only case 1B、 Only case 2C、 Only case 3D、 Case 1 and 2E、 Case 2 and 3F、 Case 1 and 3G、 All cases， case 1， case 2， case 3
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file. 2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?（）A、8，1，3，2，4，5，7，6B、1，8，3，4，2，5，7，6C、1，3，4，2，8，5，6，7D、1，3，2，4，6，5，7，8
Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（） a. Issue a checkpoint. b. Shut down the database. c. Issue an alter database open command to open the database. d. Startup mount the database. e. Issue an alter database clear logfile command. f. Recover all database datafiles.A、a， b， c， dB、b， d， e， cC、a， b， d， e， cD、b， f， d， f， cE、b， d， a， c
A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A、 clear the redo log groupB、 perform redo log file importC、 perform an incomplete recoveryD、 perform a redo log recovery using Recovery Manager （RMAN）E、 shut down the database and open the database in the NOARCHIVELOG mode
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A、Restore all the data files and open the databaseB、Create the data file and perform tablespace recoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error. SQL startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 SQL alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1： ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log What steps must you take to resolve the error？（） a. Issue the recover database redo logs command. b. Issue the Startup Mount command to mount the database. c. Restore the last full database backup. d. Perform a point-in-time recovery， applying all archived redo logs that are available. e. Restore all archived redo logs generated during and after the last full database backup. f. Open the database using the alter database open resetlogs command. g. Issue the alter database open command.A、b， a， fB、e， b， a， fC、e， b， a， gD、b， a， gE、c， e， b， d， f
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member？（）A、import the database from the last exportB、restore all the members in the group from the last backupC、drop the lost member from the database， and then add a new member to the groupD、restore all the database files from the backup， and then perform a complete recovery E、restore all the database files from the backup， and then perform an incomplete recovery
Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）A、Restore the data file for the SYSTEM tablespace then open the database. B、Restore all redo logs form last night's backup, then restart the database. C、Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. D、Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）A、Shut down the database, restore the two data files and then start up the database. B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
多选题After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
单选题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You could consider performing the following steps to accomplish this task： 1） Restore an autobackup of the server parameter file. 2） Restore the control file. 3） Start the target database Instance. 4） Mount the database. 5） Restore the data files. 6） Open the database with the RESETLOGS option. 7） Recover the data files. 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）A 8， 1， 3， 2， 4， 5， 7， 6B 1， 8， 3， 4， 2， 5， 7， 6C 1， 3， 4， 2， 8， 5， 6， 7D 1， 3， 2， 4， 6， 5， 7， 8
单选题Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3： Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）Aonly case 1Bonly case 2Conly case 3Dcase 1 and 2Ecase 2 and 3Fcase 1 and 3Gall cases： case 1， case 2 and case 3
单选题You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）ARestore all the data files and open the databaseBCreate the data file and perform tablespace recoveryCNo need to restore any file， just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
单选题Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）ARestore the data file for the SYSTEM tablespace then open the database. BRestore all redo logs form last night's backup, then restart the database. CPerform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. DMount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
单选题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task： 1） Restore an autobackup of the server parameter file. 2） Restore the control file 3） Start the target database instance 4） Mount the database 5） Restore the data files 6） Open the database with RESETLOGS option 7） Recover the data files 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）A 8， 1， 3， 2， 4， 5， 7， 6B 1， 8， 3， 4， 2， 5， 7， 6C 1， 3， 4， 2， 8， 5， 6， 7D 1， 3， 2， 4， 6， 5， 7， 8
单选题A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A clear the redo log groupB perform redo log file importC perform an incomplete recoveryD perform a redo log recovery using Recovery Manager （RMAN）E shut down the database and open the database in the NOARCHIVELOG mode
单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）AOpen the database in NORMAL modeBOpen the database in read-only modeCOpen the database in RESTRICTED modeDOpen the database with the RESETLOGS option
单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）AOpen the database in NORMAL modeBOpen the database in read-only modeCOpen the database in RESTRICTED modeDOpen the database with the RESETLOGS option
多选题After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
单选题You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file. 2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?（）A8，1，3，2，4，5，7，6B1，8，3，4，2，5，7，6C1，3，4，2，8，5，6，7D1，3，2，4，6，5，7，8
单选题In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）A import the database from the last exportB restore all the members in the group from the last backupC drop the lost member from the database and then add a new member to the groupD restore all the database files from the backup and then perform a complete recoveryE restore all the database files from the backup and then perform an incomplete recovery