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

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


参考解析

解析: 暂无解析

相关考题:

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command?()A. You should perform a log switchB. You should make a backup of the databaseC. You should switch the database to the NONARCHIVELOG modeD. You should shut down the database instance and perform a complete database recovery

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?()A. ALTER DATABASE DROP LOGFILE GROUP 1;B. ALTER DATABASE CLEAR LOGFILE GROUP 1;C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()A、ALTER DATABASE DROP LOGFILE GROUP 1;B、ALTER DATABASE CLEAR LOGFILE GROUP 1;C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D、ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;   Which action should you perform immediately after using this command?()  A、 You should perform a log switchB、 You should make a backup of the databaseC、 You should switch the database to the NONARCHIVELOG modeD、 You should shut down the database instance and perform a complete database recovery

You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()A、Archiving will be disabled because the destination for the redo log files is missing.B、The database instance will shut down and the error details will be logged in the alert log file.C、Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.D、Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()  A、the value of the UNDO_RETENTION initialization parameterB、the value of the optimal redo log file size provided by the Redo Logfile Size AdvisorC、the online redo log files sizeD、the number of redo log members in a group

Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member.  When you attempt to start the database, you receive the following errors:()A、 ALTER DATABASE DROP LOGFILE GROUP 1B、 ALTER DATABASE CLEAR LOGFILE GROUP 1C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

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

In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server? ()A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()A、 The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.B、 Before the instance starts, you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens, but every attempt to write to redo log files fails with an error.

Your database is in NOARCHIVELOG mode. The database has three online redo log groups, and each group contains three online redo log members. The online redo log members are stored across three hard disks, E, F, and G, respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database?()A、 The database will operate normally without generating any redo.B、 The database will hang, and you must shut down and restart the instance.C、 The database will crash, and you must recover the database from the point of failure.D、 The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.

Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down?()A、any control fileB、any archive log fileC、one of the redo log membersD、loss of the initialization parameter fileE、any data file belonging to the default permanent tablespac

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.

Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database, you receive the following errors:   ORA-00313: open failed for members of log group 1 of thread 1   ORA-00312: online log 1 thread 1: ’D:///REDO01.LOG’   You discover that the online redo log file of the current redo group is corrupted.  Which statement should you use to resolve this issue?()A、 SQLALTER DATABASE DROP LOGFILE GROUP 1;B、 SQLALTER DATABASE CLEAR LOGFILE GROUP 1;C、 SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D、 SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’;

多选题In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server? ()Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members?()A V$LOGB V$LOGFILEC DBA_LOG_GROUPSD V$LOG_HISTORY

单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()AYou should perform a log switchBYou should make a backup of the databaseCYou should switch the database to the NONARCHIVELOG modeDYou should shut down the database instance and perform a complete database recovery

单选题Your database is in NOARCHIVELOG mode. The database has three online redo log groups, and each group contains three online redo log members. The online redo log members are stored across three hard disks, E, F, and G, respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database?()A The database will operate normally without generating any redo.B The database will hang, and you must shut down and restart the instance.C The database will crash, and you must recover the database from the point of failure.D The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.

单选题You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.  What will be the implications on the archiving and the location of archive redo log files()AArchiving will be disabled because the destination for the redo log files is missing.BThe database instance will shut down and the error details will be logged in the alert log file.CArchiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.DArchiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.

单选题Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()AALTER DATABASE DROP LOGFILE GROUP 1;BALTER DATABASE CLEAR LOGFILE GROUP 1;CALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;DALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG

单选题Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down?()Aany control fileBany archive log fileCone of the redo log membersDloss of the initialization parameter fileEany data file belonging to the default permanent tablespac

单选题You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()A The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.B Before the instance starts, you receive an error about the missing redo log files of a group.C The instance starts and the database opens with an error message written to the alert log file.D The instance starts and the database opens because two redo log groups still exist.E The instance starts and the database opens, but every attempt to write to redo log files fails with an error.

单选题Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member.  When you attempt to start the database, you receive the following errors:()A ALTER DATABASE DROP LOGFILE GROUP 1B ALTER DATABASE CLEAR LOGFILE GROUP 1C ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

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

单选题Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database, you receive the following errors:   ORA-00313: open failed for members of log group 1 of thread 1   ORA-00312: online log 1 thread 1: ’D:///REDO01.LOG’   You discover that the online redo log file of the current redo group is corrupted.  Which statement should you use to resolve this issue?()A SQLALTER DATABASE DROP LOGFILE GROUP 1;B SQLALTER DATABASE CLEAR LOGFILE GROUP 1;C SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’;

单选题You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()Athe value of the UNDO_RETENTION initialization parameterBthe value of the optimal redo log file size provided by the Redo Logfile Size AdvisorCthe online redo log files sizeDthe number of redo log members in a group

单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;   Which action should you perform immediately after using this command?()A You should perform a log switchB You should make a backup of the databaseC You should switch the database to the NONARCHIVELOG modeD You should shut down the database instance and perform a complete database recovery