Saturday, May 24, 2025

How to take backup of backupset in oracle RMAN ?

 RMAN> backup backupset all;


Starting backup at 24-MAY-25

using channel ORA_DISK_1

channel ORA_DISK_1: input backup set: count=78, stamp=1201960787, piece=1

channel ORA_DISK_1: starting piece 1 at 24-MAY-25

skipping backup piece handle /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_24/o1_mf_s_1201960787_n33n6o4x_.bkp; already exists

channel ORA_DISK_1: finished piece 1 at 24-MAY-25

channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:00

channel ORA_DISK_1: input backup set: count=79, stamp=1201960815, piece=1

channel ORA_DISK_1: starting piece 1 at 24-MAY-25

channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/DB1/backupset/2025_05_24/o1_mf_nnndf_TAG20250524T140015_n33n7jcg_.bkp

piece handle=/u01/app/oracle/fast_recovery_area/DB1/backupset/2025_05_24/o1_mf_nnnnf__n33n7v8r_.bkp comment=NONE

channel ORA_DISK_1: finished piece 1 at 24-MAY-25

channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:02

channel ORA_DISK_1: input backup set: count=80, stamp=1201960817, piece=1

channel ORA_DISK_1: starting piece 1 at 24-MAY-25

skipping backup piece handle /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_24/o1_mf_s_1201960817_n33n7m82_.bkp; already exists

channel ORA_DISK_1: finished piece 1 at 24-MAY-25

channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:00

Finished backup at 24-MAY-25


Starting Control File and SPFILE Autobackup at 24-MAY-25

piece handle=/u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_24/o1_mf_s_1201960828_n33n7y5b_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 24-MAY-25


RMAN>

How to backup all recovery files in oracle ?

 RMAN> backup recovery files to destination '/u01/app/oracle/';


Starting backup at 24-MAY-25

using channel ORA_DISK_1

specification does not match any datafile copy in the repository

skipping archived logs of thread 1 from sequence 17 to 19; already backed up

skipping backup set key 19; already backed up 1 time(s)

skipping backup set key 20; already backed up 1 time(s)

skipping backup set key 21; already backed up 1 time(s)

skipping backup set key 22; already backed up 1 time(s)

skipping backup set key 23; already backed up 1 time(s)

skipping backup set key 24; already backed up 1 time(s)

skipping backup set key 25; already backed up 1 time(s)

skipping backup set key 26; already backed up 1 time(s)

skipping backup set key 27; already backed up 1 time(s)

skipping backup set key 28; already backed up 1 time(s)

Finished backup at 24-MAY-25


RMAN>

How to backup recovery area in oracle database ?

 RMAN> backup recovery area to destination '/u01/app/oracle/'

2> ;


Starting backup at 24-MAY-25

using channel ORA_DISK_1

specification does not match any datafile copy in the repository

skipping backup set key 23; already backed up 1 time(s)

skipping backup set key 26; already backed up 1 time(s)

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=17 RECID=12 STAMP=1201940579

input archived log thread=1 sequence=18 RECID=13 STAMP=1201956550

input archived log thread=1 sequence=19 RECID=14 STAMP=1201956572

channel ORA_DISK_1: starting piece 1 at 24-MAY-25

channel ORA_DISK_1: finished piece 1 at 24-MAY-25

piece handle=/u01/app/oracle/DB1/backupset/2025_05_24/o1_mf_annnn_TAG20250524T135211_n33mrcpv_.bkp tag=TAG20250524T135211 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

Finished backup at 24-MAY-25


Starting Control File and SPFILE Autobackup at 24-MAY-25

piece handle=/u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_24/o1_mf_s_1201960334_n33mrjx1_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 24-MAY-25


RMAN>

what is catcon.pl (Catalog Container Script) and why very useful for Oracle Multitenant Database ?

  catcon.pl (Catalog Container Script) is an Oracle utility introduced with the Multitenant Architecture (CDB/PDB) to execute SQL scripts ...