RMAN to new host / new file location - ORA-12571 error in the end of restore

From: L C <lccronin_at_hotmail.com>
Date: Tue, 14 Aug 2007 01:44:01 GMT
Message-ID: <BN7wi.7445$Ns6.2964@trnddc01>

Hello,

I have been messing with this for a week and have asked a few questions here and read a bunch - I think I am almost there.

What I have: Both are Oracle 9i Old server W2K c:\oracle\... New server win 2003 d:\oracle\... backups using RMAN nocatalog (using controlfiles) I got most of what I did from
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/rmanreco.htm#439890 I copied my rman files from old to new - created a directory on new host c:\oracle\backups - that is where they lived on the old machine. Copied my old password file to new host
changed the machine names in my listener.ora and tsnames.ora Copied my init ora from old to new and edited file locations (changed c:\ to d:\ )

connect to rman
startup mount
got my scn number from sqlplus - 128255218

ran the following
RMAN> run {
2> set until scn 128255218; # use appropriate SCN for incomplete recovery

3>      allocate channel ch1 type disk;
4>      set newname for datafile 1 to 'd:\ORACLE\ORADATA\prod\SYSTEM01.DBF';

#
rename each datafile manually
5> set newname for datafile 2 to
'd:\ORACLE\ORADATA\prod\UNDOTBS01.DBF';

6> set newname for datafile 3 to
'd:\ORACLE\ORADATA\prod\CWMLITE01.DBF';

7>      set newname for datafile 4 to 'd:\ORACLE\ORADATA\prod\DRSYS01.DBF';
8>      set newname for datafile 5 to


'd:\ORACLE\ORADATA\prod\EXAMPLE01.DBF';

9>      set newname for datafile 6 to 'd:\ORACLE\ORADATA\prod\INDX01.DBF';
10>      set newname for datafile 7 to 'd:\ORACLE\ORADATA\prod\ODM01.DBF';
11>      set newname for datafile 8 to 'd:\ORACLE\ORADATA\prod\TOOLS01.DBF';
12>      set newname for datafile 9 to 'd:\ORACLE\ORADATA\prod\USERS01.DBF';
13>      set newname for datafile 10 to 'd:\ORACLE\ORADATA\prod\XDB01.DBF';
14>      set newname for datafile 11 to

'd:\ORACLE\ORADATA\prod\OEM_REPOSITORY.

DBF';

15>      restore database;
16>      switch datafile all;  # point control file to renamed datafiles
17>      recover database;
18>      alter database open resetlogs;
19> }

I had to run it a couple of time because I didn't have the redo logs in the correct place or I didn't have the file in c:\... yet. But in the end I got this message:

Starting recover at 13-AUG-07

starting media recovery
media recovery complete

Finished recover at 13-AUG-07

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager

RMAN-03004: fatal error during execution of command RMAN-10039: error encountered while polling for RPC completion on channel defaul
t
RMAN-10006: error running SQL statement: select act from x$ksusex where sid=:1 a

nd serial=:2
RMAN-10002: ORACLE error: ORA-12571: TNS:packet writer failure
RMAN-03002: failure of alter db command at 08/13/2007 20:48:01

ORA-01092: ORACLE instance terminated. Disconnection forced

D:\>

What did I miss?

Thanks Larry C Received on Mon Aug 13 2007 - 20:44:01 CDT