Veritas-bu
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

[Veritas-bu] unable to restore to alternate client

2003-09-30 17:03:43
Subject: [Veritas-bu] unable to restore to alternate client
From: wcao AT winants.rutgers DOT edu (Wei Cao)
Date: Tue, 30 Sep 2003 17:03:43 -0400 
The problem has been resolved. I used the ip address in one of the bp.conf and 
the host name in another bp.conf. I changed everything to hostname and it 
worked. Thanks.


-----Original Message-----
From: Ballowe, Charles [mailto:CBallowe AT usg DOT com]
Sent: Tuesday, September 30, 2003 3:45 PM
To: Wei Cao
Subject: RE: [Veritas-bu] unable to restore to alternate client


scratch my last reply -- i think i misread somthing.
what are the versions of oracle on the system running the rman
catalog and the one running the restore?

> -----Original Message-----
> From: Wei Cao [mailto:wcao AT winants.rutgers DOT edu]
> Sent: Tuesday, September 30, 2003 1:17 PM
> To: Ballowe, Charles
> Subject: RE: [Veritas-bu] unable to restore to alternate client
> 
> 
> The rman message is 
> 
> RMAN-00571: 
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS 
> ===============
> RMAN-00571: 
> ===========================================================
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: Duplicate Db
> RMAN-03015: error occurred in stored script Memory Script
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: restore
> RMAN-03007: retryable error occurred during execution of 
> command: IRESTORE
> RMAN-07004: unhandled exception during command execution on 
> channel dupt1
> RMAN-10035: exception raised in RPC: ORA-19507: failed to 
> retrieve sequential file, handle="bk_6
> 2_1_506076858", parms=""
> ORA-27029: skgfrtrv: sbtrestore returned error
> ORA-19511: sbtrestore: Backup file not found.
> RMAN-10031: ORA-19624 occurred during call to 
> DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
> 
> The script I used is 
> 
> rman catalog rman/rman@catdb target sys/syspass@prod_tmp 
> auxiliary sys/syspass@dup_prod;
> 
> run {
> # Restore all datafiles, and recovers them completely.
> allocate auxiliary channel dupt1 type 'sbt_tape' 
> parms="ENV=(NB_ORA_CLENT=host2)";
> #
> set newname for datafile 1 to 
> '/u20/oradata/dup_prod/dup_prod_system01.dbf';
> set newname for datafile 2 to 
> '/u20/oradata/dup_prod/dup_prod_rbs01.dbf';
> set newname for datafile 3 to 
> '/u20/oradata/dup_prod/dup_prod_temp01.dbf';
> set newname for datafile 4 to 
> '/u20/oradata/dup_prod/dup_prod_tools01.dbf';
> set newname for datafile 5 to 
> '/u20/oradata/dup_prod/dup_prod_advdata01.dbf';
> set newname for datafile 6 to 
> '/u20/oradata/dup_prod/dup_prod_advindex01.dbf';
> set newname for datafile 7 to 
> '/u20/oradata/dup_prod/dup_prod_temp_adv_data01.dbf';
> set newname for datafile 8 to 
> '/u20/oradata/dup_prod/dup_prod_user01.dbf';
> set newname for datafile 9 to 
> '/u20/oradata/dup_prod/dup_prod_advdata02.dbf';
> set newname for datafile 10 to 
> '/u20/oradata/dup_prod/dup_prod_temp_adv_index01.dbf';
> set newname for datafile 11 to 
> '/u20/oradata/dup_prod/dup_prod_temp_adv_index02.dbf';
> set newname for datafile 12 to 
> '/u20/oradata/dup_prod/dup_prod_temp_adv_data02.dbf';
> set newname for datafile 13 to 
> '/u20/oradata/dup_prod/dup_prod_rbs02.dbf';
> set newname for datafile 14 to 
> '/u20/oradata/dup_prod/dup_prod_temp02.dbf';
> set newname for datafile 15 to 
> '/u20/oradata/dup_prod/dup_prod_temp03.dbf';
> set newname for datafile 16 to 
> '/u20/oradata/dup_prod/dup_prod_advindex02.dbf';
> set newname for datafile 17 to 
> '/u20/oradata/dup_prod/dup_prod_advdata03.dbf';
> #
> duplicate target database to dup_prod
> logfile
> group 1 ('/u20/oradata/dup_prod/dup_prod_redo01a.log',
>          '/u20/oradata/dup_prod/dup_prod_redo01b.log') size 50m,
> group 2 ('/u20/oradata/dup_prod/dup_prod_redo02a.log',
>          '/u20/oradata/dup_prod/dup_prod_redo02b.log') size 50m;
> 
> The dbclient log is in my original message.
> 
> Thanks a lot for the help.
> 
> 
> Wei
> 
> 
> 
> -----Original Message-----
> From: Ballowe, Charles [mailto:CBallowe AT usg DOT com]
> Sent: Tuesday, September 30, 2003 2:04 PM
> To: Wei Cao
> Subject: RE: [Veritas-bu] unable to restore to alternate client
> 
> 
> anything useful in logs/dbext ? What are the errors from rman
> if any? What does the rman script look like?
> 
> > -----Original Message-----
> > From: Wei Cao [mailto:wcao AT winants.rutgers DOT edu]
> > Sent: Tuesday, September 30, 2003 11:08 AM
> > To: veritas-bu AT mailman.eng.auburn DOT edu
> > Cc: Wei Cao
> > 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
> > 
>
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  [Veritas-bu] Sun Cobalt Raq3 Linux with Veritas Netbackup?, Syed, Mukarram
Previous by Thread:  [Veritas-bu] unable to restore to alternate client, Wei Cao
Next by Thread:  [Veritas-bu] Find all streams in a wildcard multistream policy., Darren Dunham
Indexes:  [Date] [Thread] [Top] [All Lists]