thanks for the information!! This is what I received from Veritas, and it
worked perfectly:
things to note:
-same oracle sid on restore to client as original
-oracle already installed/working, and can backup and restore from current
master
-Veritas engineer suggested adding the No.Restrictions file instead of the
client2 file with client1 name added
-Netbackup master sever:
/usr/openv/netbackup/db/altnames/No.Restrictions
Directions from Veritas engineer:
1. By using the NB_ORA_CLIENT variable in the RMAN script for the restore
you will query the NBU database as the original server, so you will then not
need to make any changes to the bp.conf files on the alternate server
http://seer.support.veritas.com/docs/262915.htm.
2. The following technote outlines the basic procedure for the alternate
client restore of Oracle for NBU 3.4
http://seer.support.veritas.com/docs/196781.htm. Take note of the
NB_ORA_CLIENT varible.
This 3.4 document works with 4.5.
This 3.4 document does work. DBA used these directions and had no problems.
Also, I did not user the No.Restrictions file (way to risky) and had no
problems.
-Dwayne
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of
Ed.Toner AT eu.nabgroup DOT com
Sent: Friday, April 23, 2004 3:56 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] alternate client restore with Rman
The trick is to make sure that you set the environment variables on client2
to pretend to be client1. The logs directorys dbclient and
user_ops/dbext/logs are important as they are used to communicate between
rman and the master.
On client2 in rman (set up SID etc) -
allocate channel t1 type 'SBT_TAPE' parms="ENV=(NB_ORA_SERVER=nbmaster,
NB_ORA_CLIENT=client1)";
Also see - http://seer.support.veritas.com/docs/196781.htm
We saw weird failure messages which was caused by a dns error in that
client2's ip address didn't reverse lookup.
Cheers
Ed
"Brzozowski, Dwayne" <Dwayne.Brzozowski AT mail.va DOT
gov>@mailman.eng.auburn.edu
on 22/04/2004 22:55:42
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu
To: veritas-bu AT mailman.eng.auburn DOT edu
cc:
Subject: [Veritas-bu] alternate client restore with Rman
HI,
I have a NB 4.5.1 FP4 Solaris 8 server. I also have 2 NB clients, both
Solaris 8. One NB client, client2, wants to restore rman data from client1.
I have created n file under altnames to facilitate this. My problem is, the
backup was done with RMAN on client1, and client2 wants to initiate a RMAN
restore of client1's data. Does anyone know how this can be accomplished??
Thanks for the help!
Dwayne J. Brzozowski
Department of Veterans Affairs
Austin Automation center
(512)326-6728 work
dwayne.brzozowski AT mail.va DOT gov
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
===============================================================
National Australia Group Europe Limited (Company Number 02108635,
Registered Office 88 Wood Street, London EC2V 7QQ) (NAGE) is a subsidiary
of National Australia Bank Limited (an Australian registered company). The
following UK subsidiaries of NAGE are authorised and regulated by the
Financial Services Authority: Clydesdale Bank PLC, Yorkshire Bank PLC,
Northern Bank Limited, Northern Bank Executor and Trustee Company Limited,
MLC Savings Limited, MLC Trust Management Company Limited, Clydesdale Bank
Insurance Brokers Limited, Yorkshire Bank Financial Services Limited,
Northern Bank Insurance Services Limited, National Australia Bank Limited.
In Ireland National Irish Bank Limited and National Irish Investment Bank
Limited are regulated by the Irish Financial Services Regulatory
Authority.
The views and opinions expressed in this email may not reflect the views
and opinions of any member of the group of which NAGE forms part. The
information contained in this message is confidential and may also be
privileged. It is intended only for the addressee named above. The
unauthorised use, disclosure, copying or alteration of this message is
strictly prohibited. If you are not the addressee (or responsible for
delivery of the message to the addressee), please notify the originator
immediately by return message and destroy the original message. This
message and any attachments have been scanned for viruses prior to leaving
the NAGE network. However, NAGE does not guarantee the security of this
message and will not be responsible for any damages arising as a result of
any virus being passed on or arising from any alteration of this message
by a third party. NAGE may monitor emails sent to and from the NAGE
network.
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|