1. Home
  2. Knowledge Base
  3. ZDLRA
  4. Zero Data Loss Recovery Appliance (ZDLRA) Hands-On Lab 2

Zero Data Loss Recovery Appliance (ZDLRA) Hands-On Lab 2

Tutorial Objectives

  • Connect to ZDLRA and perform Incremental Level 0 Backup
  • Connect to ZDLRA and perform Incremental Level 1 Backup
  • Monitor ZDLRA Catalog backup tasks
  • Verify creation of Virtual Level 0 Backup
  • Configure Redo Transport to ZDLRA
  • Validate Redo Transport to ZDLRA

INCREMENTAL LEVEL 0 BACKUP

[oracle@prdb01 server_wallet]$ . oraenv
ORACLE_SID = [cdb] ? cdb
The Oracle base remains unchanged with value /u01/app/oracle

CONNECT TO CATALOG DATABASE

[oracle@prdb01 server_wallet]$ rman target / catalog /@dr_zdlra

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Sep 19 21:12:48 2021
Version 19.10.0.0.0

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

connected to target database: CDB (DBID=2200216847)
connected to recovery catalog database
recovery catalog schema version 21.01.00.00. is newer than RMAN version


Execute RMAN command

run
{
allocate channel sbt1 device type sbt
format '%d_%U'
PARMS="SBT_LIBRARY=/u01/app/oracle/product/19.0.0.0/dbhome_2/lib/libra.so,
ENV=(RA_WALLET='location=file:/u01/app/oracle/product/19.0.0.0/dbhome_2/network/admin/server_wallet
credential_alias=dr_zdlra')";

allocate channel sbt2 device type sbt
format '%d_%U'
PARMS="SBT_LIBRARY=/u01/app/oracle/product/19.0.0.0/dbhome_2/lib/libra.so,
ENV=(RA_WALLET='location=file:/u01/app/oracle/product/19.0.0.0/dbhome_2/network/admin/server_wallet
credential_alias=dr_zdlra')";

backup
cumulative incremental level 0
filesperset 1
section size 64g
database
plus archivelog
not backed up
filesperset 32
delete input;
}




allocated channel: sbt1
channel sbt1: SID=3029 device type=SBT_TAPE
channel sbt1: RA Library (SEZDRDB) SID=CC58422740A95C3BE0537C01360A6D37

allocated channel: sbt2
channel sbt2: SID=3513 device type=SBT_TAPE
channel sbt2: RA Library (SEZDRDB) SID=CC58422CE7CA5C3CE0537C01360A099D


Starting backup at 19-SEP-21
current log archived
channel sbt1: starting archived log backup set
channel sbt1: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=1 STAMP=1083619548
input archived log thread=1 sequence=13 RECID=2 STAMP=1083619571
input archived log thread=1 sequence=14 RECID=3 STAMP=1083619572
input archived log thread=1 sequence=15 RECID=4 STAMP=1083650469
input archived log thread=1 sequence=16 RECID=5 STAMP=1083686421
channel sbt1: starting piece 1 at 19-SEP-21
channel sbt2: starting archived log backup set
channel sbt2: specifying archived log(s) in backup set
input archived log thread=1 sequence=17 RECID=6 STAMP=1083700928
input archived log thread=1 sequence=18 RECID=10 STAMP=1083700935
input archived log thread=1 sequence=19 RECID=13 STAMP=1083700941
input archived log thread=1 sequence=20 RECID=15 STAMP=1083705228
channel sbt2: starting piece 1 at 19-SEP-21
channel sbt1: finished piece 1 at 19-SEP-21
piece handle=CDB_0f09g1sd_15_1_1 tag=TAG20210919T211349 comment=API Version 2.0, MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:16
channel sbt1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09 _18/o1_mf_1_12_jncm5w8v_.arc RECID=1 STAMP=1083619548
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09 _18/o1_mf_1_13_jncm6mvc_.arc RECID=2 STAMP=1083619571
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09 _18/o1_mf_1_14_jncm6n2z_.arc RECID=3 STAMP=1083619572
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09 _19/o1_mf_1_15_jndkd5hd_.arc RECID=4 STAMP=1083650469
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09 _19/o1_mf_1_16_jnfnhodd_.arc RECID=5 STAMP=1083686421
channel sbt2: finished piece 1 at 19-SEP-21
piece handle=CDB_0g09g1se_16_1_1 tag=TAG20210919T211349 comment=API Version 2.0, MMS Version 19.0.0.1
channel sbt2: backup set complete, elapsed time: 00:00:15
channel sbt1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09 _19/o1_mf_1_17_jng2o0or_.arc RECID=6 STAMP=1083700928
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09 _19/o1_mf_1_18_jng2o7b3_.arc RECID=10 STAMP=1083700935
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09 _19/o1_mf_1_19_jng2ofgy_.arc RECID=13 STAMP=1083700941
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09 _19/o1_mf_1_20_jng6vdbx_.arc RECID=15 STAMP=1083705228
Finished backup at 19-SEP-21

Starting backup at 19-SEP-21
channel sbt1: starting incremental level 0 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB/system01.dbf
channel sbt1: starting piece 1 at 19-SEP-21
channel sbt2: starting incremental level 0 datafile backup set
channel sbt2: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/CDB/undotbs01.dbf
channel sbt2: starting piece 1 at 19-SEP-21
channel sbt2: finished piece 1 at 19-SEP-21
piece handle=CDB_0i09g1t0_18_1_1 tag=TAG20210919T211407 comment=API Version 2.0, MMS Version 19.0.0.1
channel sbt2: backup set complete, elapsed time: 00:00:01
channel sbt2: starting incremental level 0 datafile backup set
channel sbt2: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB/sysaux01.dbf
channel sbt2: starting piece 1 at 19-SEP-21
channel sbt1: finished piece 1 at 19-SEP-21
piece handle=CDB_0h09g1t0_17_1_1 tag=TAG20210919T211407 comment=API Version 2.0, MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:04
channel sbt1: starting incremental level 0 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDB/pdb1/CDB/CC434 AC3B1A81647E0537C01360AE1F5/datafile/o1_mf_sysaux_jncgx9yc_.dbf
channel sbt1: starting piece 1 at 19-SEP-21
channel sbt2: finished piece 1 at 19-SEP-21
piece handle=CDB_0j09g1t1_19_1_1 tag=TAG20210919T211407 comment=API Version 2.0, MMS Version 19.0.0.1
channel sbt2: backup set complete, elapsed time: 00:00:03
channel sbt2: starting incremental level 0 datafile backup set
channel sbt2: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/CDB/pdbseed/o1_mf_ sysaux_j23p0nok_.dbf
channel sbt2: starting piece 1 at 19-SEP-21
channel sbt1: finished piece 1 at 19-SEP-21
piece handle=CDB_0k09g1t4_20_1_1 tag=TAG20210919T211407 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:03
channel sbt1: starting incremental level 0 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/CDB/pdbseed/o1_mf_system_j23p0hvr_.dbf
channel sbt1: starting piece 1 at 19-SEP-21
channel sbt2: finished piece 1 at 19-SEP-21
piece handle=CDB_0l09g1t4_21_1_1 tag=TAG20210919T211407 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt2: backup set complete, elapsed time: 00:00:03
channel sbt2: starting incremental level 0 datafile backup set
channel sbt2: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/CDB/pdb1/CDB/CC434AC3B1A81647E0537C01360AE1F5/datafile/o1_mf_system_jncgx9y8_.dbf
channel sbt2: starting piece 1 at 19-SEP-21
channel sbt1: finished piece 1 at 19-SEP-21
piece handle=CDB_0m09g1t7_22_1_1 tag=TAG20210919T211407 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:04
channel sbt1: starting incremental level 0 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00008 name=/u01/app/oracle/oradata/CDB/pdbseed/o1_mf_undotbs1_j23tn2pf_.dbf
channel sbt1: starting piece 1 at 19-SEP-21
channel sbt2: finished piece 1 at 19-SEP-21
piece handle=CDB_0n09g1t8_23_1_1 tag=TAG20210919T211407 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt2: backup set complete, elapsed time: 00:00:03
channel sbt2: starting incremental level 0 datafile backup set
channel sbt2: specifying datafile(s) in backup set
input datafile file number=00011 name=/u01/app/oracle/oradata/CDB/pdb1/CDB/CC434AC3B1A81647E0537C01360AE1F5/datafile/o1_mf_undotbs1_jncgx9yd_.dbf
channel sbt2: starting piece 1 at 19-SEP-21
channel sbt1: finished piece 1 at 19-SEP-21
piece handle=CDB_0o09g1tb_24_1_1 tag=TAG20210919T211407 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
channel sbt1: starting incremental level 0 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/app/oracle/oradata/CDB/users01.dbf
channel sbt1: starting piece 1 at 19-SEP-21
channel sbt2: finished piece 1 at 19-SEP-21
piece handle=CDB_0p09g1tb_25_1_1 tag=TAG20210919T211407 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt2: backup set complete, elapsed time: 00:00:01
channel sbt1: finished piece 1 at 19-SEP-21
piece handle=CDB_0q09g1tc_26_1_1 tag=TAG20210919T211407 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
Finished backup at 19-SEP-21

Starting backup at 19-SEP-21
current log archived
channel sbt1: starting archived log backup set
channel sbt1: specifying archived log(s) in backup set
input archived log thread=1 sequence=21 RECID=17 STAMP=1083705261
channel sbt1: starting piece 1 at 19-SEP-21
channel sbt1: finished piece 1 at 19-SEP-21
piece handle=CDB_0r09g1te_27_1_1 tag=TAG20210919T211421 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
channel sbt1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/CDB/archivelog/2021_09_19/o1_mf_1_21_jng6wf6d_.arc RECID=17 STAMP=1083705261
Finished backup at 19-SEP-21

Starting Control File and SPFILE Autobackup at 19-SEP-21
piece handle=c-2200216847-20210919-01 comment=API Version 2.0,MMS Version 19.0.0.1
Finished Control File and SPFILE Autobackup at 19-SEP-21
released channel: sbt1
released channel: sbt2

INCREMENTAL LEVEL 1 BACKUP

EXECUTE RMAN COMMAND 

run
{
allocate channel sbt1 device type sbt
format '%d_%U'
PARMS="SBT_LIBRARY=/u01/app/oracle/product/19.0.0.0/dbhome_2/lib/libra.so,
ENV=(RA_WALLET='location=file:/u01/app/oracle/product/19.0.0.0/dbhome_2/network/admin/server_wallet
credential_alias=dr_zdlra')";

allocate channel sbt2 device type sbt
format '%d_%U'
PARMS="SBT_LIBRARY=/u01/app/oracle/product/19.0.0.0/dbhome_2/lib/libra.so,
ENV=(RA_WALLET='location=file:/u01/app/oracle/product/19.0.0.0/dbhome_2/network/admin/server_wallet
credential_alias=dr_zdlra')";

backup
cumulative incremental level 1
filesperset 1
section size 64g
database
plus archivelog
not backed up
filesperset 32
delete input;
}


allocated channel: sbt1
channel sbt1: SID=852 device type=SBT_TAPE
channel sbt1: RA Library (SEZDRDB) SID=CB756B71F4BB4E21E0537C01360A8D37

allocated channel: sbt2
channel sbt2: SID=975 device type=SBT_TAPE
channel sbt2: RA Library (SEZDRDB) SID=CB756B76E0064E23E0537C01360A2541


Starting backup at 08-SEP-21
current log archived
channel sbt1: starting archived log backup set
channel sbt1: specifying archived log(s) in backup set
input archived log thread=1 sequence=23 RECID=20 STAMP=1082730963
channel sbt1: starting piece 1 at 08-SEP-21
channel sbt1: finished piece 1 at 08-SEP-21
piece handle=CDB2_0u08iaek_30_1_1 tag=TAG20210908T143603 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:15
channel sbt1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/CDB2/archivelog/2021_09_08/o1_mf_1_23_jmjhfmgg_.arc RECID=20 STAMP=1082730963
Finished backup at 08-SEP-21

Starting backup at 08-SEP-21
channel sbt1: starting incremental level 1 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB2/system01.dbf
channel sbt1: starting piece 1 at 08-SEP-21
channel sbt2: starting incremental level 1 datafile backup set
channel sbt2: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/CDB2/undotbs01.dbf
channel sbt2: starting piece 1 at 08-SEP-21
channel sbt1: finished piece 1 at 08-SEP-21
piece handle=CDB2_0v08iaf3_31_1_1 tag=TAG20210908T143619 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
channel sbt1: starting incremental level 1 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB2/sysaux01.dbf
channel sbt1: starting piece 1 at 08-SEP-21
channel sbt1: finished piece 1 at 08-SEP-21
piece handle=CDB2_1108iaf4_33_1_1 tag=TAG20210908T143619 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
channel sbt1: starting incremental level 1 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/CDB2/pdb1/CDB2/CB6357DD582A7625E0537C01360A4B1A/datafile/o1_mf_sysaux_jmg3mdyf_.dbf
channel sbt1: starting piece 1 at 08-SEP-21
channel sbt1: finished piece 1 at 08-SEP-21
piece handle=CDB2_1208iaf5_34_1_1 tag=TAG20210908T143619 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
channel sbt1: starting incremental level 1 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/CDB2/pdbseed/o1_mf_sysaux_j23p0nok_.dbf
skipping datafile 00006 because it has not changed
channel sbt1: backup cancelled because all files were skipped
channel sbt1: starting incremental level 1 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/CDB2/pdbseed/o1_mf_system_j23p0hvr_.dbf
skipping datafile 00005 because it has not changed
channel sbt1: backup cancelled because all files were skipped
channel sbt1: starting incremental level 1 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/CDB2/pdb1/CDB2/CB6357DD582A7625E0537C01360A4B1A/datafile/o1_mf_system_jmg3mdy9_.dbf
channel sbt1: starting piece 1 at 08-SEP-21
channel sbt1: finished piece 1 at 08-SEP-21
piece handle=CDB2_1508iaf7_37_1_1 tag=TAG20210908T143619 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
channel sbt1: starting incremental level 1 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00008 name=/u01/app/oracle/oradata/CDB2/pdbseed/o1_mf_undotbs1_j23tn2pf_.dbf
skipping datafile 00008 because it has not changed
channel sbt1: backup cancelled because all files were skipped
channel sbt1: starting incremental level 1 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00011 name=/u01/app/oracle/oradata/CDB2/pdb1/CDB2/CB6357DD582A7625E0537C01360A4B1A/datafile/o1_mf_undotbs1_jmg3mdyf_.dbf
channel sbt1: starting piece 1 at 08-SEP-21
channel sbt1: finished piece 1 at 08-SEP-21
piece handle=CDB2_1708iaf8_39_1_1 tag=TAG20210908T143619 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
channel sbt1: starting incremental level 1 datafile backup set
channel sbt1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/app/oracle/oradata/CDB2/users01.dbf
channel sbt1: starting piece 1 at 08-SEP-21
channel sbt1: finished piece 1 at 08-SEP-21
piece handle=CDB2_1808iaf9_40_1_1 tag=TAG20210908T143619 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
channel sbt2: finished piece 1 at 08-SEP-21
piece handle=CDB2_1008iaf3_32_1_1 tag=TAG20210908T143619 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt2: backup set complete, elapsed time: 00:00:13
Finished backup at 08-SEP-21

Starting backup at 08-SEP-21
current log archived
channel sbt1: starting archived log backup set
channel sbt1: specifying archived log(s) in backup set
input archived log thread=1 sequence=24 RECID=22 STAMP=1082730992
channel sbt1: starting piece 1 at 08-SEP-21
channel sbt1: finished piece 1 at 08-SEP-21
piece handle=CDB2_1908iafh_41_1_1 tag=TAG20210908T143633 comment=API Version 2.0,MMS Version 19.0.0.1
channel sbt1: backup set complete, elapsed time: 00:00:01
channel sbt1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/CDB2/archivelog/2021_09_08/o1_mf_1_24_jmjhgjc3_.arc RECID=22 STAMP=1082730992
Finished backup at 08-SEP-21

Starting Control File and SPFILE Autobackup at 08-SEP-21
piece handle=c-829695276-20210908-01 comment=API Version 2.0,MMS Version 19.0.0.1
Finished Control File and SPFILE Autobackup at 08-SEP-21
released channel: sbt1
released channel: sbt2

MONITOR ZDLRA CATALOG TASKS (while backup is running)

As RASYS User 


col task_type format a20
col state format a20
col last_execute_time format a40

select TASK_TYPE,STATE,WAITING_ON
,LAST_EXECUTE_TIME from ra_task
where db_unique_name='CDB'
and STATE <> 'COMPLETED'
order by LAST_EXECUTE_TIME;


SQL> /

TASK_TYPE STATE WAITING_ON LAST_EXECUTE_TIME
-------------------- -------------------- ---------- ----------------------------------------
INDEX_BACKUP RUNNING 17-SEP-21 02.20.11.652980 PM +10:00

SQL> /

TASK_TYPE STATE WAITING_ON LAST_EXECUTE_TIME
-------------------- -------------------- ---------- ----------------------------------------
DEFERRED_DEL EXECUTABLE

SQL> /

no rows selected

VERIFY VIRTUAL 0 LEVEL BACKUP

RMAN>  list backup of datafile 1 completed after 'sysdate-10/1440';

List of Backup Sets
===================


LEVEL 0 BACKUP LOCATED ON BOTH PRIMARY AND SECONDARY CATALOG

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
67742 Incr 0 842.00M SBT_TAPE 00:00:35 08-SEP-21
BP Key: 67890 Status: AVAILABLE Compressed: NO Tag: TAG20210908T143005
Handle: RA_SBT_CDB2_2950937840_67709_0i08ia3e_1_2_67742 Media: Recovery Appliance (PRZDRDB)
List of Datafiles in backup set 67742
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 0 Incr 3115650 08-SEP-21 NO /u01/app/oracle/oradata/CDB2/system01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
67850 Incr 0 380.64M SBT_TAPE 00:00:04 08-SEP-21
BP Key: 67851 Status: AVAILABLE Compressed: YES Tag: TAG20210908T143005
Handle: VB$_2950937840_67825I Media:
List of Datafiles in backup set 67850
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 0 Incr 3115650 08-SEP-21 NO /u01/app/oracle/oradata/CDB2/system01.dbf



LEVEL 1 BACKUP LOCATED ON BOTH PRIMARY AND SECONDARY CATALOG

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
67966 Incr 1 256.00K SBT_TAPE 00:00:25 08-SEP-21
BP Key: 68102 Status: AVAILABLE Compressed: NO Tag: TAG20210908T143619
Handle: RA_SBT_CDB2_2950937840_67709_0v08iaf3_1_2_67966 Media: Recovery Appliance (PRZDRDB)
List of Datafiles in backup set 67966
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 1 Incr 3117046 08-SEP-21 NO /u01/app/oracle/oradata/CDB2/system01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68008 Incr 1 96.00K SBT_TAPE 00:00:01 08-SEP-21
BP Key: 68009 Status: AVAILABLE Compressed: YES Tag: TAG20210908T143619
Handle: VB$_2950937840_68007I Media:
List of Datafiles in backup set 68008
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 1 Incr 3117046 08-SEP-21 NO /u01/app/oracle/oradata/CDB2/system01.dbf


LEVEL 1 BACKUP CONVERTED TO VIRTUAL LEVEL 0 BACKUP - Note Checkpoint SCN value for VIRTUAL LEVEL 0 backup is same as INCREMENTAL LEVEL 1 backup


BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68012 Incr 0 379.38M SBT_TAPE 00:00:01 08-SEP-21
BP Key: 68013 Status: AVAILABLE Compressed: YES Tag: TAG20210908T143619
Handle: VB$_2950937840_68007_1 Media:
List of Datafiles in backup set 68012
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 0 Incr 3117046 08-SEP-21 NO /u01/app/oracle/oradata/CDB2/system01.dbf

CONFIGURE REDO TRANSPORT TO ZDLRA DESTINATION

[oracle@prdb01 ~]$ sqlplus sys as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 26 10:56:52 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0



SQL> alter session set "_oracle_script"=true;

Session altered.

SQL> create user vpc_cdb identified by Oracle_4U container=all;

User created.

SQL> grant sysoper to vpc_cdb container=all;

Grant succeeded.

SQL> grant create session to vpc_cdb container=all;

Grant succeeded.

SQL> alter session set "_oracle_script"=false;

Session altered.

SQL>


On BOTH Primary and Standby


SQL> show parameter redo_transport_user;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
redo_transport_user string

SQL> alter system set redo_transport_user=VPC_CDB scope=both;

System altered.


SQL> ALTER SYSTEM SET log_archive_config='DG_CONFIG=(cdb,cdb_sb,SEZDRDB)' scope=both;

System altered.

SQL> ALTER SYSTEM SET log_archive_dest_3='SERVICE="czdr8nse-scan.mycorp.gov.au:1521/SEZDRDB1_2060:dedicated" ASYNC NOAFFIRM
DB_UNIQUE_NAME=SEZDRDB VALID_FOR=(ONLINE_LOGFILE,ALL_ROLES)' scope = both;


System altered.


Shutdown BOTH Primary and Standby


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0


Copy password file to Standby

[oracle@prdb01 ~]$ cd $ORACLE_HOME/dbs

[oracle@prdb01 dbs]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_2/dbs

[oracle@prdb01 dbs]$ ls -lrt orapwcdb
-rw-r-----. 1 oracle oinstall 2560 Sep 20 13:33 orapwcdb


[oracle@prdb01 dbs]$ scp -rp orapwcdb oracle@sbdb01:/u01/app/oracle/product/19.0.0.0/dbhome_2/dbs
oracle@sbdb01's password:
orapwcdb 100% 2560 6.4MB/s 00:00


Startup BOTH Primary and Standby



[oracle@prdb01 dbs]$ sqlplus sys as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 26 11:23:45 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle. All rights reserved.

Enter password:
Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 3221223568 bytes
Fixed Size 9144464 bytes
Variable Size 1023410176 bytes
Database Buffers 2164260864 bytes
Redo Buffers 24408064 bytes
Database mounted.
Database opened.

SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0




SQL> alter system set log_archive_dest_state_2=defer;

System altered.

SQL> alter system set log_archive_dest_state_2=enable;

System altered.

SQL> alter system set log_archive_dest_state_3=defer;

System altered.

SQL> alter system set log_archive_dest_state_3=enable;

System altered.

SQL> select destination,status,error from v$archive_dest_status where rownum < 4;

DESTINATION
--------------------------------------------------------------------------------
STATUS ERROR
--------- -----------------------------------------------------------------
/u01/app/oracle/product/19.0.0.0/dbhome_2/dbs/arch
VALID

cdb_sb
VALID

czdr8nse-scan.mycorp.gov.au:1521/SEZDRDB1_2060:dedicated
VALID

VALIDATE REDO TRANSPORT TO ZDLRA

<<<Check which is the last backup of archivelog available>>>

ARCHIVED REDO LOG SEQUENCE # 45 IS LAST BACKUP AVAILABLE

[oracle@prdb01 server_wallet]$ rman target / catalog /@czdr8nse-scan.mycorp.gov.au:1521/SEZDRDB1_2060:dedicated

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 8 16:48:23 2021
Version 19.10.0.0.0

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

connected to target database: CDB (DBID=829695276)
connected to recovery catalog database
recovery catalog schema version 21.01.00.00. is newer than RMAN version

RMAN> list backup of archivelog all completed after 'sysdate-5/1440';

starting full resync of recovery catalog
full resync complete

List of Backup Sets
===================


BS Key Size
------- ----------
68388 29.00K

List of Archived Logs in backup set 68388
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 45 3142196 08-SEP-21 3142304 08-SEP-21

Backup Set Copy #1 of backup set 68388
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:20 08-SEP-21 YES TAG20210908T164327

List of Backup Pieces for backup set 68388 Copy #1
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
68389 1 AVAILABLE $RSCN_1920977_RTIM_1082648239_THRD_1_SEQ_45_CTKEY_68381_BACKUP

Backup Set Copy #2 of backup set 68388
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:20 08-SEP-21 YES TAG20210908T164327

List of Backup Pieces for backup set 68388 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
68396 1 AVAILABLE Recovery Appliance (PRZDRDB) RA_SBT_CDB2_2950937840_67709_tt08ihtf_1_2_68388


RMAN> quit

Recovery Manager complete.


SWITCH LOGFILES AND NOTE THAT ARCHIVE LOG BACKUP AUTOMATICALLY HAPPENS ON ZDLRA.

ARCHIVED REDO LOG SEQUENCE # 48 IS NOW LAST BACKUP AVAILABLE

[oracle@prdb01 server_wallet]$ sqlplus sys as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 8 16:49:31 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 48
Next log sequence to archive 50
Current log sequence 50

SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0


[oracle@prdb01 server_wallet]$ rman target / catalog /@czdr8nse-scan.mycorp.gov.au:1521/SEZDRDB1_2060:dedicated

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 8 16:49:59 2021
Version 19.10.0.0.0

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

connected to target database: CDB (DBID=829695276)
connected to recovery catalog database
recovery catalog schema version 21.01.00.00. is newer than RMAN version

RMAN> list backup of archivelog all completed after 'sysdate-5/1440';


List of Backup Sets
===================


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
68497 7.50K SBT_TAPE 00:00:00 08-SEP-21
BP Key: 68498 Status: AVAILABLE Compressed: YES Tag: TAG20210908T164950
Handle: $RSCN_1920977_RTIM_1082648239_THRD_1_SEQ_48_CTKEY_68493_BACKUP Media:

List of Archived Logs in backup set 68497
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 48 3143460 08-SEP-21 3143471 08-SEP-21

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
68501 348.00K SBT_TAPE 00:00:00 08-SEP-21
BP Key: 68502 Status: AVAILABLE Compressed: YES Tag: TAG20210908T164954
Handle: $RSCN_1920977_RTIM_1082648239_THRD_1_SEQ_46_CTKEY_68386_BACKUP Media:

List of Archived Logs in backup set 68501
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 46 3142304 08-SEP-21 3143448 08-SEP-21

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
68505 11.50K SBT_TAPE 00:00:00 08-SEP-21
BP Key: 68506 Status: AVAILABLE Compressed: YES Tag: TAG20210908T164955
Handle: $RSCN_1920977_RTIM_1082648239_THRD_1_SEQ_47_CTKEY_68492_BACKUP Media:

List of Archived Logs in backup set 68505
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 47 3143448 08-SEP-21 3143460 08-SEP-21

Next Hands-On Lab

Updated on May 18, 2024

Was this article helpful?

Related Articles

Leave a Comment