資料庫的standby模式是一種離線的物理儲存模式。用Read only方式開啟standby db，做一些查詢，然後恢復到開啟前的狀態(standby db的報表用途)。在備庫上進行操作。首先取消恢復應用SYS@dg2>recover managed standby database cancel;Media recovery complete.SYS@dg2>alter database open;Database altered.SYS@dg2>select open_mode from v$database;OPEN_MODE--------------------READ ONLYSYS@dg2>conn bys/bysConnected.BYS@dg2>select * from tab;TNAME TABTYPE CLUSTERID------------------------------ ------- ----------TEST TABLEBYS@dg2>select * from test; A---------- 999 111關閉並重新開啟資料庫到MOUNT狀態，執行恢復應用：alter database recover managed standby database disconnect from session;