L C wrote:
> <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?
It looks like you are recovering at a PIT when UNDOTBS1 was still used
by the instance. So just change UNDOTBS2 to UNDOTBS1 in your instance
parameter file and relaunch the restore operation (the whole run job -
the restore part may take no time since the datafiles are already on
disks - they would be restored once more time only if the recovery had
begun to work on them).
Received on Tue Aug 14 2007 - 05:30:03 CDT
