Moneycontrol Brokerage Recos

Sunday, December 11, 2011

Database Backup Using RMAN including current controlfile and archivelogs

C:\>rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 11 00:27:36 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: TESTDB (DBID=1278452275)
RMAN> list incarnation of database
2> ;
using target database control file instead of recovery catalog
List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TESTDB  1278452275       PARENT  1          02-APR-10
2       2       TESTDB  1278452275       CURRENT 940976     10-DEC-11
RMAN>
RMAN>
RMAN> list backupset;
specification does not match any backup in the repository
RMAN> backup as compressed backupset database include current controlfile plus archivelog delete input;


Starting backup at 11-DEC-11
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=1 STAMP=769532924
input archived log thread=1 sequence=4 RECID=2 STAMP=769533898
input archived log thread=1 sequence=5 RECID=3 STAMP=769555449
input archived log thread=1 sequence=6 RECID=4 STAMP=769564042
input archived log thread=1 sequence=7 RECID=5 STAMP=769564076
input archived log thread=1 sequence=8 RECID=6 STAMP=769564095
input archived log thread=1 sequence=9 RECID=7 STAMP=769564115
input archived log thread=1 sequence=10 RECID=8 STAMP=769564133
input archived log thread=1 sequence=11 RECID=9 STAMP=769564287
input archived log thread=1 sequence=12 RECID=10 STAMP=769564335
input archived log thread=1 sequence=13 RECID=11 STAMP=769564365
input archived log thread=1 sequence=14 RECID=12 STAMP=769564407
input archived log thread=1 sequence=15 RECID=13 STAMP=769564447
input archived log thread=1 sequence=16 RECID=14 STAMP=769564511
input archived log thread=1 sequence=17 RECID=15 STAMP=769564598
input archived log thread=1 sequence=18 RECID=16 STAMP=769564666
input archived log thread=1 sequence=19 RECID=17 STAMP=769564836
input archived log thread=1 sequence=20 RECID=18 STAMP=769565147
input archived log thread=1 sequence=21 RECID=19 STAMP=769566519
channel ORA_DISK_1: starting piece 1 at 11-DEC-11
channel ORA_DISK_1: finished piece 1 at 11-DEC-11
piece handle=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\BACKUPSET\2011_12_11\O1_MF_ANNNN_TAG20111211T002840_7G7B
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: deleting archived log(s)
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_3_7G6B51TC_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_4_7G6C3LF5_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_5_7G70507T_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_6_7G78KJ6C_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_7_7G78LK8S_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_8_7G78M4J3_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_9_7G78MR3F_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_10_7G78NBVC_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_11_7G78S40Z_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_12_7G78TNPG_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_13_7G78VM7B_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_14_7G78WXNZ_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_15_7G78Y4SD_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_16_7G79041G_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_17_7G792VRW_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_10\O1_MF_1_18_7G7950F5_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_11\O1_MF_1_19_7G79B9FO_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_11\O1_MF_1_20_7G79N2SW_.ARC
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_11\O1_MF_1_21_7G7BYXJ3_.ARC
Finished backup at 11-DEC-11
Starting backup at 11-DEC-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\RAJKUMAR\ORADATA\TESTDB\SYSTEM01.DBF
input datafile file number=00002 name=C:\APP\RAJKUMAR\ORADATA\TESTDB\SYSAUX01.DBF
input datafile file number=00003 name=C:\APP\RAJKUMAR\ORADATA\TESTDB\UNDOTBS01.DBF
input datafile file number=00005 name=C:\APP\RAJKUMAR\ORADATA\TESTDB\EXAMPLE01.DBF
input datafile file number=00004 name=C:\APP\RAJKUMAR\ORADATA\TESTDB\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 11-DEC-11
channel ORA_DISK_1: finished piece 1 at 11-DEC-11
piece handle=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\BACKUPSET\2011_12_11\O1_MF_NNNDF_TAG20111211T002942_7G7C
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting compressed 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 11-DEC-11
channel ORA_DISK_1: finished piece 1 at 11-DEC-11
piece handle=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\BACKUPSET\2011_12_11\O1_MF_NCSNF_TAG20111211T002942_7G7C
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 11-DEC-11
Starting backup at 11-DEC-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=22 RECID=20 STAMP=769566681
channel ORA_DISK_1: starting piece 1 at 11-DEC-11
channel ORA_DISK_1: finished piece 1 at 11-DEC-11
piece handle=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\BACKUPSET\2011_12_11\O1_MF_ANNNN_TAG20111211T003121_7G7C
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=C:\APP\RAJKUMAR\FLASH_RECOVERY_AREA\TESTDB\ARCHIVELOG\2011_12_11\O1_MF_1_22_7G7C41HN_.ARC
Finished backup at 11-DEC-11
RMAN>

No comments:

Post a Comment