[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

SQL> truncate table t_zhongwc;

Table truncated.

SQL> select count(*) from t_zhongwc;

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

[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                                     
               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.oc