恢复后,需要验证数据文件及内容是否可用,主库的变化是否可以继续同步到备库;
1.察看表空间情况
[oracle@dbserver sztech1]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 24 17:24:32 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect / as sysdba Connected. SQL> SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS ------------------------------ --------- SYSTEM ONLINE SYSAUX ONLINE UNDOTBS1 ONLINE TEMP ONLINE USERS ONLINE EXAMPLE ONLINE
2.在users表空间上的内容进行变化
[oracle@dbserver sztech1]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 24 17:24:32 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn hr/hr Connected. SQL> select table_name,tablespace_name from tabs;
TABLE_NAME TABLESPACE_NAME ------------------------------ ------------------------------ COUNTRIES JOB_HISTORY EXAMPLE EMPLOYEES EXAMPLE JOBS EXAMPLE DEPARTMENTS EXAMPLE LOCATIONS EXAMPLE REGIONS EXAMPLE DEPT USERS EMP USERS
删除99行数据
SQL> delete from emp where rownum<100;
99 rows deleted.
SQL> commit;
Commit complete.
SQL> select count(*) from emp;
COUNT(*) ---------- 8
SQL> conn / as sysdba Connected.
进行日志切换:
SQL> alter system switch logfile;
System altered.
SQL> r 1* alter system switch logfile
System altered.
SQL>
3.备库上验证数据是否同步
[oracle@auxdb ~]$ sqlplus /nolog co SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 24 17:27:59 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> nnect / as sysdba Connected. SQL> conn hr/hr Connected. SQL> select count(*) from emp;
COUNT(*) ---------- 8
SQL>
和数据一致。
说明数据同步没有问题。使用备库的备份,用于恢复主库,不影响主备关系。
其实,这里是物理备库,备库就是主库的一个克隆。所以,备库的备份可以直接在主库使用 。只是事先需要catalog一下,否则主库认不到这些备份而已。
|