单选题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  

题目
单选题
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？（）
A

 SQL>ALTER DATABASE DROP LOGFILE GROUP 1；

B

 SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；

C

 SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；

D

 SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；

相似考题

1.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

2.Which two statements are true regarding the database in ARCHIVELOG mode？（）A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

3.If you create your database using Oracle Managed Files （OMF）， what is true？（）A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. B、You must define directories for two online redo log groups and three copies of the control file. C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

4.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？ （）A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer

更多“Your database is in ARCHIVELOG mode. You have two online red”相关问题

  • 第1题：

    You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

    • A、You must shut down the database instance to perform the backups.
    • B、You must configure the Flash Recovery Area （FRA） for the database.
    • C、You can perform complete database backups without closing the database.
    • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

    正确答案:C,D

  • 第2题：

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

    • A、Database Datafiles 
    • B、Database Control Files 
    • C、Online redo logs
    • D、Archived redo logs 
    • E、The database SPFILE 
    • F、None of the above, all these files are backed up. 

    正确答案:C

  • 第3题：

    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）

    • A、The instance aborts.
    • B、The database cannot be recovered.
    • C、The database can be recovered by restoring the control files from the backup.
    • D、The database remains opened and you have to shut it down with the ABORT option.
    • E、The database can be restored till the point of the last closed whole database backup.

    正确答案:A,E

  • 第4题：

    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

    • A、Only bring the tablespace back online.
    • B、Only recover the tablespace and then bring the tablespace back online.
    • C、Shut down the database， recover the data file and then start up the database.
    • D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
    • E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

    正确答案:D

  • 第5题：

    单选题
    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：（）
    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’


    正确答案： A
    解析： 暂无解析

  • 第6题：

    多选题
    Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process？ （）
    A

    open the database with the RESETLOGS option

    B

    open the database with the RESTRICTED option

    C

    recover all the data files to the same system change number （SCN）

    D

    recover to the required SCN only that data file in which the error occurred


    正确答案： A,C
    解析： 暂无解析

  • 第7题：

    多选题
    Which two statements are true regarding the database in ARCHIVELOG mode？（）
    A

    You have to shut down the database to perform the backups.

    B

    Archiving information is written to the data files and redo log files.

    C

    You can perform complete database backups without closing the database.

    D

    Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

    E

    All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.


    正确答案： B,C
    解析： 暂无解析

  • 第8题：

    单选题
    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
    A

    Shut down the database, restore the two data files and then start up the database. 

    B

    Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 

    C

    Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 

    D

    Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    多选题
    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）
    A

    backup of offline tablespaces

    B

    backup of read­only tablespaces

    C

    backup of system­critical tablespaces

    D

    backup of online， locally managed tablespaces

    E

    backup of read/write dictionary­managed tablespaces


    正确答案： B,A
    解析： 暂无解析

  • 第10题：

    多选题
    Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）
    A

    open the database with the RESTRICTED option

    B

    open the database with the RESETLOGS option

    C

    recover to the required SCN only that data file in which the error occurred

    D

    recover all the data files to the same system change number （SCN）


    正确答案： A,D
    解析： 暂无解析

  • 第11题：

    多选题
    You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）
    A

    Execute the ALTER DATABASE ARCHIVELOG statement

    B

    Select ARCHIVELOG option in the database control and restart the database to apply the changes.

    C

    Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

    D

    Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.


    正确答案： C,D
    解析： 暂无解析

  • 第12题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


    正确答案： B,C
    解析： 暂无解析

  • 第13题：

    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：（）

    • 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’

    正确答案:C

  • 第14题：

    You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）

    • A、flashback log files
    • B、backups that have become obsolete
    • C、copies of the data files and control files
    • D、archived redo log files that have multiple copies in a different archive location and not backed up

    正确答案:A,B

  • 第15题：

    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

    • A、 UNTIL SEQUENCE
    • B、 UNTIL SCN
    • C、 UNTIL CHANGE
    • D、 UNTIL CANCEL

    正确答案:C,D

  • 第16题：

    多选题
    You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）
    A

    You must shut down the database instance to perform the backups.

    B

    You must configure the Flash Recovery Area （FRA） for the database.

    C

    You can perform complete database backups without closing the database.

    D

    All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.


    正确答案： C,B
    解析： 暂无解析

  • 第17题：

    单选题
    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
    A

    Only bring the tablespace back online.

    B

    Only recover the tablespace and then bring the tablespace back online.

    C

    Shut down the database， recover the data file and then start up the database.

    D

    Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.

    E

    Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    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？（）
    A

     The database will operate normally without generating any redo.

    B

     The database will hang， and you must shut down and restart the instance.

    C

     The database will crash， and you must recover the database from the point of failure.

    D

     The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually.  Which action should you take to enable archiving at instance startup？（）
    A

    A

    B

    B

    C

    C

    D

    D


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    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?（）
    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


    正确答案： A
    解析： 暂无解析

  • 第21题：

    多选题
    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
    A

    Backup of offline tablespaces.

    B

    Backup of read-only tablespaces.

    C

    Backup of system-critical tablespaces.

    D

    Backup of online， locally managed tablespaces.

    E

    Backup of read/write dictionary-managed tablespaces.


    正确答案： A,D
    解析： 暂无解析

  • 第22题：

    多选题
    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？ （）
    A

    Open the database in read-only mode.

    B

    Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.

    C

    Enable the block change tracking feature.

    D

    Execute the ALTER DATABASE FLASHBACK ON statement.


    正确答案： A,D
    解析： 暂无解析

  • 第23题：

    多选题
    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？ （）
    A

    archival

    B

    log writer

    C

    database writer

    D

    system monitor

    E

    process monitor

    F

    change tracking writer


    正确答案： B,D
    解析： 暂无解析

  • 第24题：

    单选题
    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）
    A

     Database Datafiles

    B

     Database Control Files

    C

     Online redo logs

    D

     Archived redo logs

    E

     The database SPFILE

    F

     None of the above，all these files are backed up


    正确答案： C
    解析： 暂无解析

相关内容