ITPub博客

首页 > 数据库 > Oracle > OCP课程38:管理Ⅰ之恢复

OCP课程38:管理Ⅰ之恢复

原创 Oracle 作者:stonebox1122 时间:2016-02-18 09:07:24 0 删除 编辑

课程目标:

  • 何时需要进行恢复
  • 使用EM或者命令行进行恢复
  • 恢复控制文件,重做日志文件和数据文件

1、打开数据库

clipboard

数据库启动的各个阶段:

nomount:必须要读取初始化参数文件,不检查数据文件

mount:读取初始化参数文件中指定的所有控制文件,缺少其中一个控制文件会返回错误

open:检查控制文件中指定的所有重做日志组是否至少有一个成员存在,如果缺少某一个成员,会在告警文件中标注。检查控制文件中指定的数据文件是否存在,如果数据文件以前是离线的,则不做检查,进行在线的时候再做检查。如果有一些文件不存在,只会对检查到的第一个文件返回错误,可以通过V$RECOVER_FILE动态性能视图查看所有需要介质恢复的文件。


2、保持数据库打开

clipboard[1]

数据库打开后,如果以下文件丢失会引起实例失败:

  • 任何一个控制文件
  • 属于SYSTEM或者UNDO表空间的数据文件
  • 整个重做日志组

要对以上文件进行恢复,需要使用SHUTDOWN ABORT命令关闭数据库。

属于其他表空间的数据文件损坏不会导致实例失败,可以在数据库打开的状态下进行恢复。


3、数据恢复顾问

clipboard[2]

数据恢复顾问自动收集数据失败信息,包括当前日志文件丢失,数据文件块损坏等,在数据库进程发现数据损坏前进行检测和分析。可以使用数据恢复顾问处理以下2种情况:

  • 数据文件丢失、不一致或者损坏导致不能启动数据库
  • 在数据库运行时出现文件损坏

数据故障可以采取以下措施:

(1)如果配置了DG,切换到备库

(2)修复数据故障

可以通过EM或者RMAN使用数据恢复顾问,当前版本只支持单实例,不支持RAC,支持故障转移到备库,不支持分析和修复备库。


3、丢失控制文件

clipboard[3]

丢失控制文件分2种,一种是只丢失其中的一个,一种是丢失所有的控制文件,这里只说明丢失其中一个控制文件如何恢复。可以通过拷贝剩余的控制文件到control_files参数指定的位置进行恢复,也可以通过修改control_files,删掉失效的地址解决。

例子:ASM下丢失某一个控制文件的恢复

SQL> show parameter control_files

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_files                        string      +DATA/stone/controlfile/curren

                                                 t.260.893370773, +FRA/stone/co

                                                 ntrolfile/current.256.89337077

                                                 3

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

ASMCMD> rm  +FRA/stone/controlfile/current.256.893370773

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area  889389056 bytes

Fixed Size                  2258360 bytes

Variable Size             868223560 bytes

Database Buffers           12582912 bytes

Redo Buffers                6324224 bytes

ORA-00205: error in identifying control file, check alert log for more info

RMAN> restore controlfile from '+DATA/stone/controlfile/current.260.893370773';

Starting restore at 29-DEC-15

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=23 device type=DISK

channel ORA_DISK_1: copied control file copy

output file name=+DATA/stone/controlfile/current.260.893370773

output file name=+FRA/stone/controlfile/current.256.899747345

Finished restore at 29-DEC-15

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.


4、重做日志文件丢失

clipboard[4]

如果只是丢失重做日志组中的某一个文件,不会影响正常的实例操作,

例子:丢失某一个重做日志文件的恢复,删除重建

SQL> select l.group#,archived,member from v$log l join v$logfile f on l.group#=f.group#  order by 1;

    GROUP# ARC MEMBER

---------- --- --------------------------------------------------

         1 YES +DATA/stone/onlinelog/group_1.275.899664931

         1 YES +DATA/stone/onlinelog/group_1.261.893370775

         1 YES +FRA/stone/onlinelog/group_1.257.893370777

         2 YES +DATA/stone/onlinelog/group_2.262.893370777

         2 YES +FRA/stone/onlinelog/group_2.258.893370779

         3 NO  +DATA/stone/onlinelog/group_3.263.893370779

         3 NO  +FRA/stone/onlinelog/group_3.259.893370781

7 rows selected.

ASMCMD> rm +DATA/stone/onlinelog/group_1.261.893370775

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area  889389056 bytes

Fixed Size                  2258360 bytes

Variable Size             868223560 bytes

Database Buffers           12582912 bytes

Redo Buffers                6324224 bytes

Database mounted.

Database opened.

[oracle@oracletest1 ~]$ grep +DATA/stone/onlinelog/group_1.261.893370775 /u01/app/oracle/diag/rdbms/stone/stone/trace/alert_stone.log | grep ORA

ORA-00312: online log 1 thread 1: '+DATA/stone/onlinelog/group_1.261.893370775'

ORA-17503: ksfdopn:2 Failed to open file +DATA/stone/onlinelog/group_1.261.893370775

ORA-15012: ASM file '+DATA/stone/onlinelog/group_1.261.893370775' does not exist

ORA-00312: online log 1 thread 1: '+DATA/stone/onlinelog/group_1.261.893370775'

ORA-00312: online log 1 thread 1: '+DATA/stone/onlinelog/group_1.261.893370775'

ORA-17503: ksfdopn:2 Failed to open file +DATA/stone/onlinelog/group_1.261.893370775

ORA-15012: ASM file '+DATA/stone/onlinelog/group_1.261.893370775' does not exist

SQL> alter database drop logfile member '+DATA/stone/onlinelog/group_1.261.893370775';

Database altered.

SQL> select l.group#,archived,member from v$log l join v$logfile f on l.group#=f.group#  order by 1;

    GROUP# ARC MEMBER

---------- --- --------------------------------------------------

         1 YES +FRA/stone/onlinelog/group_1.257.893370777

         1 YES +DATA/stone/onlinelog/group_1.275.899664931

         2 YES +DATA/stone/onlinelog/group_2.262.893370777

         2 YES +FRA/stone/onlinelog/group_2.258.893370779

         3 NO  +DATA/stone/onlinelog/group_3.263.893370779

         3 NO  +FRA/stone/onlinelog/group_3.259.893370781

6 rows selected.

SQL> alter database add logfile member '+DATA' to group 1;

Database altered.

SQL> select l.group#,archived,member from v$log l join v$logfile f on l.group#=f.group#  order by 1;

    GROUP# ARC MEMBER

---------- --- --------------------------------------------------

         1 YES +DATA/stone/onlinelog/group_1.275.899664931

         1 YES +DATA/stone/onlinelog/group_1.261.899749145

         1 YES +FRA/stone/onlinelog/group_1.257.893370777

         2 YES +DATA/stone/onlinelog/group_2.262.893370777

         2 YES +FRA/stone/onlinelog/group_2.258.893370779

         3 NO  +DATA/stone/onlinelog/group_3.263.893370779

         3 NO  +FRA/stone/onlinelog/group_3.259.893370781

7 rows selected.

例子:丢失某一个重做日志文件的恢复,使用alter database clear logfile group #

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

ASMCMD> rm +DATA/stone/onlinelog/group_1.261.899749145

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area  889389056 bytes

Fixed Size                  2258360 bytes

Variable Size             868223560 bytes

Database Buffers           12582912 bytes

Redo Buffers                6324224 bytes

Database mounted.

SQL> select l.group#,archived,member from v$log l join v$logfile f on l.group#=f.group#  order by 1;

    GROUP# ARC MEMBER

---------- --- --------------------------------------------------

         1 YES +DATA/stone/onlinelog/group_1.275.899664931

         1 YES +DATA/stone/onlinelog/group_1.261.899749145

         1 YES +FRA/stone/onlinelog/group_1.257.893370777

         2 YES +DATA/stone/onlinelog/group_2.262.893370777

         2 YES +FRA/stone/onlinelog/group_2.258.893370779

         3 NO  +DATA/stone/onlinelog/group_3.263.893370779

         3 NO  +FRA/stone/onlinelog/group_3.259.893370781

7 rows selected.

SQL> alter database clear logfile group 1;

Database altered.

SQL> select l.group#,archived,member from v$log l join v$logfile f on l.group#=f.group#  order by 1;

    GROUP# ARC MEMBER

---------- --- --------------------------------------------------

         1 YES +DATA/stone/onlinelog/group_1.275.899664931

         1 YES +DATA/stone/onlinelog/group_1.261.899749329

         1 YES +FRA/stone/onlinelog/group_1.257.893370777

         2 YES +DATA/stone/onlinelog/group_2.262.893370777

         2 YES +FRA/stone/onlinelog/group_2.258.893370779

         3 NO  +DATA/stone/onlinelog/group_3.263.893370779

         3 NO  +FRA/stone/onlinelog/group_3.259.893370781

7 rows selected.

例子:丢失某一个重做日志文件的恢复,该重做日志文件处于非归档状态

SQL> select l.group#,archived,member from v$log l join v$logfile f on l.group#=f.group#  order by 1;

    GROUP# ARC MEMBER

---------- --- --------------------------------------------------

         1 NO  +DATA/stone/onlinelog/group_1.275.899664931

         1 NO  +DATA/stone/onlinelog/group_1.261.899749329

         1 NO  +FRA/stone/onlinelog/group_1.257.893370777

         2 YES +DATA/stone/onlinelog/group_2.262.893370777

         2 YES +FRA/stone/onlinelog/group_2.258.893370779

         3 YES +DATA/stone/onlinelog/group_3.263.893370779

         3 YES +FRA/stone/onlinelog/group_3.259.893370781

7 rows selected.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

ASMCMD> rm +DATA/stone/onlinelog/group_1.261.899749329

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area  889389056 bytes

Fixed Size                  2258360 bytes

Variable Size             868223560 bytes

Database Buffers           12582912 bytes

Redo Buffers                6324224 bytes

Database mounted.

Database opened.

SQL> select l.group#,archived,member from v$log l join v$logfile f on l.group#=f.group#  order by 1;

    GROUP# ARC MEMBER

---------- --- --------------------------------------------------

         1 NO  +DATA/stone/onlinelog/group_1.275.899664931

         1 NO  +DATA/stone/onlinelog/group_1.261.899749329

         1 NO  +FRA/stone/onlinelog/group_1.257.893370777

         2 YES +DATA/stone/onlinelog/group_2.262.893370777

         2 YES +FRA/stone/onlinelog/group_2.258.893370779

         3 YES +DATA/stone/onlinelog/group_3.263.893370779

         3 YES +FRA/stone/onlinelog/group_3.259.893370781

7 rows selected.

SQL> alter database clear logfile group 1;

alter database clear logfile group 1

*

ERROR at line 1:

ORA-01624: log 1 needed for crash recovery of instance stone (thread 1)

ORA-00312: online log 1 thread 1: '+FRA/stone/onlinelog/group_1.257.893370777'

ORA-00312: online log 1 thread 1: '+DATA/stone/onlinelog/group_1.275.899664931'

ORA-00312: online log 1 thread 1: '+DATA/stone/onlinelog/group_1.261.899749329'

SQL> alter system switch logfile;

System altered.

SQL> alter database clear logfile group 1;

Database altered.

SQL> select l.group#,archived,member from v$log l join v$logfile f on l.group#=f.group#  order by 1;

    GROUP# ARC MEMBER

---------- --- --------------------------------------------------

         1 YES +DATA/stone/onlinelog/group_1.275.899664931

         1 YES +DATA/stone/onlinelog/group_1.261.899750189

         1 YES +FRA/stone/onlinelog/group_1.257.893370777

         2 NO  +DATA/stone/onlinelog/group_2.262.893370777

         2 NO  +FRA/stone/onlinelog/group_2.258.893370779

         3 YES +DATA/stone/onlinelog/group_3.263.893370779

         3 YES +FRA/stone/onlinelog/group_3.259.893370781

7 rows selected.


5、非归档模式下丢失数据文件

clipboard[5]

非归档模式下任何数据文件丢失需要进行数据库完全还原,包括控制文件和数据文件,且只能还原到上次备份的时候,必须重新录入备份之后的数据。具体步骤如下:

(1)关闭实例

(2)还原整个数据库


6、归档模式下丢失非关键数据文件

clipboard[6]

如果数据库处于归档模式,则只要丢失的数据文件不属于SYSTEM和UNDO表空间的非关键文件,只影响丢失数据文件的对象,其他数据文件仍然可用。且可以恢复到最后一次提交的时候。

例子:模拟数据文件丢失或者损坏,并进行恢复

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

ASMCMD> rm +DATA/stone/datafile/tbs_2.272.899478255

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area  889389056 bytes

Fixed Size                  2258360 bytes

Variable Size             868223560 bytes

Database Buffers           12582912 bytes

Redo Buffers                6324224 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 11 - see DBWR trace file

ORA-01110: data file 11: '+DATA/stone/datafile/tbs_2.272.899478255'

SQL> select name,error from v$datafile join v$recover_file using(file#);

NAME                                     ERROR

---------------------------------------- --------------------

+DATA/stone/datafile/tbs_2.272.899478255 FILE NOT FOUND

clipboard[7]

clipboard[8]

clipboard[9]

clipboard[10]

clipboard[11]

clipboard[12]

clipboard[13]

RMAN> list failure all;

using target database control file instead of recovery catalog

List of Database Failures

=========================

Failure ID Priority Status    Time Detected Summary

---------- -------- --------- ------------- -------

616        HIGH     OPEN      29-DEC-15     One or more non-system datafiles need media recovery

RMAN> advise failure;

List of Database Failures

=========================

Failure ID Priority Status    Time Detected Summary

---------- -------- --------- ------------- -------

616        HIGH     OPEN      29-DEC-15     One or more non-system datafiles need media recovery

analyzing automatic repair options; this may take some time

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=22 device type=DISK

analyzing automatic repair options complete

Automated Repair Options

========================

Option Repair Description

------ ------------------

1      Restore and recover datafile 11 

  Strategy: The repair includes complete media recovery with no data loss

  Repair script: /u01/app/oracle/diag/rdbms/stone/stone/hm/reco_882858745.hm

[root@oracletest1 ~]# cat /u01/app/oracle/diag/rdbms/stone/stone/hm/reco_882858745.hm

   # restore and recover datafile

   restore datafile 11;

   recover datafile 11;

   sql 'alter database datafile 11 online';


7、归档模式下丢失系统关键数据文件

clipboard[14]

丢失SYSTEM或者UNDO表空间的关键数据文件,需要在mount状态进行还原和恢复。

例子:模拟关键数据文件丢失或者损坏,并进行恢复

SQL> select file_name,file_id from dba_data_files where file_id=1;

FILE_NAME                                             FILE_ID

-------------------------------------------------- ----------

+DATA/stone/datafile/system.256.893370691                   1

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

ASMCMD> rm +DATA/stone/datafile/system.256.893370691

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area  889389056 bytes

Fixed Size                  2258360 bytes

Variable Size             868223560 bytes

Database Buffers           12582912 bytes

Redo Buffers                6324224 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '+DATA/stone/datafile/system.256.893370691'

SQL> select * from v$recover_file;

     FILE# ONLINE  ONLINE_ ERROR                   CHANGE# TIME

---------- ------- ------- -------------------- ---------- ------------

         1 ONLINE  ONLINE  FILE NOT FOUND                0

RMAN> list failure all;

using target database control file instead of recovery catalog

List of Database Failures

=========================

Failure ID Priority Status    Time Detected Summary

---------- -------- --------- ------------- -------

1199       CRITICAL OPEN      29-DEC-15     System datafile 1: '+DATA/stone/datafile/system.256.893370691' is missing

RMAN> advise failure;

List of Database Failures

=========================

Failure ID Priority Status    Time Detected Summary

---------- -------- --------- ------------- -------

1199       CRITICAL OPEN      29-DEC-15     System datafile 1: '+DATA/stone/datafile/system.256.893370691' is missing

analyzing automatic repair options; this may take some time

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=22 device type=DISK

analyzing automatic repair options complete

Not all specified failures can currently be repaired.

The following failures must be repaired before advise for others can be given.

Failure ID Priority Status    Time Detected Summary

---------- -------- --------- ------------- -------

1199       CRITICAL OPEN      29-DEC-15     System datafile 1: '+DATA/stone/datafile/system.256.893370691' is missing

Optional Manual Actions

=======================

1. If file +DATA/stone/datafile/system.256.893370691 was unintentionally renamed or moved, restore it

Automated Repair Options

========================

Option Repair Description

------ ------------------

1      Restore and recover datafile 1 

  Strategy: The repair includes complete media recovery with no data loss

  Repair script: /u01/app/oracle/diag/rdbms/stone/stone/hm/reco_2329703306.hm

RMAN> repair failure;

Strategy: The repair includes complete media recovery with no data loss

Repair script: /u01/app/oracle/diag/rdbms/stone/stone/hm/reco_2329703306.hm

contents of repair script:

   # restore and recover datafile

   restore datafile 1;

   recover datafile 1;

   sql 'alter database datafile 1 online';

Do you really want to execute the above repair (enter YES or NO)? yes

executing repair script

Starting restore at 29-DEC-15

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to +DATA/stone/datafile/system.256.893370691

channel ORA_DISK_1: reading from backup piece +FRA/stone/backupset/2015_12_29/nnndf0_tag20151229t162117_0.337.899742079

channel ORA_DISK_1: piece handle=+FRA/stone/backupset/2015_12_29/nnndf0_tag20151229t162117_0.337.899742079 tag=TAG20151229T162117

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:01:15

Finished restore at 29-DEC-15

Starting recover at 29-DEC-15

using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 138 is already on disk as file +FRA/stone/archivelog/2015_12_29/thread_1_seq_138.339.899749511

archived log for thread 1 with sequence 139 is already on disk as file +FRA/stone/archivelog/2015_12_29/thread_1_seq_139.340.899749883

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=137

channel ORA_DISK_1: reading from backup piece +FRA/stone/backupset/2015_12_29/annnf0_tag20151229t162422_0.334.899742263

channel ORA_DISK_1: piece handle=+FRA/stone/backupset/2015_12_29/annnf0_tag20151229t162422_0.334.899742263 tag=TAG20151229T162422

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=+FRA/stone/archivelog/2015_12_29/thread_1_seq_137.342.899753731 thread=1 sequence=137

channel default: deleting archived log(s)

archived log file name=+FRA/stone/archivelog/2015_12_29/thread_1_seq_137.342.899753731 RECID=136 STAMP=899753730

archived log file name=+FRA/stone/archivelog/2015_12_29/thread_1_seq_139.340.899749883 thread=1 sequence=139

media recovery complete, elapsed time: 00:00:05

Finished recover at 29-DEC-15

sql statement: alter database datafile 1 online

repair failure complete

SQL> alter database open;

Database altered.


8、数据问题

clipboard[15]

数据问题包括:

  • 不可访问的组件:数据文件丢失,不正确的权限,表空间离线
  • 物理损坏:块校验失败,无效的块头值
  • 逻辑损坏:数据字典不一致,错误行块,索引目录或者事务
  • 不一致:控制文件比数据文件和联机重做日志文件新或者旧
  • I/O问题:超过最大打开文件数目限制,不可访问的通道,网络或者I/O错误

以上问题都可以使用数据恢复顾问进行分析。


9、数据恢复顾问

clipboard[16]

使用数据恢复顾问步骤如下:

(1)健康管理器自动检测并将问题记录到ADR

(2)数据恢复顾问获取问题并列出

(3)获取修复建议

(4)选择和执行修复建议

(5)验证结果,使用VALIDATE命令

RMAN> validate database;


10、评估数据问题

clipboard[17]

通过健康监视器和数据恢复顾问评估数据问题。

clipboard[18]

clipboard[19]


11、数据问题

clipboard[20]

使用检查器检测数据问题,可以自动也可以主动,当数据库出现问题时,自动进行检查,也可以通过执行类似于VALIDATE DATABASE命令主动进行检查。


12、列出数据问题

clipboard[21]

“查看和管理故障”页面是数据恢复顾问的主页,此处列出了目前的问题,与使用RMAN命令list failure all一样。可以选择“建议”,“设置优先级”以及“关闭”问题。


13、修复建议

clipboard[22]

如果在“查看和管理故障”页面点击了“建议”,则会生成手动操作建议,例如如果是重命名导致的错误,通过将名字修改正确比使用RMAN进行恢复更快。手动修复后,可以点击“重新评估故障”,解决了的故障就会被关闭。点击“继续完成建议”进入自动恢复选项,与使用RMAN命令advise failure一样。


14、执行恢复

clipboard[23]

根据恢复后打开数据库。


15、数据恢复顾问视图

clipboard[24]

V$IR_FAILURE:列出所有的问题,包括关闭的,RMAN命令LIST FAILURE的结果

V$IR_MANUAL_CHECKLIST:列出需要手动操作的建议,RMAN命令ADVISE FAILURE的结果

V$IR_REPAIR:列出自动修复建议,RMAN命令ADVISE FAILURE的结果

V$IR_FAILURE_SET:是否只能手动修复


16、相关习题:

(1)In which of the scenario will the DBA perform recovery? (Choose all that apply.)
A.  The alert log file is corrupted
B.  A tablespace is accidentally dropped
C.  One of the redo log members is corrupted
D.  A database user terminates the session abnormally
E.  The hard disk on which the data files is stored is corrupted

答案:BE

(2)Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.
What would you do to recover the data file?
A.  Take the USERS tablespace offline and re-create the lost data file
B.  Shutdown the instance, restore the data file from the last consistent backup and restart the database instance
C.  Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance
D.  Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online

答案:C

(3)The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?
A. Inactive and current redo log files are required to accomplish recovery
B. Online and archived redo files are required to accomplish instance recovery
C. All redo log entries after the last checkpoint are applied from redo log files to data files
D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

答案:C

(4)View the Exhibit to examine the error that occurred during the database startup.
You  opened  an  RMAN  session  for  the  database.  To  repair  the  failure,  you  executed  the following command as the first RMAN command:
   RMAN> REPAIR FAILURE;
Which statement describes the consequence of this command?
clipboard[25]
A.  The command performs the recovery and closes the failure
B.  The command only displays the advice and the RMAN script required for recovery
C.  The  command  executes the  RMAN  script to  repair  the failure  and  remove the  entry from the  Automatic Diagnostic Repository (ADR)
D.  The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command

答案:D

(5)Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A.  The database files are corrupted when the database is open
B.  The user has dropped an important table that needs to be recovered
C.  The archived redo log files are missing for which the backup is not available
D.  The database is not opening because the required database files are missing

答案:AD

(6)The database instance is currently using SPFILE. View the Exhibit and examine the error that you  received  while  running  the  DB  Structure  Integrity  check.  Given  below  are  the  steps  to recover from the error in random order:

   1. Shut down the instance, if not already done.
   2. Copy one of the remaining control files to a new location.
   3.  Change  the  value of  the  CONTROL_FILES  initialization  parameter  to  correspond to the new location of the control files.
   4. Start up the database instance to the NOMOUNT stage.
   5. Recover the database to the point of failure of the control file.
   6. Open the database.
Identify the correct sequence of steps?

A.  1, 2, 4, 3, 5, 6
B.  2, 4, 3, 5, 6; 1 not required
C.  4, 5, 6, 2, 3; 1 not required
D.  5, 2, 3, 4; 1 and 6 not required

答案:A

(7)Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
A.  Recover from failures in the RAC environment.
B.  Diagnose and repair a data file corruption online.
C.  Diagnose and repair a data file corruption offline.
D.  Diagnose and repair failures on a standby database.

答案:AD

(8)Given below is a list of scenarios:
   1. A user terminates his session abnormally.
   2. The connection between the server and the client application terminates because of a network failure.
   3. A schema is accidentally dropped.
   4. The tablespace is accidentally dropped from the database.
   5. The hard disk gets corrupted and the data files in the disk are lost.
   6. The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
A. 1, 3, and 6
B. 4, 5, and 6
C. 3, 4, and 5
D. 1, 2, and 6

答案:C

(9)Which two kinds of  failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
A.  Failure when no standby database is configured
B.  Failure because a data file is renamed accidentally
C.  Failure that requires no archive logs to be applied for recovery
D.  Failure due to loss of connectivity-for example, an unplugged disk cable

答案:BD

(10)In which of the scenario will the DBA perform recovery? (Choose all that apply.)
A.  The alert log file is corrupted
B.  A tablespace is accidentally dropped
C.  One of the redo log members is corrupted
D.  A database user terminates the session abnormally
E.  The hard disk on which the data files is stored is corrupted

答案:BE

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28536251/viewspace-1990353/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-12-13

  • 博文量
    204
  • 访问量
    1078062