oracle_redo*log,被移动后的恢复

oracle_redo*log,被移动后的恢复[@more@]

startup nomount;
alter database mount;
or

/export/home/oracle/9i/dbs/pfileECOM.ora
*._ALLOW_RESETLOGS_CORRUPTION='TRUE'
*.undo_management='manual'

startup mount pfile='/export/home/oracle/9i/dbs/pfileECOM.ora';
# 手工切换日志
alter database open;
alter system switch logfile;
alter database clear unarchived logfile group 3 ;
alter database clear unarchived logfile group 2 unrecoverable datafile;

recover database using backup controlfile until cancel;
alter database open resetlogs ;
# alter database open NORESETLOGS;

select TABLESPACE_NAME,STATUS from dba_tablespaces where TABLESPACE_NAME like 'UNDO%';
create undo tablespace undotbs3 datafile '/data/oradata/ECOM/undotbs2.dbf' size 500m;

# under undo_management='auto'
alter system set UNDO_TABLESPACE=undotbs2;

# under undo_management='manul'
vi /export/home/oracle/9i/dbs/pfileECOM.ora
*.undo_tablespace='UNDOTBS2'
startup pfile='/export/home/oracle/9i/dbs/pfileECOM.ora';

create spfile='/export/home/oracle/9i/dbs/spfileECOM.ora' from pfile='/export/home/oracle/9i/dbs/pfileECOM.ora';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8806316/viewspace-1001672/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8806316/viewspace-1001672/