Oracle RMAN Recover中使用BBED跳过缺失的归档继续Recover的测试(三)
Size 436208104 bytes
Database Buffers 276824064 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
SQL>
库终于拉起来了。
2.9 验证
SQL> select name,checkpoint_change# fromv$datafile;
NAME CHECKPOINT_CHANGE#
-------------------------------------------------------------------------
/u01/app/oracle/oradata/dave/system.256.816661027 3857521
/u01/app/oracle/oradata/dave/sysaux.257.816661033 3857521
/u01/app/oracle/oradata/dave/undotbs1.dbf 3857521
/u01/app/oracle/oradata/dave/users.259.816661039 3857521
/u01/app/oracle/oradata/dave/undotbs2.265.816661787 3857521
/u01/app/oracle/oradata/dave/dave01.dbf 3857521
/u01/app/oracle/oradata/dave/dave02.dbf 3857521
7 rows selected.
SQL> select name,checkpoint_change# fromv$datafile_header;
NAME CHECKPOINT_CHANGE#
-------------------------------------------------------------------------
/u01/app/oracle/oradata/dave/system.256.816661027 3857521
/u01/app/oracle/oradata/dave/sysaux.257.816661033 3857521
/u01/app/oracle/oradata/dave/undotbs1.dbf 3857521
/u01/app/oracle/oradata/dave/users.259.816661039 3857521
/u01/app/oracle/oradata/dave/undotbs2.265.816661787 3857521
/u01/app/oracle/oradata/dave/dave01.dbf 3857521
/u01/app/oracle/oradata/dave/dave02.dbf 3857521
7 rows selected.
SQL> select checkpoint_change# fromv$database;
CHECKPOINT_CHANGE#
------------------
3857521
SQL> select count(1) from dave1;
select count(1) from dave1
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select count(1) from dave2;
select count(1) from dave2
*
ERROR at line 1:
ORA-00942: table or view does not exist
库是正常拉起来了，不过之前创建的表都没有成功恢复。