[重慶思莊每日技術分享]-ORA-1142 signalled during: ALTER DATABASE END BACKUP

WARNING: datafile #849 was not in online backup mode

WARNING: datafile #850 was not in online backup mode

WARNING: datafile #851 was not in online backup mode

WARNING: datafile #852 was not in online backup mode

WARNING: datafile #853 was not in online backup mode

WARNING: datafile #854 was not in online backup mode

WARNING: datafile #855 was not in online backup mode

WARNING: datafile #856 was not in online backup mode

WARNING: datafile #857 was not in online backup mode

ORA-1142 signalled during: ALTER DATABASE END BACKUP...

解決辦法：

如果對資料庫設定為結束熱備份時日誌中才會報以上錯誤日誌資訊，因為沒有把資料庫設定為開始熱備份的狀態。

SQL> alter database end backup;

alter database end backup

*

第 1 行出現錯誤:

ORA-1142 signalled during: ALTER DATABASE END BACKUP...

SQL> alter database begin backup;

資料庫已更改。

SQL> alter database end backup;

資料庫已更改。

則資料庫日誌報以下資訊，不再出現警告資訊

alter database begin backup

Completed: alter database begin backup

alter database end backup

Completed: alter database end backup