Oracle 11gR2 Single Instance + asm for RMAN

Single Instance for RMAN backup and recovery]

Topic: simple use of RMAN]
I. rman backup operations:
1. Log On As an oracle user. First, check whether the/u02/rman directory exists.
2. log on to rman using the sys user and the password oracle
Rman target sys/oracle
Run {
Crosscheck archivelog all;
Allocate channel specified device type disk format'/u02/rman/test _ % U ';
Allocate channel CH2 device type disk format'/u02/rman/test _ % U ';
BACKUP incremental level 0 DATABASE plus archivelog delete input;
Release channel identifier;
Release channel CH2;
}
RMAN> list backupset;

650) this. width = 650; "title =" 1.jpg" src = "http://img1.51cto.com/attachment/201308/105441445.jpg"/>

// After the backup is complete, make sure to record the scn.
The SCN number after the backup is completed. This SCN number must be recorded as the time point for database recovery)
# The SCN number is similar to the following:
--------------------------------------------------------------------------
Ii. Restore rman for the first time
1. ORACLE user logon
2. Restore for the first time
Use the sys user to log on to rman
Rman target sys/oracle
Shutdown immediate;
Startup mount;
Run {
Set until scn 277970;
Allocate channel specified device type disk format'/u02/rman/test _ % U ';
Allocate channel CH2 device type disk format'/u02/rman/test _ % U ';
Restore database;
Recover database;
SQL 'alter database open resetlogs ';
Release channel identifier;
Release channel CH2;
}
Iii. Multiple rman recovery operations
After you use the backup file to restore the database and open resetlogs to open the data,
To recover the database again, you must specify the database's incarnation.
1. ORACLE user logon
2. Restore
Use the sys user to log on to rman
Rman target sys/oracle
Shutdown immediate;
Startup mount;
List incarnation;
Reset database to incarnation 1;
Run {
Set until scn 1;
Allocate channel specified device type disk format'/u02/rman/test _ % U ';
Allocate channel CH2 device type disk format'/u02/rman/test _ % U ';
Restore database;
Recover database;
SQL 'alter database open resetlogs ';
Release channel identifier;
Release channel CH2;
}

650) this. width = 650; "title =" 2.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2155124Z3-1.jpg"/>

---------------------------------------------------------

One of RMAN backup and recovery: Oracle 11gR2 Single Instance + asm for RMAN
RMAN backup and recovery 2: Oracle 11gR2 RAC + asm for RMAN
RMAN backup and recovery 3: Oracle 11gR2 + asm for RMAN command Application

-----------------------------------------------------------

This article from "Han Feng" blog, please be sure to keep this source http://linuxxx.blog.51cto.com/1824808/1279451