DanBrother的部落格

Restore Database Using RMAN: 

Prerequisite:
a. controlfile  copied to the db controlfile path
b. database  started in mount mode

c:\> set NLS_DATE_FORMAT=YYYY/MM/DD HH24:MI:SS
c:\> set NLS_LANG=AMERICAN.ZHT16BIG5

set local=testdb
set oracle_sid=testdb
rman target / nocatalog

RMAN> run {
allocate channel t1 type disk;
set limit channel t1 kbytes 769500;
allocate channel t2 type disk;
set limit channel t2 kbytes 769500;
allocate channel t3 type disk;
set limit channel t3 kbytes 769500;
allocate channel t4 type disk;
set limit channel t4 kbytes 769500;
restore database;
recover database;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}

Restore a  Read-Only Datafile Using RMAN:
run {
allocate channel t1 type disk;
restore datafile 4;
restore database check readonly;
recover database;
release channel t1;
}