achampav

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1102344192 bytes
Fixed Size 2227584 bytes
Variable Size 318767744 bytes
Database Buffers 771751936 bytes
Redo Buffers 9596928 bytes

achampav

TESTDG.__db_cache_size=771751936
TESTDG.__java_pool_size=16777216
TESTDG.__large_pool_size=16777216
TESTDG.__oracle_base='/oracle'#ORACLE_BASE set from environment
TESTDG.__pga_aggregate_target=369098752
TESTDG.__sga_target=1107296256
TESTDG.__shared_io_pool_size=0
TESTDG.__shared_pool_size=285212672
TESTDG.__streams_pool_size=0
*.archive_lag_target=0

achampav

[oracle@dataguard03 ~]$ cd $ORACLE_HOME/dbs
[oracle@dataguard03 dbs]$ scp dataguard02:/oracle/ora112/dbs/orapwTESTDG .

achampav

RMAN> backup current controlfile for standby;

Starting backup at 06-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=164 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including standby control file in backup set
channel ORA_DISK_1: starting piece 1 at 06-DEC-16

achampav

RMAN> backup database plus archivelog;
Starting backup at 06-DEC-16
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=1 STAMP=929889249
input archived log thread=1 sequence=2 RECID=2 STAMP=929890538
input archived log thread=1 sequence=3 RECID=3 STAMP=929890542
input archived log thread=1 sequence=4 RECID=4 STAMP=929890554

achampav

TESTDG_DG03_DG =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = dataguard03)(PORT = 1521))
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TESTDG_DG03_DGB)
    (UR = A)
  )
)

achampav

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dataguard01)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =

achampav

[oracle@dataguard01 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/xxxxxxx
Connected.
DGMGRL> show configuration

achampav

alter database start logical standby apply immediate;

achampav

alter database open resetlogs;