drdb2
作者drdb2·2012-11-08 03:38
系统工程师·se

RMAN experiemnt demo: recover of missing a datafile

字数 1118阅读 1906评论 0赞 0
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 11/07/2012 13:18:18
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file

RMAN> list failure;
List of Database Failures
=========================
Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
515922     HIGH     OPEN      07-NOV-12     One or more non-system datafiles are missing

RMAN> advise failure;
....
Automated Repair Options
========================
Option Repair Description
------ ------------------
1      Restore and recover datafile 12 
  Strategy: The repair includes complete media recovery with no data loss
...
#repair  failure;
RMAN> restore datafile 12;
RMAN> recover datafile 12;
RMAN> alter database open;

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关资料

X社区推广