单选题Which statement about recovering from the loss of a redo log group is true?()A If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B If the lost redo log group is CURRENT, you must clear the log file.C If the lost redo log group is ACTIVE, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.D If the lost redo log group is CURRENT, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.

单选题
Which statement about recovering from the loss of a redo log group is true?()
A

 If the lost redo log group is ACTIVE, you should first attempt to clear the log file.

B

 If the lost redo log group is CURRENT, you must clear the log file.

C

 If the lost redo log group is ACTIVE, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.

D

 If the lost redo log group is CURRENT, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.


参考解析

解析: 暂无解析

相关考题:

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

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager (RMAN) to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.

You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case; an instance recovery will be performed by the SMON process on startup.

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

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

As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?()  A、 Shut down the databaseB、 Clear the online redo logC、 Back up the databaseD、 Checkpoint the databaseE、 Call Oracle support

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’

Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?()A、 The redo log file should belong to an active group.B、 The redo log file should belong to an inactive group.C、 The redo log file should belong to the current group.D、 The redo log file can be dropped only if all the transactions are stopped.E、 Before a redo log file is dropped, it should be deleted from the operating system (OS).

Which statement about recovering from the loss of a redo log group is true?()A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B、If the lost redo log group is CURRENT, you must clear the log file.C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

You have the following online redo log configuration:    Group       Member   1     ’/disk1/oradata/redo01a.log’   2     ’/disk2/oradata/redo02a.log’   3     ’/disk3/oradata/redo03a.log’   You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files?()A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1;B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1;C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2;D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2;E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3;F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3;

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery?()A、You find that one of the redo log members in each redo log group is lost.B、You find that a data file that belongs to the USERS tablespace is damaged.C、You find that a data file that belongs to the SYSTEM tablespace is damaged.D、You find that the current redo log group is damaged and is not available for recovery.E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

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:   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’;

单选题Which statement about recovering from the loss of a redo log group is true?()A If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B If the lost redo log group is CURRENT, you must clear the log file.C If the lost redo log group is ACTIVE, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.D If the lost redo log group is CURRENT, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.

单选题You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()A Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, open the database with the RESETLOGS option after performing a cancel-based recovery.B Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D Do nothing. You do not need to recover the database in this case; an instance recovery will be performed by the SMON process on startup.

单选题As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?()A Shut down the databaseB Clear the online redo logC Back up the databaseD Checkpoint the databaseE Call Oracle support

单选题Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()ASMON would automatically restore the lost file.BYou would need to restore the whole database from the last backup.CYou would need to restore the file from the last full database backup.DYou would need to use flashback technology to restore the lost redo log member.EYou would need to use Recovery Manager (RMAN) to restore the lost redo log member.FYou would need to restore the missing log file by copying one of the remaining files from the same group.

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

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

单选题Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?()A The redo log file should belong to an active group.B The redo log file should belong to an inactive group.C The redo log file should belong to the current group.D The redo log file can be dropped only if all the transactions are stopped.E Before a redo log file is dropped, it should be deleted from the operating system (OS).

多选题Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? ()AYou find that one of the redo log members in each redo log group is lost.BYou find that a data file that belongs to the USERS tablespace is damaged.CYou find that a data file that belongs to the SYSTEM tablespace is damaged.DYou find that the current redo log group is damaged and is not available for recovery.EYou realized while performing a recovery that an archived redo log file needed for recovery is lost.

单选题Which statement about recovering from the loss of a redo log group is true?()AIf the lost redo log group is ACTIVE, you should first attempt to clear the log file.BIf the lost redo log group is CURRENT, you must clear the log file.CIf the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.DIf the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

单选题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?()Aimport the database from the last exportBrestore all the members in the group from the last backupCdrop the lost member from the database, and then add a new member to the groupDrestore all the database files from the backup, and then perform a complete recovery Erestore all the database files from the backup, and then perform an incomplete recovery

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

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