Oracle 12c-ocm 题库 skillset5
免费下载
更多 IT 认证课程请访问 美河学习在线 www.eimhe.com
Skillset5
TASKS:
0. PROD2 was destroyed again (implied)
0.1 The data file that belongs to the system tablespace is deleted
0.2 The controlfile is deleted
[oracle@edbjr2p1 ~]$ export ORACLE_SID=PROD2
[oracle@edbjr2p1 ~]$ ss
SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 11 18:30:47 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@PROD2>startup
ORACLE instance started.
Total System Global Area 175775744 bytes
Fixed Size 1343668 bytes
Variable Size 117444428 bytes
Database Buffers 50331648 bytes
Redo Buffers 6656000 bytes
ORA-00205: error in identifying control file, check alert log for more info
SYS@PROD2>exit
[oracle@edbjr2p1 ~]$
[oracle@edbjr2p1 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Sun Oct 11 18:31:18 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD2 (not mounted)
RMAN> list failure;
using target database control file instead of recovery catalog
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
102 CRITICAL OPEN 11-OCT-15 Control file /u01/app/oracle/oradata/PROD2/control01.ctl is missing
RMAN> repair failure;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of repair command at 10/11/2015 18:31:40
RMAN-06954: REPAIR command must be preceded by ADVISE command in same session
RMAN> advise failure;
更多 IT 认证课程请访问 美河学习在线 www.eimhe.com
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
102 CRITICAL OPEN 11-OCT-15 Control file /u01/app/oracle/oradata/PROD2/control01.ctl is 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
Mandatory Manual Actions
========================
no manual actions available
Optional Manual Actions
=======================
no manual actions available
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Use a multiplexed copy to restore control file /u01/app/oracle/oradata/PROD2/control01.ctl
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/prod2/PROD2/hm/reco_2602954565.hm
RMAN> repair failure;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/prod2/PROD2/hm/reco_2602954565.hm
contents of repair script:
# restore control file using multiplexed copy
restore controlfile from '/u01/app/oracle/fast_recovery_area/PROD2/control02.ctl';
sql 'alter database mount';
Do you really want to execute the above repair (enter YES or NO)? yes
executing repair script
Starting restore at 11-OCT-15
using channel ORA_DISK_1
channel ORA_DISK_1: copied control file copy
output file name=/u01/app/oracle/oradata/PROD2/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/PROD2/control02.ctl
Finished restore at 11-OCT-15
sql statement: alter database mount
released channel: ORA_DISK_1
repair failure complete
RMAN> list failure;
of 14
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论