Simplifies database backup operations with the Rman plus archvielog option

Backup | data | database
Oracle9i begins Rman to provide the plus archivelog option, greatly simplifying the operation of the Rman backup.

When you define the plus Archivelog statement, 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 will only back up logs that have not been backed up
3. Back up the files defined in the backup command
4. Run alter SYSTEM archivelog current command
5. Back up all the remaining archive logs

To test the 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-productioncopyright (c) 1995, 2002, Oracl E Corporation. All rights reserved.connected to target Database:conner (dbid=3152029224) 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 input; }starting backup at 04-nov-04current log archivedusing target database controlfile instead of recovery catalogallocated CH Annel:ora_disk_1channel ora_disk_1:sid=12 devtype=diskchannel ora_disk_1:starting archive log Backupsetchannel ORA_ Disk_1:specifying Archive log (s) in Backup SetInput archive log thread=1 sequence=163 recid=6 stamp=541351580channel Disk_1:starting piece 1 at 04-nov-04channel ora_disk_1:finished piece 1 at 04-nov-04piece Handle=/opt/oracle/orabak/arch _conner_20041104_7 Comment=nonechannel ora_disk_1:backup set complete. Elapsed Time:00:00:02channel Ora_disk_1: Deleting archive Log (s) archive log filename=/opt/oracle/oradata/conner/archive/1_163.dbf recid=6 stamp=541351580finished backup at 04- Nov-04starting backup at 04-nov-04using Channel Ora_disk_1channel ora_disk_1:starting full datafile backupsetchannel ORA _disk_1:specifying DataFile (s) in backupsetincluding-SPFILE in backupsetincluding current controlfile in Backupse Tinput datafile fno=00004 name=/opt/oracle/oradata/conner/eygle01.dbfinput datafile fno=00001 Oradata/conner/system01.dbfinput datafile fno=00002 name=/opt/oracle/oradata/conner/undotbs01.dbfinput datafile FNO =00003 Name=/opt/oracle/oradata/conner/users01.dbfchannel ora_disk_1:starting piece 1 at 04-NOV-04aaaachannel ORA_ disk_1:finished piece 1 at 04-nov-04piece handle=/opt/oracle/orabak/full_conner_20041104_8 Comment=NONEchannel Disk_1:backup set complete, elapsed time:00:04:04finished backup at 04-nov-04starting backup at 04-nov-04current log arc hivedusing channel Ora_disk_1channel ora_disk_1:starting ARChive log Backupsetchannel ora_disk_1:specifying archive log (s) in Backup SetInput archive log thread=1 sequence=164 Reci d=7 Stamp=541351832channel ora_disk_1:starting piece 1 at 04-nov-04channel ora_disk_1:finished piece 1 at 04-NOV-04piece Handle=/opt/oracle/orabak/arch_conner_20041104_9 Comment=nonechannel ora_disk_1:backup set complete, elapsed time: 00:00:02channel ora_disk_1:deleting Archive Log (s) archive log filename=/opt/oracle/oradata/conner/archive/1_164.dbf Recid=7 stamp=541351832finished Backup at 04-nov-04rman>

The plus Archivelog simplifies backup operations while ensuring that the required logs are backed up.

[Oracle@jumper orabak]$ ls-ltotal 751628-rw-r-----1 Oracle DBA 156160 Nov 4 15:26 arch_conner_20041104_7-rw-r-----1 ora CLE DBA 60928 Nov 4 15:30 arch_conner_20041104_9-rw-r-----1 Oracle DBA 768679936 Nov 4 15:30 full_conner_20041104_8







The author of this article:
Eygle,oracle technology concern, from China's largest Oracle technology forum Itpub.
Www.eygle.com is the author's personal site. You can contact the author by Guoqiang.Gai@gmail.com. Welcome technical discussions and exchange of links.

Original source:

Http://www.eygle.com/ha/Use.Rman.Plus.Archivelog.Option.htm