[askdba] Re: Stby DB Backup failed
- From: drumil narayan <drumilnarayan@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Wed, 14 Nov 2007 21:05:15 +0530 (IST)
Hi all,
i forced delete the archive and now the backup is in process..Drumil
----- Original Message ----
From: drumil narayan <drumilnarayan@xxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Sent: Wednesday, 14 November, 2007 12:58:32 AM
Subject: [askdba] Re: Stby DB Backup failed
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
run
{
allocate channel for maintenance type disk;
#allocate channel for maintenance type sbt_tape;
#crosscheck backup;
#delete expired backup;
crosscheck archivelog all;
release channel;
}
EOF
# Test for success of Job
if [ $? != 0 ]
then
echo "maint backup FAILED for sbmems " | mail -s "Maint BKUP Problems "
drumilnarayan@xxxxxxxxx
fi
exit
after execution am getting following
validation succeeded for archived log
archive log filename=/MemsInbound/0002_0000113881.arc recid=87631
stamp=638533232
Crosschecked 1316 objects
RMAN>
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>
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
statement.
We are using RMAN, we do not have complete documentation, our usual DBA is on
leave.
Kindly help.
Drumil
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.
Forgot the famous last words? Access your message archive online. Click here.
Get the freedom to save as many mails as you wish. To know how, go to
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html
Other related posts:
