Paul,
I have never tried this architecture, so I cannot say whether it will
work or not. I doubt that you would be able to do this via the client
GUI, but you might be able to get it to work using RMAN itself. In the
RMAN catalog world, you run the restore from the destination client.
You connect to the source database, and then to the target database as
"auxiliary", then run the restore. You will definitely need to set up
the appropriate file in the altnames directory on the master to allow
the alternate client restore on the NBU side. The problem may occur on
the RMAN side when you try to connect to the source database to get the
backup info and then try to tell it to restore to different database.
Good luck.
P.S.: You really should use a recovery catalog. It is an Oracle
recommended configuration because without one, if you lose the control
file on the database that you are backing up, you can't recover since
that is where the RMAN data goes.
Mark Hickey
Senior Technical Consultant
Glasshouse Technologies, Inc.
www.glasshouse.com
--__--__--
Message: 5
Date: Mon, 1 Dec 2003 10:01:33 -0000
From: "Paul Porcelli" <Paul.Porcelli AT aggreko DOT biz>
To: <veritas-bu AT mailman.eng.auburn DOT edu>
Subject: [Veritas-bu] Oracle Backup - Redirected with Recovery Catalog ?
Hi folks,
we currently perform a cold Oracle backup using NetBackup 4.5
and the Database Agent for Oracle.
This is done via a script which uses RMAN commands (i.e no RMAN
recovery catalog).
This is fine for restores to the client.
We would like to be able to do a redirected restore to another
client. The documentation explains how to do this by using the
RMAN recovery catalog.
As we have not created an RMAN recovery catalog, is there any other
way to perform a redirected restore ?
Many thanks,
Paul
Visit us at www.aggreko.com
________________________________________________________________________
Confidentiality Notice: This communication and any accompanying
attachments contain confidential information intended for a specific
individual and purpose. This communication is private and protected
by law. If you are not the intended recipient, you are hereby
respectfully notified that any disclosures, copying, forwarding or
distribution, or the taking of any action based on the contents of
this communication is strictly prohibited.
________________________________________________________________________
--__--__--
Message: 6
From: "Markham, Richard" <RLMarkham AT hafeleamericas DOT com>
To: veritas-bu AT mailman.eng.auburn DOT edu
Date: Mon, 1 Dec 2003 10:05:17 -0500
Subject: [Veritas-bu] bparchive of Oracle Database archivelogs
My question seems to cross both boundaries of RMAN and Netbackup.
I need to know that when restoring with RMAN, if RMAN will be
able to ~recover~ datafiles when the archive logs were backed up
using the bparchive binary. My understanding is that when you
backup archive logs via an RMAN script, both Netbackup and RMAN
will have created the necessary information so that they cand find
the respective archive logs. So my question is that with RMAN,
Will I be able to allocate a 'sbt_tape' channel during a database
recovery and then netbackup will be able to feed RMAN the needed
archive logs?
Netbackup 3.4.2
Oracle/RMAN 8.1.7.4
RMAN catalog 9.1.0.3
--__--__--
Message: 7
From: "Shafto, Eric" <Eric.Shafto AT drkw DOT com>
To: veritas-bu AT mailman.eng.auburn DOT edu
Date: Mon, 1 Dec 2003 10:25:23 -0500
Subject: [Veritas-bu] Adding NDMP drives
Hello, all.
I must be missing something terribly simple. I am trying to do remote
NDMP
under NBU 4.5FP3 (about to upgrade to FP5).
It looks like there is something wrong with the way the drives are owned
by
the ndmp STU. bpstulist shows that it contains 2 drives, but the bptm
log
says, "no NDMP drives connected to host xxxxx were found in robot
number =
0, Robot type = TLD, density = hcart2", and backups fail with a 219
("required storage unit unavailable").
The robot number in the policy (and everywhere else, AFAICT) is 0. The
robot
type is TLD, and the density is hcart2.
A Google search and a search of Veritas's support site found no hits for
"no
NDMP drives".
Does anyone have any suggestions?
If you have received this e-mail in error or wish to read our e-mail
disclaimer statement and monitoring policy, please refer to
http://www.drkw.com/disc/email/ or contact the sender.
--__--__--
Message: 8
Date: Mon, 01 Dec 2003 10:27:00 -0500
From: Wayne T Smith <WTSmith AT maine DOT edu>
To: Cris Rhea <crhea AT mayo DOT edu>, veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Problems with NB 4.5 and RH9 workaround
[repost]
Cris Rhea wrote, in part:
> I'm running NB4.5 (FP5) with the workaround posted for RH9 clients.
>
> All seemed OK, but I recently noticed that incremental backups are
> actually doing full backups.
I haven't seen this one, but the workaround I posted works for only some
systems (certain library levels, we presume). We recently updated a
number of our (NBU working) RH9 systems to find NBU no longer works ...
and no workaround has become evident. :-( We are backing up those
systems by other means (rsync, etc.). cheers, wayne
--__--__--
Message: 9
From: Cris Rhea <crhea AT mayo DOT edu>
Subject: Re: [Veritas-bu] Problems with NB 4.5 and RH9 workaround
[repost]
To: WTSmith AT maine DOT edu (Wayne T Smith)
Date: Mon, 1 Dec 2003 09:42:34 -0600 (CST)
Cc: "Rhea, Cristopher J." <crhea AT mayo DOT edu> (Cris Rhea),
veritas-bu AT mailman.eng.auburn DOT edu
>
> Cris Rhea wrote, in part:
> > I'm running NB4.5 (FP5) with the workaround posted for RH9 clients.
> >
> > All seemed OK, but I recently noticed that incremental backups are
> > actually doing full backups.
>
> I haven't seen this one, but the workaround I posted works for only
some
> systems (certain library levels, we presume). We recently updated a
> number of our (NBU working) RH9 systems to find NBU no longer works
...
> and no workaround has become evident. :-( We are backing up those
> systems by other means (rsync, etc.). cheers, wayne
>
>
Thanks for the info.
It's only going to get worse with Fedora/RHEL/etc....
Grumble!
--- Cris
--
Cristopher J. Rhea Mayo Foundation
Research Computing Facility Pavilion 2-25
crhea AT Mayo DOT EDU Rochester, MN 55905
(507) 284-0587 Fax: (507) 284-5231
--__--__--
Message: 10
Date: Mon, 1 Dec 2003 10:00:43 -0600
From: David Rock <dave-bu AT graniteweb DOT com>
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Problems with NB 4.5 and RH9 workaround
[repost]
Reply-To: David Rock <dave-bu AT graniteweb DOT com>
--SLDf9lqlvOQaIe6s
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
* Cris Rhea <crhea AT mayo DOT edu> [2003-12-01 09:42]:
> >=20
> > Cris Rhea wrote, in part:
> > > I'm running NB4.5 (FP5) with the workaround posted for RH9
clients.
> > >=20
> > > All seemed OK, but I recently noticed that incremental backups are
> > > actually doing full backups.
> >=20
> > I haven't seen this one, but the workaround I posted works for only
som=
e=20
> > systems (certain library levels, we presume). We recently updated
a=
=20
> > number of our (NBU working) RH9 systems to find NBU no longer works
...=
=20
> > and no workaround has become evident. :-( We are backing up
those=20
> > systems by other means (rsync, etc.). cheers, wayne
> >=20
> >=20
>=20
> Thanks for the info.
>=20
> It's only going to get worse with Fedora/RHEL/etc....
To be fair, I think RHEL will be BETTER as we move forward, since RedHat
will be focusing on that as THE offering, which should make it easier
for Veritas to write for it.
Now Fedora on the other hand... ;-)
--=20
David Rock
david AT graniteweb DOT com
--SLDf9lqlvOQaIe6s
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQE/y2WrMrO4/Yb/xwYRAnHSAJ4tHqXASSA5so4XXjGZsWHA8oqm5wCfWYWU
o0k/DgPac9MXM7BlGhvtrBg=
=u2/1
-----END PGP SIGNATURE-----
--SLDf9lqlvOQaIe6s--
--__--__--
Message: 11
From: "Donaldson, Mark" <Mark.Donaldson AT experianems DOT com>
To: "'Markham, Richard'" <RLMarkham AT hafeleamericas DOT com>,
veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] bparchive of Oracle Database archivelogs
Date: Mon, 1 Dec 2003 09:25:01 -0700
If RMAN doesn't send the file, then RMAN can't recover the file.
You have to send your .arc files via RMAN. If you then bparchive them
later, that works fine but RMAN can't fetch them back, you'll have to
bprestore them back into place.
RMAN does have a feature to delete the redo log once sent via RMAN to
tape.
-M
-----Original Message-----
From: Markham, Richard [mailto:RLMarkham AT hafeleamericas DOT com]
Sent: Monday, December 01, 2003 8:05 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] bparchive of Oracle Database archivelogs
My question seems to cross both boundaries of RMAN and Netbackup.
I need to know that when restoring with RMAN, if RMAN will be
able to ~recover~ datafiles when the archive logs were backed up
using the bparchive binary. My understanding is that when you
backup archive logs via an RMAN script, both Netbackup and RMAN
will have created the necessary information so that they cand find
the respective archive logs. So my question is that with RMAN,
Will I be able to allocate a 'sbt_tape' channel during a database
recovery and then netbackup will be able to feed RMAN the needed
archive logs?
Netbackup 3.4.2
Oracle/RMAN 8.1.7.4
RMAN catalog 9.1.0.3
_______________________________________________
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
End of Veritas-bu Digest
|
