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.
Before the instance starts, you receive an error about the missing redo log files of a group.
The instance starts and the database opens with an error message written to the alert log file.
The instance starts and the database opens because two redo log groups still exist.
The instance starts and the database opens, but every attempt to write to redo log files fails with an error.
第1题:
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?()
第2题:
Which two statements are true regarding the database in ARCHIVELOG mode?()
第3题:
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
第4题:
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:()
第5题:
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()
第6题:
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()
第7题:
In which two cases would you perform only consistent backup?()
第8题:
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?()
第9题:
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?()
第10题:
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?()