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