Oracle RAC 执行闪回数据库操作

核心提示：ONLINE ONLINE zhongwc2 ora.LISTENER.lsnr ONLINE ONLINE zhongwc1 ONLIN

ONLINE ONLINE zhongwc2
ora.LISTENER.lsnr
ONLINE ONLINE zhongwc1
ONLINE ONLINE zhongwc2
ora.asm
ONLINE ONLINE zhongwc1 Started
ONLINE ONLINE zhongwc2 Started
ora.gsd
OFFLINE OFFLINE zhongwc1
OFFLINE OFFLINE zhongwc2
ora.net1.network
ONLINE ONLINE zhongwc1
ONLINE ONLINE zhongwc2
ora.ons
ONLINE ONLINE zhongwc1
ONLINE ONLINE zhongwc2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE zhongwc1
ora.cvu
1 ONLINE ONLINE zhongwc1
ora.oc4j
1 ONLINE ONLINE zhongwc1
ora.scan1.vip
1 ONLINE ONLINE zhongwc1
ora.zhongwc.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.zhongwc1.vip
1 ONLINE ONLINE zhongwc1
ora.zhongwc2.vip
1 ONLINE ONLINE zhongwc2
[oracle@zhongwc1 ~]$

[oracle@zhongwc1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 23 17:22:40 2013

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

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1269366784 bytes
Fixed Size 2227984 bytes
Variable Size 889192688 bytes
Database Buffers 369098752 bytes
Redo Buffers 8847360 bytes
Database mounted.
SQL> flashback database to scn 1395475;

Flashback complete.

SQL> alter database open read only;

Database altered.

SQL> conn zwc
Enter password:
Connected.
SQL> select count(*) from t_zhongwc;

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

resetlogs打开数据库,启动zhongwc2
SQL> shutdown immediate
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.