Oracle RAC 执行闪回数据库操作

　2013-01-23 18:00:57　来源：WEB开发网　　　

[oracle@zhongwc1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 23 17:02:01 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> set lines 200
SQL> select instance_name,host_name from v$instance;

INSTANCE_NAME HOST_NAME
---------------- ----------------------------------------------------------------
zhongwc1 zhongwc1.oracle.com

SQL> select instance_name,host_name from gv$instance;

INSTANCE_NAME HOST_NAME
---------------- ----------------------------------------------------------------
zhongwc1 zhongwc1.oracle.com
zhongwc2 zhongwc2.oracle.com

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
NO

SQL> show release
release 1102000300
SQL> alter database flashback on;

Database altered.

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
YES

SQL> conn zwc
Enter password:
Connected.
SQL> create table t_zhongwc as select * from dba_objects;

Table created.

SQL> select count(*) from t_zhongwc;

COUNT(*)
----------
75289

SQL>

记录当前的scn(oracle11gR2可以在open状态flashback on)
SQL> select current_scn from v$database;

CURRENT_SCN
-----------
1395475

截断t_zhongwc表
SQL> truncate table t_zhongwc;

Table truncated.

SQL> select count(*) from t_zhongwc;

COUNT(*)
----------
0

开始执行闪回,关闭所有实例，启动zhongwc1到mount,闪回到scn 1395475,以只读模式打开验证
[oracle@zhongwc1 ~]$ srvctl stop database -d zhongwc
[oracle@zhongwc1 ~]$ su - grid -c "crsctl stat res -t"
Password:
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE zhongwc1
ONLINE ONLINE zhongwc2
ora.DATADG.dg
ONLINE ONLINE zhongwc1
ONLINE ONLINE zhongwc2
ora.FRADG.dg
ONLINE ONLINE zhongwc1