Rman Learning Summary as follows, has been tested run, no problem.
1. Set the database as the archive mode
Check Archive mode
Select Log_mode from V$database;
If noarchivelog, it needs to be set to archive mode
Shutdown immediate;
Startup Mount;
Alter database Archivelog;
2, create the table space needed to restore the directory
Create tablespace Rman_ts
DataFile ' E:oracleproduct10.1.0oradataoraclerman_ts. DBF '
Size 1G autoextend on next 1M MaxSize Unlimited
3. Create an Rman user and authorize
Create user Rman identified by Rman
Default tablespace rman_ts Temporarytablespace temp;
This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/
Grant Connect,resource,recovery_catalog_owner to Rman;
--rman the command line operation
4. Create a recovery directory
Rman Target Rman/rman@oracle
Create catalog Tablespace rman_ts;
5. Registration Target Database
Register database;
6. Rman Backup (full database backup)
Run {
Allocatechannel dev1 type disk;
Backup database;
Release channel Dev1;
}
7. Backup Archive Log
run{
Allocate channel DEV1 type disk;
Backup Archivelog all;
Release channel Dev1;
}
8. View backup Information
List backup;
9. Rman Recovery
Set the database to Mount state
Shutdown immediate;
Startup Mount;
--rman the command line
run{
Allocate channel DEV1 type disk;
Restore database;
Recover database;
Release channel Dev1;
}