[askdba] Re: Stby DB Backup failed

  • From: drumil narayan <drumilnarayan@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Wed, 14 Nov 2007 00:58:32 +0530 (IST)

Thanks Nisar,

yes that archive log file is missing and am fixing using following script, but 
getting the errors, below the script you can find them

rman target sys/0d1n@sbmems catalog prodrman/rcat@rman log 
/MemsScripts/log/archbackup.log <<EOF
allocate channel for maintenance type disk;
#allocate channel for maintenance type sbt_tape;
#crosscheck backup;
#delete expired backup;
crosscheck archivelog all;
release channel;
# Test for success of Job
if [ $? != 0 ]
 echo "maint backup FAILED for sbmems " | mail -s "Maint BKUP Problems " 

after execution am getting following 

validation succeeded for archived log
archive log filename=/MemsInbound/0002_0000113881.arc recid=87631 
Crosschecked 1316 objects

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 11/13/2007 13:16:08
RMAN-06474: maintenance channels are not allocated
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "}": expecting one of: "allocate, alter, 
backup, beginline, blockrecover, catalog, change, connect, copy, create, 
crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, 
{, library, list, mount, open, print, quit, recover, register, release, 
replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, 
setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01007: at line 1 column 1 file: standard input

kindly help..drumil

----- Original Message ----
From: Nisar Tareen <ntareen@xxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Sent: Tuesday, 13 November, 2007 11:30:16 PM
Subject: [askdba] Re: Stby DB Backup failed

Sorry to hear this,  but the DBA is on leave, for sure you can Phone him.  
Pleae study the recovery procedure and look for the deleted archive log file in 
the backup some where, I  am sure you can find it.  
Else painfull but the Production is still good,  take a new back up as a base.  
the delay , God forbid can put  real issue on your hand. 
Take a Fresh Cold Base Backup soon, do not waite for your DBA  or the solution. 
run man. run......
But the best solution is use  inhouse scripts. 
Nisar tareen 

----- Original Message ----
From: drumil narayan <drumilnarayan@xxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Sent: Tuesday, November 13, 2007 9:17:53 AM
Subject: [askdba] Stby DB Backup failed

Dear All,
am facing a problem on standby database.
On November 9 a file was supposed to ship from the actual database to standby 
db that archive file may not be shipped or might have been deleted/archived, 
how do i know what exactly has happened.
Now if am executing manual backup script its poinitng to the archive file of 
November 9, which am not able to find. 
Now, how should i proceed my admin is saying if stby backup is not done, there 
will not be a backup of primay datbase also. how should i validate this 
We are using RMAN, we do not have complete documentation, our usual DBA is on 
Kindly help.

Get the freedom to save as many mails as you wish. Click here to know how.

Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.

      Now you can chat without downloading messenger. Go to 

Other related posts: