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

考题 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？（）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

查看答案

考题单选题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

查看答案

考题单选题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.

查看答案

考题单选题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?（）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

查看答案

考题单选题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

查看答案

考题多选题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?（）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

查看答案

考题单选题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

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：