01. Shutdown database normal/immediate but not abort.
>shutdown immediate;
>shutdown immediate;
02. Copy the online redo log files to the new location.
Linux/Unix use mv command
Windows move command
03. Startup MOUNT database logging in as sysdba (do not open the database)
>startup mount pfile=<initialization parameter file with path>
04. Issue the following statement
Ex
You are changing the file from c:\oracle\oradata\redologs to c:\oracle\oradata\whs\redologs and like wise on d:\ drive.
ALTER DATABASE
RENAME FILE
'c:\oracle\oradata\redologs\redo_01_01.log',
'd:\oracle\oradata\redologs\redo_01_02.log'
TO
'c:\oracle\oradata\whs\redologs\redo_01_01.log',
'd:\oracle\oradata\whs\redologs\redo_01_02.log'
/
RENAME FILE
'c:\oracle\oradata\redologs\redo_01_01.log',
'd:\oracle\oradata\redologs\redo_01_02.log'
TO
'c:\oracle\oradata\whs\redologs\redo_01_01.log',
'd:\oracle\oradata\whs\redologs\redo_01_02.log'
/
05. Open the database
>alter database open;
No comments:
Post a Comment