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

On Aug 14, 11:44 am, "L C" <lccro..._at_hotmail.com> wrote:
> 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 fromhttp://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a769...
> 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

Is the name of your undo tablespace specified correctly in the new init.ora?
It's not the only cause of mysterious instance terminations in Oracle, but it's certainly one of them.

Anything in the alert log?

Regards
HJR Received on Mon Aug 13 2007 - 21:13:10 CDT