Restore Oracle on another host

Hello,

I'm trying to simulate the scenarion that If I totaly lost the machine running my production Oracle DB, on another machine.

Production Server is Sun Solaris 9 OS, with Oracle RAC 9i 64 bit (9.2.0.1.0), and Data Protection for Oracle: version 5.4.1.0

The machine I'm trying to restore on is Windows 2003 Server machine SP2, Oracle 9i 9.2.0.1.0, and Data Protection for Oracle: version 5.4.1.0

Production Machine TDPO Node name is Oracle1-TDP
Test Machine TDPO Node name is Test-Server-TDP

TDPO.opt on test server is,
################################################## ############
************************************************** *******************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the Data Protection for Oracle on Win32
************************************************** *******************
*================================================= ===================
* TSM API configuration
*================================================= ===================
DSMI_ORC_CONFIG c:\Program Files\tivoli\tsm\agentoba\dsm.opt
*DSMI_ORC_CONFIG C:\scripts\dsm.opt
DSMI_LOG c:\Program Files\tivoli\tsm\agentoba
*TDPO_NODE Test-Server-TDP
*TDPO_OWNER Magrabi\Administrator
*TDPO_PSWDPATH C:\Program Files\Tivoli\TSM\AgentOBA

*================================================= ===================
* TSM Server - filespace name
*
* TDPO_FS default: adsmorc
*
*================================================= ===================
TDPO_FS adsmorc

*================================================= ====================
* NLS Configuration
*
* TDPO_DATE_FMT default: 1
* TDPO_NUM_FMT default: 1
* TDPO_TIME_FMT default: 1
* TDPO_LANGUAGE default: enu
*
*================================================= ====================
* TDPO_DATE_FMT 3
* TDPO_TIME_FMT 3
* TDPO_NUM_FMT 3
* TDPO_LANGUAGE chs

*================================================= ===================
* Management Class binding for Rman Duplex Copy
*================================================= ===================
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4
################################################## ##############

dsm.opt contents are
################################################## ##############

passwordaccess generate
Nodename Test-Server-TDP
*PASSWORDACCESS prompt
DOMAIN C:
DOMAIN E:
DOMAIN SYSTEMSERVICES
DOMAIN SYSTEMSTATE
DOMAIN ALL-LOCAL
TCPSERVERADDRESS 192.168.0.118




EXCLUDE.BACKUP "*:\microsoft uam volume\...\*"
EXCLUDE.BACKUP "*:\microsoft uam volume\...\*.*"
EXCLUDE.BACKUP "*:\...\EA DATA. SF"
EXCLUDE.BACKUP "*:\IBMBIO.COM"
EXCLUDE.BACKUP "*:\IBMDOS.COM"
EXCLUDE.BACKUP "*:\IO.SYS"
EXCLUDE.BACKUP "*:\...\system32\config\...\*"
EXCLUDE.BACKUP "*:\...\system32\Perflib*.dat"
EXCLUDE.BACKUP "*:\...\system32\dhcp\...\*"
INCLUDE.BACKUP "*:\...\system32\dhcp\backup\...\*"
EXCLUDE.BACKUP "*:\...\system32\dns\...\*"
INCLUDE.BACKUP "*:\...\system32\dns\backup\...\*"
EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*"
EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*.*"
EXCLUDE.ARCHIVE "*:\...\EA DATA. SF"
EXCLUDE.ARCHIVE "*:\IBMBIO.COM"
EXCLUDE.ARCHIVE "*:\IBMDOS.COM"
EXCLUDE.ARCHIVE "*:\IO.SYS"
EXCLUDE.ARCHIVE "*:\...\system32\config\...\*"
EXCLUDE.ARCHIVE "*:\...\system32\Perflib*.dat"
EXCLUDE.ARCHIVE "*:\...\system32\dhcp\...\*"
INCLUDE.ARCHIVE "*:\...\system32\dhcp\backup\...\*"
EXCLUDE.ARCHIVE "*:\...\system32\dns\...\*"
INCLUDE.ARCHIVE "*:\...\system32\dns\backup\...\*"
EXCLUDE.DIR "*:\System Volume Information"
EXCLUDE.DIR "*:\...\Temporary Internet Files"
EXCLUDE.DIR "*:\Recycled"
EXCLUDE.DIR "*:\Recycler"

################################################## ##############

When I try to restore on the test server, I got the following error,'

RMAN> run {
2> allocate channel sbt_tape type sbt parms
3> 'ENV=(nb_ora_serv=Test-Server-TDP, nb_ora_client=Oracle1-TDP, TDPO_OPTFILE=C:
\scripts\tdpo.opt)';
4> restore spfile from autobackup;}
allocated channel: sbt_tape
channel sbt_tape: sid=9 devtype=SBT_TAPE
channel sbt_tape: Data Protection for Oracle: version 5.4.1.0
Starting restore at 14-MAY-08
channel sbt_tape: looking for autobackup on day: 20080514
released channel: sbt_tape
RMAN-00571: ================================================== ========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================================================== =========
RMAN-03002: failure of restore command at 05/14/2008 14:47:01
ORA-27191: sbtinfo2 returned error

By investigating the errolog, I found,

05/14/2008 14:47:01 ANS1088E File space '' does not exist
05/14/2008 14:47:01 TID<568> ==> ANS1088E (RC124) File space '*' does not exist

Any clue?

WaleedStart Free Trial