标题: ORA-00258: NOARCHIVELOG 模式下的人工存档必须标识日志 [打印本页] 作者: 刘泽宇 时间: 2021-3-14 17:47 标题: ORA-00258: NOARCHIVELOG 模式下的人工存档必须标识日志 在查看数据库日志时发现数据库采用手工归档，但是报错：
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
MOS中的描述信息
OERR: ORA 258 manual archiving in NOARCHIVELOG mode must identify log [ID 18327.1]
Error: ORA 258
Text: manual archiving in NOARCHIVELOG mode must identify log
-------------------------------------------------------------------------------
Cause: An attempt was made to archive a redo log file manually without
specifying the sequence number, group number, or filename while the
database was in NOARCHIVELOG mode.
Action: The name, group number, or thread and sequence number of redo log
files must be specified to archive redo log files manually while the
database is in NOARCHIVELOG mode.
————————————————
处理方法：
1.将数据库改为归档模式
2.使用带有指定日志组的SQL命令完成归档操作（意义不大）
alter system archive log group 1;
alter system archive log group 1
*
ERROR at line 1:
ORA-00259: log 1 of open instance ora10g (thread 1) is the current log, cannot archive
错误提示很显然，当前日志组不允许归档。
尝试归档第二组日志
alter system archive log group 2;
alter system archive log group 2
*
ERROR at line 1:
ORA-16013: log 2 sequence# 1526 does not need archiving
因为归档状态是“YES”，因此该组日志无需归档。
尝试归档第三组日志
alter system archive log group 3;
System altered.
归档成功。