Charles,
   Your problem is exactly as you thought.  The first thing that a
restore
does is to issue a list request to the master for backups for the
system.  In order for this to work the altnames directory must me
configured to allow the target system to restore from the sources
system's backups.  Furthermore, the owner of the oracle binaries on both
machines must be the same.

If you need further help with this, please let me know.  I have done a
ton of Oracle with NBU.

Mark Hickey
Senior Technology Consultant
Glasshouse Technologies, Inc.

===================================
Message: 9
From: "Ballowe, Charles" <CBallowe AT usg DOT com>
To: "'veritas-bu AT mailman.eng.auburn DOT edu'"
         <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Wed, 17 Dec 2003 16:39:35 -0600
Subject: [Veritas-bu] NBU 4.5 + RMAN alternate system restore

I just got this question from one of the DBAs here - they're trying
to do an alternate system restore of a database using RMAN.
Unfortunately
it's in an outsourced environment that I don't have access to.

While I think the error that is showing up is related to something like
altnames not being set up properly, I can't check.

AFAIK the master server is a Win2K system, the clients in this case are
HP/UX 11i.

Anybody seen the error in question and maybe have a pointer?

Support is suggesting MP3 or better (I think the environment is
currently
at MP2).

>  -----Original Message-----
> Charles,
> 
> We had another Netbackup/RMAN restore from edb01  to epirdb01.  I
checked
the Netbackup log file on epirdb01 (see the blue line).  It seems that
the
media manager could not resolve the name "epirdb01.xxx.com"
> 
> Do you have any insight into this?
> 
> -----Original Message-----
> 
> 
> More infor from target server (epirdb01).
> 
> =====================================
> epirdb01- oracle> pwd /usr/openv/netbackup/logs/user_ops/dbext/logs
> epirdb01- oracle>
> 
> epirdb01- oracle> ll
> total 96
> -rw-r--r--   1 oracle     dba            165 Dec 15 15:01
21800.0.1071525679
> -rw-r--r--   1 oracle     dba            165 Dec 15 15:17
22757.0.1071526643
> -rw-r--r--   1 oracle     dba            165 Dec 16 08:09
23066.0.1071587343
> -rw-r--r--   1 oracle     dba            165 Dec 15 15:34
23712.0.1071527662
> -rw-r--r--   1 oracle     dba            165 Dec 16 11:41
2925.0.1071600105
> -rw-r--r--   1 oracle     dba            165 Dec 16 11:45
3080.0.1071600295
> epirdb01- oracle> cat 3080.0.1071600295
> Restore started Tue Dec 16 11:44:55 2003
> 11:44:59 client edb01.xxx.com peername epirdb01.xxx.com is invalid for
restore request 11:45:00 INF - Server status = 135
> epirdb01- oracle> pwd /usr/openv/netbackup/logs/user_ops/dbext/logs
> epirdb01- oracle> 
> 
> 
> 
> 
> -----Original Message-----
> 
> 
> Keith:
> 
> We, John and I, used both short-name and FQDN for the client system
(edb01). Bu the test failed again:
> 
> ===========================   RMAN  LOG file   ==========
> ..............        
> restoring datafile 00006 to /u003/app/oradata/rman_backup/indx01.dbf
> restoring datafile 00007 to /u003/app/oradata/rman_backup/odm01.dbf
> restoring datafile 00008 to /u003/app/oradata/rman_backup/tools01.dbf
> restoring datafile 00009 to /u003/app/oradata/rman_backup/users01.dbf
> restoring datafile 00010 to /u003/app/oradata/rman_backup/xdb01.dbf
> restoring datafile 00011 to
/u003/app/oradata/rman_backup/oem_repository.dbf
> released channel: ch00
> RMAN-00571:
===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
> RMAN-00571:
===========================================================
> RMAN-03002: failure of Duplicate Db command at 12/16/2003 11:45:02
> RMAN-03015: error occurred in stored script Memory Script
> ORA-19507: failed to retrieve sequential file,
handle="bk_ud1f8l2ek_s9633_p1_t512395732", parms=""
> ORA-27029: skgfrtrv: sbtrestore returned error
> ORA-19511: Error received from media manager layer, error text:
>    sbtrestore: Failed to open for restore.
> 
> RMAN> 
> RMAN> **end-of-file**
> 
> epirdb01- oracle>  
> 
> 
> -----Original Message-----
> 
> 
> edb01 backed up
> epirdb01 restore
> 
> On the master in /usr/openv/netbackup/db/altnames directory create a
file
named epirdb01 Edit the file and put one line in it  -  edb01
> 


--__--__--

_______________________________________________
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