RMAN backup recovery

Method 1: Restore all

I. Back up the database first:

650) This. width = 650; "Title =" developer.png "alt =" wkiom1o5bevsonfaaay_n2ge7xu237.jpg "src =" http://s3.51cto.com/wyfs02/M01/39/5B/wKiom1O5bevSOnfAAAY_n2gE7XU237.jpg "/>

View the destination address of the data file in report Schema

Ii. Delete system01.dbf and sysaux01.dbf

650) This. width = 650; "Title =" delete .png "alt =" wkiom1o5bnhqp6vpaaxkcpw7k6o813.jpg "src =" http://s3.51cto.com/wyfs02/M00/39/5B/wKiom1O5bnHQP6VpAAXkcPW7K6o813.jpg "/>

Iii. Close the database and start it to the Mount state.

650) This. width = 650; "Title =" .png "alt =" wkiom1o5bwgt_gfaaae3uwxdejc296.jpg "src =" http://s3.51cto.com/wyfs02/M00/39/5B/wKiom1O5bwGT_gfaAAE3UWxdEjc296.jpg "/>

4. Use the RMAN command to restore the database:

650) This. width = 650; "Title =" .png "alt =" wkiom1o5b17z4b7gaasi6fvaexy759.jpg "src =" http://s3.51cto.com/wyfs02/M00/39/5B/wKiom1O5b17z4b7gAASI6fVAexY759.jpg "/>

5. Completed

 

Method 2: directly restore lost data files

I. query the number of data files in system01:

650) This. width = 650; "Title =" query.png "src =" http://s3.51cto.com/wyfs02/M02/39/5B/wKioL1O5eSbgytzRAAFG-3hY7cQ249.jpg "alt =" wKioL1O5eSbgytzRAAFG-3hY7cQ249.jpg "/>

 

Ii. Delete system01

650) This. width = 650; "Title =" delete .png "src =" http://s3.51cto.com/wyfs02/M01/39/5B/wKiom1O5eXDSVN1NAAOe_GVF-lM850.jpg "alt =" wKiom1O5eXDSVN1NAAOe_GVF-lM850.jpg "/>

Iii. Restore the system01 data file:

650) This. width = 650; "Title =" restore.png "src =" http://s3.51cto.com/wyfs02/M00/39/5B/wKioL1O5eWbg2qqtAAKfePP3zBQ674.jpg "alt =" wkiol1o5ewbg2qqtaakfepp3zbq674.jpg "/>

Iv. Restore the system01 data file:

650) This. width = 650; "Title =" recover.png "src =" http://s3.51cto.com/wyfs02/M02/39/5B/wKiom1O5ecWT8XEfAADeqf0Ky8M500.jpg "alt =" wkiom1o5ecwt8xefaadeqf0ky8m500.jpg "/>

V. Verify database status:

650) This. width = 650; "Title =" validation .png "src =" http://s3.51cto.com/wyfs02/M01/39/5B/wKioL1O5eerha6L-AADZKkoMCx4267.jpg "alt =" wKioL1O5eerha6L-AADZKkoMCx4267.jpg "/>

 

In addition:

 

Differences between recover and restore in Oracle RMAN:
 
Restore just copy the physical file, recover will consistent the database.
 
Restore is a file-level restoration. Physical file restoration.
A recover is a data-level recovery. Logical recovery, such as archiving and redo logs of applications, must be synchronized to ensure consistency.
 
In my own words, we use restore to copy the backup file to the database directory and replace it with the recover file. After some processing, the database will be restored to normal.
 
1. Restore command: Used to restore data files that have been backed up.
(1) Restore all data files in the Restore database.
(2) Restore tablespace to restore data files in a specific tablespace.
(3) Restore datafile to restore a specific data file.
(4). Restore controlfile restores the control file.
(5) Restore archivelog to restore archived log files.
 
2. Recover command: Use the recover command when the database needs to apply archive log files to restore data files. Using this command, the database system automatically applies archived log files.
(1) recover all data files in the database.
(2) recover tablespace to restore data files in a specific tablespace.
(3) recover datafile to restore a specific data file.

 

 

This article is from the "one fan" blog, please be sure to keep this source http://1336014.blog.51cto.com/1326014/1435144