Database - RAC/Scalability (MOSC)

MOSC Banner

Recommended way to change redo log file location for RAC database?

edited Apr 21, 2023 3:01PM in Database - RAC/Scalability (MOSC) 5 commentsAnswered ✓

Recommended way to change redo log file location for RAC database? 


I am able to to shutdown RAC database and cluster. I need to change redo log file location for all instances in the RAC.

edit for clarity: I'm using NFS volumes (not ASM)


Are below steps "recommended" way for RAC?

Oracle RAC 19.4 version. Linux 7

thanks


srvctl stop database -d TO1TEST -stopoption IMMEDIATE

mv /diska/logs/log1a.log /diskc/logs/log1c.log
mv /diska/logs/log2a.log /diskc/logs/log2c.log

srvctl start database -d TO1TEST -startoption mount

sqlplus / as sysdba

ALTER DATABASE 
RENAME FILE '/diska/logs/log1a.log', '/diska/logs/log2a.log' 
     TO '/diskc/logs/log1c.log', '/diskc/logs/log2c.log';


srvctl stop database -d TO1TEST -stopoption IMMEDIATE

srvctl start instance -d TO1TEST

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center