Oracle9i starts RMAN to provide the Plus archivelog option, which greatly simplifies the operation of the RMAN backup.
When you define a Plus ArchiveLog statement, the RMAN performs the following steps: 1. Run an Alter System ArchiveLog Current Command 2. Run the Backup ArchiveLog all command. Note If backup optimization is enabled, RMAN only backs up unstoping logs 3. Back up the files defined in the backup command. Run the Alter System ArchiveLog Current Command 5. Back up all the remaining archiving logs
Test backup script:
Backup Database
Format '/ OPT / Oracle / ORABAK / FULL_% D_% T_% s'
Plus archivelog
Format '/ OPT / Oracle / ORABAK / ARCH_% D_% T_% s'
DELETE ALL INPUT;
Test log:
[Oracle @ Jumper Oracle] $ RMAN Target /
Recovery Manager: Release 9.2.0.4.0 - Production
CopyRight (C) 1995, 2002, Oracle Corporation. All Rights Reserved.
Connected to Target Database: Conner (DBID = 315202922)
Rman> Run {
2> Backup Database
3> format '/ opt / oracle / ORABAK / FULL% D_% T_% s'
4> Plus archivelog
5> format '/ opt / oracle / ORABAK / ARCH_% D_% T_% s'
6> delete all infut;}
Starting Backup AT 04-NOV-04
Current Log Archived
Using Target Database ControlFile INSTEAD OF Recovery Catalog
Allocated Channel: ORA_DISK_1
CHANNEL ORA_DISK_1: SID = 12 DevType = Disk
Channel Ora_Disk_1: Starting Archive Log Backupset
Channel Ora_Disk_1: Specifying Archive Log (S) in Backup Set
Input Archive log thread = 1 sequence = 163 Recid = 6 stamp = 541351580
Channel Ora_Disk_1: Starting Piece 1 AT 04-NOV-04
CHANNEL ORA_DISK_1: Finished Piece 1 AT 04-NOV-04
Piece Handle = / OPT / ORACLE / ORABAK / ARCH_CONNER_20041104_7 Comment = NONE
Channel Ora_Disk_1: Backup Set Complete, ELAPSED TIME: 00:00:02
Channel Ora_Disk_1: Deleting Archive Log (s)
Archive log filename = / opt / oracle / oradata / conn / archive / 1_163.dbf recid = 6 stamp = 541351580
Finished Backup AT 04-NOV-04
Starting Backup AT 04-NOV-04
USING CHANNEL ORA_DISK_1
CHANNEL ORA_DISK_1: Starting Full DataFile Backupset
Channel Ora_Disk_1: Specifying DataFile (S) in Backupset
Including Current SPFILE IN BACKUPSET
INCLUDING CURRENT ControlFile in Backupset
INPUT DATAFILE FNO = 00004 Name = / OPT / ORACLE / ORADATA / CNNER / EYGLE01.DBF
Input datafile fno = 00001 name = / opt / oracle / oradata / conn / system01.dbf
Input DataFile FNO = 00002 Name = / OPT / ORACLE / ORADATA / CNNER / UNDOTBS01.DBF
Input DataFile FNO = 00003 Name = / OPT / Oracle / ORADATA / CNNER / USERS01.DBF
Channel Ora_Disk_1: Starting Piece 1 AT 04-NOV-04
AAAACHANNEL ORA_DISK_1: Finished Piece 1 AT 04-NOV-04
Piece Handle = / OPT / ORACLE / ORABAK / FULL_CONNER_20041104_8 Comment = NONE
Channel Ora_Disk_1: Backup Set Complete, ELAPSED TIME: 00:04:04
Finished Backup AT 04-NOV-04
Starting Backup AT 04-NOV-04
Current Log Archived
USING CHANNEL ORA_DISK_1
Channel Ora_Disk_1: Starting Archive Log Backupset
Channel Ora_Disk_1: Specifying Archive Log (S) in Backup Set
Input Archive log thread = 1 sequence = 164 Recid = 7 stamp = 541351832
Channel Ora_Disk_1: Starting Piece 1 AT 04-NOV-04
CHANNEL ORA_DISK_1: Finished Piece 1 AT 04-NOV-04
Piece Handle = / OPT / ORACLE / ORABAK / ARCH_CONNER_20041104_9 Comment = NONE
Channel Ora_Disk_1: Backup Set Complete, ELAPSED TIME: 00:00:02
Channel Ora_Disk_1: Deleting Archive Log (s)
Archive log filename = / opt / oracle / oradata / conn / archive / 1_164.dbf recid = 7 stamp = 541351832
Finished Backup AT 04-NOV-04
Rman>
By Plus ArchiveLog, backup operations are simplified while ensuring that the required logs are backed up.
[Oracle @ Jumper ORABAK] $ ls -l
Total 751628
-rw-r ----- 1 Oracle DBA 156160 NOV 4 15:26 Arch_Conner_20041104_7
-rw-r ----- 1 Oracle DBA 60928 NOV 4 15:30 Arch_Conner_20041104_9
-rw-r ----- 1 Oracle DBA 768679936 NOV 4 15:30 Full_Conner_20041104_8
Author: eygle, Oracle technology followers, Oracle technical forum itpub.www.eygle.com from China is the biggest author's personal site you may contact the author by Guoqiang.Gai@gmail.com welcome to explore technical exchanges and links. exchange.
Original source:
Http://www.eygle.com/ha/use.rman.plus.archivelog.Option.htm
