You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery
第1题:
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?()
第2题:
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:()
第3题:
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?()
第4题:
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery?()
第5题:
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?()
第6题:
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?()
第7题:
You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery
第8题:
1,3,4,and 5
7,3,4. and 5
2,3,4,and 5
7,4,3,and 5
Only 6 is required
第9题:
You find that one of the redo log members in each redo log group is lost.
You find that a data file that belongs to the USERS tablespace is damaged.
You find that a data file that belongs to the SYSTEM tablespace is damaged.
You find that the current redo log group is damaged and is not available for recovery.
You realized while performing a recovery that an archived redo log file needed for recovery is lost.
第10题:
ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3;
ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3;
第11题:
SQL>ALTER DATABASE DROP LOGFILE GROUP 1;
SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1;
SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’;
第12题:
b, a, f
e, b, a, f
e, b, a, g
b, a, g
c, e, b, d, f
第13题:
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?()
第14题:
A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow. 1) Restore the corrupted redo log group. 2) Restore from a whole database backup. 3) Perform incomplete recovery. 4) Relocate by renaming the member of the damaged online redo log group to a new location. 5) Open the database with the RESETLOGS option. 6) Restart the database instance. 7) Issue a checkpoint and clear the log. Identify the option with the correct sequential steps to accomplish the task efficiently().
第15题:
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?()
第16题:
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?()
第17题:
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?()
第18题:
SMON would automatically restore the lost file.
You would need to restore the whole database from the last backup.
You would need to restore the file from the last full database backup.
You would need to use flashback technology to restore the lost redo log member.
You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
You would need to restore the missing log file by copying one of the remaining files from the same group.
第19题:
The database will operate normally without generating any redo.
The database will hang, and you must shut down and restart the instance.
The database will crash, and you must recover the database from the point of failure.
The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.
第20题:
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
第21题:
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.
第22题:
ALTER DATABASE DROP LOGFILE GROUP 1
ALTER DATABASE CLEAR LOGFILE GROUP 1
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
第23题:
You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery