Oracle日志异常：错误级别、信息丢失等问题实例-向日葵屋

Oracle日志异常：错误级别、信息丢失等问题实例

原创清疚 2025-03-11 02:42 18阅读 0赞

在Oracle数据库中，如果出现日志相关的异常，可能会有以下几种情况和对应的示例：

错误级别：比如ERROR级别表示严重错误。例如：

SQL> ROLLBACK;
Oracle Database error code 60005
- ORA-60005: No rollback performed due to errors during transaction.

信息丢失：如果日志空间不足，可能会导致日志记录的中断。例如：
```sql
SQL> alter system set log_file_size=’1MB’ scope=database;
System changed.

SQL> SELECT * FROM V$LOGFILE;
Name Status Size Next Log File Name
/u01/app/oracle/ora01/data/orcl.log OPEN 2097152 /u01/app/oracle/ora01/data/orcl.next

SQL> SELECT * FROM V$LOG;
Serial# Group# Member# Status Size Next File
34408634 1 1 OPEN 1679508 NULL /u01/app/oracle/ora01/data/orcl.log

SQL> alter system set log_file_count=’2’ scope=database;
System changed.

SQL> SELECT * FROM V$LOGFILE;
Name Status Size Next Log File Name
/u01/app/oracle/ora01/data/orcl.log OPEN 1679508 /u01/app/oracle/ora01/data/orcl.next

SQL> SELECT * FROM V$LOG;
Serial# Group# Member# Status Size Next File
34408634 1 1 OPEN 1679508 NULL /u01/app/oracle/ora01/data/orcl.log

SQL> alter system set log_file_size=’2MB’ scope=database;
System changed.

SQL> SELECT * FROM V$LOGFILE;
Name Status Size Next Log File Name
/u01/app/oracle/ora01/data/orcl.log OPEN 3359200 NULL /u01/app/oracle/ora01/data/orcl.next

SQL> SELECT * FROM V$LOG;
Serial# Group# Member# Status Size Next File
34408634 1 1 OPEN 3359200 NULL /u01/app/oracle/ora01/data/orcl.log