Execute the ALTER DATABASE ARCHIVELOG statement
Select ARCHIVELOG option in the database control and restart the database to apply the changes.
Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
第1题:
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?()
第2题:
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?()
第3题:
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 switch
B. You should make a backup of the database
C. You should switch the database to the NONARCHIVELOG mode
D. You should shut down the database instance and perform a complete database recovery
第4题:
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
第5题:
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?()
第6题:
You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?()
第7题:
Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database?()
第8题:
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode, and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature? ()
第9题:
Which two statements are true regarding the database in ARCHIVELOG mode?()
第10题:
Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database?()