startup nomount;
alter database mount;
/export/home/oracle/9i/dbs/pfileECOM.ora
*._ALLOW_RESETLOGS_CORRUPTION='TRUE'
*.undo_management='manual'
startup mount pfile='/export/home/oracle/9i/dbs/pfileECOM.ora';
# 查看实例状态
select status from v$instance;
alter database open;
# 手工切换日志
alter system switch logfile;
# 查看当前日志
select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- ------ -------------------------------- ------------- ---------
1 1 0 1048576 1 YES UNUSED 0
2 1 0 1048576 1 YES UNUSED 0
3 1 1 1048576 1 NO CURRENT 13935560 30-MAR-08
# 非当前日志恢复
alter database clear unarchived logfile group 1 unrecoverable datafile;
or
alter database clear unarchived logfile group 1 ;
alter database clear unarchived logfile group 2 unrecoverable datafile;
or
alter database clear unarchived logfile group 2 ;
# 当前日志恢复
recover database using backup controlfile until cancel;
alter database clear unarchived logfile group 3 unrecoverable datafile;
or
alter database clear unarchived logfile group 3 ;
alter database open resetlogs ;
# alter database open NORESETLOGS;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8806316/viewspace-1001673/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8806316/viewspace-1001673/