Friday, 23 May 2014

Change REDO log location


1. sql>select * from v$logfile;

Note the location of the redo logs and copy it safely

2. sql > shutdown immediate

3. mv the redo logs to the new location

4. startup mount

5. change the location using below alter script

SQLPLUS >

ALTER DATABASE RENAME FILE '/backup/redologs/PEMSAPMS/redo01.log', '/backup/redologs/PEMSAPMS/redo02.log' ,'/backup/redologs/PEMSAPMS/redo03.log' TO '/redo/PEMSAPMS/redo01.log',

'/redo/PEMSAPMS/redo02.log','/redo/PEMSAPMS/redo03.log';

6. Alter database open;

No comments:

Post a Comment