Menu

Navigation

How do I add a redo log group in Oracle 11g RAC?

Posted on by Arif Clayton

How do I add a redo log group in Oracle 11g RAC?

Steps to add redo log groups to Oracle RAC setup. Check existing redo log groups & redo log file size. As we checked redo log file location & size, we will proceed for redo log group addtions. SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 5 (‘+REDO/proddb/redo05. log’) SIZE 100m, GROUP 6 (‘+REDO/proddb/redo06.

How do you add a redo log group in ASM?

Create new Redo Log members for an existing group ALTER DATABASE ADD LOGFILE MEMBER ‘+REDO’ TO GROUP 1; Notice that filenames must be specified, but sizes need not be. The size of the new members is determined from the size of the existing members of the group.

How do I drop a redo log group in Oracle RAC?

To drop specific inactive redo log members, use the ALTER DATABASE statement with the DROP LOGFILE MEMBER clause. The following statement drops the redo log /oracle/dbs/log3c. rdo : ALTER DATABASE DROP LOGFILE MEMBER ‘/oracle/dbs/log3c.

How do I rename a redo log in Oracle 11g ASM?

To move or rename a logfile do the following.

  1. Shutdown the database.
  2. Rename the physical file on the OS.
  3. Start the database in mount mode.
  4. Issue the ALTER DATABASE RENAME FILE command to rename the file within the Oracle dictionary.
  5. Open the database.

How do I resize a redo log in Oracle 12c RAC?

How to Resizing Oracle Redo Log Groups in RAC. Resizing Oracle’s redo log groups is performed in 2 Steps. Step1> Add new the redo log groups with expected size. Step2> Drop the old redo log groups.

How do you add and drop a redo log group in Oracle?

To drop a member of an online redo log group use the following command: ALTER DATABASE DROP LOGFILE MEMBER ‘/DISK4/log2b. dbf’; Same statement holds good for OMF, find the logfile member full_path_file_name and drop the member.

How do I edit a redo log in Oracle?

To create a new group of redo log files, use the SQL statement ALTER DATABASE with the ADD LOGFILE clause. The following statement adds a new group of redo logs to the database: ALTER DATABASE ADD LOGFILE (‘/oracle/dbs/log1c.

How to add redo log groups in Oracle RAC?

Steps to add redo log groups to Oracle RAC setup. Check existing redo log groups & redo log file size. As we checked redo log file location & size, we will proceed for redo log group addtions. SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 5 (‘+REDO/proddb/redo05.log’) SIZE 100m, GROUP 6 (‘+REDO/proddb/redo06.log’) SIZE 100m; Database altered.

How to create new group of redo log files?

To create a new group of redo log files, use the SQL statement ALTER DATABASE with the ADD LOGFILE clause. The following statement adds a new group of redo logs to the database: ALTER DATABASE ADD LOGFILE (‘/oracle/dbs/log1c.rdo’, ‘/oracle/dbs/log2c.rdo’) SIZE 100M;

How to create new redo log members in SQL?

To create new redo log members for an existing group, use the SQL statement ALTER DATABASE with the ADD LOGFILE MEMBER clause. The following statement adds a new redo log member to redo log group number 2:

What does it mean to multiplex redolog in RAC?

Multiplexing means to keep multiple copies of redo log in different diskgroup. It is similar to that of multiplexing in standalone, Only change is RAC will have threads for node. i.e a 2 node RAC will have 2 threads. So while adding redolog group, we need to mention the thread parameter.