Re: Critical restore issue with Veritas

  • From: "Sandra Becker" <sbecker6925@xxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 14 Jan 2007 13:17:49 -0700

Thank you all for your suggestions.  Since we had already lost 34 hours over
the tape issue, the SA's agreed to NFS the backup disk from the new server
onto the old server; something I asked for 4 months ago and was told that it
was too much trouble.  I ran an RMAN backup and restore was a piece of
cake.  I copied the archivelogs to the new node and recovery worked like a
charm.  I'm now migrating the database from 32-bit to 64-bit and upgrading
to 9.2.0.8.  We'll be doing disk backups on the new server and the OS
backups are working with Veritas so they can backup my RMAN backups to
tape.  I also created a small test 9.2.0.8 database that we're going to
trouble-shoot the tape issue as a backup plan for disk backups and placing a
copy of production into test.

Thanks again.  With any good luck at all today, I'll be able to get to bed
before midnight.

Sandy


On 1/13/07, Jeremiah Wilton <jeremiah@xxxxxxxxxxx> wrote:

Sandra,

Netbackup logs into a variety of log files in /usr/openv/netbackup/logs/.
Your best bet to get the real reason for failure is to look in those logs.

Depending on the version of NBU, the logs for the Oracle library end up in
the above directory under ./dbclient/ (on the client) or
./user_ops/dbext/logs/.  Look for and tail the most recently created log
files(s).

In certain cases, to make a component of NBU start logging, you must
create
the logging directory in order for NBU to begin logging to it.

Presumably this is covered somewhere in the NBU documentation.  Good luck
searching that (see previous thread on searching Veritas documentation
with
Google).

Good luck,

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

________________________________________
From: Sandra Becker

I need to restore my production database to a new node but I'm getting the
following errors:

ORA-19507: failed to retrieve sequential file,
handle="PRDRUBY_14478_1_611444563", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file <PRDRUBY_14478_1_611444563>

RHEL 4, Oracle 9.2.0.5 Standard One edition, Veritas 6.0



Other related posts: