Home » RDBMS Server » Backup & Recovery » Rman Backup with plus archivelog ( Oralce 10g / RH 06)
Rman Backup with plus archivelog [message #323808] Thu, 29 May 2008 10:05 Go to next message
girish.udipi
Messages: 3
Registered: May 2008
Location: Calgary Canada
Junior Member
Hi Everyone !
Had run this script but it didnot work properly and when we tried to test by restore it kept on asking for additional archive logs.Our guess was it didnot archive the current log So we run another script and it worked Can anyone tell me what might have been the problem? plus arhivelog should have archived the current log too right?Kindly advice !!
Thanks !

This script didnot work !!

run {
allocate channel c1 device type disk format '/RH06_MD3000_01/backups/PROD02/20080527_090842/%U';
allocate channel c2 device type disk format '/RH06_MD3000_02/backups/PROD02/20080527_090842/%U';
allocate channel c3 device type disk format '/RH06_MD3000_03/backups/PROD02/20080527_090842/%U';
allocate channel c4 device type disk format '/RH06_MD3000_04/backups/PROD02/20080527_090842/%U';
allocate channel c5 device type disk format '/RH06_MD3000_05/backups/PROD02/20080527_090842/%U';
allocate channel c6 device type disk format '/RH06_MD3000_06/backups/PROD02/20080527_090842/%U';

backup as backupset
tag='PROD02_20080527_090842'
maxsetsize=350G
(tablespace
CWMLITE
,DRSYS
,METAFRAME
,ODM
,SYSAUX
,SYSTEM
,TOOLS
,UNDOTBS1
,USERS
,XDB)
plus archivelog;
}


This script worked !!

run {
sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
allocate channel c1 device type disk format '/RH06_MD3000_06/backups/PROD02/20080527_090842/%U';
backup as backupset
tag='AL_PROD02_20080527_090842'
maxsetsize=350G
archivelog all;
}

Report message to a moderator

Re: Rman Backup with plus archivelog [message #323817 is a reply to message #323808] Thu, 29 May 2008 10:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What about copying and pasting your RMAN session that we can see it?

Regards
Michel

Report message to a moderator

Re: Rman Backup with plus archivelog [message #323832 is a reply to message #323808] Thu, 29 May 2008 11:41 Go to previous messageGo to next message
girish.udipi
Messages: 3
Registered: May 2008
Location: Calgary Canada
Junior Member
Thanks Michel for your immediate reply.
Posted below is the RMAN session.The session as such didnot give any errors just that the it didnot take backup of Current logs and hence asked for additional archives while restore !! The below script had to be added to take care of missing current log archive.But from the documentation "plus archivelog" option should take care of it.
The DB is in archive mode,Optimization not enabled,and backup was taken when it was hot/Up.

run {

sql "ALTER SYSTEM ARCHIVE LOG CURRENT";

allocate channel c1 device type disk format '/RH06_MD3000_06/backups/PROD02/20080527_090842/%U';

backup as backupset

tag='AL_PROD02_20080527_090842'

maxsetsize=350G

archivelog all;


The RMAN session O/P
--------------------->>
Spooling started in log file: /home/oracle/scripts/RMAN/PROD02.rman.backup.log

Recovery Manager10.2.0.4.0

RMAN>
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

RMAN>
RMAN> 2> 3> 4> 5> 6> 7> 8>
sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

allocated channel: c1
channel c1: sid=291 devtype=DISK

Starting backup at 28-MAY-08
current log archived
channel c1: starting archive log backupset channel c1: specifying archive log(s) in backup set input archive log thread=1 sequence=184667 recid=109 stamp=655927980 input archive log thread=1 sequence=184668 recid=110 stamp=655928571 input archive log thread=1 sequence=184669 recid=111 stamp=655928921 input archive log thread=1 sequence=184670 recid=112 stamp=655930926 input archive log thread=1 sequence=184671 recid=113 stamp=655931474 input archive log thread=1 sequence=184672 recid=114 stamp=655934915 input archive log thread=1 sequence=184673 recid=115 stamp=655934915 channel c1: starting piece 1 at 28-MAY-08 channel c1: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_06/backups/PROD02/20080528_200701/44jhhhe4_1_1 tag=AL_PROD02_20080528_200701 comment=NONE channel c1: backup set complete, elapsed time: 00:21:06 Finished backup at 28-MAY-08

Starting Control File and SPFILE Autobackup at 28-MAY-08 piece handle=/home/oracle/product/10.2.0/dbs/c-3402402951-20080528-03 comment=NONE Finished Control File and SPFILE Autobackup at 28-MAY-08 released channel: c1

RMAN>
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46>
allocated channel: c1
channel c1: sid=291 devtype=DISK

allocated channel: c2
channel c2: sid=232 devtype=DISK

allocated channel: c3
channel c3: sid=235 devtype=DISK

allocated channel: c4
channel c4: sid=240 devtype=DISK

allocated channel: c5
channel c5: sid=190 devtype=DISK

allocated channel: c6
channel c6: sid=181 devtype=DISK


Starting backup at 28-MAY-08
current log archived
channel c1: starting archive log backupset channel c1: specifying archive log(s) in backup set input archive log thread=1 sequence=184667 recid=109 stamp=655927980 input archive log thread=1 sequence=184668 recid=110 stamp=655928571 channel c1: starting piece 1 at 28-MAY-08 channel c2: starting archive log backupset channel c2: specifying archive log(s) in backup set input archive log thread=1 sequence=184669 recid=111 stamp=655928921 input archive log thread=1 sequence=184670 recid=112 stamp=655930926 channel c2: starting piece 1 at 28-MAY-08 channel c3: starting archive log backupset channel c3: specifying archive log(s) in backup set input archive log thread=1 sequence=184671 recid=113 stamp=655931474 input archive log thread=1 sequence=184672 recid=114 stamp=655934915 channel c3: starting piece 1 at 28-MAY-08 channel c4: starting archive log backupset channel c4: specifying archive log(s) in backup set input archive log thread=1 sequence=184673 recid=115 stamp=655934915 input archive log thread=1 sequence=184674 recid=116 stamp=655936189 channel c4: starting piece 1 at 28-MAY-08 channel c4: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_04/backups/PROD02/20080528_200701/49jhhilt_1_1 tag=PROD02_20080528_200701 comment=NONE channel c4: backup set complete, elapsed time: 00:00:03 channel c3: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_03/backups/PROD02/20080528_200701/48jhhilt_1_1 tag=PROD02_20080528_200701 comment=NONE channel c3: backup set complete, elapsed time: 00:19:29 channel c1: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_01/backups/PROD02/20080528_200701/46jhhilt_1_1 tag=PROD02_20080528_200701 comment=NONE channel c1: backup set complete, elapsed time: 00:19:54 channel c2: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_02/backups/PROD02/20080528_200701/47jhhilt_1_1 tag=PROD02_20080528_200701 comment=NONE channel c2: backup set complete, elapsed time: 00:19:54 Finished backup at 28-MAY-08

Starting backup at 28-MAY-08
channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset input datafile fno=00486 name=/S6140_Undo_L01/oradata/prod02/undotbs01_06.dbf
input datafile fno=00487 name=/S6140_Undo_L01/oradata/prod02/undotbs01_07.dbf
input datafile fno=00001 name=/S6140_DB_L03/oradata/prod02/system01.dbf
input datafile fno=00853 name=/S6140_DB_L03/oradata/prod02/GAB_DATA02.dbf
input datafile fno=01556 name=/S6140_DB_L03/oradata/prod02/WPS_DATA2.dbf
input datafile fno=00762 name=/S6140_Undo_L01/oradata/prod02/undotbs01_08.dbf
input datafile fno=00857 name=/S6140_Undo_L01/oradata/prod02/undotbs01_09.dbf
input datafile fno=00882 name=/S6140_Undo_L01/oradata/prod02/undotbs01_10.dbf
input datafile fno=00983 name=/S6140_Undo_L01/oradata/prod02/undotbs01_11.dbf
channel c1: starting piece 1 at 28-MAY-08 channel c2: starting full datafile backupset channel c2: specifying datafile(s) in backupset input datafile fno=01093 name=/S6140_Undo_L01/oradata/prod02/undotbs01_12.dbf
input datafile fno=01094 name=/S6140_Undo_L01/oradata/prod02/undotbs01_13.dbf
input datafile fno=01219 name=/S6140_Undo_L01/oradata/prod02/undotbs01_14.dbf
input datafile fno=01220 name=/S6140_Undo_L01/oradata/prod02/undotbs01_15.dbf
input datafile fno=01221 name=/S6140_Undo_L01/oradata/prod02/undotbs01_16.dbf
channel c2: starting piece 1 at 28-MAY-08 channel c3: starting full datafile backupset channel c3: specifying datafile(s) in backupset input datafile fno=01222 name=/S6140_Undo_L01/oradata/prod02/undotbs01_17.dbf
input datafile fno=01223 name=/S6140_Undo_L01/oradata/prod02/undotbs01_18.dbf
input datafile fno=01233 name=/S6140_Undo_L01/oradata/prod02/undotbs01_19.dbf
input datafile fno=01234 name=/S6140_Undo_L01/oradata/prod02/undotbs01_20.dbf
input datafile fno=01235 name=/S6140_Undo_L01/oradata/prod02/undotbs01_21.dbf
channel c3: starting piece 1 at 28-MAY-08 channel c4: starting full datafile backupset channel c4: specifying datafile(s) in backupset input datafile fno=01236 name=/S6140_Undo_L01/oradata/prod02/undotbs01_22.dbf
input datafile fno=01237 name=/S6140_Undo_L01/oradata/prod02/undotbs01_23.dbf
input datafile fno=01238 name=/S6140_Undo_L01/oradata/prod02/undotbs01_24.dbf
input datafile fno=01239 name=/S6140_Undo_L01/oradata/prod02/undotbs01_25.dbf
input datafile fno=01240 name=/S6140_Undo_L01/oradata/prod02/undotbs01_26.dbf
channel c4: starting piece 1 at 28-MAY-08 channel c5: starting full datafile backupset channel c5: specifying datafile(s) in backupset input datafile fno=00144 name=/S6140_Undo_L01/oradata/prod02/undotbs01_04.dbf
input datafile fno=01349 name=/S6140_DB_L03/oradata/prod02/CORE_DATA7.dbf
input datafile fno=00752 name=/S6140_DB_L03/oradata/prod02/CORE_DATA3.dbf
input datafile fno=00499 name=/S6140_DB_L03/oradata/prod02/sysaux_01.dbf
input datafile fno=01578 name=/S6140_DB_L03/oradata/prod02/bf_apex_files.dbf
input datafile fno=00543 name=/S6140_DB_L03/oradata/prod02/system03.dbf
input datafile fno=00950 name=/S6140_DB_L03/oradata/prod02/WPS_DATA1.dbf
input datafile fno=00004 name=/S6140_DB_L03/oradata/prod02/drsys01.dbf
input datafile fno=00007 name=/S6140_DB_L03/oradata/prod02/odm01.dbf
input datafile fno=00038 name=/S6140_DB_L03/oradata/prod02/secur_data1.dbf
input datafile fno=00039 name=/S6140_DB_L03/oradata/prod02/secur_indx1.dbf
input datafile fno=00010 name=/S6140_DB_L02/oradata/prod02/xdb01.dbf
input datafile fno=00145 name=/S6140_Undo_L01/oradata/prod02/undotbs01_05.dbf
channel c5: starting piece 1 at 28-MAY-08 channel c6: starting full datafile backupset channel c6: specifying datafile(s) in backupset input datafile fno=00064 name=/S6140_Undo_L01/oradata/prod02/undotbs01_02.dbf
input datafile fno=00829 name=/S6140_DB_L03/oradata/prod02/CORE_DATA4.dbf
input datafile fno=00401 name=/S6140_DB_L03/oradata/prod02/CORE_DATA1.dbf
input datafile fno=00469 name=/S6140_DB_L03/oradata/prod02/system02.dbf
input datafile fno=00952 name=/S6140_DB_L03/oradata/prod02/WPS_LARGE_DATA1.dbf
input datafile fno=00402 name=/S6140_DB_L03/oradata/prod02/CORE_INDX1.dbf
input datafile fno=00949 name=/S6140_DB_L03/oradata/prod02/MetaFrame1.dbf
input datafile fno=01048 name=/S6140_DB_L05/oradata/prod02/GAB_LARGE_INDX03.DBF
input datafile fno=00953 name=/S6140_DB_L05/oradata/prod02/WPS_LARGE_INDX1.dbf
input datafile fno=00303 name=/S6140_DB_L05/oradata/prod02/GAB2_INDX1.dbf
input datafile fno=00271 name=/S6140_DB_L05/oradata/prod02/GAB_LARGE_INDX01.dbf
input datafile fno=00905 name=/S6140_DB_L05/oradata/prod02/GAB_LARGE_INDX02.dbf
input datafile fno=00304 name=/S6140_DB_L05/oradata/prod02/GAB2_LARGE_INDX1.dbf
channel c6: starting piece 1 at 28-MAY-08 channel c6: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_06/backups/PROD02/20080528_200701/4fjhhjr9_1_1 tag=PROD02_20080528_200701 comment=NONE channel c6: backup set complete, elapsed time: 01:08:08 channel c6: starting full datafile backupset channel c6: specifying datafile(s) in backupset input datafile fno=00002 name=/S6140_Undo_L01/oradata/prod02/undotbs01_01.dbf
input datafile fno=01346 name=/S6140_DB_L03/oradata/prod02/CORE_DATA5.dbf
input datafile fno=00485 name=/S6140_DB_L03/oradata/prod02/CORE_DATA2.dbf
input datafile fno=00268 name=/S6140_DB_L03/oradata/prod02/GAB_DATA01.dbf
input datafile fno=00301 name=/S6140_DB_L03/oradata/prod02/GAB2_DATA1.dbf
input datafile fno=00320 name=/S6140_DB_L03/oradata/prod02/testtrack_01.dbf
input datafile fno=00006 name=/S6140_DB_L03/oradata/prod02/indx01.dbf
input datafile fno=00003 name=/S6140_DB_L03/oradata/prod02/cwmlite01.dbf
input datafile fno=00265 name=/S6140_DB_L02/oradata/prod02/tools02.dbf
input datafile fno=01477 name=/S6140_DB_L02/oradata/prod02/WEB_REPORTS06.dbf
input datafile fno=00704 name=/S6140_DB_L02/oradata/prod02/WEB_REPORTS02.DBF
input datafile fno=00231 name=/S6140_DB_L02/oradata/prod02/WEB_REPORTS01.dbf
input datafile fno=00009 name=/S6140_DB_L02/oradata/prod02/users01.dbf
channel c6: starting piece 1 at 28-MAY-08 channel c5: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_05/backups/PROD02/20080528_200701/4ejhhjr9_1_1 tag=PROD02_20080528_200701 comment=NONE channel c5: backup set complete, elapsed time: 01:21:03 channel c5: starting full datafile backupset channel c5: specifying datafile(s) in backupset input datafile fno=00065 name=/S6140_Undo_L01/oradata/prod02/undotbs01_03.dbf
input datafile fno=01348 name=/S6140_DB_L03/oradata/prod02/CORE_DATA6.dbf
input datafile fno=01000 name=/S6140_DB_L03/oradata/prod02/GAB_DATA03.dbf
input datafile fno=00302 name=/S6140_DB_L03/oradata/prod02/GAB2_LARGE_DATA1.dbf
input datafile fno=00269 name=/S6140_DB_L03/oradata/prod02/GAB_LARGE_DATA.dbf
input datafile fno=01577 name=/S6140_DB_L03/oradata/prod02/bf_apex.dbf
input datafile fno=01568 name=/S6140_DB_L03/oradata/prod02/plpdf_data.dbf
input datafile fno=00270 name=/S6140_DB_L05/oradata/prod02/GAB_INDX.dbf
input datafile fno=00951 name=/S6140_DB_L05/oradata/prod02/WPS_INDX1.dbf
input datafile fno=01127 name=/S6140_DB_L02/oradata/prod02/WEB_REPORTS04.DBF
input datafile fno=00008 name=/S6140_DB_L02/oradata/prod02/tools01.dbf
input datafile fno=01047 name=/S6140_DB_L02/oradata/prod02/WEB_REPORTS03.DBF
input datafile fno=01343 name=/S6140_DB_L02/oradata/prod02/WEB_REPORTS05.DBF
channel c5: starting piece 1 at 28-MAY-08 channel c6: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_06/backups/PROD02/20080528_200701/4gjhhnr1_1_1 tag=PROD02_20080528_200701 comment=NONE channel c6: backup set complete, elapsed time: 01:03:53 channel c6: starting full datafile backupset channel c6: specifying datafile(s) in backupset input datafile fno=01380 name=/S6140_Undo_L01/oradata/prod02/undotbs01_27.dbf
channel c6: starting piece 1 at 28-MAY-08 channel c5: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_05/backups/PROD02/20080528_200701/4hjhhoj9_1_1 tag=PROD02_20080528_200701 comment=NONE channel c5: backup set complete, elapsed time: 00:55:52 channel c2: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_02/backups/PROD02/20080528_200701/4bjhhjr9_1_1 tag=PROD02_20080528_200701 comment=NONE channel c2: backup set complete, elapsed time: 02:22:41 channel c3: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_03/backups/PROD02/20080528_200701/4cjhhjr9_1_1 tag=PROD02_20080528_200701 comment=NONE channel c3: backup set complete, elapsed time: 02:22:41 channel c4: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_04/backups/PROD02/20080528_200701/4djhhjr9_1_1 tag=PROD02_20080528_200701 comment=NONE channel c4: backup set complete, elapsed time: 02:22:42 channel c6: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_06/backups/PROD02/20080528_200701/4ijhhriq_1_1 tag=PROD02_20080528_200701 comment=NONE channel c6: backup set complete, elapsed time: 00:19:16 channel c1: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_01/backups/PROD02/20080528_200701/4ajhhjr9_1_1 tag=PROD02_20080528_200701 comment=NONE channel c1: backup set complete, elapsed time: 02:36:32 Finished backup at 28-MAY-08

Starting backup at 28-MAY-08
current log archived
channel c1: starting archive log backupset channel c1: specifying archive log(s) in backup set input archive log thread=1 sequence=184675 recid=117 stamp=655944217 input archive log thread=1 sequence=184676 recid=118 stamp=655944567 channel c1: starting piece 1 at 28-MAY-08 channel c2: starting archive log backupset channel c2: specifying archive log(s) in backup set input archive log thread=1 sequence=184681 recid=123 stamp=655946502 input archive log thread=1 sequence=184682 recid=124 stamp=655946772 channel c2: starting piece 1 at 28-MAY-08 channel c3: starting archive log backupset channel c3: specifying archive log(s) in backup set input archive log thread=1 sequence=184677 recid=119 stamp=655945244 input archive log thread=1 sequence=184678 recid=120 stamp=655945459 channel c3: starting piece 1 at 28-MAY-08 channel c4: starting archive log backupset channel c4: specifying archive log(s) in backup set input archive log thread=1 sequence=184679 recid=121 stamp=655945904 input archive log thread=1 sequence=184680 recid=122 stamp=655946276 channel c4: starting piece 1 at 28-MAY-08 channel c5: starting archive log backupset channel c5: specifying archive log(s) in backup set input archive log thread=1 sequence=184683 recid=125 stamp=655946802 channel c5: starting piece 1 at 28-MAY-08 channel c5: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_05/backups/PROD02/20080528_200701/4njhht1k_1_1 tag=PROD02_20080528_200701 comment=NONE channel c5: backup set complete, elapsed time: 00:03:35 channel c1: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_01/backups/PROD02/20080528_200701/4jjhht1k_1_1 tag=PROD02_20080528_200701 comment=NONE channel c1: backup set complete, elapsed time: 00:27:41 channel c2: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_02/backups/PROD02/20080528_200701/4kjhht1k_1_1 tag=PROD02_20080528_200701 comment=NONE channel c2: backup set complete, elapsed time: 00:27:41 channel c3: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_03/backups/PROD02/20080528_200701/4ljhht1k_1_1 tag=PROD02_20080528_200701 comment=NONE channel c3: backup set complete, elapsed time: 00:27:41 channel c4: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_04/backups/PROD02/20080528_200701/4mjhht1k_1_1 tag=PROD02_20080528_200701 comment=NONE channel c4: backup set complete, elapsed time: 00:27:41 Finished backup at 28-MAY-08

Starting Control File and SPFILE Autobackup at 28-MAY-08 piece handle=/home/oracle/product/10.2.0/dbs/c-3402402951-20080528-04 comment=NONE Finished Control File and SPFILE Autobackup at 28-MAY-08 released channel: c1 released channel: c2 released channel: c3 released channel: c4 released channel: c5 released channel: c6

RMAN>
RMAN> 2> 3> 4>
allocated channel: c1
channel c1: sid=291 devtype=DISK

Starting backup at 28-MAY-08
channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset including current control file in backupset channel c1: starting piece 1 at 28-MAY-08 channel c1: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_01/backups/PROD02/20080528_200701.ctlfile tag=PROD02_20080528_200701 comment=NONE channel c1: backup set complete, elapsed time: 00:00:08 Finished backup at 28-MAY-08

Starting Control File and SPFILE Autobackup at 28-MAY-08 piece handle=/home/oracle/product/10.2.0/dbs/c-3402402951-20080528-05 comment=NONE Finished Control File and SPFILE Autobackup at 28-MAY-08 released channel: c1

RMAN>
RMAN> 2> 3> 4>
allocated channel: c1
channel c1: sid=291 devtype=DISK

Starting backup at 28-MAY-08
channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset including current SPFILE in backupset channel c1: starting piece 1 at 28-MAY-08 channel c1: finished piece 1 at 28-MAY-08 piece handle=/RH06_MD3000_01/backups/PROD02/20080528_200701.spfile tag=PROD02_20080528_200701 comment=NONE channel c1: backup set complete, elapsed time: 00:00:26 Finished backup at 28-MAY-08

Starting Control File and SPFILE Autobackup at 28-MAY-08 piece handle=/home/oracle/product/10.2.0/dbs/c-3402402951-20080528-06 comment=NONE Finished Control File and SPFILE Autobackup at 28-MAY-08 released channel: c1

RMAN>
RMAN>

Recovery Manager complete.

Report message to a moderator

Re: Rman Backup with plus archivelog [message #323833 is a reply to message #323808] Thu, 29 May 2008 11:57 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Post the session for the first script that did not work.

Report message to a moderator

Re: Rman Backup with plus archivelog [message #323837 is a reply to message #323832] Thu, 29 May 2008 12:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As varu123 said!
Do you think that posting something that works will help us to know what is the error in the script that does not work?

Regards
Michel

Report message to a moderator

Re: Rman Backup with plus archivelog [message #323856 is a reply to message #323808] Thu, 29 May 2008 15:24 Go to previous messageGo to next message
girish.udipi
Messages: 3
Registered: May 2008
Location: Calgary Canada
Junior Member
Hi Guys
Looks like I haven’t been able to communicate properly .I apologize ! Hope I am able to get through this time

Target : To take backup of selected Table space of DB and test if it restores properly.

The script used

run {
allocate channel c1 device type disk format '/RH06_MD3000_01/backups/PROD02/20080527_090842/%U';
allocate channel c2 device type disk format '/RH06_MD3000_02/backups/PROD02/20080527_090842/%U';
allocate channel c3 device type disk format '/RH06_MD3000_03/backups/PROD02/20080527_090842/%U';
allocate channel c4 device type disk format '/RH06_MD3000_04/backups/PROD02/20080527_090842/%U';
allocate channel c5 device type disk format '/RH06_MD3000_05/backups/PROD02/20080527_090842/%U';
allocate channel c6 device type disk format '/RH06_MD3000_06/backups/PROD02/20080527_090842/%U';

backup as backupset
tag='PROD02_20080527_090842'
maxsetsize=350G
(tablespace
CWMLITE
,DRSYS
,METAFRAME
,ODM
,SYSAUX
,SYSTEM
,TOOLS
,UNDOTBS1
,USERS
,XDB)
plus archivelog;
}

Output: Have posted in last mail !

Result :1)As you have observed there was no error while
taking backup.
2) The problem came when we tried to restore the backup. It asked for additional archive and there was no archive missing ! Realised that Current Logs were not archived by RMAN, even though “ plus archivelog” is supposed to do that. Hence the missing archives

“plus archivelog” is supposed to do all this
1. Runs an ALTER SYSTEM ARCHIVE LOG CURRENT statement.
2. Runs the BACKUP ARCHIVELOG ALL command. Note that if backup
optimization is enabled, then RMAN only backs up logs that have not yet been backed up.
3. Backs up the files specified in the BACKUP command.
4. Runs an ALTER SYSTEM ARCHIVE LOG CURRENT statement.
5. Backs up any remaining archived redo logs.”

So we had to run the below script before the earlier script to make sure RMAN takes backup of Current logs too !! Restore worked after this .I am sorry but I have lost the Output of RMAN restore session to post here on the forum

Added
*********
run {
sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
allocate channel c1 device type disk format '/RH06_MD3000_06/backups/PROD02/20080527_090842/%U';
backup as backupset
tag='AL_PROD02_20080527_090842'
maxsetsize=350G
archivelog all;
}
************
[Earlier script]
run {
allocate channel c1 device type disk format '/RH06_MD3000_01/backups/PROD02/20080527_090842/%U';
allocate channel c2 device type disk format '/RH06_MD3000_02/backups/PROD02/20080527_090842/%U';
allocate channel c3 device type disk format '/RH06_MD3000_03/backups/PROD02/20080527_090842/%U';
allocate channel c4 device type disk format '/RH06_MD3000_04/backups/PROD02/20080527_090842/%U';
allocate channel c5 device type disk format '/RH06_MD3000_05/backups/PROD02/20080527_090842/%U';
allocate channel c6 device type disk format '/RH06_MD3000_06/backups/PROD02/20080527_090842/%U';
backup as backupset
tag='PROD02_20080527_090842'
maxsetsize=350G
(tablespace
CWMLITE
,DRSYS
,METAFRAME
,ODM
,SYSAUX
,SYSTEM
,TOOLS
,UNDOTBS1
,USERS
,XDB)
plus archivelog;
}


Question: Why “plus archivelog” did not archive Current logs. Is there any mistakes in the script.
Thanks

Report message to a moderator

Re: Rman Backup with plus archivelog [message #323861 is a reply to message #323856] Thu, 29 May 2008 19:20 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You still didn't post the RMAN output from the script that you claim doesn't work.

By the way, how are you performing your restore?

Report message to a moderator

Re: Rman Backup with plus archivelog [message #324073 is a reply to message #323808] Fri, 30 May 2008 11:22 Go to previous message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi,

Are you restoring your control file as well? Or just the data files? this could be the reason for asking for missing archivelog.

Report message to a moderator

Previous Topic: clarifications
Next Topic: validate RMAN backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 21:49:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.