Active Dataguard Configuration

Active Dataguard

SQL> select * from v$restore_point;

       SCN DATABASE_INCARNATION# GUA STORAGE_SIZE
---------- --------------------- --- ------------
TIME
---------------------------------------------------------------------------
RESTORE_POINT_TIME                                                          PRE
--------------------------------------------------------------------------- ---
NAME
--------------------------------------------------------------------------------
5.9853E+12                     2 YES   1.6781E+11
07-JUL-12 12.35.01.000000000 PM
                                                                            YES
BEFORE_R2_SCR_KSC


SQL> select instance_name, status, host_name from v$instance;

INSTANCE_NAME    STATUS       HOST_NAME
---------------- ------------ ----------------------------------------------------------------
pbpn1k           OPEN         cds2ksc16


SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter system set dg_broker_start=false scope=both;

System altered.


SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT
ORACLE instance started.

Total System Global Area 2.6732E+10 bytes
Fixed Size                  2170944 bytes
Variable Size            5771370432 bytes
Database Buffers         2.0670E+10 bytes
Redo Buffers              288612352 bytes
Database mounted.


SQL> drop restore point BEFORE_R2_SCR_KSC;

Restore point dropped.

SQL> select * from v$restore_point order by scn;

no rows selected

SQL> ALTER DATABASE FLASHBACK off;

Database altered.

SQL> SELECT flashback_on, log_mode FROM v$database;

FLASHBACK_ON       LOG_MODE
------------------ ------------
NO                 ARCHIVELOG

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database open read only;

Database altered.

SQL> !ps -ef | grep mrp
  oracle 18550  8819   0 13:55:23 pts/2       0:00 grep mrp

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY WITH APPLY

SQL> !ps -ef | grep mrp
  oracle 18665  8819   0 13:55:52 pts/2       0:00 grep mrp
  oracle 18576     1   0 13:55:34 ?           0:00 ora_mrp0_pbpn1k

SQL> alter system set dg_broker_start=true scope=both;

System altered.

SQL> !ps -ef | grep dmon
  oracle 18872     1   0 13:56:59 ?           0:00 ora_dmon_pbpn1k
  oracle 19370  8819   0 13:57:05 pts/2       0:00 grep dmon

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE                          0                         0               0
REDO LOG                              0                         0               0
ARCHIVED LOG                          0                         0               0
BACKUP PIECE                        .04                         0               2
IMAGE COPY                            0                         0               0
FLASHBACK LOG                         0                         0               0
FOREIGN ARCHIVED LOG                  0                         0               0

SQL> select process, status, sequence# from v$managed_standby;

PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
ARCH      CONNECTED             0
ARCH      CLOSING           55393
ARCH      CONNECTED             0
ARCH      CLOSING           55392
RFS       IDLE                  0
RFS       IDLE              55394
RFS       IDLE                  0
MRP0      APPLYING_LOG      55394


Archive Used

select name,total_mb/1024,free_mb/1024,(free_mb/total_mb)*100 "%Free" from v$asm_diskgroup;

ps -ef | grep rman