Printable View
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
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
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
if it's only few datafiles and logs
then follow what nabaig suggestion
otherwise anandharaj suggetion will
be much appropriate.
Thanks alot!
/J