Firing Command ----> backup database plus archivelog;
RMAN> backup database plus archivelog; ---------> this command will take full database backup plus backup of archivelogs
Starting backup at 20-DEC-17
current log archived
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=5 RECID=1 STAMP=963237178
channel ORA_DISK_1: starting piece 1 at 20-DEC-17
channel ORA_DISK_1: finished piece 1 at 20-DEC-17
piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135258_f3n7h3w3_.bkp tag=TAG20171220T135258 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-DEC-17
Starting backup at 20-DEC-17
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oraclebase/oradata/testdb2/system01.dbf
input datafile file number=00002 name=/u01/app/oraclebase/oradata/testdb2/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oraclebase/oradata/testdb2/example01.dbf
input datafile file number=00003 name=/u01/app/oraclebase/oradata/testdb2/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oraclebase/oradata/testdb2/users01.dbf
channel ORA_DISK_1: starting piece 1 at 20-DEC-17
channel ORA_DISK_1: finished piece 1 at 20-DEC-17
piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T135301_f3n7h5k2_.bkp tag=TAG20171220T135301 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
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
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 20-DEC-17
channel ORA_DISK_1: finished piece 1 at 20-DEC-17
piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T135301_f3n7k9sv_.bkp tag=TAG20171220T135301 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-DEC-17
Starting backup at 20-DEC-17
current log archived
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=6 RECID=2 STAMP=963237251
channel ORA_DISK_1: starting piece 1 at 20-DEC-17
channel ORA_DISK_1: finished piece 1 at 20-DEC-17
piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135411_f3n7kcp0_.bkp tag=TAG20171220T135411 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-DEC-17
List Backup :
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 1.07G DISK 00:00:49 20-DEC-17
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20171220T134938
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T134938_f3n78vhm_.bkp
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1011626 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/system01.dbf
2 Full 1011626 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/sysaux01.dbf
3 Full 1011626 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/undotbs01.dbf
4 Full 1011626 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/users01.dbf
5 Full 1011626 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 9.36M DISK 00:00:01 20-DEC-17
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20171220T134938
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T134938_f3n7bodf_.bkp
SPFILE Included: Modification time: 20-DEC-17
SPFILE db_unique_name: TESTDB2
Control File Included: Ckp SCN: 1011646 Ckp time: 20-DEC-17
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------- -------------------> Part of previous backup (OBSOLETE)
3 28.04M DISK 00:00:01 20-DEC-17
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20171220T135258
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135258_f3n7h3w3_.bkp
List of Archived Logs in backup set 3 -------> Archive log files backup before backup
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 5 987658 19-DEC-17 1011720 20-DEC-17
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 1.07G DISK 00:00:57 20-DEC-17
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20171220T135301
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T135301_f3n7h5k2_.bkp
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/system01.dbf
2 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/sysaux01.dbf
3 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/undotbs01.dbf
4 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/users01.dbf
5 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 9.36M DISK 00:00:04 20-DEC-17
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20171220T135301
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T135301_f3n7k9sv_.bkp
SPFILE Included: Modification time: 20-DEC-17
SPFILE db_unique_name: TESTDB2
Control File Included: Ckp SCN: 1011748 Ckp time: 20-DEC-17
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6 2.50K DISK 00:00:00 20-DEC-17
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20171220T135411
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135411_f3n7kcp0_.bkp
List of Archived Logs in backup set 6 -------> Archive log files backup after backup
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6 1011720 20-DEC-17 1011754 20-DEC-17
No comments:
Post a Comment