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>
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博客 ” ，链接：https://blog.itpub.net/22741583/viewspace-683925/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
RMAN系列-数据文件恢复
下一篇：
RMAN系列-控制文件丢失
请登录后发表评论
登录
全部评论
