Hello Friends,I have an activity of datafiles movement how the steps involved in that? If anyuone know the process and steps involved in it then please explain them to me here.
Thanks in Advance!
Non system file can me moved without any downtime.
1: offline the datafile or tablespace2: go to os level and move the file to desired location3: come back to db leve.and run the alter statment to update the control file.with new location.4: online the datafile/tablespace.
Is it s specific file you are moving or whole database files?
If it is in ni archive log mode..shutdown immediatecp datafile from old path ti new pathstartup mountalter database rename file from oldpath to newpath;alter database open;
1. If you are moving only few data files then Lone Abdul steps will really works for non system data files. 2. If you are moving all the files (C,R,D) then take cold/hot backup and open/recreate control file..
I am not exactly sure if the 2nd steps workouts for you.Keep me solution posted.
If you are moving few data files then Lone Abdul steps is fine, but if whole datafiles movements then.1- take full backup of database2- then while restoring--run(Set newname of datafile 'old location' to 'new location'Restore database;Switch data file all;Recover database;)
Sign up for STechies