Oracle log file query

1. query the list of log files used:
Select * from V $ log;

2. query the log files of the Group in use:
Select * from V $ logfile;

3. Force log switching:
Alter system switch logfile;

4. query historical logs:
Select * from V $ log_history;

5. Log archiving mode:
Select dbid, name, created, log_mode from V $ database;

6. query the archived log information:
Select recid, stamp, thread #, sequence #, name from V $ archived_log;

7. add and delete a log file group
Alter database add logfile group 1 ('/home1/Oracle/oradata/ora8i/log1a. log'), '/home2/Oracle/oradata/ora8i/log1b. log') size 100 m;

Alter database drop logfile group 1;

8. add and delete log members
Alter database add logfile member '/home1/Oracle/oradata/ora8i/log1a. log 'to group 1,'/home1/Oracle/oradata/ora8i/log2a. log' to group 2;

Alter database drop logfile member '/home1/Oracle/oradata/ora8i/log1a. log ';

9. Move log files
Alter database rename File '/home1/Oracle/oradata/ora8i/log1a. log' to'/home2/Oracle/oradata/ora8i/log1a. log ';
Before executing this command, make sure that the log file has been physically moved to the new directory.

10. Clear log files
Alter database clear logfile '/home1/Oracle/oradata/ora8i/log1a. log ';
This command is used when you cannot use the delete group or group member command to delete logs.