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

<hjr.pythian_at_gmail.com> wrote in message news:1187057590.031160.146730_at_g12g2000prg.googlegroups.com...
> 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
>

I had an issue during the week where I deleted my undotbs1. So I created a undotbs2 using some instructions I found on the web. That was most likely the cause of this from the alert log.

Mon Aug 13 22:01:03 2007
Errors in file d:\oracle\admin\prod\udump\prod_ora_2884.trc: ORA-30012: undo tablespace 'UNDOTBS2' does not exist or of wrong type

Mon Aug 13 22:01:03 2007
Error 30012 happened during db open, shutting down database USER: terminating instance due to error 30012 Instance terminated by USER, pid = 2884
ORA-1092 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ...

Any hints on what to do?

Larry C Received on Mon Aug 13 2007 - 21:38:48 CDT