svrmgrl
svrmgrl>connect internal
svrmgrl>startup mount
svrmgrl>recover database until 'yyyy-mm-dd:hh:mm:ss';-修改前的时间
svrmgrl>alter database open resetlogs;
Media Recovery Start
WARNING! Recovering data file 11 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 12 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 13 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 14 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 15 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 16 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER database
...
Wed Oct 20 14:16:15 2004
ALTER DATABASE RECOVER LOGFILE 'aaa.log'
Media Recovery Log aaa.log
ORA-308 signalled during: ALTER DATABASE RECOVER LOGFILE 'aaa.log' ...
Wed Oct 20 14:16:15 2004
ALTER DATABASE RECOVER CANCEL
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL
Wed Oct 20 14:17:53 2004
Starting ORACLE instance (normal)
Wed Oct 20 14:18:46 2004
ALTER DATABASE RECOVER database
Wed Oct 20 14:18:46 2004
Media Recovery Start
WARNING! Recovering data file 11 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 12 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 13 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 14 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 15 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 16 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER database
...
Wed Oct 20 14:21:04 2004
ALTER DATABASE RECOVER CONTINUE DEFAULT
Wed Oct 20 14:21:04 2004
Media Recovery Log D:\ORANT\RDBMS80\ARC4540.1
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Wed Oct 20 14:21:04 2004
ALTER DATABASE RECOVER CANCEL
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL