How to delete the online redo log files and add the new logs

Viewing information about log files

select * from v$log; 

select * from v$logfile;

Adding a new redo logfile group

alter database add logfile group 1 ('/d01/testdb/test/log3a.log','/d01/testdb/test/log4e.log') size 100m;

Adding members to an existing group

alter database add logfile member '/d01/testdb/test/log5e.log ' to group 1;

 For Deleting redo log files it shouldn’t be active the redo log file what we are going to be delete it. In this types cases we use to switch the log file to another log file.

 alter system switch logfile    - it forces to switch to the another redo log file

Dropping members from a group

alter database drop logfile member ‘/d01/testdb/test/log5e.log ’;

Dropping logfile group

alter database drop logfile group 4;

 Renaming Log files

1. Shut down the database

2. Go to the OS level and change the redo log file names – mv log3a.log log3b.log

3. startup mount

4. alter database rename file ‘/d01/testdb/test/log3a.log’ to '/d01/testdb/test/log3b.log';

5. alter database open;

Clearing Redo log files:

alter database clear logfile group 1;

Use full Meta Links Notes

Concurrent Requests:

What Are Concurrent Reports That Should Be Scheduled Periodically [ID 1066117.1]

What is the Gather Statistic Program or Gather Schema Statistics? [ID 155766.1]

How to Cancel a Concurrent Request Stuck in the Queue? [ID 749748.1]

Invalid Objects:

How to compile Invalid Objects [ID 143734.1]

How To Validate Invalid Dbms_xsoq Package [ID 807321.1]

Adadmin:

How To relink a single executable via ADADMIN Utility [ID 388198.1]

How to Generate a Specific Form Through AD utility adadmin [ID 178722.1]

Browsers:

Recommended Browsers for Oracle E-Business Suite Release 12 [ID 389422.1]

Forms:

How Do You Manually Generate A Form In Release 12 [ID 554336.1]