Oracle-RAC-执行闪回数据库操作

[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: