Dataguard : SETUP

• Creating A DataGuard Broker Configuration Using DGMGRL

1. Configure Primary tnsname hint db_unique_name  of standby
2. LTER SYSTEM SET dg_broker_start=TRUE; # on both site, start DMON process
3. dgmgrl> connect sys/xxxxx

CREATE CONFIGURATION 'myndb_config' AS

PRIMARY DATABASE IS 'myndb'

CONNECT IDENTIFIER IS myndb;

show configuration;

ADD DATABASE 'myndb_pra' AS

CONNECT IDENTIFIER IS myndb_pra

MAINTAINED AS PHYSICAL;

show configuration; 

SHOW DATABASE VERBOSE gdddev1;

SHOW DATABASE VERBOSE gdddev1_terre; 

ENABLE CONFIGURATION; 

EDIT DATABASE 'gdddev1_terre' SET PROPERTY LogXptMode='ASYNC';

• Activating Standby and going back to Standby

alter system set log_archive_dest_state_3='defer'; # primary site

alter database recover managed standby database cancel;

alter system set DG_BROKER_START=FALSE;

CREATE RESTORE POINT before_pra_myn GUARANTEE FLASHBACK DATABASE;

select * from v$restore_point;

alter database activate standby database;

startup mount force;

alter database open;

create table test ( id number);

shutdown immediate

STARTUP MOUNT FORCE;

flashback database to restore point before_pra_myn;

ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

ALTER SYSTEM SET DG_BROKER_START=TRUE;

STARTUP MOUNT FORCE;

shutdown immediate;

startup nomount;

alter database mount standby database;

alter database recover managed standby database disconnect from session;

drop restore point before_pra_myn ;

alter system set log_archive_dest_state_3='enable';  # primary site

• Using RMAN Incremental Backups to Refresh a Standby Database

BACKUP DEVICE TYPE DISK INCREMENTAL FROM SCN 750983 DATABASE FORMAT '/tmp/incr_standby_%U'; # primary site

CATALOG START WITH '/standbydisk1/incrback/';

RECOVER DATABASE NOREDO;

• Renaming a bad file name

ALTER SYSTEM SET standby_file_management='MANUAL';

alter database create datafile '/u01/app/oracle/product/10.2.0.4/dbs/UNNAMED00422' as '/u01/ORADATA/mydb/myntbs_06.dbf'; -

ALTER SYSTEM SET standby_file_management=AUTO;

• Finding duplicate archivelog names on standby

set heading off

set feedback off

set linesize 200

set pagesize 0

spool calalog.txt

select al.recid, al.name from v$archived_log al

where al.status = 'A' and al.standby_dest= 'NO'

minus

select al.recid, al.name from v$archived_log al,

(select max(recid) recid

from v$archived_log

where status = 'A'

group by name) keepal

where al.status = 'A'

and al.standby_dest = 'NO'

and keepal.recid = al.recid;

RMAN> catalog archivelog '/u01/ORADATA/myndb/arch/arch_35_1_716749251';

• Creating Standby with RMAN 11G

run {

DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK ;

}

rman target / AUXILIARY "sys/xxxxx@myndb" cmdfile=$1 log=log/$1.log