What is the difference between restoring and recovering
摘自orafaq
Restoring involves copying backup files from secondary storage (backup media) to disk. This can be done to replace damaged files or to copy/move a database to a new location.
Recovery is the process of applying redo logs to the database to roll it forward. One can roll-forward until a specific point-in-time (before the disaster occurred), or roll-forward until the last transaction recorded in the log files.
SQL> connect SYS as SYSDBA
SQL> RECOVER DATABASE UNTIL TIME '2001-03-06:16:00:00' USING BACKUP CONTROLFILE;
RMAN> run {
set until time to_date('04-Aug-2004 00:00:00', 'DD-MON-YYYY HH24:MI:SS');
restore database;
recover database;
}
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-996248/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- What is the difference between <%, <%=, <%# and -%> in ERB in Rails?AI
- What is the difference between gross sales and revenue?ROS
- What is the difference between application server and web server?APPServerWeb
- Some difference between mysql & oracleMySqlOracle
- Whats the difference between the v$sql* viewsSQLView
- Difference between business area and profit center
- The difference between literal and label.
- What is the difference Put and Post and Get?
- What is the difference between Mysql InnoDB B+ tree index and hash index? Why does MongoDB use B-tree?MySqlIndexMongoDB
- Difference between prop and attr in different version of jqueryjQuery
- Difference between sap_all and sap_new
- The main difference between Java & C++(轉載)AIJavaC++
- 【Oracle】-Difference between Instance recovery and Crash RecoveryOracle
- SAP Difference between Credit memo and subsequent debits/credits
- Difference Between Arraylist And Vector : Core Java Interview Collection QuestionJavaView
- What is the different between ALE, IDOC and BAPI?API
- 「萌新指南」SOA vs. 微服務:What’s the Difference?微服務
- Difference between Microsoft Dynamics 365 WEB API, Organization Service and Organization Data ServicROSWebAPI
- Python中print用法及The difference between Python 2 and 3Python
- Difference between 2>&-, 2>/dev/null, |&, &>/dev/null, >/dev/null, 2>&1devNull
- What is the difference betn i step=2 and i step=3 in variable user exit EXIT SAPLRRS0 001
- 3.4.3 Restoring the System to Normal OperationRESTORM
- 【oracle官網】 Restoring a Database on a New HostOracleRESTDatabase
- GoldenGate - What is supported and what is not ....Go
- Description of restoring file and filegroup backups in SQL ServerRESTSQLServer
- What is it?
- Error 600 encountered while recovering transaction (10, 0)ErrorWhile
- Difference of Revoke System Privileges and Object PrivilegesObject
- Diffrence Between delete and truncatedelete
- length() between oracle and postgresqlOracleSQL
- Relationship between BAPI and RFCAPI
- What is WebpackWeb
- What is Babel?Babel
- What is MySQL?MySql
- What is Gravity
- what is life?
- difference with PerlApp 7.0 and PerlApp 6.0APP
- The SQL vs NoSQL Difference: MySQL vs MongoDBMySqlMongoDB