PDA

View Full Version : Any Oracle folks around here?


fildien
04-30-2008, 10:44 AM
Yesterday we created a standby database on another node at our DR site and implemented a job that pulls the redo logs from the main site prod dB.

Last night our RMAN backup (archive logs) failed but the hot backup ran ok.

Here is the error:

allocated channel: t1
channel t1: sid=447 devtype=SBT_TAPE
channel t1: BrightStor ARCserve Backup Oracle Agent v11.5


Starting backup at 30-APR-08
released channel: t1
RMAN-00571: ================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================================================== =========
RMAN-03002: failure of backup command at 04/30/2008 00:30:17
ORA-19563: header validation failed for file

Recovery Manager complete.



I am not a DBA and have limited knowledge but manage the OS and backup manager. The DBA is running a crosscheck in RMAN and has tried purging them out of RMAN. We think the error occurred yesterday but we trying to find bad log and are unsure how to. Does anyone have any idea? Unfortunately RMAN didn't bother to tell us the bad file =\

fildien
04-30-2008, 01:05 PM
Never mind, we found it had to manually try backing up each frigging redo log to find the bad one.

Sixee
04-30-2008, 01:27 PM
Mindless grunt work FTW!

Sanchek
04-30-2008, 01:36 PM
Oracle fails. Hate Oracle so much.

Malse
04-30-2008, 08:23 PM
In as much as I hate to say it, Microsoft bought a really good database and renamed it SQL Server and it's so much better than Oracle it's not funny :( Wish they would port it to a real platform though.

Sanchek
04-30-2008, 08:25 PM
Windows Server 2008 is nice. Don't be a hater.

Malse
04-30-2008, 09:53 PM
Nice doesn't cover doing real work. Some of us don't run webservers :>

Sanchek
04-30-2008, 10:03 PM
For now.

fildien
05-01-2008, 10:35 AM
haha I don't think a Window server could run our production clinical database or application :) hence why the db is oracle b/c it runs on a Unix platform.