Re: HELP RE: RELOCATION SYSTEM FILES

From: ba la <bala_at_hotmail.com>
Date: Sat, 16 Jan 1999 22:05:58 +0800
Message-ID: <77q606$6f52@news.asiaonline.net>

Hi,

You can try to recreate the control file by using the extracted trace file.

svrmgrl>alter database backup controlfile to trace;

edit the trace file to change the file location ( say script.sql) shut your database down in normal.

svrmgrl> shutdown normal;

relocation your system files.
svrmgrl> startup nomount ;

modify the script.sql to change noretlogs to resetlogs. svrmgrl>@script.sql

svrmgrl>alter database open resetlogs;

Ken Chow

Glen Upreti wrote in message <369E7A4B.62665D2D_at_nau.edu>...
>shutdown your database
>copy whichever files you want to move
>copy c:\blah\system01.dbf d:\blah2\system01.dbf
>startup mount
>alter database rename file 'c:\blah\system01.dbf' to
>'d:\blah2\system01.dbf';
>then
>alter database open;
>Then you should be done, this works for both log and data files. What I
>do though is before shutdown I generate a sql script (in sqlplus) to
>spool all of the changes for me and I run it. Some thing like this:
>
>spool foo.sql
>select 'alter database rename file '''||file_name||....
>you get the point.
>Enjoy,
>Glen
>
>mark.ragan_at_dial.pipex.com wrote:
>>
>> Could anyone please advise me how to move the "SYSTEM" tablespace &
>> redo LOG files from one drive to another on Windows NT.
>>
>> I am unable to use tablespace manager because I cannot set SYSTEM to
>> offline!
>>
>> Thanks
>
>--
><html>
>size=1>|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-| 
>Glen
>Upreti<x-tab>     </x-tab><x-tab>  &nbsp
;     </x-tab><x-tab>         </x-tab><x-tab>       & nbsp;</x-tab>    
> 
>Oracle
>DBA<x-tab>      </x-tab><x-tab>  &n
bsp;     </x-tab><x-tab>    &nb sp;   </x-tab>       &nbsp ;            
> 
>Northern Arizona University 
>Phone: (520)523-8393 
><x-tab>  </x-tab>Fax:(520)523-7407 
>Glen.Upreti_at_nau.edu 
></html>
Received on Sat Jan 16 1999 - 08:05:58 CST