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

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

 1，3，4，and 5

B

 7，3，4. and 5

C

 2，3，4，and 5

D

 7，4，3，and 5

E

 Only 6 is required

相似考题

1.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()A. Creating the control file for the duplicate databaseB. Restoring the target data files to the duplicate databaseC. Performing complete recovery using all available backupsD. Generating a new, unique DBID for the duplicate databaseE. Copying the online redo log files from the target database to the duplicate database

2.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? ()(Choose Two)A. Creating the control file for the duplicate databaseB. Restoring the target data files to the duplicate databaseC. Performing complete recovery using all available backupsD. Generating a new, unique DBID for the duplicate databaseE. Copying the online redo log files from the target database to the duplicate database

3.You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

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

更多“A database is running In ARCHIVBXXMS mode. It has two online”相关问题

  • 第1题：

    An administrator is planning a cluster running applications in 3 separate resource groups. RGA - Database 1 RGB - Web Server RGC - Database 2 Database 1 and Database 2 must be online before the Web Server. All resource groups have a Startup Policyof Online on Home Node Only. Which of the following will ensure that the resource groups are processed in the correct order？（）

    • A、Set the Serial Acquisition Order
    • B、Set the Parallel Acquisition Order
    • C、Configure Online on the Same Node Dependency
    • D、Configure Online on Different Nodes Dependency

    正确答案:A

  • 第2题：

    In order to perform Flashback Transaction Query operations， which of these steps are required？（）

    • A、 Ensure that database is running with version 10.1 compatibility.
    • B、 Enable Flashback Logging.
    • C、 Enable Supplemental Logging.
    • D、 Ensure that the database is running with version 10.0 compatibility.
    • E、 Ensure that the database is in ARCHIVELOG mode.

    正确答案:C,D

  • 第3题：

    Which two prerequisites are needed for performing workload capture and replay？（）

    • A、Close all sessions performing queries using database links
    • B、running the database in shared server mode
    • C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
    • D、setting up the directory to capture the workload

    正确答案:C,D

  • 第4题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)

    • A、Creating the control file for the duplicate database
    • B、Restoring the target data files to the duplicate database
    • C、Performing complete recovery using all available backups
    • D、Generating a new, unique DBID for the duplicate database
    • E、Copying the online redo log files from the target database to the duplicate database

    正确答案:C,E

  • 第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题：

    单选题
    A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）
    A

    Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 

    B

    Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. 

    C

    Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.

    D

    Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 


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

  • 第7题：

    多选题
    Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）
    A

    The destination must be global only.

    B

    A maximum of five destinations can be assigned.

    C

    A maximum of ten different destinations can be assigned.

    D

    All the destinations are determined by the server automatically.

    E

    The destination may be local or remote for a Standby Database.

    F

    The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.


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

  • 第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题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第11题：

    多选题
    You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）
    A

    The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.

    B

    The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.

    C

    Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.

    D

    The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.


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

  • 第12题：

    多选题
    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）
    A

    Restore the data file and perform incomplete recovery.

    B

    Restore the data file and perform point-in-time recover.

    C

    Drop the tablespace and lose all data in the tablespace.

    D

    Restore the database and lose all data since the last backup.


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

  • 第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？ （）

    • A、archival
    • B、log writer
    • C、database writer
    • D、system monitor
    • E、process monitor
    • F、change tracking writer

    正确答案:A,B,C

  • 第14题：

    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.

    正确答案:C,E

  • 第15题：

    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

  • 第16题：

    多选题
    In order to perform Flashback Transaction Query operations， which of these steps are required？（）
    A

    Ensure that database is running with version 10.1 compatibility.

    B

    Enable Flashback Logging.

    C

    Enable Supplemental Logging.

    D

    Ensure that the database is running with version 10.0 compatibility.

    E

    Ensure that the database is in ARCHIVELOG mode.


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

  • 第17题：

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


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

  • 第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题：

    单选题
    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
    A

    You can perform online whole database backups.

    B

    You can performofflinewhole database backups.

    C

    You cannot perform schema-level export/import operations.

    D

    You can perform the backup of only the SYSTEM tablespace when the database is open.


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

  • 第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题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?（）
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第22题：

    多选题
    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
    解析： 暂无解析

  • 第23题：

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


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

相关内容