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
