Example of actual application code for Oracle Problem Solving

I have encountered such a problem before solving the Oracle problem. I did not know how to solve it due to the urgent time. I will share it with you. The following is a detailed introduction of the article, hope you can learn from it. Today, we met again because the log is damaged.

 
 

  
  
cmd -> sqlplus  
  
  
SQL> select group#,sequence#,archived,status from v$log;  
  
  
GROUP# SEQUENCE# ARC STATUS  
  
  
86 NO INACTIVE  
  
  
87 NO INVALIDATED  
  
  
85 NO INACTIVE  
  
  
alter database clear logfile group 1;  
  
  
alter database clear logfile group 2;  
  
  
alter database clear logfile group 3;  
  
  
shutdown immediate;  
  
  
startup mount;  
  
  
SQL> select group#,sequence#,archived,status from v$log;  
  
  
GROUP# SEQUENCE# ARC STATUS  
  
  
88 NO CURRENT  
  
  
0 NO UNUSED  
  
  
0 NO UNUSED  
  
  
alter database clear logfile group 1;  
  
  
alter database clear unarchived logfile group 1;  
  
  
alter database clear logfile group 2;  
  
  
alter database clear unarchived logfile group 2;  
  
  
alter database clear logfile group 3;  
  
  
alter database clear unarchived logfile group 3;  
  
  
shutdown;  
  
  
startup mount;  
  
  
alter database open;  
 
 

The above content is a description of the Code related to Oracle problem solving, hoping to provide you with some help in this regard.