How To Rename A REDO Log file ?
Answer > You can rename a REDO Log file by executing following command.
ALTER DATABASE RENAME FILE 'E:\APP\ORADATA\PKT008\REDO017.LOG', 'E:\APP\ORADATA\PKT008\REDO017.LOG' TO 'E:\APP\ORADATA\PKT008\REDO017.LOG', 'E:\APP\ORADATA\PKT008\REDO017.LOG';
Note : Make sure to change your parameters accordingly.
Answer > You can rename a REDO Log file by executing following command.
ALTER DATABASE RENAME FILE 'E:\APP\ORADATA\PKT008\REDO017.LOG', 'E:\APP\ORADATA\PKT008\REDO017.LOG' TO 'E:\APP\ORADATA\PKT008\REDO017.LOG', 'E:\APP\ORADATA\PKT008\REDO017.LOG';
Note : Make sure to change your parameters accordingly.
No comments:
Post a Comment