UNDO--shutdown abort,UNDO文件丢失,有备份,数据库无活动事务

UNDO--shutdown abort,UNDO文件丢失,有备份,数据库无活动事务

没有活动事务，直接使用备份CP回来覆盖就行了

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     1
Next log sequence to archive   2
Current log sequence           2
SQL> alter tablespace undotbs1 begin backup;

Tablespace altered.

SQL> host cp /u01/app/oracle/oradata/shujukuai/undotbs01.dbf /u01/app/oracle/oradata/shujukuai/undotbs01.bak

SQL> alter tablespace undotbs1 end backup;

Tablespace altered.

SQL> shutdown abort;
ORACLE instance shut down.
SQL> host vi /u01/app/oracle/oradata/shujukuai/undotbs01.dbf

这里破坏UNDO文件

:%!xxd

/20000 修改00a2

保存退出

SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  2083368 bytes
Variable Size             113247704 bytes
Database Buffers          163577856 bytes
Redo Buffers                6303744 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/u01/app/oracle/oradata/shujukuai/undotbs01.dbf'

SQL> col error for a20
SQL> select file#,error,name from v$datafile_header;

     FILE# ERROR                NAME
---------- -------------------- -------------------------------------------------------
         1                      /u01/app/oracle/oradata/shujukuai/system01.dbf
         2 FILE NOT FOUND
         3                      /u01/app/oracle/oradata/shujukuai/sysaux01.dbf
         4                      /u01/app/oracle/oradata/shujukuai/users01.dbf

SQL> host cp /u01/app/oracle/oradata/shujukuai/undotbs01.bak /u01/app/oracle/oradata/shujukuai/undotbs01.dbf

SQL> select file#,error,name from v$datafile_header;

     FILE# ERROR                NAME
---------- -------------------- -------------------------------------------------------
         1                      /u01/app/oracle/oradata/shujukuai/system01.dbf
         2                      /u01/app/oracle/oradata/shujukuai/undotbs01.dbf
         3                      /u01/app/oracle/oradata/shujukuai/sysaux01.dbf
         4                      /u01/app/oracle/oradata/shujukuai/users01.dbf

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: '/u01/app/oracle/oradata/shujukuai/undotbs01.dbf'

SQL> recover datafile 2;
Media recovery complete.
SQL> alter database datafile 2 online;

Database altered.

SQL> alter database open;

Database altered.

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

转载于:http://blog.itpub.net/21158541/viewspace-667396/