Sunday 6 June 2021

RMAN - Rman Backup using Sysbackup

 

Scenario: 

Small example for taking rman backing using sysbackup instead sysdba  

Database Name : TEST10 

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN

--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------

TEST10  TEST10        TEST10                      READ WRITE           PRIMARY          NO                 0


 
  • Create user bkpadmin

SQL> CREATE USER bkpadmin identified by bkpadmin;


User created.

  • Grant sysbackup and some session  privilege's  to bkpadmin

SQL> GRANT SYSBACKUP TO bkpadmin;


Grant succeeded.

SQL> GRANT CREATE SESSION TO bkpadmin;


Grant succeeded.

  • Connect rman with bkpadmin user and with sysbackup privileges' 

 

oracle@TEST10:~> rman target "'bkpadmin/bkpadmin@TEST10 as sysbackup'"

oracle@TEST10:~> vi /u02/scripts/rmanbackupstatusTEST10.sh

oracle@TEST10:~> vi /u02/scripts/rman_TEST10.sh

oracle@TEST10:~> vi /u02/scripts/rman_TEST10.sh

oracle@TEST10:~> cat /u02/scripts/rman_TEST10.sh

ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1

export ORACLE_HOME

ORACLE_SID=TEST10

export ORACLE_SID

/u01/app/oracle/product/12.1.0/dbhome_1/bin/rman target "'bkpadmin/bkpadmin@TEST10 as sysbackup'" @/u02/scripts/rman_TEST10.rcv >> /u02/scripts/rman_TEST10_bkp.log


  • Log file output rman_TEST10_bkp.log 


 

RMAN> run

2> {

3> allocate channel c1 device type disk format '/u04/db_backup/rman/TEST10/Backup_%d_DB_%u_%s_%p_%T';

4> allocate channel c2 device type disk format '/u04/db_backup/rman/TEST10/Backup_%d_DB_%u_%s_%p_%T';

5> crosscheck archivelog all;

6> report obsolete;

7> delete noprompt obsolete;

8> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

9> BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 tag='FULL_BACKUP_Daily' DATABASE INCLUDE CURRENT CONTROLFILE FILESPERSET 1;

10> BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL;

11> #delete noprompt archivelog all backed up 1 times to disk;

12> copy current controlfile to '/u04/db_backup/rman/TEST10/control_%d_%u_%T.bak';

13> release channel c1;

14> release channel c2;

15> }

16>

using target database control file instead of recovery catalog

allocated channel: c1

channel c1: SID=619 device type=DISK


allocated channel: c2

channel c2: SID=924 device type=DISK


validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2164_jbmlys9p_.arc RECID=2148 STAMP=1073280508

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2165_jbn3g8jp_.arc RECID=2149 STAMP=1073297385

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2166_jbnh15s4_.arc RECID=2150 STAMP=1073309254

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2167_jbov1d2z_.arc RECID=2151 STAMP=1073354317

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2168_jboxvhnb_.arc RECID=2152 STAMP=1073357200

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2169_jbr1gsfk_.arc RECID=2153 STAMP=1073426427

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2170_jbrhjjs5_.arc RECID=2154 STAMP=1073440818

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2171_jbrlcyhj_.arc RECID=2155 STAMP=1073443744

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2172_jbsqsq59_.arc RECID=2156 STAMP=1073482077

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2173_jbtovrr2_.arc RECID=2157 STAMP=1073512857

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2174_jbtox2rg_.arc RECID=2158 STAMP=1073512899

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2175_jbv6lqtz_.arc RECID=2159 STAMP=1073529976

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2176_jbw3kmp3_.arc RECID=2160 STAMP=1073559636

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2177_jbxb7c1r_.arc RECID=2161 STAMP=1073599244

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2178_jbxbd71c_.arc RECID=2162 STAMP=1073599400

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2179_jbxtyhm1_.arc RECID=2163 STAMP=1073616368

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2180_jbzjh1k7_.arc RECID=2164 STAMP=1073671170

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2181_jbzynpp9_.arc RECID=2165 STAMP=1073685687

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2182_jc08c8wh_.arc RECID=2166 STAMP=1073695626

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2183_jc0hc052_.arc RECID=2167 STAMP=1073702785

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2184_jc1tc751_.arc RECID=2168 STAMP=1073746824

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2185_jc2m3z7p_.arc RECID=2169 STAMP=1073772192

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2186_jc2phgn5_.arc RECID=2170 STAMP=1073775631

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2187_jc33q21q_.arc RECID=2171 STAMP=1073789186

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2188_jc3h370q_.arc RECID=2172 STAMP=1073800840

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2189_jc4co2t8_.arc RECID=2173 STAMP=1073830084

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2190_jc57t39b_.arc RECID=2174 STAMP=1073858916

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2191_jc5r36jm_.arc RECID=2175 STAMP=1073875594

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2192_jc5zyow9_.arc RECID=2176 STAMP=1073883640

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2193_jc613s9q_.arc RECID=2177 STAMP=1073884825

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2194_jc61x8mh_.arc RECID=2178 STAMP=1073885641

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2195_jc6l1r24_.arc RECID=2179 STAMP=1073902169

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2196_jc7w9bhr_.arc RECID=2180 STAMP=1073945420

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_31/o1_mf_1_2197_jc86v33k_.arc RECID=2181 STAMP=1073956227

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_31/o1_mf_1_2198_jc8dh756_.arc RECID=2182 STAMP=1073961991

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_31/o1_mf_1_2199_jcbj2jh9_.arc RECID=2183 STAMP=1074031217

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_01/o1_mf_1_2200_jcbvb7xj_.arc RECID=2184 STAMP=1074042729

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_01/o1_mf_1_2201_jcc0tbof_.arc RECID=2185 STAMP=1074048363

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_01/o1_mf_1_2202_jccpr5sy_.arc RECID=2186 STAMP=1074070822

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_01/o1_mf_1_2203_jcf4ghnr_.arc RECID=2187 STAMP=1074117617

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_02/o1_mf_1_2204_jcfhsm9d_.arc RECID=2188 STAMP=1074129236

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_02/o1_mf_1_2205_jcfo77xw_.arc RECID=2189 STAMP=1074134792

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_02/o1_mf_1_2206_jcgtw0xb_.arc RECID=2190 STAMP=1074173346

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_02/o1_mf_1_2207_jchrvnqt_.arc RECID=2191 STAMP=1074204053

validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_03/o1_mf_1_2208_jcj52887_.arc RECID=2192 STAMP=1074216553

Crosschecked 23 objects


validation succeeded for archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_06_03/o1_mf_1_2209_jcj9mdo5_.arc RECID=2193 STAMP=1074221197

Crosschecked 23 objects



RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Report of obsolete backups and copies

Type                 Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set           295    23-MAY-2021 05:28:18

  Backup Piece       295    23-MAY-2021 05:28:18 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9kvvht0t_308_1_20210523

Backup Set           285    23-MAY-2021 05:21:17

  Backup Piece       285    23-MAY-2021 05:21:17 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9lvvht0u_309_1_20210523

Backup Set           286    23-MAY-2021 05:21:26

  Backup Piece       286    23-MAY-2021 05:21:26 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9mvvht2l_310_1_20210523

Backup Set           287    23-MAY-2021 05:21:35

  Backup Piece       287    23-MAY-2021 05:21:35 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9nvvht2o_311_1_20210523

Backup Set           288    23-MAY-2021 05:21:41

  Backup Piece       288    23-MAY-2021 05:21:41 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9ovvht30_312_1_20210523

Backup Set           289    23-MAY-2021 05:22:04

  Backup Piece       289    23-MAY-2021 05:22:04 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9pvvht38_313_1_20210523

Backup Set           290    23-MAY-2021 05:22:12

  Backup Piece       290    23-MAY-2021 05:22:12 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9qvvht41_314_1_20210523

Backup Set           291    23-MAY-2021 05:22:13

  Backup Piece       291    23-MAY-2021 05:22:13 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9rvvht44_315_1_20210523

Backup Set           292    23-MAY-2021 05:22:14

  Backup Piece       292    23-MAY-2021 05:22:14 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9svvht46_316_1_20210523

Archive Log          2148   23-MAY-2021 05:28:28 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2164_jbmlys9p_.arc

Backup Set           294    23-MAY-2021 05:22:17

  Backup Piece       294    23-MAY-2021 05:22:17 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9uvvht49_318_1_20210523

Control File Copy     24     23-MAY-2021 05:29:28 /u04/db_backup/rman/TEST10/control_TEST10_a1vvhtho_20210523.bak

Backup Set           297    23-MAY-2021 05:29:27

  Backup Piece       297    23-MAY-2021 05:29:27 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_a0vvhtg5_320_1_20210523

Archive Log          2149   23-MAY-2021 10:09:45 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2165_jbn3g8jp_.arc

Archive Log          2150   23-MAY-2021 13:27:34 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2166_jbnh15s4_.arc

Archive Log          2151   24-MAY-2021 01:58:37 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2167_jbov1d2z_.arc

Archive Log          2152   24-MAY-2021 02:46:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2168_jboxvhnb_.arc

Archive Log          2153   24-MAY-2021 22:00:27 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2169_jbr1gsfk_.arc

Archive Log          2154   25-MAY-2021 02:00:18 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2170_jbrhjjs5_.arc

Archive Log          2155   25-MAY-2021 02:49:04 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2171_jbrlcyhj_.arc

Archive Log          2156   25-MAY-2021 13:27:57 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2172_jbsqsq59_.arc

Archive Log          2157   25-MAY-2021 22:00:57 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2173_jbtovrr2_.arc

Archive Log          2158   25-MAY-2021 22:01:39 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2174_jbtox2rg_.arc

Archive Log          2159   26-MAY-2021 02:46:16 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2175_jbv6lqtz_.arc

Archive Log          2160   26-MAY-2021 11:00:36 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2176_jbw3kmp3_.arc

Archive Log          2161   26-MAY-2021 22:00:44 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2177_jbxb7c1r_.arc

Archive Log          2162   26-MAY-2021 22:03:20 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2178_jbxbd71c_.arc

Archive Log          2163   27-MAY-2021 02:46:08 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2179_jbxtyhm1_.arc

Archive Log          2164   27-MAY-2021 17:59:30 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2180_jbzjh1k7_.arc

Archive Log          2165   27-MAY-2021 22:01:27 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2181_jbzynpp9_.arc

Archive Log          2166   28-MAY-2021 00:47:06 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2182_jc08c8wh_.arc

Archive Log          2167   28-MAY-2021 02:46:25 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2183_jc0hc052_.arc

Archive Log          2168   28-MAY-2021 15:00:24 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2184_jc1tc751_.arc

Archive Log          2169   28-MAY-2021 22:03:12 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2185_jc2m3z7p_.arc

Archive Log          2170   28-MAY-2021 23:00:31 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2186_jc2phgn5_.arc

Archive Log          2171   29-MAY-2021 02:46:26 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2187_jc33q21q_.arc

Archive Log          2172   29-MAY-2021 06:00:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2188_jc3h370q_.arc

Archive Log          2173   29-MAY-2021 14:08:04 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2189_jc4co2t8_.arc

Archive Log          2174   29-MAY-2021 22:08:36 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2190_jc57t39b_.arc

Archive Log          2175   30-MAY-2021 02:46:34 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2191_jc5r36jm_.arc

Archive Log          2176   30-MAY-2021 05:00:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2192_jc5zyow9_.arc

Archive Log          2177   30-MAY-2021 05:20:25 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2193_jc613s9q_.arc

Backup Set           306    30-MAY-2021 05:22:01

  Backup Piece       306    30-MAY-2021 05:22:01 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_ab004bnn_331_1_20210530

Backup Set           309    30-MAY-2021 05:35:58

  Backup Piece       309    30-MAY-2021 05:35:58 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_ad004cel_333_1_20210530


RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set           295    23-MAY-2021 05:28:18

  Backup Piece       295    23-MAY-2021 05:28:18 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9kvvht0t_308_1_20210523

Backup Set           285    23-MAY-2021 05:21:17

  Backup Piece       285    23-MAY-2021 05:21:17 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9lvvht0u_309_1_20210523

Backup Set           286    23-MAY-2021 05:21:26

  Backup Piece       286    23-MAY-2021 05:21:26 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9mvvht2l_310_1_20210523

Backup Set           287    23-MAY-2021 05:21:35

  Backup Piece       287    23-MAY-2021 05:21:35 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9nvvht2o_311_1_20210523

Backup Set           288    23-MAY-2021 05:21:41

  Backup Piece       288    23-MAY-2021 05:21:41 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9ovvht30_312_1_20210523

Backup Set           289    23-MAY-2021 05:22:04

  Backup Piece       289    23-MAY-2021 05:22:04 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9pvvht38_313_1_20210523

Backup Set           290    23-MAY-2021 05:22:12

  Backup Piece       290    23-MAY-2021 05:22:12 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9qvvht41_314_1_20210523

Backup Set           291    23-MAY-2021 05:22:13

  Backup Piece       291    23-MAY-2021 05:22:13 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9rvvht44_315_1_20210523

Backup Set           292    23-MAY-2021 05:22:14

  Backup Piece       292    23-MAY-2021 05:22:14 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9svvht46_316_1_20210523

Archive Log          2148   23-MAY-2021 05:28:28 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2164_jbmlys9p_.arc

Backup Set           294    23-MAY-2021 05:22:17

  Backup Piece       294    23-MAY-2021 05:22:17 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_9uvvht49_318_1_20210523

Control File Copy     24     23-MAY-2021 05:29:28 /u04/db_backup/rman/TEST10/control_TEST10_a1vvhtho_20210523.bak

Backup Set           297    23-MAY-2021 05:29:27

  Backup Piece       297    23-MAY-2021 05:29:27 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_a0vvhtg5_320_1_20210523

Archive Log          2149   23-MAY-2021 10:09:45 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2165_jbn3g8jp_.arc

Archive Log          2150   23-MAY-2021 13:27:34 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2166_jbnh15s4_.arc

Archive Log          2151   24-MAY-2021 01:58:37 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2167_jbov1d2z_.arc

Archive Log          2152   24-MAY-2021 02:46:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2168_jboxvhnb_.arc

Archive Log          2153   24-MAY-2021 22:00:27 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2169_jbr1gsfk_.arc

Archive Log          2154   25-MAY-2021 02:00:18 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2170_jbrhjjs5_.arc

Archive Log          2155   25-MAY-2021 02:49:04 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2171_jbrlcyhj_.arc

Archive Log          2156   25-MAY-2021 13:27:57 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2172_jbsqsq59_.arc

Archive Log          2157   25-MAY-2021 22:00:57 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2173_jbtovrr2_.arc

Archive Log          2158   25-MAY-2021 22:01:39 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2174_jbtox2rg_.arc

Archive Log          2159   26-MAY-2021 02:46:16 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2175_jbv6lqtz_.arc

Archive Log          2160   26-MAY-2021 11:00:36 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2176_jbw3kmp3_.arc

Archive Log          2161   26-MAY-2021 22:00:44 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2177_jbxb7c1r_.arc

Archive Log          2162   26-MAY-2021 22:03:20 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2178_jbxbd71c_.arc

Archive Log          2163   27-MAY-2021 02:46:08 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2179_jbxtyhm1_.arc

Archive Log          2164   27-MAY-2021 17:59:30 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2180_jbzjh1k7_.arc

Archive Log          2165   27-MAY-2021 22:01:27 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2181_jbzynpp9_.arc

Archive Log          2166   28-MAY-2021 00:47:06 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2182_jc08c8wh_.arc

Archive Log          2167   28-MAY-2021 02:46:25 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2183_jc0hc052_.arc

Archive Log          2168   28-MAY-2021 15:00:24 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2184_jc1tc751_.arc

Archive Log          2169   28-MAY-2021 22:03:12 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2185_jc2m3z7p_.arc

Archive Log          2170   28-MAY-2021 23:00:31 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2186_jc2phgn5_.arc

Archive Log          2171   29-MAY-2021 02:46:26 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2187_jc33q21q_.arc

Archive Log          2172   29-MAY-2021 06:00:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2188_jc3h370q_.arc

Archive Log          2173   29-MAY-2021 14:08:04 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2189_jc4co2t8_.arc

Archive Log          2174   29-MAY-2021 22:08:36 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2190_jc57t39b_.arc

Archive Log          2175   30-MAY-2021 02:46:34 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2191_jc5r36jm_.arc

Archive Log          2176   30-MAY-2021 05:00:40 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2192_jc5zyow9_.arc

Archive Log          2177   30-MAY-2021 05:20:25 /u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2193_jc613s9q_.arc

Backup Set           306    30-MAY-2021 05:22:01

  Backup Piece       306    30-MAY-2021 05:22:01 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_ab004bnn_331_1_20210530

Backup Set           309    30-MAY-2021 05:35:58

  Backup Piece       309    30-MAY-2021 05:35:58 /u04/db_backup/rman/TEST10/Backup_TEST10_DB_ad004cel_333_1_20210530

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9kvvht0t_308_1_20210523 RECID=295 STAMP=1073280030

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9lvvht0u_309_1_20210523 RECID=285 STAMP=1073280030

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9mvvht2l_310_1_20210523 RECID=286 STAMP=1073280086

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9nvvht2o_311_1_20210523 RECID=287 STAMP=1073280089

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9ovvht30_312_1_20210523 RECID=288 STAMP=1073280097

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9pvvht38_313_1_20210523 RECID=289 STAMP=1073280104

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9rvvht44_315_1_20210523 RECID=291 STAMP=1073280133

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9qvvht41_314_1_20210523 RECID=290 STAMP=1073280129

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2164_jbmlys9p_.arc RECID=2148 STAMP=1073280508

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9svvht46_316_1_20210523 RECID=292 STAMP=1073280134

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_9uvvht49_318_1_20210523 RECID=294 STAMP=1073280137

deleted control file copy

control file copy file name=/u04/db_backup/rman/TEST10/control_TEST10_a1vvhtho_20210523.bak RECID=24 STAMP=1073280568

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_a0vvhtg5_320_1_20210523 RECID=297 STAMP=1073280522

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2165_jbn3g8jp_.arc RECID=2149 STAMP=1073297385

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_23/o1_mf_1_2166_jbnh15s4_.arc RECID=2150 STAMP=1073309254

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2167_jbov1d2z_.arc RECID=2151 STAMP=1073354317

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2168_jboxvhnb_.arc RECID=2152 STAMP=1073357200

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_24/o1_mf_1_2169_jbr1gsfk_.arc RECID=2153 STAMP=1073426427

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2170_jbrhjjs5_.arc RECID=2154 STAMP=1073440818

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2171_jbrlcyhj_.arc RECID=2155 STAMP=1073443744

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2172_jbsqsq59_.arc RECID=2156 STAMP=1073482077

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2173_jbtovrr2_.arc RECID=2157 STAMP=1073512857

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_25/o1_mf_1_2174_jbtox2rg_.arc RECID=2158 STAMP=1073512899

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2175_jbv6lqtz_.arc RECID=2159 STAMP=1073529976

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2176_jbw3kmp3_.arc RECID=2160 STAMP=1073559636

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2177_jbxb7c1r_.arc RECID=2161 STAMP=1073599244

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_26/o1_mf_1_2178_jbxbd71c_.arc RECID=2162 STAMP=1073599400

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2179_jbxtyhm1_.arc RECID=2163 STAMP=1073616368

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2180_jbzjh1k7_.arc RECID=2164 STAMP=1073671170

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_27/o1_mf_1_2181_jbzynpp9_.arc RECID=2165 STAMP=1073685687

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2182_jc08c8wh_.arc RECID=2166 STAMP=1073695626

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2183_jc0hc052_.arc RECID=2167 STAMP=1073702785

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2184_jc1tc751_.arc RECID=2168 STAMP=1073746824

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2185_jc2m3z7p_.arc RECID=2169 STAMP=1073772192

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_28/o1_mf_1_2186_jc2phgn5_.arc RECID=2170 STAMP=1073775631

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2187_jc33q21q_.arc RECID=2171 STAMP=1073789186

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2188_jc3h370q_.arc RECID=2172 STAMP=1073800840

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2189_jc4co2t8_.arc RECID=2173 STAMP=1073830084

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_29/o1_mf_1_2190_jc57t39b_.arc RECID=2174 STAMP=1073858916

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2191_jc5r36jm_.arc RECID=2175 STAMP=1073875594

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2192_jc5zyow9_.arc RECID=2176 STAMP=1073883640

deleted archived log

archived log file name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/archivelog/2021_05_30/o1_mf_1_2193_jc613s9q_.arc RECID=2177 STAMP=1073884825

deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ab004bnn_331_1_20210530 RECID=306 STAMP=1073884920

Deleted 22 objects


deleted backup piece

backup piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ad004cel_333_1_20210530 RECID=309 STAMP=1073885668

Deleted 22 objects



sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT


Starting backup at 03-JUN-2021 14:47:52

channel c1: starting compressed incremental level 0 datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00004 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/idata01.dbf

channel c1: starting piece 1 at 03-JUN-2021 14:47:52

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00002 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/sysaux01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:47:52

channel c2: finished piece 1 at 03-JUN-2021 14:48:27

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ah00fuco_337_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:35

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00008 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/tcmanagerdb01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:27

channel c2: finished piece 1 at 03-JUN-2021 14:48:28

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ai00fudr_338_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00003 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/undotbs01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:28

channel c2: finished piece 1 at 03-JUN-2021 14:48:31

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_aj00fuds_339_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

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

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00009 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafiletcprodmanager01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:31

channel c2: finished piece 1 at 03-JUN-2021 14:48:32

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ak00fudv_340_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00001 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/system01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:33

channel c2: finished piece 1 at 03-JUN-2021 14:48:48

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_al00fue1_341_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:15

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/ilog01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:48

channel c2: finished piece 1 at 03-JUN-2021 14:48:51

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_am00fueg_342_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

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

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00006 name=/u04/db_backup/Flash_recovery_area/TEST10/TEST10/datafile/indx01.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:51

channel c2: finished piece 1 at 03-JUN-2021 14:48:52

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_an00fuej_343_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00007 name=/u01/app/oracle/product/12.1.0/dbhome_1/tcservermanagerdb.dbf

channel c2: starting piece 1 at 03-JUN-2021 14:48:52

channel c2: finished piece 1 at 03-JUN-2021 14:48:53

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ao00fuek_344_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

including current control file in backup set

channel c2: starting piece 1 at 03-JUN-2021 14:48:54

channel c2: finished piece 1 at 03-JUN-2021 14:48:58

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ap00fuel_345_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:04

channel c2: starting compressed incremental level 0 datafile backup set

channel c2: specifying datafile(s) in backup set

including current SPFILE in backup set

channel c2: starting piece 1 at 03-JUN-2021 14:48:58

channel c2: finished piece 1 at 03-JUN-2021 14:48:59

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_aq00fueq_346_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c1: finished piece 1 at 03-JUN-2021 14:52:23

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ag00fuco_336_1_20210603 tag=FULL_BACKUP_DAILY comment=NONE

channel c1: backup set complete, elapsed time: 00:04:31

Finished backup at 03-JUN-2021 14:52:23


Starting backup at 03-JUN-2021 14:52:24

current log archived

channel c1: starting compressed archived log backup set

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

input archived log thread=1 sequence=2194 RECID=2178 STAMP=1073885641

input archived log thread=1 sequence=2195 RECID=2179 STAMP=1073902169

input archived log thread=1 sequence=2196 RECID=2180 STAMP=1073945420

input archived log thread=1 sequence=2197 RECID=2181 STAMP=1073956227

input archived log thread=1 sequence=2198 RECID=2182 STAMP=1073961991

input archived log thread=1 sequence=2199 RECID=2183 STAMP=1074031217

input archived log thread=1 sequence=2200 RECID=2184 STAMP=1074042729

input archived log thread=1 sequence=2201 RECID=2185 STAMP=1074048363

input archived log thread=1 sequence=2202 RECID=2186 STAMP=1074070822

channel c1: starting piece 1 at 03-JUN-2021 14:52:24

channel c2: starting compressed archived log backup set

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

input archived log thread=1 sequence=2203 RECID=2187 STAMP=1074117617

input archived log thread=1 sequence=2204 RECID=2188 STAMP=1074129236

input archived log thread=1 sequence=2205 RECID=2189 STAMP=1074134792

input archived log thread=1 sequence=2206 RECID=2190 STAMP=1074173346

input archived log thread=1 sequence=2207 RECID=2191 STAMP=1074204053

input archived log thread=1 sequence=2208 RECID=2192 STAMP=1074216553

input archived log thread=1 sequence=2209 RECID=2193 STAMP=1074221197

input archived log thread=1 sequence=2210 RECID=2194 STAMP=1074264472

input archived log thread=1 sequence=2211 RECID=2195 STAMP=1074264744

channel c2: starting piece 1 at 03-JUN-2021 14:52:24

channel c1: finished piece 1 at 03-JUN-2021 14:52:49

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_ar00ful8_347_1_20210603 tag=TAG20210603T145224 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:25

channel c2: finished piece 1 at 03-JUN-2021 14:52:49

piece handle=/u04/db_backup/rman/TEST10/Backup_TEST10_DB_as00ful8_348_1_20210603 tag=TAG20210603T145224 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:25

Finished backup at 03-JUN-2021 14:52:49


Starting backup at 03-JUN-2021 14:52:49

channel c1: starting datafile copy

copying current control file

output file name=/u04/db_backup/rman/TEST10/control_TEST10_at00fum2_20210603.bak tag=TAG20210603T145249 RECID=26 STAMP=1074264770

channel c1: datafile copy complete, elapsed time: 00:00:01

Finished backup at 03-JUN-2021 14:52:51


released channel: c1


released channel: c2


Recovery Manager complete.


No comments:

Post a Comment