[Veritas-bu] NB 4.5 & live Oracle / RMAN failures
2003-05-07 08:56:32
Hi,
since cold backup works fine it means that loading of library works fine but
you may not know that you can NOT perform online backup inclusive archive log
files if target database is in NOARCHIVE mode (it would create an inconsistent
backup and RMAN generates error).
If you (it seems so) use recovery catalog (database that stores all backup
files inclusive control file) than you should check if this database is
configured as it should be for online backups (they are a little bit special
cause the redo files must be synchronized for consistent backup).
I don't know if it helps, but you may check this out.
Good luck!
/Jadranko
Jadranko Boljanovic
electrical engineer
System Design
Service Network development
Ericsson AB
Phone: +46 455 39 53 09
Mobile: +46 708 696 145
E-mail: jadranko.boljanovic AT epk.ericsson DOT se
-----Original Message-----
From: Wilkinson, Mike [mailto:Mike.Wilkinson AT pegs DOT com]
Sent: den 5 maj 2003 08:38
To: 'jtaylor AT ithaca DOT edu'; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] NB 4.5 & live Oracle / RMAN failures
I'm not a DBA either (but I play one on TV) but I have recently been
recently setting up Oracle to Netbackup backups...
It looks like your problem is not Netbackup, but the oracle catalog
database. I would attempt to do an oracle backup to Netbackup using only the
control files as checkpoint control, (see the RMAN manual for details) and
see if you get the same problem. If you don't then I would suggest you get
your DBAs to take a look at the recovery catalog database and see if they
see any problems (perhaps you are out of free space or something trivial
like that.)
- MW
-----Original Message-----
From: Jeremy Taylor [mailto:jtaylor AT ithaca DOT edu]
Sent: Friday, May 02, 2003 9:16 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Anybody seen this before?
This problem is driving me crazy. I've ruled out both firewall issues
and db version compatibility between the RMAN and target db. Regular NB
cold backups work fine. Im not a DBA so I am struggling through this.
The entire instance backs up just fine over an hour plus then this error
is generated just prior to deleting archive logs, I think, and NB errors
out with a 23 error. thanks in advance for any pointers!
---snip---
RMAN-08525: backup set complete, elapsed time: 00:00:50
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch00
RMAN-08031: released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: partial resync
RMAN-06004: ORACLE error from recovery catalog database: ORA-03113:
end-of-file
on communication channel
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . resetAll
; :succe
ss := dbms_rcvman . SUCCESS ; :av
RMAN-06099: error occurred in source file: krmk.pc, line: 9433
RMAN>
Recovery Manager complete.
Script /export/home/oraprod/scripts/hot_database_backup.sh
==== ended in error on Thu May 1 13:32:30 EDT 2003 ====
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
|
|