Oracle 12c-ocm 题库 skillset3
免费下载
更多 IT 认证课程请访问 美河学习在线 www.eimhe.com
Skillset3
TASKS:
Questition:
0. PROD2 is corrupted(Implicit subject)
1.1 Redo log is deleted.
1.2 The datafile in the tablespace of users is deteted.
[oracle@edbjr2p1 ~]$ sqlplus / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/u01/app/oracle/oradata/PROD2/users01.dbf'
[oracle@edbjr2p1 PROD2]$ rman target /
connected to target database: PROD2 (DBID=1512727797, not open)
RMAN> list failure;
using target database control file instead of recovery catalog
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
207 CRITICAL OPEN 06-OCT-15 Redo log group 3 is unavailable
315 HIGH OPEN 06-OCT-15 Redo log file /u01/app/oracle/oradata/PROD2/redo03.log is missing
204 HIGH OPEN 06-OCT-15 Redo log file /u01/app/oracle/oradata/PROD2/redo03.log is corrupt
121 HIGH OPEN 05-OCT-15 One or more non-system datafiles need media recovery
68 HIGH OPEN 05-OCT-15 One or more non-system datafiles are missing
RMAN> advise failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
207 CRITICAL OPEN 06-OCT-15 Redo log group 3 is unavailable
315 HIGH OPEN 06-OCT-15 Redo log file /u01/app/oracle/oradata/PROD2/redo03.log is missing
204 HIGH OPEN 06-OCT-15 Redo log file /u01/app/oracle/oradata/PROD2/redo03.log is corrupt
121 HIGH OPEN 05-OCT-15 One or more non-system datafiles need media recovery
68 HIGH OPEN 05-OCT-15 One or more non-system datafiles are missing
analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
analyzing automatic repair options complete
更多 IT 认证课程请访问 美河学习在线 www.eimhe.com
Mandatory Manual Actions
========================
no manual actions available
Optional Manual Actions
=======================
1. If file /u01/app/oracle/oradata/PROD2/redo03.log was unintentionally renamed or moved, restore it
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Perform incomplete database recovery to SCN 939638
Strategy: The repair includes point-in-time recovery with some data loss
Repair script: /u01/app/oracle/diag/rdbms/prod2/PROD2/hm/reco_1930275487.hm
RMAN> repair failure;
Strategy: The repair includes point-in-time recovery with some data loss
Repair script: /u01/app/oracle/diag/rdbms/prod2/PROD2/hm/reco_1930275487.hm
contents of repair script:
# database point-in-time recovery
restore database until scn 939638;
recover database until scn 939638;
alter database open resetlogs;
Do you really want to execute the above repair (enter YES or NO)? yes
executing repair script
Starting restore at 06-OCT-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 /u01/app/oracle/oradata/PROD2/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/PROD2/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/PROD2/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/PROD2/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/PROD2/example01.dbf
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/fast_recovery_area/PROD2/backupset/2015_10_06/o1_mf_nnndf_TAG20151006T000839_c1584865_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/fast_recovery_area/PROD2/backupset/2015_10_06/o1_mf_nnndf_TAG20151006T000839_c158486
5_.bkp tag=TAG20151006T000839
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:19
Finished restore at 06-OCT-15
Starting recover at 06-OCT-15
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:02
Finished recover at 06-OCT-15
database opened
of 12
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论