move dbf files and log files

[johan]

Is it possible to move your dbf files or redo logfiles
after the DB is created?
If it is, where do I change the path to the new place...?

My purpose would be to spread these files in to separate
disks and filesystems...

Is this possible or do I have to export the old one...
create a new instance and then import???

please be nice, I am an almost complete newbie..
/Johan

[nabaig]

Yes you can:

Take the datafiles you want to relocate offline and then copy them over using OS commands and then change the control file pointers using:

alter tablespace name
rename datafile 'new location';

Nizar

[anandharaj]

Hi

It is possible to move the datafile and redo logfile without using export/import.

Step1: Take a control file backup, using "alter database backup controlfile to trace"

Step2: Take the backup of your full db (for safer side).

Step3: Shutdown DB

Step4: Move the Datafile and log file to new location (where u want).

Step5: Create a new Controlfile script, using the backup controlfile and change the Path to new location.

Step6: Startup the Listener Service alone from services
Startup nomount from svrmgr

Step7: Execute the Controlfile script

Step8: Execute "Alter database open resetlogs"

Step9: Thats it...


Hope this will help you...

Regards

[reydp]

if it's only few datafiles and logs
then follow what nabaig suggestion
otherwise anandharaj suggetion will
be much appropriate.

[johan]

Thanks alot!

/J