Backup And Recovery User's Guide-禁用塊改變跟蹤
禁用塊改變跟蹤
假設塊改變跟蹤已經開啟。
當禁用塊改變跟蹤,資料庫會從作業系統移除塊改變跟蹤檔案
練習:禁用塊改變跟蹤
--1.啟動SQL*Plus,以管理員許可權連線到目標資料庫 --2.確保資料庫處於MOUNT或OPEN狀態 --3. 關閉塊改變跟蹤 sys@TESTDB12>alter database disable block change tracking;
Database altered. |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1087816/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Backup And Recovery User's Guide-開啟和禁用塊改變跟蹤GUIIDE
- Backup And Recovery User's Guide-改變塊改變跟蹤檔案的位置GUIIDE
- Backup And Recovery User's Guide-使用塊改變跟蹤來提升增量備份的效能GUIIDE
- Backup And Recovery User's Guide-檢查改變跟蹤是否被開啟GUIIDE
- Backup And Recovery User's Guide-備份控制檔案到跟蹤檔案GUIIDE
- Backup And Recovery User's Guide-RMAN備份概念-增量備份-塊改變追蹤GUIIDE
- Backup And Recovery User's Guide-允許恢復損壞塊:階段4GUIIDE
- Backup And Recovery User's Guide-建立和更新增量備份GUIIDE
- Backup And Recovery User's Guide-聯機重做日誌切換GUIIDE
- Backup And Recovery User's Guide-執行閃回刪除操作GUIIDE
- Backup And Recovery User's Guide-閃回技術基本概念GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-恢復單個的資料塊GUIIDE
- Backup And Recovery User's Guide-在還原之前驗證備份GUIIDE
- Backup And Recovery User's Guide-進行臨時歸檔備份GUIIDE
- Backup And Recovery User's Guide-介質恢復問題解決GUIIDE
- Backup And Recovery User's Guide-執行完全資料庫恢復GUIIDE資料庫
- Backup And Recovery User's Guide-使用RECOVER命令的自動恢復GUIIDE
- Backup And Recovery User's Guide-執行基於時間的或基於改變的不完全恢復GUIIDE
- Backup And Recovery User's Guide-備份歸檔重做日誌檔案GUIIDE
- Backup And Recovery User's Guide-使用RMAN備份歸檔重做日誌GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-恢復表空間GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-指令碼化RMAN操作GUIIDE指令碼
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-概覽RMAN環境GUIIDE
- Backup And Recovery User's Guide-覆蓋歸檔日誌目的地GUIIDE
- Backup And Recovery User's Guide-使用SET AUTORECOVERY進行自動恢復GUIIDE
- Backup And Recovery User's Guide-對於SUSPENDED資料庫的備份GUIIDE資料庫
- Backup And Recovery User's Guide-執行完全自動的RMAN TSPITRGUIIDE
- Backup And Recovery User's Guide-為TSPITR做計劃和準備GUIIDE
- Backup And Recovery User's Guide-恢復資料庫到祖先incarnationGUIIDE資料庫
- Backup And Recovery User's Guide-閃回刪除的先決條件GUIIDE
- Backup And Recovery User's Guide-時間點恢復的基本概念GUIIDE
- Backup And Recovery User's Guide-還原歸檔重做日誌到新位置GUIIDE
- Backup And Recovery User's Guide-為完全資料庫恢復做準備GUIIDE資料庫
- Backup And Recovery User's Guide-備份後刪除歸檔重做日誌GUIIDE
- Backup And Recovery User's Guide-建立正常和保證的還原點GUIIDE
- Backup And Recovery User's Guide-執行不完全資料庫恢復GUIIDE資料庫
- Backup And Recovery User's Guide-恢復的取消(並行介質恢復)GUIIDE並行