Backup based Cloning a database using RMAN

RMAN BACKUP BASED DUPLICATION:

High-Level Steps

Creating Directories 

Verifying the RMAN backup database with the control file 

Creating pfile for clone database 

Copying Password file for clone database 

copy paste listener and tns for each other: prod & clone 

Moving backup files to the directories created for the clone database 

Connecting Rman and issue the duplicate command 

Target database : TEST 

Cloned database: TESTDB

Verifying the database name, Backups available in RMAN 

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
TEST      READ WRITE


RMAN> SHOW CONTROLFILE AUTOBACKUP;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
RMAN> CROSSCHECK BACKUP OF DATABASE;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=70 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0106mhr1_1_1 RECID=1 
STAMP=1080772449 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/090798lu_1_1 RECID=9
STAMP=1081385662 Crosschecked 2 objects
RMAN>  list backup of database;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    1.19G      DISK        00:00:44     16-AUG-21
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20210816T223409
        Piece Name: /u01/app/oracle/product/19.0.0/dbhome_1/dbs/0106mhr1_1_1
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1       Full 2351179    16-AUG-21              NO    /u01/app/oracle/oradata/TEST/system01.dbf
  3       Full 2351179    16-AUG-21              NO    /u01/app/oracle/oradata/TEST/sysaux01.dbf
  4       Full 2351179    16-AUG-21              NO    /u01/app/oracle/oradata/TEST/undotbs01.dbf
  7       Full 2351179    16-AUG-21              NO    /u01/app/oracle/oradata/TEST/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Full    1.23G      DISK        00:00:51     24-AUG-21
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20210824T005422
        Piece Name: /u01/app/oracle/oradata/TEST/backup/090798lu_1_1
  List of Datafiles in backup set 9
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1       Full 2769124    24-AUG-21              NO    /u01/app/oracle/oradata/TEST/system01.dbf
  3       Full 2769124    24-AUG-21              NO    /u01/app/oracle/oradata/TEST/sysaux01.dbf
  4       Full 2769124    24-AUG-21              NO    /u01/app/oracle/oradata/TEST/undotbs01.dbf
  7       Full 2769124    24-AUG-21              NO    /u01/app/oracle/oradata/TEST/users01.dbf

Creating Pfile for TESTDB

[oratest@oracle dbs]$ vi inittestdb.ora


*.db_name='testdb
*.control_files='/u01/app/oracle/oradata/TESTDB/control04.ctl','/u01/app/oracle/oradata/TESTDB/control05.ctl'
#*.db_recovery_file_dest size=1g
#*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_file_name_convert='/u01/app/oracle/oradata/TEST/datafile','/u01/app/oracle/oradata/TESTDB'
*.log_file_name_convert='/u01/app/oracle/oracle/oradata/TEST/onlinelog','/u01/app/oracle/oradata/TESTDB'

Copy  Target Database Password File to Auxiliary Database 

[oratest@oracle dbs]$ cp orapwtest orapwtestdb
[oratest@oracle oradata]$ mkdir testdb


[oratest@oracle oradata]$ ls
data01.dbf  ORCL  TEST  testdb

Copying the RMAN backup pieces and control file auto backup to Desired location ‘TESTDB’ 

[oratest@oracle backup]$ cp c-2378581000-20210824/u01/app/oracle/oradata/testdb
[oratest@oracle backup]$ cp c-2378581002021082402/u01/app/oracle/oradata/testdb
[oratest@oracle backup]$ cp 070798lh_1_1 /u01/app/oracle/oradata/testdb
[oratest@oracle backup]$ cp 090798lu_1_1 /u01/app/oracle/oradata/testdb

[oratest@oracle testdb]$ ls -l
total 1319440
-rw-rw----. 1 oratest oratest   10682368 Aug 24 01:01 070798lh_1_1
-rw-rw----. 1 oratest oratest 1318993920 Aug 24 01:02 090798lu_1_1
-rw-rw----. 1 oratest oratest   10715136 Aug 24 01:01 c-2378581000-20210824-01
-rw-rw----. 1 oratest oratest   10715136 Aug 24 01:01 c-2378581000-20210824-02
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch
Oldest online log sequence     10
Next log sequence to archive   12
Current log sequence           12
[oratest@oracle dbs]$ export ORACLE_SID=testdb
[oratest@oracle dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 24 22:33:36 2021
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup pfile='$ORACLE_HOME/dbs/inittestdb.ora' nomount;
ORACLE instance started.

Total System Global Area  281017392 bytes
Fixed Size                  8895536 bytes
Variable Size             218103808 bytes
Database Buffers           50331648 bytes
Redo Buffers                3686400 bytes

SQL> exit
[oratest@oracle dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 24 22:54:08 2021
Version 19.3.0.0.0

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

connected to target database: TESTDB (not mounted)

RMAN> exit

Verifying Listener and Tns Entries

TESTDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.24 )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testdb)
      (UR = A)
    )
  )

[oratest@oracle admin]$ rman target sys/oracle@test

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 24 22:55:01 2021
Version 19.3.0.0.0

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

connected to target database: TEST (DBID=2378581000)

RMAN>  connect auxiliary sys/oracle@testdb

connected to auxiliary database: TESTDB (not mounted)

Making the clone Database in nomount state to Duplicate the Database

[oratest@oracle dbs]$ export ORACLE_SID=testdb
[oratest@oracle dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 24 23:09:52 2021
Version 19.3.0.0.0

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


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

SQL> select status from v$instance;

STATUS
------------
STARTED

[oratest@oracle dbs]$  rman auxiliary /

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 24 23:11:06 2021
Version 19.3.0.0.0

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

connected to auxiliary database: TESTDB (not mounted)

RMAN> duplicate target database to testdb backup location
'/u01/app/oracle/oradata/testdb' nofilenamecheck;

Starting Duplicate Db at 24-AUG-21
searching for database ID
found backup of database ID 2378581000

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     281017392 bytes

Fixed Size                     8895536 bytes
Variable Size                218103808 bytes
Database Buffers              50331648 bytes
Redo Buffers                   3686400 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name =
 ''TEST'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
 ''testdb'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile from  '/u01/app/oracle/oradata/testdb/c-2378581000-20210824-04';
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''TEST'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''testdb'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area     281017392 bytes

Fixed Size                     8895536 bytes
Variable Size                218103808 bytes
Database Buffers              50331648 bytes
Redo Buffers                   3686400 bytes

Starting restore at 24-AUG-21
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=424 device type=DISK

channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/TESTDB/control07.ctl
output file name=/u01/app/oracle/oradata/TESTDB/control08.ctl
Finished restore at 24-AUG-21

database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=424 device type=DISK
RMAN-05158: WARNING: auxiliary (bctfile) file name /u01/app/oracle/oradata/TEST/changetracking/o1_mf_jl7qx7bp_.chg conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/oradata/TEST/redo01.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/oradata/TEST/redo02.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/oradata/TEST/redo03.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/TEST/system01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/TEST/sysaux01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/TEST/undotbs01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/TEST/users01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /u01/app/oracle/oradata/TEST/temp01.dbf conflicts with a file used by the target database

contents of Memory Script:
{
   set until scn  2841711;
   set newname for datafile  1 to
 "/u01/app/oracle/oradata/TEST/system01.dbf";
   set newname for datafile  3 to
 "/u01/app/oracle/oradata/TEST/sysaux01.dbf";
   set newname for datafile  4 to
 "/u01/app/oracle/oradata/TEST/undotbs01.dbf";
   set newname for datafile  7 to
 "/u01/app/oracle/oradata/TEST/users01.dbf";
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 24-AUG-21
using channel ORA_AUX_DISK_1

database opened 
Cannot remove created server parameter file 
Finished Duplicate Db at 24-AUG-21
 
RMAN> exit 
 
Recovery Manager complete. 
 

Now the database has been successfully cloned we can verify the Database

SQL> select name,open_mode from v$database;
 
NAME         OPEN_MODE
---------  --------------------
TESTDB      READ WRITE
 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

RMAN Backup archive log between SCN

RMAN Backup archive log between SCN:

 

RMAN> backup archivelog scn between 34535421234 and 67555696397;

Starting backup at 2021/08/22 01:46:29
using channel ORA_DISK_1
specification does not match any archived log in the repository
backup cancelled because there are no files to backup
Finished backup at 2021/08/22 01:46:30

Starting Control File and SPFILE Autobackup at 2021/08/22 01:46:31
piece handle=/backup/oracle/ORACLEAGENT/rman/WWIQDW_autobcf_c-759447934-20210822-05 
comment=NONE
Finished Control File and SPFILE Autobackup at 2021/08/22 01:46:38

RMAN Backup Archive log between Sequence

RMAN Backup Archive log between Sequence:

RMAN> backup archivelog sequence between 2044002 and 2044096;

Starting backup at 2021/08/22 01:35:55
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=315 device type=DISK
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044063 RECID=2044031 STAMP=1081215146
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044063.416.1081215359 RECID=2044082 STAMP=1081215358
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044007 RECID=2043975 STAMP=1081214910
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044007.417.1081215359 RECID=2044083 STAMP=1081215359
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044022 RECID=2043990 STAMP=1081214979
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044022.419.1081215361 RECID=2044084 STAMP=1081215360
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044065 RECID=2044033 STAMP=1081215155
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044065.421.1081215361 RECID=2044085 STAMP=1081215361
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044030 RECID=2043998 STAMP=1081215011
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044030.424.1081215363 RECID=2044086 STAMP=1081215362
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044073 RECID=2044041 STAMP=1081215188
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044073.427.1081215363 RECID=2044087 STAMP=1081215363
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044038 RECID=2044006 STAMP=1081215042
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044038.413.1081215365 RECID=2044089 STAMP=1081215365
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044059 RECID=2044027 STAMP=1081215129
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044059.412.1081215365 RECID=2044090 STAMP=1081215366
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044062 RECID=2044030 STAMP=1081215141
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044062.411.1081215367 RECID=2044091 STAMP=1081215367
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044092 RECID=2044060 STAMP=1081215261
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044092.410.1081215367 RECID=2044092 STAMP=1081215368
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044086 RECID=2044054 STAMP=1081215237
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044086.408.1081215369 RECID=2044093 STAMP=1081215369
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044018 RECID=2043986 STAMP=1081214961
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044018.382.1081215371 RECID=2044094 STAMP=1081215370
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044027 RECID=2043995 STAMP=1081214997
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044027.378.1081215371 RECID=2044095 STAMP=1081215371
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044032 RECID=2044000 STAMP=1081215018
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044032.375.1081215373 RECID=2044097 STAMP=1081215372
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044025 RECID=2043993 STAMP=1081214990
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044025.371.1081215373 RECID=2044098 STAMP=1081215373
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044037 RECID=2044005 STAMP=1081215038
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044037.368.1081215375 RECID=2044099 STAMP=1081215374
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044039 RECID=2044007 STAMP=1081215046
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044039.364.1081215375 RECID=2044100 STAMP=1081215376
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044091 RECID=2044059 STAMP=1081215257
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044091.363.1081215377 RECID=2044101 STAMP=1081215377
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044033 RECID=2044001 STAMP=1081215022
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044033.362.1081215377 RECID=2044102 STAMP=1081215378
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044096 RECID=2044064 STAMP=1081215276
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044096.361.1081215379 RECID=2044103 STAMP=1081215379
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044090 RECID=2044058 STAMP=1081215254
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044090.356.1081215379 RECID=2044105 STAMP=1081215380
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044056 RECID=2044024 STAMP=1081215116
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044056.306.1081215381 RECID=2044106 STAMP=1081215381
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044021 RECID=2043989 STAMP=1081214975
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044021.268.1081215383 RECID=2044107 STAMP=1081215382
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044072 RECID=2044040 STAMP=1081215184
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044072.266.1081215383 RECID=2044108 STAMP=1081215383
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044019 RECID=2043987 STAMP=1081214966
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044019.265.1081215385 RECID=2044109 STAMP=1081215384
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044068 RECID=2044036 STAMP=1081215167
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044068.263.1081215385 RECID=2044110 STAMP=1081215385
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044015 RECID=2043983 STAMP=1081214945
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044015.262.1081215387 RECID=2044111 STAMP=1081215386
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044077 RECID=2044045 STAMP=1081215203
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044077.260.1081215387 RECID=2044113 STAMP=1081215388
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044088 RECID=2044056 STAMP=1081215245
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044088.259.1081215389 RECID=2044114 STAMP=1081215389
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044028 RECID=2043996 STAMP=1081215002
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044028.258.1081215389 RECID=2044115 STAMP=1081215390
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044006 RECID=2043974 STAMP=1081214906
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044006.705.1081215391 RECID=2044116 STAMP=1081215391
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044078 RECID=2044046 STAMP=1081215207
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044078.708.1081215391 RECID=2044117 STAMP=1081215392
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044004 RECID=2043972 STAMP=1081214897
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044004.707.1081215393 RECID=2044118 STAMP=1081215393
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044016 RECID=2043984 STAMP=1081214951
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044016.703.1081215395 RECID=2044119 STAMP=1081215394
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044051 RECID=2044019 STAMP=1081215095
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044051.700.1081215395 RECID=2044120 STAMP=1081215395
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044034 RECID=2044002 STAMP=1081215026
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044034.498.1081215397 RECID=2044122 STAMP=1081215396
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044069 RECID=2044037 STAMP=1081215172
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044069.591.1081215397 RECID=2044123 STAMP=1081215397
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044035 RECID=2044003 STAMP=1081215030
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044035.349.1081215399 RECID=2044124 STAMP=1081215399
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044023 RECID=2043991 STAMP=1081214982
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044023.334.1081215399 RECID=2044125 STAMP=1081215400
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044061 RECID=2044029 STAMP=1081215137
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044061.505.1081215401 RECID=2044126 STAMP=1081215401
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044087 RECID=2044055 STAMP=1081215241
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044087.278.1081215401 RECID=2044127 STAMP=1081215402
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044085 RECID=2044053 STAMP=1081215233
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044085.532.1081215403 RECID=2044128 STAMP=1081215403
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044036 RECID=2044004 STAMP=1081215034
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044036.509.1081215403 RECID=2044129 STAMP=1081215404
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044058 RECID=2044026 STAMP=1081215125
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044058.740.1081215405 RECID=2044130 STAMP=1081215405
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044066 RECID=2044034 STAMP=1081215159
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044066.671.1081215407 RECID=2044132 STAMP=1081215406
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044045 RECID=2044013 STAMP=1081215071
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044045.397.1081215407 RECID=2044133 STAMP=1081215407
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044041 RECID=2044009 STAMP=1081215054
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044041.295.1081215409 RECID=2044134 STAMP=1081215408
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044074 RECID=2044042 STAMP=1081215191
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044074.325.1081215409 RECID=2044135 STAMP=1081215409
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044012 RECID=2043980 STAMP=1081214931
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044012.714.1081215411 RECID=2044136 STAMP=1081215411
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044089 RECID=2044057 STAMP=1081215250
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044089.698.1081215411 RECID=2044137 STAMP=1081215412
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044055 RECID=2044023 STAMP=1081215111
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044055.723.1081215413 RECID=2044138 STAMP=1081215413
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044024 RECID=2043992 STAMP=1081214986
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044024.401.1081215413 RECID=2044139 STAMP=1081215414
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044054 RECID=2044022 STAMP=1081215107
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044054.267.1081215415 RECID=2044141 STAMP=1081215415
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044048 RECID=2044016 STAMP=1081215083
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044048.670.1081215417 RECID=2044142 STAMP=1081215416
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044057 RECID=2044025 STAMP=1081215121
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044057.343.1081215417 RECID=2044143 STAMP=1081215417
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044009 RECID=2043977 STAMP=1081214918
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044009.404.1081215419 RECID=2044144 STAMP=1081215418
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044081 RECID=2044049 STAMP=1081215217
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044081.530.1081215419 RECID=2044145 STAMP=1081215419
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044008 RECID=2043976 STAMP=1081214914
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044008.352.1081215421 RECID=2044146 STAMP=1081215421
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044079 RECID=2044047 STAMP=1081215211
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044079.527.1081215421 RECID=2044147 STAMP=1081215422
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044070 RECID=2044038 STAMP=1081215176
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044070.329.1081215423 RECID=2044148 STAMP=1081215423
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044013 RECID=2043981 STAMP=1081214936
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044013.496.1081215423 RECID=2044150 STAMP=1081215424
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044020 RECID=2043988 STAMP=1081214971
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044020.522.1081215425 RECID=2044151 STAMP=1081215425
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044064 RECID=2044032 STAMP=1081215150
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044064.560.1081215425 RECID=2044152 STAMP=1081215426
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044043 RECID=2044011 STAMP=1081215063
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044043.755.1081215427 RECID=2044153 STAMP=1081215427
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044011 RECID=2043979 STAMP=1081214927
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044011.345.1081215429 RECID=2044154 STAMP=1081215428
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044031 RECID=2043999 STAMP=1081215014
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044031.582.1081215429 RECID=2044155 STAMP=1081215429
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044071 RECID=2044039 STAMP=1081215180
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044071.272.1081215431 RECID=2044156 STAMP=1081215430
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044083 RECID=2044051 STAMP=1081215225
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044083.735.1081215431 RECID=2044157 STAMP=1081215432
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044002 RECID=2043970 STAMP=1081214889
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044002.742.1081215433 RECID=2044158 STAMP=1081215433
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044075 RECID=2044043 STAMP=1081215195
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044075.783.1081215433 RECID=2044159 STAMP=1081215434
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044026 RECID=2043994 STAMP=1081214993
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044026.782.1081215435 RECID=2044160 STAMP=1081215435
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044046 RECID=2044014 STAMP=1081215075
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044046.781.1081215435 RECID=2044162 STAMP=1081215436
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044040 RECID=2044008 STAMP=1081215050
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044040.780.1081215439 RECID=2044163 STAMP=1081215439
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044052 RECID=2044020 STAMP=1081215099
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044052.779.1081215439 RECID=2044164 STAMP=1081215440
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044082 RECID=2044050 STAMP=1081215221
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044082.778.1081215441 RECID=2044165 STAMP=1081215441
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044003 RECID=2043971 STAMP=1081214893
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044003.777.1081215443 RECID=2044166 STAMP=1081215443
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044094 RECID=2044062 STAMP=1081215268
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044094.570.1081215443 RECID=2044167 STAMP=1081215444
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044049 RECID=2044017 STAMP=1081215087
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044049.316.1081215445 RECID=2044168 STAMP=1081215445
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044042 RECID=2044010 STAMP=1081215059
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044042.393.1081215445 RECID=2044169 STAMP=1081215446
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044095 RECID=2044063 STAMP=1081215272
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044095.327.1081215447 RECID=2044170 STAMP=1081215447
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044010 RECID=2043978 STAMP=1081214922
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044010.326.1081215447 RECID=2044171 STAMP=1081215448
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044076 RECID=2044044 STAMP=1081215199
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044076.593.1081215449 RECID=2044173 STAMP=1081215449
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044014 RECID=2043982 STAMP=1081214940
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044014.757.1081215449 RECID=2044174 STAMP=1081215450
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044029 RECID=2043997 STAMP=1081215006
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044029.566.1081215453 RECID=2044175 STAMP=1081215453
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044093 RECID=2044061 STAMP=1081215265
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044093.536.1081215455 RECID=2044176 STAMP=1081215454
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044067 RECID=2044035 STAMP=1081215163
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044067.398.1081215455 RECID=2044177 STAMP=1081215455
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044017 RECID=2043985 STAMP=1081214956
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044017.696.1081215457 RECID=2044178 STAMP=1081215457
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044005 RECID=2043973 STAMP=1081214901
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044005.554.1081215459 RECID=2044179 STAMP=1081215460
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044047 RECID=2044015 STAMP=1081215079
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044047.453.1081215461 RECID=2044180 STAMP=1081215461
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044050 RECID=2044018 STAMP=1081215091
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044050.304.1081215461 RECID=2044181 STAMP=1081215462
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044084 RECID=2044052 STAMP=1081215229
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044084.283.1081215463 RECID=2044182 STAMP=1081215463
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044060 RECID=2044028 STAMP=1081215133
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044060.733.1081215463 RECID=2044184 STAMP=1081215464
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044044 RECID=2044012 STAMP=1081215067
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044044.753.1081215467 RECID=2044185 STAMP=1081215467
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044053 RECID=2044021 STAMP=1081215103
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044053.601.1081215467 RECID=2044186 STAMP=1081215468
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=2044080 RECID=2044048 STAMP=1081215214
output file name=+ORA_FRA/ORACLEAGENT/ARCHIVELOG/2021_08_22/thread_1_seq_2044080.292.1081215469 RECID=2044187 STAMP=1081215470
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03
Finished backup at 2021/08/22 01:37:52

 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

RMAN Backup Archive log Until Sequence

RMAN Backup Archive log Until Sequence :

RMAN>  backup archivelog until sequence 5000;

Starting backup at 11-AUG-21
using channel ORA_DISK_1
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=9 RECID=5 STAMP=1080341951
channel ORA_DISK_1: starting piece 1 at 11-AUG-21
channel ORA_DISK_1: finished piece 1 at 11-AUG-21
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0k069eq4_1_1 
tag=TAG20210811T232244 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-AUG-21

Starting Control File and SPFILE Autobackup at 11-AUG-21
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-1608118455-20210811-08 
comment=NONE
Finished Control File and SPFILE Autobackup at 11-AUG-21


 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

RMAN Backup Current Controlfile

RMAN Backup Current controlfile:

 

RMAN> backup current controlfile;

Starting backup at 11-AUG-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 11-AUG-21
channel ORA_DISK_1: finished piece 1 at 11-AUG-21
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0m069eu0_1_1 
tag=TAG20210811T232448 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-AUG-21

Starting Control File and SPFILE Autobackup at 11-AUG-21
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-1608118455-20210811-09 
comment=NONE
Finished Control File and SPFILE Autobackup at 11-AUG-21

 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

RMAN Backup Spfile

RMAN Backup spfile :

RMAN> backup spfile;

Starting backup at 11-AUG-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 11-AUG-21
channel ORA_DISK_1: finished piece 1 at 11-AUG-21
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0o069ev4_1_1 
tag=TAG20210811T232524 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-AUG-21

Starting Control File and SPFILE Autobackup at 11-AUG-21
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-1608118455-20210811-0a 
comment=NONE
Finished  at 11-AUG-21

 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

19C RMAN CONCEPTS

rman

19c RMAN CONCEPTS:

RECOVER DATAFILE WITHOUT RMAN BACKUP
RECOVER THROUGH RESETLOGS
BLOCK CHANGE TRACKING
RECOVER LOSS OF ALL CONTROL FILE USING AUTO BACKUP
RECOVER LOSS OF ALL ONLINE REDO LOGS 
POINT IN TIME RECOVERY 
RMAN-06183: datafile or datafile copy xyz.dbf larger than MAXSETSIZE
RMAN Database Restore ASM
DATABASE INCARNATION USING RMAN
Restore Tablespace using RMAN
RESTORE SPFILE USING RMAN
RMAN backup Full Database
RMAN Backup Tablespace
RMAN Backup Particular Datafile
RMAN Backup Spfile
RMAN Backup Current Control file
RMAN Backup Archive log Until Sequence
RMAN Backup Archive log Between Sequence
RMAN Backup Archive log Between SCN
RMAN Backup Archive log Until SCN
RMAN Backup Database Plus Archive log
RMAN Backup Database Includes A Control file
RMAN Backup Archive log and All Delete Input
RMAN Backup Archive log All and Skip Inaccessible
LEVEL 0 and LEVEL 1 Backup And Recovery using RMAN
CROSSCHECK BACKUPS Using RMAN
RESTORE CONTROL FILE USING RMAN
Backup-based Cloning of a database using RMAN
RECOVERY CATALOG DATABASE IN RMAN
RMAN ORA ERRORS
DBVERIFY
END-OF-FILE ERROR
LEVEL 0 INCREMENTAL BACKUP
point-in-time recovery using RMAN in 19c
Recover a loss of all online redo log files

Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8