Version 11.2
Platform : Solaris 10
We are restoring the RMAN cold backup to a new server. It is a basic RMAN restore where DB name remains the same.
I gather that RMAN doesn't backup Online redo logs and for a good reason.
We have restored our datafiles succefully. The control file still has old entries so the below query shows old info about redo logs
-- Showing the log file config from the Old control file data
SYS > select * from v$logfile; ------------> The below output shows the result of the source server
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ----------------------------------- ---
1 ONLINE /DATAM/DB/oradata/slmps/redo1.log NO
2 ONLINE /DATAM/DB/oradata/slmps/redo2.log NO
3 ONLINE /DATAM/DB/oradata/slmps/redo3.log NO
I have to use ALTER DATABASE RENAME FILE command like below to update the control file.
alter database rename file '/DATAM/DB/oradata/slmps/redo1.log' to '/data/oradata/slmps/slmps_log01.dbf' ;
alter database rename file '/DATAM/DB/oradata/slmps/redo2.log' to '/data/oradata/slmps/slmps_log02.dbf' ;
alter database rename file '/DATAM/DB/oradata/slmps/redo3.log' to '/data/oradata/slmps/slmps_log03.dbf' ;
Currently, in the new server, at OS level there are no physical files like above at
/data/oradata/slmps
Do I have to physically create the new redo logs using touch command
or Will the above ALTER DATABASE RENAME command create a physical file at OS level?