Oracle Arch - status 6
Updated: 21 May 2010 | 18 comments
This issue has been solved. See solution.
Does anyone know something about it?
i don't know about oracle.
I don't know where to start looking
someaone could help-me please?
discussion Filed Under:
Comments
Status 6 means, don't call
Status 6 means, don't call the backup guy, call the Oracle DBA... LOL
The Netbackup job calls an oracle script, which (should) contain information about where oracle logs the output of the job. That log file will have the reason for the error.
Tip - on new policies, 90% is typo in oracle scripts - client, policy name mistyped, etc.
NBU 7.0.1 on Solaris 10
writing to EMC 4206 VTL
duplicating to LTO2 in SL8500
(Soon to be LTO5)
using ACSLS 7.3.1
Can you provide a bit more detail?
Are you saying you're backing up an Oracle d/b & it's failing with Status Code 6?
If so, can you provide the full error details? NetBackup version, O/S on master/client etc?
If it helps, looking at this T/N for Status 6 - there are a lot of Oracle related errors, each with an ORA error as well as the NetBackup error code:
This Technote contains a table for NetBackup's Status Codes, with links to potential resolutions for each.
It may be worth looking in the Oracle Admin Guide for NetBackup in the troubleshooting section?
Veritas NetBackup (tm) 6.5 for Oracle Administrator's Guide for UNIX and Linux
Veritas NetBackup (tm) 6.5 for Oracle Administrator's Guide for Windows
Regards Andy
"It's not too late to panic ..."
Wow.. thanks a lot,
I'll try to find some logs...
I don't know beans about oracle.
I 'm moving the archivelogs to another partition ... while I cant help.
what shoul I ask to de DBA?
Claudio Veronezi Mendes
EMC TA - Pre Sales at Compwire
Londrina - Pr - Brazil
S'pose
that depends on what's in the logs! ;)
***Edit***
Can't harm to post them (or excerpts from them) here too. :)
Regards Andy
"It's not too late to panic ..."
Thanks Andy
Andy,
netbackup 6.5.4
orecle is running over Solaris 10 Container,
it was running and somehow it stops running.
Claudio Veronezi Mendes
EMC TA - Pre Sales at Compwire
Londrina - Pr - Brazil
If oracle stopped running
Then I think the DBA has a larger issue than backups on his/her hands :)
One thing to ask, and this could be a quick learning experience for future backup failures, is where they keep the rman logs. If you find their location, and if you have permission to read them, tail -50 the rman log, and it will tell you why Oracle thinks the backup failed. This can usually be a good place to start when tracking down the issue. This way, you can quickly point out to the DBA what you think might be wrong.
When you tail the file, you will see a pretty obvious error stack if something went wrong. If Oracle simply does not know what to do with the rman script that NBU is provided, it will simply say that the database was not backed up.
***EDIT***
The rman logs are kept on the client, not the master/media server, so you would have to have access to the client in order to read them.
where should i
Where should I find the rman log?
is there any patern?
find / -name <something> -print
Claudio Veronezi Mendes
EMC TA - Pre Sales at Compwire
Londrina - Pr - Brazil
In my enviornment
they have always been the script_name_,<date>.out
So if your script is called "hot_database_backup.sh" then your logfile would be "hot_database_backup.sh_102109.out"
I'm not sure if this is something that can be modified for different environments.
Netbackup policy calls an Oracle script
which contents should be known by your DBA
log files are usually .out files under /opt/oracle or something like that
~ Bill
I got thise whit RMAN
released channel: ch00
INF - RMAN-00571: ===========================================================
INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
INF - RMAN-00571: ===========================================================
INF - RMAN-03002: failure of backup command at 10/22/2009 11:42:19
INF - RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
INF - ORA-19625: error identifying file /usr2/archivelogs/DBFAT/1_33103_684406673.log
INF - ORA-27037: unable to obtain file status
INF - SVR4 Error: 2: No such file or directory
INF - Additional information: 3
INF - Recovery Manager complete.
INF - End of Recovery Manager output.
INF - End Oracle Recovery Manager.
Claudio Veronezi Mendes
EMC TA - Pre Sales at Compwire
Londrina - Pr - Brazil
I agree with rjrumfelt -
I agree with rjrumfelt - start with the rman log. You need to find rman error message.
The most common reason for failure of Archive log backups is that there are either no logs to be backed up or expected logs no longer there due to manual intervention (move/delete).
Whenever you start using rman, rman manages archive logs.
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links
Congrats Marianne!
See you are now a TA!!
Regards Andy
"It's not too late to panic ..."
Thanks Andy. I was invited
Thanks Andy.
I was invited by the Storage Foundation Admin, although most of my posts and solutions are for this list. I am truly humbled by this appointment and had to check with the Admins that this status would not cause a problem on the NBU list.
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links
Cool...
If you hadn't have said I would've presumed it was for the NBU list anyway - you could be a double-TA!!
Regards Andy
"It's not too late to panic ..."
as I had to move
as I had to move files to another partition, is that the cause of the problem????
the problem is, if it was working i didn't had to move..
by tha way thaks a lot folks
Claudio Veronezi Mendes
EMC TA - Pre Sales at Compwire
Londrina - Pr - Brazil
thanks
Wow Marinanne too..
what a great help team.
I sent the error to the DBA lady,
I think that RMAN is not updating the log.. or something...
is there something that I could do in paralell??
whille the DBA don't answer?
Claudio Veronezi Mendes
EMC TA - Pre Sales at Compwire
Londrina - Pr - Brazil
solution
The log file is in
/usr/openv/netbackup/logs/user_ops/dbext/oracle/
the solution is on
http://seer.entsupport.symantec.com/docs/275089.htm
Solution
THANKS A LOT
really..
I hope some day i help you all too.
Claudio Veronezi Mendes
EMC TA - Pre Sales at Compwire
Londrina - Pr - Brazil
who will get the solution vote?
Who will have the solution vote??
Claudio Veronezi Mendes
EMC TA - Pre Sales at Compwire
Londrina - Pr - Brazil
Would you like to reply?
Login or Register to post your comment.