oracle10g_rman_語法測試_8
Keywords and Parameters
Syntax Element | Description |
---|---|
KEEP | Overrides any configured retention policy for this backup or copy so that the backup is not obsolete. The BACKUP ... KEEP command specifies a new retention time for this backup. Use this option to create a long-term backup, that is, a backup that want you to archive. |
FOREVER | Specifies that the backup or copy never expires. You must use a recovery catalog when FOREVER is specified, because the backup records eventually age out of the control file. |
UNTIL TIME = 'date_string' | Specifies the date until which the backup or copy must be kept. You can either specify a specific time by using the current NLS_DATE_FORMAT, or a SQL date expression, such as 'SYSDATE+365'. |
LOGS | Specifies that all of the archived logs required to recover this backup or copy must remain available as long as this backup or copy is available. |
NOLOGS | Specifies that this backup or copy cannot be recovered because the archived logs needed to recover this backup will not be kept. The only use for this backup or copy is to restore the database to the point in time that the backup or copy was taken. This is the only valid recoverability option when the database operates in NOARCHIVELOG mode. This option is not valid if the backup or copy is inconsistent. |
NOKEEP | Specifies that the backup or copy expires according to the user's retention policy. This is the default behavior. if no KEEP option is specified. |
Examples
Making a Long-Term Backup: Example This example makes a long-term backup of the database and specifies that it should never become obsolete and that the logs required to recover it should not be retained:
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
BACKUP DATABASE
KEEP FOREVER NOLOGS;
ALTER DATABASE OPEN;
Changing the Status of a Copy: Example This example specifies that any long-term image copies of datafiles and control files should lose their exempt status and so become eligible to be obsolete according to the existing retention policy:
CHANGE COPY OF DATABASE CONTROLFILE NOKEEP; --nokeep就是預設的
--以上的logs就是備份或複製對應的歸檔日誌也要可用
--nologs就是用於非歸檔模式
--until time就是備份集可以一直儲存到這個時間
--keep只是針對目前你進行的備份動作進行控制
--forever用於rman catalog中,因為controlfile record最終會age out,呵呵
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-615370/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle10g_rman_語法測試_1Oracle
- oracle10g_rman_語法測試_2Oracle
- oracle10g_rman_語法測試_3Oracle
- oracle10g_rman_語法測試_4Oracle
- oracle10g_rman_語法測試_5Oracle
- oracle10g_rman_語法測試_6Oracle
- oracle10g_rman_語法測試_7Oracle
- oracle10g_rman_語法測試_10Oracle
- oracle10g_rman_語法測試_restore專題OracleREST
- oracle10g_rman_語法測試_show專題Oracle
- oracle10g_rman_語法測試_spool_sql_startupOracleSQL
- oracle10g_rman_語法測試_reset database_allocate channel_OracleDatabase
- if測試和語法規則
- 前端測試框架Jest——語法篇前端框架
- python語法-測試程式碼Python
- 軟體測試培訓之:白盒測試的語句覆蓋法和判定覆蓋法
- Javascrip—AST抽象語法樹(8)JavaAST抽象語法樹
- PJzhang:搜尋引擎高階語法與滲透測試
- 以太坊Solidity程式語言開發框架————8、測試合約Solid框架
- K8S 操作測試K8S
- python介面自動化測試之python基礎語法Python
- 軟體測試術語
- 常用Java8語法小結Java
- ES8 async/await語法AI
- 程式測試第一法則?
- ESlint語法檢測工具EsLint
- 測試工程師必知的10大測試法則工程師
- Oracle 11.2.0.1 Result Cache 測試 - 8Oracle
- Oracle Stream實戰(8)—測試(一)Oracle
- C語言單元測試C語言
- 測試測試測試測試測試測試
- 《shell條件測試語句,字串測試apache是否開啟》字串Apache
- 整合測試時 MockMvc 無法注入MockMVC
- 八大藝術測試法
- oracle儲存過程plsql_sp_多個out引數測試語法Oracle儲存過程SQL
- 我的測試之旅:(8)困難——沒有現成的測試工具
- Angular8單元測試示例指南Angular
- k8s線上測試環境K8S