1.Repair failure should follow steps
(a) list failure
(b) advise failure
(c) Repair failure
(a) list failure
(b) advise failure
(c) Repair failure
RMAN> list failure; List of Database Failures ========================= Failure ID Priority Status Time Detected Summary ---------- -------- --------- ------------- ------- 548 HIGH OPEN 09-JUN-14 Tablespace 4: 'USERS' is offline 542 HIGH OPEN 09-JUN-14 One or more non-system datafiles are offline RMAN> repair failure; Strategy: The repair includes complete media recovery with no data loss Repair script: /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/hm/reco_1312477392.hm contents of repair script: # online a offline tablespace sql "begin sys.dbms_ir.execsqlscript(filename => ''/u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/hm/reco_3578264930.hm'' ); end;"; Do you really want to execute the above repair (enter YES or NO)? yes executing repair script sql statement: begin sys.dbms_ir.execsqlscript(filename => ''/u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/hm/reco_3578264930.hm'' ); end; repair failure complete RMAN> list failure; no failures found that match specification
No comments:
Post a Comment