Oracle redo management, oracleredo

Oracle redo management, oracleredo
1. Category

Several types of log files in Oracle

• Redo log files-> online Redo log

• Archive log files-> Archive log

• Alert log files-> alarm log

• Trace files-> Trace logs

• User_dump_dest-> User tracking log

• Backupground_dump_dest-> process trace log

2. Operation

View redo groups

SELECT group#,sequence#,members,bytes,status,archived FROM v$log;

View Details of members in the redo Group
select * from v$logfile
Add Group

alter  database add  logfile group 4 ('/opt/oradata/orcl/redo04.log') size 52428800;

Delete Group

alter database drop logfile group 4;

Add Member
"
Alter database add logfile member '/opt/oradata/orcl/redo04a. log' to group 4;

Warning log

Select * from v $ diag_info;
''

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.