Friday , June 21 2024

How To Move Oracle Redo Logs

In today’s article we will be learning how to Move Redo Log File in oracle database.

Moving Redo Log files with the database open is dangerous work. Therefore, it is not recommended.

The database is closed;

Redo Log files are moved to the desired location in the operating system. (I’m just going to change the name here)

First go to the file location;

We then move or change the name;

The database opens in MOUNT mode;

New locations or names of Redo Log files are written to the Control File;

We put the database in OPEN mode;

Let’s check and see if it’s changed;



Leave a Reply

Your email address will not be published. Required fields are marked *