The database instance aborts.
The database operation temporarily halts till the member becomes available.
Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
第1题:
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?()
第2题:
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?()
第3题:
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:()
第4题:
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?()
第5题:
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?()
第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题:
increase the size of the redo log buffer
increase the number of redo log groups
increase the number of log writer processes
increase the number of ARCn processes
change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
第8题:
The instance would normally abort.
The instance would not be affected.
The instance would be invalid, so would have to be aborted.
The instance would remain open, but the LGWR process would fail.
The instance would remain open and would automatically create the missing file
第9题:
the time when the last flashback operation in your database was performed
the time when the first flashback operation in your database was performed
a list of flashback operations performed in your database using SCN and time
the approximate time and the lowest system change number (SCN) to which you can flash back your database
第10题:
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.
第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题:
import the database from the last export
restore all the members in the group from the last backup
drop the lost member from the database and then add a new member to the group
restore all the database files from the backup and then perform a complete recovery
restore all the database files from the backup and then perform an incomplete recovery
第13题:
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? ()
第14题:
You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running?()
第15题:
In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()
第16题:
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?()
第17题:
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?()
第18题:
The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
第19题:
The database will hang.
The database will be crashed.
The database will be shut down.
The LGWR process writes redo log entries to the other redo log member of the Group2 group
第20题:
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.
第21题:
archival
log writer
database writer
system monitor
process monitor
change tracking writer
第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题:
RECOVER LOFIEL BLOCK GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE CLEAR LOGFILE GROUP 2;
ALTER DATABASE RECOVER LOGFILE GROUP 2;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;