Home » RDBMS Server » Backup & Recovery » RMAN hotbackup (merged 3)
RMAN hotbackup (merged 3) [message #419153] Thu, 20 August 2009 02:16 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

i have my production db which has two destinations for archivelog. the reason i have two locations is because on one location, the log are being deleted by RMAN itself and the second location is being deleted manually for replication of archivelog to the DR sites. After sending to the DR site it is being rename.

My problem is when the archivelogs is being rename or deleted in the second location, RMAN give me an error when performing hotbackup, missing archivelog. yes, it is true that on the second location the archivelog has been rename, but in the first location the archivelog is there.
Is there any way so that RMAN does not crosscheck the sequence of archivelog in the second location.

Thanks,

sailesh
RMAN hotbackup [message #419155 is a reply to message #419153] Thu, 20 August 2009 02:31 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

i have a production db with two location for archivelogs, archiv1 & archiv2. The reason i have configured this, is that i am using RMAN to perform hotbackup and when the backup ends it deletes the archivelog in location 1 whereas on location 2 the archivelog should remain there for remote transfer to my DR site. After sending, the archivelog is being rename in location 2.

The problem is that when i am performing a hotbackup, rman giving an error: archivelog missing. Indeed, in location 2 the archivelog has been rename, but in location 1, the archivelog is still there.

Is there any way so that when i perform a hotbackup, rman just verifies the log in location 1 only.

OR,

on the scripts "BACKUP ARCHIVELOG ALL DELETE ALL INPUT", can i specifies a date which backup to delete. or just delete archivelog which are older than 1 day. Then, one location for archivelog destination would do the job.

Thanks,

Sailesh
Re: RMAN hotbackup [message #419385 is a reply to message #419155] Fri, 21 August 2009 14:09 Go to previous messageGo to next message
babuknb
Messages: 1718
Registered: December 2005
Location: NJ
Senior Member


Please post your complete RMAN Script.

Thanks
Re: RMAN hotbackup (merged 3) [message #419406 is a reply to message #419153] Fri, 21 August 2009 22:30 Go to previous messageGo to next message
purple73
Messages: 7
Registered: August 2009
Junior Member
The problem is you are deleting archived logs other than RMAN means. So before you backup your logs try the following:

rman> change archivelog all crosscheck;

source: Metalink Doc ID: 112829.1

Re: RMAN hotbackup [message #419429 is a reply to message #419385] Sat, 22 August 2009 03:40 Go to previous message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi gentlebabu,

Please find attached my scripts and the logs.

Script /usr/openv/netbackup/ext/db_ext/oracle/hot_database_backup.sh
==== started on Sat Aug 22 07:50:46 MUT 2009 ====


RMAN: /oracle/app/oracle/product/10.2/bin/rman
ORACLE_SID: cnp1
ORACLE_USER: oracle
ORACLE_HOME: /oracle/app/oracle/product/10.2

NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: hypervisor2
NB_ORA_POLICY: live_cnp1_hotbackup

Full backup requested
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
You have new mail.
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> RMAN> nected to target database: CNP (DBID=66200643)
connected to recovery catalog database

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>
allocated channel: ch00
channel ch00: sid=776 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

Starting backup at 22-AUG-09
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00006 name=/data2/cnp/cnp.dbf
input datafile fno=00016 name=/data1/cnp/rocdata.dbf
input datafile fno=00007 name=/data1/cnp/cnpind.dbf
input datafile fno=00017 name=/data1/cnp/rocind.dbf
input datafile fno=00001 name=/data1/cnp/system.dbf
input datafile fno=00020 name=/data1/cnp/users01.dbf
input datafile fno=00003 name=/data1/cnp/sysaux01.dbf
input datafile fno=00002 name=/data1/cnp/undotbs2.dbf
input datafile fno=00019 name=/data1/cnp/undotbs1.dbf
input datafile fno=00005 name=/data1/cnp/cms.dbf
input datafile fno=00027 name=/data1/cnp/mccico.dbf
input datafile fno=00026 name=/data1/cnp/mast.dbf
input datafile fno=00014 name=/data1/cnp/portalind.dbf
input datafile fno=00023 name=/data1/cnp/xdb.dbf
input datafile fno=00008 name=/data1/cnp/cwmlite.dbf
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=bk_306_1_695548256 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:12:06
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00024 name=/data2/cnp/bankdata.dbf
input datafile fno=00025 name=/data2/cnp/bankind.dbf
input datafile fno=00004 name=/data2/cnp/arch.dbf
input datafile fno=00013 name=/data2/cnp/portal.dbf
input datafile fno=00010 name=/data2/cnp/eur1.dbf
input datafile fno=00021 name=/data2/cnp/wlportal.dbf
input datafile fno=00015 name=/data2/cnp/dmsdata.dbf
input datafile fno=00028 name=/data2/cnp/dmsind.dbf
input datafile fno=00022 name=/data2/cnp/wlportalind.dbf
input datafile fno=00011 name=/data1/cnp/indx.dbf
input datafile fno=00018 name=/data1/cnp/tools.dbf
input datafile fno=00009 name=/data1/cnp/drsys.dbf
input datafile fno=00012 name=/data1/cnp/odm.dbf
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=bk_307_1_695548983 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:01:45
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
including current control file in backupset
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=bk_308_1_695549089 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:56
Finished backup at 22-AUG-09

sql statement: alter system archive log current

released channel: ch00

allocated channel: ch00
channel ch00: sid=776 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

Starting backup at 22-AUG-09
current log archived
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=11 recid=15239 stamp=695503793
input archive log thread=1 sequence=12 recid=15240 stamp=695503806
input archive log thread=1 sequence=13 recid=15241 stamp=695503826
input archive log thread=1 sequence=14 recid=15242 stamp=695503840
input archive log thread=1 sequence=15 recid=15243 stamp=695503859
input archive log thread=1 sequence=16 recid=15244 stamp=695503878
input archive log thread=1 sequence=17 recid=15245 stamp=695503894
input archive log thread=1 sequence=18 recid=15246 stamp=695503898
input archive log thread=1 sequence=19 recid=15247 stamp=695503905
input archive log thread=1 sequence=20 recid=15248 stamp=695503908
input archive log thread=1 sequence=21 recid=15249 stamp=695503916
input archive log thread=1 sequence=22 recid=15250 stamp=695503919
input archive log thread=1 sequence=23 recid=15251 stamp=695503926
input archive log thread=1 sequence=24 recid=15252 stamp=695503930
input archive log thread=1 sequence=25 recid=15253 stamp=695503936
input archive log thread=1 sequence=26 recid=15254 stamp=695503940
input archive log thread=1 sequence=27 recid=15255 stamp=695503946
input archive log thread=1 sequence=28 recid=15256 stamp=695503950
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=al_309_1_695549169 tag=TAG20090822T080608 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:56
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=47 recid=15275 stamp=695505392
input archive log thread=1 sequence=48 recid=15276 stamp=695505403
input archive log thread=1 sequence=49 recid=15277 stamp=695505416
input archive log thread=1 sequence=50 recid=15278 stamp=695505421
input archive log thread=1 sequence=51 recid=15279 stamp=695505429
input archive log thread=1 sequence=52 recid=15280 stamp=695505435
input archive log thread=1 sequence=53 recid=15281 stamp=695505445
input archive log thread=1 sequence=54 recid=15282 stamp=695505458
input archive log thread=1 sequence=55 recid=15283 stamp=695505468
input archive log thread=1 sequence=56 recid=15284 stamp=695505479
input archive log thread=1 sequence=57 recid=15285 stamp=695505489
input archive log thread=1 sequence=58 recid=15286 stamp=695505499
input archive log thread=1 sequence=59 recid=15287 stamp=695505510
input archive log thread=1 sequence=60 recid=15288 stamp=695505521
input archive log thread=1 sequence=61 recid=15289 stamp=695505531
input archive log thread=1 sequence=62 recid=15290 stamp=695505545
input archive log thread=1 sequence=63 recid=15291 stamp=695505561
input archive log thread=1 sequence=64 recid=15292 stamp=695505581
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=al_310_1_695549225 tag=TAG20090822T080608 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:56
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=65 recid=15293 stamp=695505603
input archive log thread=1 sequence=66 recid=15294 stamp=695505616
input archive log thread=1 sequence=67 recid=15295 stamp=695505638
input archive log thread=1 sequence=68 recid=15296 stamp=695505651
input archive log thread=1 sequence=69 recid=15297 stamp=695505673
input archive log thread=1 sequence=70 recid=15298 stamp=695505689
input archive log thread=1 sequence=71 recid=15299 stamp=695505709
input archive log thread=1 sequence=72 recid=15300 stamp=695505722
input archive log thread=1 sequence=73 recid=15301 stamp=695505739
input archive log thread=1 sequence=74 recid=15302 stamp=695505760
input archive log thread=1 sequence=75 recid=15303 stamp=695505777
input archive log thread=1 sequence=76 recid=15304 stamp=695505798
input archive log thread=1 sequence=77 recid=15305 stamp=695505819
input archive log thread=1 sequence=78 recid=15306 stamp=695505839
input archive log thread=1 sequence=79 recid=15307 stamp=695505867
input archive log thread=1 sequence=80 recid=15308 stamp=695505993
input archive log thread=1 sequence=81 recid=15309 stamp=695506008
input archive log thread=1 sequence=82 recid=15310 stamp=695506085
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=al_311_1_695549282 tag=TAG20090822T080608 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:56
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=29 recid=15257 stamp=695503955
input archive log thread=1 sequence=30 recid=15258 stamp=695503958
input archive log thread=1 sequence=31 recid=15259 stamp=695503966
input archive log thread=1 sequence=32 recid=15260 stamp=695503969
input archive log thread=1 sequence=33 recid=15261 stamp=695503976
input archive log thread=1 sequence=34 recid=15262 stamp=695503979
input archive log thread=1 sequence=35 recid=15263 stamp=695503985
input archive log thread=1 sequence=36 recid=15264 stamp=695503989
input archive log thread=1 sequence=37 recid=15265 stamp=695503996
input archive log thread=1 sequence=38 recid=15266 stamp=695503999
input archive log thread=1 sequence=39 recid=15267 stamp=695504006
input archive log thread=1 sequence=40 recid=15268 stamp=695504010
input archive log thread=1 sequence=41 recid=15269 stamp=695504021
input archive log thread=1 sequence=42 recid=15270 stamp=695504190
input archive log thread=1 sequence=43 recid=15271 stamp=695505355
input archive log thread=1 sequence=44 recid=15272 stamp=695505361
input archive log thread=1 sequence=45 recid=15273 stamp=695505373
input archive log thread=1 sequence=46 recid=15274 stamp=695505383
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=al_312_1_695549338 tag=TAG20090822T080608 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:56
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=83 recid=15311 stamp=695506406
input archive log thread=1 sequence=84 recid=15312 stamp=695506411
input archive log thread=1 sequence=85 recid=15313 stamp=695508833
input archive log thread=1 sequence=86 recid=15314 stamp=695508838
input archive log thread=1 sequence=87 recid=15315 stamp=695511597
input archive log thread=1 sequence=88 recid=15316 stamp=695513692
input archive log thread=1 sequence=89 recid=15317 stamp=695513706
input archive log thread=1 sequence=90 recid=15318 stamp=695513797
input archive log thread=1 sequence=91 recid=15319 stamp=695513844
input archive log thread=1 sequence=92 recid=15320 stamp=695513885
input archive log thread=1 sequence=93 recid=15321 stamp=695513920
input archive log thread=1 sequence=94 recid=15322 stamp=695514047
input archive log thread=1 sequence=95 recid=15323 stamp=695514095
input archive log thread=1 sequence=96 recid=15324 stamp=695514688
input archive log thread=1 sequence=97 recid=15325 stamp=695517141
input archive log thread=1 sequence=98 recid=15326 stamp=695519049
input archive log thread=1 sequence=99 recid=15327 stamp=695519051
input archive log thread=1 sequence=100 recid=15328 stamp=695519056
input archive log thread=1 sequence=101 recid=15329 stamp=695519057
input archive log thread=1 sequence=102 recid=15330 stamp=695519062
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=al_313_1_695549395 tag=TAG20090822T080608 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:56
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=103 recid=15331 stamp=695519063
input archive log thread=1 sequence=104 recid=15332 stamp=695519069
input archive log thread=1 sequence=105 recid=15333 stamp=695519075
input archive log thread=1 sequence=106 recid=15334 stamp=695520027
input archive log thread=1 sequence=107 recid=15335 stamp=695523655
input archive log thread=1 sequence=108 recid=15336 stamp=695528538
input archive log thread=1 sequence=109 recid=15337 stamp=695533131
input archive log thread=1 sequence=110 recid=15338 stamp=695538028
input archive log thread=1 sequence=111 recid=15339 stamp=695541608
input archive log thread=1 sequence=112 recid=15340 stamp=695541616
input archive log thread=1 sequence=113 recid=15341 stamp=695541628
input archive log thread=1 sequence=114 recid=15342 stamp=695541640
input archive log thread=1 sequence=115 recid=15343 stamp=695541651
input archive log thread=1 sequence=116 recid=15344 stamp=695541667
input archive log thread=1 sequence=117 recid=15345 stamp=695545227
input archive log thread=1 sequence=118 recid=15346 stamp=695548866
input archive log thread=1 sequence=119 recid=15347 stamp=695549157
input archive log thread=1 sequence=120 recid=15348 stamp=695549164
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=al_314_1_695549451 tag=TAG20090822T080608 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:56
Finished backup at 22-AUG-09


List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
18431 18342 1 1 AVAILABLE SBT_TAPE al_241_1_693697763
18445 18356 1 1 AVAILABLE SBT_TAPE al_256_1_693950036
18452 18363 1 1 AVAILABLE SBT_TAPE al_263_1_693993501
18462 18373 1 1 AVAILABLE SBT_TAPE al_275_1_694011657
18463 18374 1 1 AVAILABLE SBT_TAPE al_276_1_694011723
19315 19312 1 1 AVAILABLE SBT_TAPE al_281_1_694024529
19316 19313 1 1 AVAILABLE SBT_TAPE al_282_1_694024594
39262 39254 1 1 AVAILABLE SBT_TAPE al_374_1_695194936
39263 39255 1 1 AVAILABLE SBT_TAPE al_375_1_695195002
39265 39257 1 1 AVAILABLE SBT_TAPE al_377_1_695195155
39266 39258 1 1 AVAILABLE SBT_TAPE al_378_1_695195231
39267 39259 1 1 AVAILABLE SBT_TAPE al_379_1_695195298

Do you really want to delete the above objects (enter YES or NO)?
Error occurred getting response - assuming NO response

released channel: ch00

allocated channel: ch00
channel ch00: sid=776 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

Starting backup at 22-AUG-09
channel ch00: starting full datafile backupset
channel ch00: specifying datafile(s) in backupset
including current control file in backupset
channel ch00: starting piece 1 at 22-AUG-09
channel ch00: finished piece 1 at 22-AUG-09
piece handle=cntrl_315_1_695549519 tag=TAG20090822T081159 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:56
Finished backup at 22-AUG-09

released channel: ch00

RMAN>

Recovery Manager complete.

Script /usr/openv/netbackup/ext/db_ext/oracle/hot_database_backup.sh
==== ended successfully on Sat Aug 22 08:13:08 MUT 2009 ====

Thanks,


Sailesh
Previous Topic: Retrieve truncated data (merged)
Next Topic: How can recover uncommitted data?
Goto Forum:
  


Current Time: Fri Aug 01 11:37:51 CDT 2014

Total time taken to generate the page: 0.15243 seconds