achampav

Tue Dec 06 17:10:26 2016
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Assigned to RFS process 23900
RFS[3]: Selected log 4 for thread 1 sequence 17 dbid -1432246771 branch 929889243
Tue Dec 06 17:10:26 2016
Media Recovery Waiting for thread 1 sequence 17 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 17 Reading mem 0
Mem# 0: +HISTO/testdg_dg03/onlinelog/group_4.260.929898091

achampav

SQL> alter system set log_archive_dest_state_2 = enable scope = both;

System altered.

SQL> alter system archive log current;

System altered.

achampav

SQL> alter database recover managed standby database cancel;

System altered.

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

System altered.

achampav

SQL> alter system set fal_server = 'testdg_dg02' scope = both;

System altered.

achampav

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fal_client                           string      testdg_dg03_dg
fal_server                           string      testdg_dg01_dg

achampav

SQL> alter system set log_archive_dest_state_3 = defer scope = both;

System altered.

SQL> alter system set fal_client = 'testdg_dg02' scope = both;

System altered.

achampav

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_3                   string      service="testdg_dg03_dg", LGWR
                                                 ASYNC NOAFFIRM delay=0 option
                                                 al compression=disable max_fai
                                                 lure=0 max_connections=1 reope
                                                 n=300 db_unique_name="testdg_d
                                                 g03" net_timeout=30, valid_for
                                                 =(all_logfiles,primary_role)
fal_client                           string      testdg_dg02_dg,testdg_dg03_dg

achampav

SQL> alter system set log_archive_dest_2 = 'service=testdg_dg03_dg lgwr async noaffirm db_unique_name=testdg_dg03 valid_for=(all_logfiles,standby_role)' scope=both;

System altered.

SQL> show parameter fal

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fal_client                           string      TESTDG_DG02
fal_server                           string      testdg_dg01_dg

achampav

DGMGRL> add database testdg_dg03 as connect identifier is testdg_dg03_dg maintained as physical;
Database "testdg_dg03" added
DGMGRL> enable database testdg_dg03
Enabled.

achampav

[oracle@dataguard03 ~]$ rman target sys/xxxxxxx@testdg_dg02_dg auxiliary sys/xxxxxxx@testdg_dg03_dg

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Dec 6 17:00:42 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: TESTDG (DBID=2862720525)
connected to auxiliary database: TESTDG (not mounted)

RMAN> duplicate target database for standby dorecover nofilenamecheck;