ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode ORACLE 报错 故障修复 远程处理

文档解释

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

Cause: You tried to copy or backup a file that was not closed cleanly, and the database was in NOARCHIVELOG mode. This is not allowed because when restored, the file will require redo application before it is usable, and redo is not currently being saved beyond the contents of the online redo logs.

Action: Take the tablespace offline clean or close the database and retry the copy or backup.

ORA-19602：表示您尝试在NOARCHIVELOG模式下备份或复制正在使用的文件，不允许操作。

官方解释

常见案例

一般处理方法及步骤

1. 对该RAC实例执行：ALTER SYSTEM ARCHIVE LOG START。

2. 使用ALTER SYSTEM SWITCH LOGFILE命令在所有实例上切换日志文件。

3. 然后可以安全地进行操作，例如备份、复制。