rman target /

run
{
  set nocfau;
  allocate channel ch01 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/_keep_/RAC/21/backupset/%d_%U_%s_%t.bck';
  allocate channel ch02 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/_keep_/RAC/21/backupset/%d_%U_%s_%t.bck';
  allocate channel ch03 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/_keep_/RAC/21/backupset/%d_%U_%s_%t.bck';
  allocate channel ch04 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/_keep_/RAC/21/backupset/%d_%U_%s_%t.bck';
  backup as compressed backupset incremental level 0 database section size 2G include current controlfile plus archivelog delete input;
  release channel ch01;
  release channel ch02;
  release channel ch03;
  release channel ch04;
  allocate channel ch01 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/_keep_/RAC/21/backupset/%d_%U_%s_%t.controlfile';
  backup current controlfile;
  release channel ch01;
}

srvctl add database -d HUTTPRD  -o /app/oracle/product/19 -p '+DATA/HUTTPRD/spfile.ora' 

~~ create passwordfile on ASM; if the DB is not yet registered on CRS, you will get a WARNING
orapwd FILE='+DATA/HUTTPRD/orapwHUTTPRD' ENTRIES=10 DBUNIQUENAME='HUTTPRD' password="Secret00!"
srvctl modify database -d HUTTPRD -pwfile '+DATA/HUTTPRD/orapwHUTTPRD'

srvctl add instance -d HUTTPRD -i HUTTPRD1 -n ylesia-db01
srvctl add instance -d HUTTPRD -i HUTTPRD2 -n ylesia-db02


alias HUTTPRD='rlwrap sqlplus sys/"Secret00!"@ylesia-scan/HUTTPRD as sysdba'
alias HUTTDRP='rlwrap sqlplus sys/"Secret00!"@rodia-scan/HUTTDRP as sysdba'


run
{
  allocate auxiliary channel aux01 device type disk;
  allocate auxiliary channel aux02 device type disk;
  allocate auxiliary channel aux03 device type disk;
  allocate auxiliary channel aux04 device type disk;
  duplicate database 'HUTT' for standby backup location '/mnt/yavin4/tmp/_oracle_/orabackup/_keep_/RAC/21/backupset/';
}


srvctl add database -d HUTTDRP  -o /app/oracle/product/21 -p '+DATA/HUTTDRP/spfile.ora'
srvctl modify database -d HUTTDRP -r physical_standby -n HUTT -s MOUNT

srvctl add instance -d HUTTDRP -i HUTTDRP1 -n rodia-db01
srvctl add instance -d HUTTDRP -i HUTTDRP2 -n rodia-db02


# copy passwordfile from primary to standby
ASMCMD [+DATA/HUTTPRD] > pwcopy +DATA/HUTTPRD/PASSWORD/pwdhuttprd.274.1137773649 /tmp
scp /tmp/pwdhuttprd.274.1137773649 rodia-db02:/tmp
ASMCMD [+DATA/HUTTDRP] > pwcopy /tmp/pwdhuttprd.274.1137773649 +DATA/HUTTDRP/orapwhuttdrp

srvctl modify database -db HUTTDRP -pwfile '+DATA/HUTTDRP/orapwhuttdrp'


alter system set dg_broker_config_file1='+DATA/HUTTPRD/dg_broker_01.dat' scope=both sid='*';
alter system set dg_broker_config_file2='+DATA/HUTTPRD/dg_broker_02.dat' scope=both sid='*';
alter system set dg_broker_start=TRUE scope=both sid='*';

alter system set dg_broker_config_file1='+DATA/HUTTDRP/dg_broker_01.dat' scope=both sid='*';
alter system set dg_broker_config_file2='+DATA/HUTTDRP/dg_broker_02.dat' scope=both sid='*';
alter system set dg_broker_start=TRUE scope=both sid='*';


select GROUP#,THREAD#,MEMBERS,STATUS, BYTES/(1024*1024) Mb from v$log;
select GROUP#,THREAD#,STATUS, BYTES/(1024*1024) Mb from v$standby_log;

set lines 256
col MEMBER for a80
select * from v$logfile;


-- create standby redologs
select 'ALTER DATABASE ADD STANDBY LOGFILE THREAD '||thread#||' size '||bytes||';' from v$log;
select distinct 'ALTER DATABASE ADD STANDBY LOGFILE THREAD '||thread#||' size '||bytes||';' from v$log;

-- clear / drop standby redologs
select 'ALTER DATABASE CLEAR LOGFILE GROUP '||GROUP#||';' from v$standby_log;
select 'ALTER DATABASE DROP STANDBY LOGFILE GROUP '||GROUP#||';' from v$standby_log;


dgmgrl
DGMGRL> connect sys/"Secret00!"@ylesia-scan:1521/HUTTPRD
DGMGRL> create configuration HUTT as primary database is HUTTPRD connect identifier is ylesia-scan:1521/HUTTPRD;
DGMGRL> add database HUTTDRP as connect identifier is rodia-scan:1521/HUTTDRP;

DGMGRL> enable configuration;
DGMGRL> show configuration;

DGMGRL> edit database 'huttdrp' set property ArchiveLagTarget=0;
DGMGRL> edit database 'huttdrp' set property LogArchiveMaxProcesses=2;
DGMGRL> edit database 'huttdrp' set property LogArchiveMinSucceedDest=1;
DGMGRL> edit database 'huttdrp' set property StandbyFileManagement='AUTO';

DGMGRL> edit database 'huttprd' set property ArchiveLagTarget=0;
DGMGRL> edit database 'huttprd' set property LogArchiveMaxProcesses=2;
DGMGRL> edit database 'huttprd' set property LogArchiveMinSucceedDest=1;
DGMGRL> edit database 'huttprd' set property StandbyFileManagement='AUTO';

DGMGRL> show configuration;



RMAN> configure archivelog deletion policy to applied on  all standby;

# if incremental recover from source is required
RMAN> recover database from service 'ylesia-scan/HUTTPRD' using compressed backupset section size 2G;





