Oracle Log File Reconstruction Method

I believe you have some knowledge about oracle log files. The following describes how to reconstruct oracle log files.

1. Assume that there are three log groups with one member in each group. The size of each member is 1 MB. Now we want to change the size of all three log groups to 20 MB.

2. Create a New log Group
Alter database add logfile group4 ('d: \ oradb \ redo04.log ') size 2048 k;
Alter database add logfile group5 ('d: \ oradb \ redo05.log ') size 2048 k;

3. Switch the current log to the new log Group
Alter system switch logfile;
Alter system switch logfile;

4. Delete the old oracle Log File
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;

5. In the operating system, delete the files in the old oracle Log File Group 1, 2, and 3.

6. Recreate the log group 1, 2, 3
Alter database add logfile group 1 ('d: \ oradb \ redo01_1.log ') size 20 M;
Alter database add logfile group 2 ('d: \ oradb \ redo02_1.log ') size 20 M;
Alter database add logfile group 3 ('d: \ oradb \ redo03_1.log ') size 20 M;

7. Switch the log Group
Alter system switch logfile;
Alter system switch logfile;
Alter system switch logfile;

8. Delete the log group 4 and 5 of the intermediate transition.
Alter database drop logfile group 4;
Alter database drop logfile group 5;

Concepts of oracle users

Permission management for Oracle Super Users

Provides you with an in-depth understanding of Oracle system services.

How to change the password of an Oracle user

Queries the number of cursors in an Oracle database