Offline Method 1. Shut down the database. 2. Copy the online redo log files to the new location. Operating system files, such as online redo log members, must be copied using the appropriate operating system commands. The following example uses operating system commands (UNIX) to move the online redo log members to a new location: […]
Archives for April 2021
Oracle Database: Redo log operations (Add/Drop/Change Location)
Question: How to add or drop online redo logs? How to change redo log file location? How to determine the optimal size for redo logs using OPTIMAL_LOGFILE_SIZE? How to add or drop online redo logs 1. Review information on existing redo logs: SELECT a.group#, b.member, a.status, a.bytes FROM v$log a, v$logfile b WHERE a.group#=b.group# 2. […]