Deploy

 

Stop Data gaurd replication using DGMGRL from Ora11g(Oracle+ABC1)

dgmgrl sys/pswd(Optional)

dgmgrl /

#stop data gaurd archive

show database abcdr

show database ABC

validate database abcdr--Optional

validate database ABC--Optional

EDIT DATABASE 'abcdr' SET STATE='APPLY-OFF';

show database abcdr

show database ABC

validate database abcdr--Optional

validate database ABC--Optional

3.3 Stop database from Ora11g(Oracle+ABC1)

srvctl status database -d ABC

srvctl stop database -d ABC -o immediate

srvctl start database -d ABC  -o mount

srvctl status database -d ABC

select name,open_mode,database_role from gv$database;

3.4 Take the ABC consistent Backup

mkdir /bkp/ABC_BKP_16AUG

rman target / log=/bkp/ABC_BKP_16AUG/rman_backup_ABC.log

RUN {

ALLOCATE CHANNEL disk1 DEVICE TYPE DISK;

ALLOCATE CHANNEL disk2 DEVICE TYPE DISK;

ALLOCATE CHANNEL disk3 DEVICE TYPE DISK;

ALLOCATE CHANNEL disk4 DEVICE TYPE DISK;

ALLOCATE CHANNEL disk5 DEVICE TYPE DISK;

ALLOCATE CHANNEL disk6 DEVICE TYPE DISK;

backup as compressed backupset database FORMAT '/bkp/ABC_BKP_16AUG/%d_%U_%T_%s_%p_Full';

BACKUP CURRENT CONTROLFILE FORMAT '/bkp/ABC_BKP_16AUG/%d_%U_%T_CTRL';

RELEASE CHANNEL disk1;

RELEASE CHANNEL disk2;

RELEASE CHANNEL disk3;

RELEASE CHANNEL disk4;

RELEASE CHANNEL disk5;

RELEASE CHANNEL disk6;

}   

Validate logfile

4. Start the database and release the env for Deployment 

srvctl status database -d ABC

srvctl stop database -d ABC -o immediate

srvctl start database -d ABC -o open

srvctl status database -d ABC

5. Start GG

agctl start goldengate gg1

info all

crs_stat -t -v

6. Start Extract from Prod Replica(OraTest)(Grid+ASM)

Start extract EXTCLN

7. Once deployment completed successfully,  Amit will confirm Bussiness verification

8. Start Data gaurd replication using DGMGRL from Ora11g(Oracle+ABC1)

dgmgrl sys/Dw8jPpGh4F24d5eB-Optional

dgmgrl /

show database abcdr

show database ABC

validate database abcdr

validate database ABC

EDIT DATABASE 'abcdr' SET STATE='APPLY-ON';

show database abcdr

show database ABC

validate database abcdr

validate database ABC

RMAN Status:

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,

ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"

FROM V$SESSION_LONGOPS

WHERE OPNAME LIKE 'RMAN%'

AND OPNAME NOT LIKE '%aggregate%'

AND TOTALWORK != 0

AND SOFAR <> TOTALWORK;