Re: Oracle db file & redo archive file relocate question

Yibai He wrote:
>
> Hi,
>
> I am try to move Oracle database directory and REDO archive log
> directory into a new disk (Mirrored), my plan is:
>
> 1. Shutdown Oracle (8.0.5) & bring system (Unix Solaris 7) into Single
> user mode.
> 2. Rename(Move) the database dir "xxxxdb" & REDO Archive dir "archive"
> as "xxxxdb.old" & "archive.old", recreate those two dirs (mount points)
> 3. Mount the new hard disk partition under the two mount points, i.e.
> $ORACLEHOME/xxxxdb and $ORACLEHOME/archive
> 4. Copy files from the ".old" dir into the new dir, i.e "xxxxdb" &
> "archive"
> 5. Restart the system (init 6) (bring up the Oracle)
>
> My question is: will this plan work? or do I need change Oracle
> configuration files as well (or other changes)? E.g files under "admin"
> dir.
>
> Your help will be great appreciated.
>
> Thanks lot
> Yibai He

Hi,

This is what I would do...

1. Make a cold backup of the database.
2. Create a backup of the control file to trace.
3. Shutdown the instance.
4. Move the file where you want them.
5. Edit the control file to trace output, changing the paths of the files you moved.
6. Re-create the control file as instructed in the control file to trace output.

Doing it this way will allow you to:

1. Recover if things don't work out (from the cold backup).
2. Not have to debug a system reboot.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.