SQL>shutdown immediate;
cmd > rman nocatalog

RMAN > connect target /

RMAN>STARTUP MOUNT;
RMAN>DELETE ARCHIVELOG ALL; // 删除所有归档日志
RMAN>CROSSCHECK ARCHIVE LOG ALL; // 对归档做一致性检查

RMAN>CROSSCHECK ARCHIVE LOG ALL; // 对归档做一致性检查
RMAN> exit;
退出RMAN
cmd> SQLPLUS /nolog
SQL>conn /as sysdba;
SQL>shutdown immediate;
SQL>STARTUP
一切恢复正常
网友评论