Firing ---> backup Database :
RMAN> backup database; ---------> To take full database backup without archivelog
Starting backup at 20-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 device type=DISK
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_TAG20171220T134938_f3n78vhm_.bkp tag=TAG20171220T134938 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
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_TAG20171220T134938_f3n7bodf_.bkp tag=TAG20171220T134938 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 20-DEC-17
List Backup :
RMAN> list backup; -----------> lists all the previous backups taken by RMAN
List of Backup Sets
===================
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
Note : Current Control File and SPfile backups are stored in a different backup set.
No comments:
Post a Comment