7 Replies Latest reply on Jun 17, 2012 7:19 AM by Mrshah-Oracle

    Dataguard Setup

    Mrshah-Oracle
      Hi Guys,

      I am trying to setup an physical standby across 2 locations in different cities. used RMAN duplicate command to setup an standby database on DR location.

      Now once RMAN completed, we executed alter database recover managed standby database using current logfile command..

      On standby database it shows:

      SQL> archive log list;
      Database log mode Archive Mode
      Automatic archival Enabled
      Archive destination USE_DB_RECOVERY_FILE_DEST
      Oldest online log sequence 0
      Next log sequence to archive 0
      Current log sequence 0

      and on primary current sequence is 3395

      Also on standby

      select PROCESS,STATUS,THREAD#,SEQUENCE#,BLOCK#,DELAY_MINS from v$managed_standby where process like 'MRP%';

      PROCESS STATUS THREAD# SEQUENCE# BLOCK# DELAY_MINS
      -----------------------------
      MRP0 WAIT_FOR_LOG 1 3788 0 0

      Not sure what is the issue, please suggest..

      Thanks and Regards!
        • 1. Re: Dataguard Setup
          CKPT
          Hello,

          Looks like dataguard parameters not configured properly,
          Can you post below link mentioned scripts in coded format.

          http://www.oracle-ckpt.com/dataguard_troubleshoot_snapper/
          • 2. Re: Dataguard Setup
            mseberg
            Hello;

            Not sure if I understand the question correctly but willing to share my notes :

            For Cascading Standby

            http://www.visi.com/~mseberg/Data_Guard_Cascading_Standby_Setup_and_Test.pdf

            For general setup

            http://www.visi.com/~mseberg/data_guard_on_oracle_10_step_by_step.html

            http://www.visi.com/~mseberg/data_guard_on_oracle_11_step_by_step.html

            http://www.visi.com/~mseberg/duprman2.html

            Best Regards

            mseberg
            1 person found this helpful
            • 3. Re: Dataguard Setup
              Mrshah-Oracle
              Hi,

              I just gathered the reports from both env, just an off the topic question, how can i put here in coded form? so tables are shown properly ?

              Regards!
              • 4. Re: Dataguard Setup
                Mrshah-Oracle
                Thanks for the reply guys..

                On Primary database:

                SQL> SELECT name, display_value FROM v$parameter WHERE name IN ('db_name','db_unique_name','log_archive_config','log_archive_dest_2','log_archive_dest_state_2','fal_client','fal_server','standby_file_management','standby_archive_dest','db_file_name_convert','log_file_name_convert','remote_login_passwordfile','local_listener','dg_broker_start','dg_broker_config_file1','dg_broker_config_file2','log_archive_max_processes') order by name;

                NAME DISPLAY_VALUE
                ------------------------------ ------------------------------
                db_file_name_convert
                db_name orcl
                db_unique_name orcl
                dg_broker_config_file1 D:\SOFTWARES\ORACLE11GR2DB\PRO
                DUCT\11.2.0\DBHOME_1\DATABASE\
                DR1ORCL.DAT

                dg_broker_config_file2 D:\SOFTWARES\ORACLE11GR2DB\PRO
                DUCT\11.2.0\DBHOME_1\DATABASE\
                DR2ORCL.DAT

                dg_broker_start FALSE
                fal_client
                fal_server
                local_listener LISTENER_ORCL
                log_archive_config dg_config=(orcl,dr)
                log_archive_dest_2 service=dr async valid_for=(on
                line_logfile,primary_role) db_
                unique_name=dr

                log_archive_dest_state_2 enable
                log_archive_max_processes 4
                log_file_name_convert
                remote_login_passwordfile EXCLUSIVE
                standby_archive_dest %ORACLE_HOME%\RDBMS
                standby_file_management MANUAL
                SQL> col name for a10
                SQL> col DATABASE_ROLE for a10
                SQL> SELECT name,db_unique_name,protection_mode,DATABASE_ROLE,OPEN_MODE,switchover_status from v$database;

                NAME DB_UNIQUE_NAME PROTECTION_MODE DATABASE_R OPEN_MODE SWITCHOVER_STATUS
                ---------- ------------------------------ -------------------- ---------- -------------------- --------------------
                ORCL orcl MAXIMUM PERFORMANCE PRIMARY READ WRITE RESOLVABLE GAP
                SQL> select thread#,max(sequence#) from v$archived_log group by thread#;

                THREAD# MAX(SEQUENCE#)
                ---------- --------------
                1 3798
                SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
                2 FROM
                3 (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
                4 (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
                5 WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;

                Thread Last Sequence Received Last Sequence Applied Difference
                ---------- ---------------------- --------------------- ----------
                1 3798 3798 0
                SQL> col severity for a15
                SQL> col message for a70
                SQL> col timestamp for a20
                SQL> select severity,error_code,to_char(timestamp,'DD-MON-YYYY HH24:MI:SS') "timestamp" , message from v$dataguard_status where dest_id=2;

                SEVERITY ERROR_CODE timestamp MESSAGE
                --------------- ---------- -------------------- ----------------------------------------------------------------------
                Error 16058 16-JUN-2012 21:30:15 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:39:52 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:40:53 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:41:53 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:42:54 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:43:54 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:44:55 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:45:55 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:46:56 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:47:56 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.


                SEVERITY ERROR_CODE timestamp MESSAGE
                --------------- ---------- -------------------- ----------------------------------------------------------------------
                Error 16058 16-JUN-2012 22:48:57 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:49:57 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:50:58 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:51:58 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:52:59 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:54:00 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:55:00 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:56:01 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:57:01 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:58:02 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 22:59:02 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:00:03 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:01:03 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:02:04 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:03:05 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:04:05 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                SEVERITY ERROR_CODE timestamp MESSAGE
                --------------- ---------- -------------------- ----------------------------------------------------------------------

                Error 16058 16-JUN-2012 23:05:06 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:06:06 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:07:07 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:08:07 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:09:08 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:10:08 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:11:09 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:12:12 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:13:13 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:14:13 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:15:14 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:16:14 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:17:15 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:18:16 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:19:16 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:20:16 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605

                SEVERITY ERROR_CODE timestamp MESSAGE
                --------------- ---------- -------------------- ----------------------------------------------------------------------
                8.

                Error 16058 16-JUN-2012 23:21:17 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:22:18 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:23:18 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:24:19 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:25:19 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:26:20 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:27:20 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:28:21 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:29:21 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:30:22 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:31:22 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:32:23 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:33:23 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:34:24 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:35:24 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.


                SEVERITY ERROR_CODE timestamp MESSAGE
                --------------- ---------- -------------------- ----------------------------------------------------------------------
                8.

                Error 16058 16-JUN-2012 23:48:31 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:49:32 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:50:32 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:51:33 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                SEVERITY ERROR_CODE timestamp MESSAGE
                --------------- ---------- -------------------- ----------------------------------------------------------------------

                Error 16058 16-JUN-2012 23:52:33 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:53:34 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:54:35 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:55:35 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:56:36 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:57:36 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:58:37 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 16-JUN-2012 23:59:37 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 00:00:38 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 00:01:39 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 00:02:39 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:10:52 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:11:52 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:12:53 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:13:54 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:14:54 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:15:55 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:16:55 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:17:56 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:18:56 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:19:57 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:20:57 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:21:58 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:22:59 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:23:59 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:25:00 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                SEVERITY ERROR_CODE timestamp MESSAGE
                --------------- ---------- -------------------- ----------------------------------------------------------------------

                Error 16058 17-JUN-2012 01:26:00 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:27:01 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:28:01 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:29:02 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:30:03 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:31:03 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:32:04 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:33:05 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:34:06 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                Error 16058 17-JUN-2012 01:35:06 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 1605
                8.

                SQL> select ds.dest_id id
                2 , ad.status
                3 , ds.database_mode db_mode
                4 , ad.archiver type
                5 , ds.recovery_mode
                6 , ds.protection_mode
                7 , ds.standby_logfile_count "SRLs"
                8 , ds.standby_logfile_active active
                9 , ds.archived_seq#
                10 from v$archive_dest_status ds
                11 , v$archive_dest ad
                12 where ds.dest_id = ad.dest_id
                13 and ad.status != 'INACTIVE'
                14 order by
                15 ds.dest_id;

                ID STATUS DB_MODE TYPE RECOVERY_MODE PROTECTION_MODE SRLs ACTIVE ARCHIVED_SEQ#
                --- --------- --------------- ---- -------------------- -------------------- ---- ------ -------------
                1 VALID OPEN ARCH IDLE MAXIMUM PERFORMANCE 0 0 3798
                2 ERROR UNKNOWN LGWR IDLE MAXIMUM PERFORMANCE 0 0 0
                SQL> column FILE_TYPE format a20
                SQL> col name format a60
                SQL> select name
                2 , floor(space_limit / 1024 / 1024) "Size MB"
                3 , ceil(space_used / 1024 / 1024) "Used MB"
                4 from v$recovery_file_dest
                5 order by name;

                NAME Size MB Used MB
                ------------------------------------------------------------ ---------- ----------
                D:\Softwares\Oracle11gR2DB\flash_recovery_area 3912 282
                SQL> spool off
                • 5. Re: Dataguard Setup
                  Mrshah-Oracle
                  On Standby database:

                  SQL> set feedback off
                  SQL> set trimspool on
                  SQL> set line 500
                  SQL> set pagesize 50
                  SQL> set linesize 200
                  SQL> column name for a30
                  SQL> column display_value for a30
                  SQL> col value for a10
                  SQL> col PROTECTION_MODE for a15
                  SQL> col DATABASE_Role for a15
                  SQL> SELECT name, display_value FROM v$parameter WHERE name IN ('db_name','db_unique_name','log_archive_config','log_archive_dest_2','log_archive_dest_state_2','fal_client','fal_server','standby_file_management','standby_archive_dest','db_file_name_convert','log_file_name_convert','remote_login_passwordfile','local_listener','dg_broker_start','dg_broker_config_file1','dg_broker_config_file2','log_archive_max_processes') order by name;

                  NAME DISPLAY_VALUE
                  ------------------------------ ------------------------------
                  db_file_name_convert D:\SOFTWARES\ORACLE11GR2DB\DAT
                  AFILES\, D:\app\ShrenikSh\orad
                  ata\dr\, D:\SOFTWARES\ORACLE11
                  GR2DB\ORADATA\ORCL\, D:\app\Sh
                  renikSh\oradata\dr\

                  db_name orcl
                  db_unique_name dr
                  dg_broker_config_file1 D:\APP\SHRENIKSH\PRODUCT\11.2.
                  0\DBHOME_1\DATABASE\DR1DR.DAT

                  dg_broker_config_file2 D:\APP\SHRENIKSH\PRODUCT\11.2.
                  0\DBHOME_1\DATABASE\DR2DR.DAT

                  dg_broker_start FALSE
                  fal_client dr
                  fal_server orcl
                  local_listener DR
                  log_archive_config dg_config=(orcl,dr)
                  log_archive_dest_2 service=orcl ASYNC valid_for=(
                  ONLINE_LOGFILE,PRIMARY_ROLE) d
                  b_unique_name=orcl

                  log_archive_dest_state_2 enable
                  log_archive_max_processes 5
                  log_file_name_convert D:\Softwares\Oracle11gR2DB\ora
                  data\orcl\, D:\app\ShrenikSh\o
                  radata\dr\

                  remote_login_passwordfile EXCLUSIVE
                  standby_archive_dest %ORACLE_HOME%\RDBMS
                  standby_file_management AUTO
                  SQL> col name for a10
                  SQL> col DATABASE_ROLE for a10
                  SQL> SELECT name,db_unique_name,protection_mode,DATABASE_ROLE,OPEN_MODE from v$database;

                  NAME DB_UNIQUE_NAME PROTECTION_MODE DATABASE_R OPEN_MODE
                  ---------- ------------------------------ --------------- ---------- --------------------
                  ORCL dr MAXIMUM PERFORM PHYSICAL S MOUNTED
                  ANCE TANDBY

                  SQL> select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#;
                  SQL> select process, status,thread#,sequence# from v$managed_standby;

                  PROCESS STATUS THREAD# SEQUENCE#
                  --------- ------------ ---------- ----------
                  ARCH CONNECTED 0 0
                  ARCH CONNECTED 0 0
                  ARCH CONNECTED 0 0
                  ARCH CONNECTED 0 0
                  ARCH CONNECTED 0 0
                  MRP0 WAIT_FOR_LOG 1 3788
                  SQL> col name for a30
                  SQL> select * from v$dataguard_stats;

                  NAME VALUE UNIT TIME_COMPUTED DATUM_TIME
                  ------------------------------ ---------- ------------------------------ ------------------------------ ------------------------------
                  transport lag day(2) to second(0) interval 06/17/2012 01:49:25
                  apply lag day(2) to second(0) interval 06/17/2012 01:49:25
                  apply finish time day(2) to second(3) interval 06/17/2012 01:49:25
                  estimated startup time 13 second 06/17/2012 01:49:25
                  SQL> select * from v$archive_gap;
                  SQL> col name format a60
                  SQL> select name
                  2 , floor(space_limit / 1024 / 1024) "Size MB"
                  3 , ceil(space_used / 1024 / 1024) "Used MB"
                  4 from v$recovery_file_dest
                  5 order by name;

                  NAME Size MB Used MB
                  ------------------------------------------------------------ ---------- ----------
                  D:\app\ShrenikSh\flash_recovery_area 3912 0
                  SQL> spool off



                  Will change format once figure out how to change it..

                  Regards!
                  • 6. Re: Dataguard Setup
                    CKPT
                    As I said you hamven't setup parameters properly

                    From primary:-

                    fal_client -- put TNS service name of primary (depricated from 11g)
                    fal_server -- put TNS service name of standby
                    $ tnsping dr

                    >
                    ID STATUS DB_MODE TYPE RECOVERY_MODE PROTECTION_MODE SRLs ACTIVE ARCHIVED_SEQ#
                    ---
                    --------------- ----
                    -------------------- ----
                    -------------
                    1 VALID OPEN ARCH IDLE MAXIMUM PERFORMANCE 0 0 3798
                    2 ERROR UNKNOWN LGWR IDLE MAXIMUM PERFORMANCE 0 0 0
                    So here destination of remote having errors.
                    Error 16058 17-JUN-2012 01:32:04 PING[ARC1]: Heartbeat failed to connect to standby 'dr'. Error is 16058
                    standby database instance is not mounted
                    Cause:      The RFS process on the standby database received an internal error.
                    Action:      Check the standby alert log and RFS trace files for more information.
                    Once bounce standby database, start MRP. Then post errors from alert log file. Make sure you have set above missing parameters.
                    • 7. Re: Dataguard Setup
                      Mrshah-Oracle
                      Thanks very much CKPT!!... it worked!!

                      Env is up and running... u rock!