Friday 10 January 2014

How to take the backup of single datafile along with archivelogs?

[oracle@wasiq ~]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Mon 30 DEC 21:23:22 2013

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

RMAN> connect target /;

connected to target database: PROD (DBID=246965557)
RMAN> BACKUP DATAFILE 1 PLUS ARCHIVELOG;


Starting backup at 30-DEC-13
current log archived
using channel ORA_DISK_1
skipping archived log file /d01/oracle/flash_recovery_area/PROD/archivelog/2013_12_27/o1_mf_1_4_9cvdkyy7_.arc; already backed up 1 time(s)
skipping archived log file /d01/oracle/flash_recovery_area/PROD/archivelog/2013_12_27/o1_mf_1_5_9cvk0qcf_.arc; already backed up 1 time(s)
skipping archived log file /d01/oracle/flash_recovery_area/PROD/archivelog/2013_12_27/o1_mf_1_6_9cvk1n6q_.arc; already backed up 1 time(s)
skipping archived log file /d01/oracle/flash_recovery_area/PROD/archivelog/2013_12_28/o1_mf_1_7_9cxx5dp7_.arc; already backed up 1 time(s)
skipping archived log file /d01/oracle/flash_recovery_area/PROD/archivelog/2013_12_28/o1_mf_1_8_9cxx6wsq_.arc; already backed up 1 time(s)
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=7 STAMP=835392439
input archived log thread=1 sequence=10 RECID=8 STAMP=835556826
input archived log thread=1 sequence=11 RECID=9 STAMP=835559895
channel ORA_DISK_1: starting piece 1 at 30-DEC-13
channel ORA_DISK_1: finished piece 1 at 30-DEC-13
piece handle=/d01/oracle/flash_recovery_area/PROD/backupset/2013_12_30/o1_mf_annnn_TAG20131230T195815_9d30qznf_.bkp tag=TAG20131230T195815 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-DEC-13

Starting backup at 30-DEC-13
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=/d01/oracle/oradata/prod/system01.dbf
channel ORA_DISK_1: starting piece 1 at 30-DEC-13
channel ORA_DISK_1: finished piece 1 at 30-DEC-13
piece handle=/d01/oracle/flash_recovery_area/PROD/backupset/2013_12_30/o1_mf_nnndf_TAG20131230T195816_9d30r0rt_.bkp tag=TAG20131230T195816 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 30-DEC-13

Starting backup at 30-DEC-13
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=12 RECID=10 STAMP=835559911
channel ORA_DISK_1: starting piece 1 at 30-DEC-13
channel ORA_DISK_1: finished piece 1 at 30-DEC-13
piece handle=/d01/oracle/flash_recovery_area/PROD/backupset/2013_12_30/o1_mf_annnn_TAG20131230T195831_9d30rj04_.bkp tag=TAG20131230T195831 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 30-DEC-13

Starting Control File and SPFILE Autobackup at 30-DEC-13
piece handle=/d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-03 comment=NONE
Finished Control File and SPFILE Autobackup at 30-DEC-13

RMAN>

No comments:

Post a Comment