When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()
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?()
During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information?()
Which statement about recovering from the loss of a redo log group is true?()
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?()
You have lost all members of your current redo log file group. You issue this query: SQL> select * from v$log; GROUP# SEQ# BYTES ARC STATUS FIRST_NAME 1 60 153600 NO INACTIVE 01-03-09:19:34 2 61 153600 NO CURRENT 01-03-09:19:50 You then perform an incomplete recover. You receive this message: ORA-00279: change 309141...03/09/01 19:50:14 Needed for thread 1 ORA-00289: suggestion : /disk1/archive/arch_61.rdo ORA-00280: change 309043 for thread 1 is in sequence #61 Specify log: {=suggested | filename | AUTO | CANCEL} How should you respond to this message?()
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()
The online redo log group configuration for your database is as follows: What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database?()
One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status?()
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?()