I have to migrate all data for an Oracle server from the present SAN to a new SAN. It is an 11g database in production on a Linux server. Database software is on local disk but all data (including datafiles, archive logs, control files, etc) are on a SAN via NFS.
The plan is to shut down Oracle before the sysadmin copies over the data to the new SAN. Since we are using NFS, when I start up Oracle again, the change should be transparent to Oracle.
The sysadmin has been told that the redo logs do not need to be copied. It seems to me that the redo logs should be archived before the copy. Should I force a log switch (alter system switch logfile)before the shutdown and then copy the archive logs? Or will a shutdown trigger the redo logs to be archived?
Best Answer
The REDO logs should be copied.
Shutdown doesn't trigger a logfile switch.
If you are changing the paths for the files, then using the "create controlfile reuse noresetlogs" method is the best. If you do move it without REDO logs, then archivelog current and then use the "create controlfile set resetlogs" method. In general though, moving the redo logs are best.
--EDIT--
Based on what you said, you are mounting these in the exact same path, then do your self a favor and just put all of the files, DATAFILES TEMPFILES CONTROLFILES REDOLOGS, etc in the exact same file path. Nothing else to do and it comes up fine.
-Richard