|
[Veritas-bu] unable to restore to alternate client
2003-09-30 13:18:49
This is a multipart message in MIME format.
--=_alternative 005F1B6F85256DB1_=
Content-Type: text/plain; charset="us-ascii"
Try checking the following:
1. Insure you can connect to the RMAN catalog database from host1
(destination client)
2. Set environment variable NBA_ORA_CLIENT=host2 (Which you have done),
and ORACLE_SID
3. Copy the init.ora file from the source client to the alternate
(destination client) to the same directory on the destination client
4. Be sure all the directories are set up on the destination client and
match exactly the ones from the source client
5. Be sure the directories on the destination client have write permission
6. Set up a password file for the desination client database
7. Start the database in nomount state
8. start "rman" on the destination client
9. set dbid to the dbid of the source client database from rman set
dbid=<dbid of source database on host2)
10 Connect to the target database without using a userid/password
11. Run the RMAN restore script
bp.conf SERVER=<Master server>
Check the Oracle System Administrator's guide for Netbackup, there are
examples in there. We have successfully
done an alternate client restore.
Hope this helps..
=============================
Carl Stehman
PHI Services Company
202-331-6619
Pager 301-765-2703
ckstehman AT pepco DOT com
"Wei Cao" <wcao AT winants.rutgers DOT edu>
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu
09/30/2003 12:07 PM
To: <veritas-bu AT mailman.eng.auburn DOT edu>
cc: "Wei Cao" <wcao AT winants.rutgers DOT edu>
Subject: [Veritas-bu] unable to restore to alternate client
Hello All,
I am trying to do an alternate client restore using NetBackup 3.4 with
Oracle extension without any success. Does anyone know what I am doing
wrong?
1) login as user oracle do a hot backup on node Host2
2) want to restore the hot backup to host1; host1 is also where the
NetBackup server is installed.
3) login as user oracle do a restore on node host1, get the following
message in the dbclient log file:
09:46:44 [27384] <4> dbc_InitializeDBClient: INF -
client's Debug Level = <1>
09:46:44 [27384] <4> dbc_InitializeDBClient: --- SESSION
INITIATED ---
09:46:44 [27384] <4> getOracleVersion: ORACLE_HOME=
</oracle/oracle805/app/oracle/product/8.1.7>
09:46:44 [27384] <4> dbc_GetServerClientConfig:
ServerName: <host1>, ClientName: <host2>
09:46:44 [27384] <4> dbc_GetServerClientConfig: NBU's
client name= <host2> differs from gethostname()= <host1>
09:46:44 [27384] <4> dbc_GetClassNameFromConfig: user's
class= <ora85>
09:46:44 [27384] <4> get_class: Class <ora85> found in
configuration
09:46:44 [27384] <4> sbtinit: VERITAS NetBackup for
Oracle8 - Release 3.4GA (030800)
System name: SunOS
Node name: host1
Release: 5.8
Version: Generic_108528-20
Machine: sun4u
User name: oracle
Group name: dba
Client Host: host1
09:46:44 [27384] <4> sbtinit: support for Proxy Copy
enabled
09:46:46 [27384] <4> get_bfs_date_range: Start Time =
09/29/03 09:54:18
09:46:46 [27384] <4> get_bfs_date_range: End Time =
10/01/03 09:54:18
09:46:46 [27384] <4> dbc_GetMediaListByName: Request
String = <3.4GA host2 host1 *NULL* 4 1064843658 1065016458
/bk_62_1_506076858>
09:46:46 [27384] <2> getsockconnected: host=host1
service=bprd address=host1 protocol=tcp non-reserved port=13720
09:46:47 [27384] <4> find_backup_image: bk_62_1_506076858
not found
09:46:47 [27384] <16> sbtrestore: Backup file not found.
09:46:47 [27384] <4> sbtend: --- END of SESSION ---
4) bp.conf for user oracle on host2 is as follows:
SERVER = host1
CLIENT_NAME = host2
BPBACKUP_CLASS = ora85
VERBOSE = 9
5) bp.conf for user oracle on host1
SERVER = host1
CLIENT_NAME = host2
BPBACKUP_CLASS = ora85
VERBOSE
6) bp file in the /usr/openv/netbackup directory
SERVER = host1
CLIENT_NAME = host2
VERBOSE
CLIENT_READ_TIMEOUT = 3600
7) No.Restrictions is in the /usr/openv/netbackup/db/altnames directory
8) NB_ORA_CLIENT is specified in the script as well
allocate auxiliary channel dupt1 type 'sbt_tape'
parms="ENV=(NB_ORA_CLENT=host2)";
I appreciate any help and ideas. Thank you very much.
Wei
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
--=_alternative 005F1B6F85256DB1_=
Content-Type: text/html; charset="us-ascii"
<br><font size=2 face="sans-serif">Try checking the following:</font>
<br>
<br><font size=2 face="sans-serif">1. Insure you can connect to the RMAN
catalog database from host1 (destination client)</font>
<br><font size=2 face="sans-serif">2. Set environment variable
NBA_ORA_CLIENT=host2 (Which you have done), and ORACLE_SID</font>
<br><font size=2 face="sans-serif">3. Copy the init.ora file from the source
client to the alternate (destination client) to the same directory on the
destination client</font>
<br><font size=2 face="sans-serif">4. Be sure all the directories are set up on
the destination client and match exactly the ones from the source client</font>
<br><font size=2 face="sans-serif">5. Be sure the directories on the
destination client have write permission</font>
<br><font size=2 face="sans-serif">6. Set up a password file for the desination
client database</font>
<br><font size=2 face="sans-serif">7. Start the database in nomount state</font>
<br><font size=2 face="sans-serif">8. start "rman" on the destination
client</font>
<br><font size=2 face="sans-serif">9. set dbid to the dbid of the source client
database from rman set dbid=<dbid of source database on host2)</font>
<br><font size=2 face="sans-serif">10 Connect to the target database without
using a userid/password</font>
<br><font size=2 face="sans-serif">11. Run the RMAN restore script</font>
<br>
<br><font size=2 face="sans-serif">bp.conf SERVER=<Master server></font>
<br><font size=2 face="sans-serif">Check the Oracle System Administrator's
guide for Netbackup, there are examples in there. We have
successfully</font>
<br><font size=2 face="sans-serif">done an alternate client restore.</font>
<br>
<br><font size=2 face="sans-serif">Hope this helps..</font>
<br><font size=2 face="sans-serif"><br>
=============================<br>
Carl Stehman<br>
PHI Services Company<br>
202-331-6619<br>
Pager 301-765-2703<br>
ckstehman AT pepco DOT com</font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"Wei Cao" <wcao AT
winants.rutgers DOT edu></b></font>
<br><font size=1 face="sans-serif">Sent by: veritas-bu-admin AT
mailman.eng.auburn DOT edu</font>
<p><font size=1 face="sans-serif">09/30/2003 12:07 PM</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To:
<veritas-bu AT mailman.eng.auburn DOT edu></font>
<br><font size=1 face="sans-serif"> cc:
"Wei Cao" <wcao AT winants.rutgers DOT
edu></font>
<br><font size=1 face="sans-serif"> Subject:
[Veritas-bu] unable to restore to alternate
client</font></table>
<br>
<br>
<br><font size=2 face="Courier New">Hello All,<br>
<br>
I am trying to do an alternate client restore using NetBackup 3.4 with Oracle
extension without any success. Does anyone know what I am doing wrong?<br>
<br>
1) login as user oracle do a hot backup on node Host2<br>
2) want to restore the hot backup to host1; host1 is also where the NetBackup
server is installed.<br>
3) login as user oracle do a restore on node host1, get the following message
in the dbclient log file:<br>
<br>
09:46:44 [27384]
<4> dbc_InitializeDBClient: INF - client's Debug Level = <1><br>
09:46:44 [27384]
<4> dbc_InitializeDBClient: --- SESSION INITIATED ---<br>
09:46:44 [27384]
<4> getOracleVersion: ORACLE_HOME=
</oracle/oracle805/app/oracle/product/8.1.7><br>
09:46:44 [27384]
<4> dbc_GetServerClientConfig: ServerName: <host1>, ClientName:
<host2><br>
09:46:44 [27384]
<4> dbc_GetServerClientConfig: NBU's client name= <host2> differs
from gethostname()= <host1><br>
09:46:44 [27384]
<4> dbc_GetClassNameFromConfig: user's class= <ora85><br>
09:46:44 [27384]
<4> get_class: Class <ora85> found in configuration<br>
09:46:44 [27384]
<4> sbtinit: VERITAS NetBackup for Oracle8 - Release 3.4GA (030800)<br>
System name: SunOS<br>
Node name: host1<br>
Release: 5.8<br>
Version: Generic_108528-20<br>
Machine: sun4u<br>
User name: oracle<br>
Group name: dba<br>
Client Host: host1<br>
<br>
09:46:44 [27384]
<4> sbtinit: support for Proxy Copy enabled<br>
09:46:46 [27384]
<4> get_bfs_date_range: Start Time = 09/29/03 09:54:18<br>
09:46:46 [27384]
<4> get_bfs_date_range: End Time = 10/01/03 09:54:18<br>
09:46:46 [27384]
<4> dbc_GetMediaListByName: Request String = <3.4GA host2 host1 *NULL*
4 1064843658 1065016458 /bk_62_1_506076858><br>
09:46:46 [27384]
<2> getsockconnected: host=host1 service=bprd address=host1 protocol=tcp
non-reserved port=13720<br>
09:46:47 [27384]
<4> find_backup_image: bk_62_1_506076858 not found<br>
09:46:47 [27384]
<16> sbtrestore: Backup file not found.<br>
09:46:47 [27384]
<4> sbtend: --- END of SESSION --- <br>
<br>
4) bp.conf for user oracle on host2 is as follows:<br>
<br>
SERVER = host1<br>
CLIENT_NAME = host2<br>
BPBACKUP_CLASS =
ora85<br>
VERBOSE = 9
<br>
<br>
5) bp.conf for user oracle on host1<br>
<br>
SERVER = host1<br>
CLIENT_NAME = host2<br>
BPBACKUP_CLASS =
ora85<br>
VERBOSE <br>
<br>
6) bp file in the /usr/openv/netbackup directory<br>
<br>
SERVER = host1<br>
CLIENT_NAME = host2<br>
VERBOSE<br>
CLIENT_READ_TIMEOUT =
3600<br>
<br>
7) No.Restrictions is in the /usr/openv/netbackup/db/altnames directory<br>
<br>
8) NB_ORA_CLIENT is specified in the script as well<br>
allocate auxiliary
channel dupt1 type 'sbt_tape' parms="ENV=(NB_ORA_CLENT=host2)";<br>
<br>
I appreciate any help and ideas. Thank you very much.</font>
<br><font size=2 face="Courier New"><br>
Wei<br>
<br>
<br>
_______________________________________________<br>
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu<br>
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu<br>
</font>
<br>
<br>
<br>
--=_alternative 005F1B6F85256DB1_=--
|
|
|
