ORA-19771: cannot rename change tracking file while database is open ORACLE 报错 故障修复 远程处理

文档解释

ORA-19771: cannot rename change tracking file while database is open

Cause: The ALTER DATABASE RENAME FILE command was used to rename the change tracking file, and the database is open by one or more instances. The database must be mounted, and not open, to rename the change tracking file.

Action: Close the database and reissue the command.

ORA-19771表示无法在数据库处于打开状态时重命名变更跟踪文件，它表明出现了重命名变更跟踪文件时发生了一些错误。

官方解释

常见案例

一般处理方法及步骤

1. 首先使用ALTER DATABASECHANGE TRACKING CLOSE关闭变更跟踪文件；

2. 使用ALTER DATABASECHANGE TRACKING RENAME将原变更跟踪文件改名；

3. 使用ALTER DATABASECHANGE TRACKING OPEN重新打开变更跟踪文件；