RMAN系列-redo丢失（redo丢失在sqlplus中恢复）

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size             100664936 bytes
Database Buffers          176160768 bytes
Redo Buffers                7168000 bytes
Database mounted.
SQL> recover database until cancel;
Media recovery complete.

SQL> alter database open resetlogs; ---------resetlogs会把online redo清空做好全备份-----

Database altered.
SQL>

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

转载于:http://blog.itpub.net/22741583/viewspace-683925/