Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle db file & redo archive file relocate question
What you guys probably didn't notice is that logical location of data
files will not be changed (while physical location will). So this
plan will most surely work right away (though I'd recommend
doing cold backup anyway, just in case). That's one great thing about
unix file system - you can move stuff around and still for applications
it will look like it's still where it was before, just use symlinks or
mount new filesystems where you want them.
Yibai He, you can do it even easier: just move files wherever you want, even rename them as you want, and then create symlinks to them in original location with original names (use ln -s) - Oracle will still be able to find them. No need to mount new fs on original location.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Yibai He" <hey_at_telecom.co.nz> wrote in message news:3B975E90.B6B33023_at_telecom.co.nz...Received on Sat Sep 08 2001 - 07:37:10 CDT
> 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
>
>
>