ORACLE 10gR2 OMF+ ASM + RMAN DISASTER RECOVERY TESZTELÉSE ???

Így mentem az adatbázist(OMF-ben lett installálva) :

oracle@k8n:~/product/10gR2/dbs/scripts> cat fullbackup.rcv
connect target sys/jelszo@k8ndb
connect catalog rman/jelszo@catalog
run {

allocate channel c1 device type disk format '/opt/oracle/backup/bkup_%U';

backup current controlfile;
backup database;

}
Hibanélkül lemegy !!!

Így állítanám vissza : (Az adatabázis nomountban van !!! eredetileg +DATA/k8ndb/ alatt van minden az ASM-ben !!! Szeretném ha +DATA/kamu/ alá allítaná vissza, de b@szik rá !!!)

oracle@k8n:~/product/10gR2/dbs/scripts> cat proba.rcv
set dbid=3643492954
connect target /
connect catalog rman/jelszo@catalog
run {

allocate channel c1 device type disk format '/opt/oracle/backup/bkup_%U';

SET NEWNAME FOR DATAFILE 1 to '+DATA/kamu/datafile/system.256.582211735';
SET NEWNAME FOR DATAFILE 2 to '+DATA/kamu/datafile/undotbs1.258.582211737';
SET NEWNAME FOR DATAFILE 3 to '+DATA/kamu/datafile/sysaux.257.582211735';
SET NEWNAME FOR DATAFILE 4 to '+DATA/kamu/datafile/users.259.582211737';
SET NEWNAME FOR DATAFILE 5 to '+DATA/kamu/datafile/example.265.582211835';

restore controlfile to '+DATA/kamu/controlfile/current.260.582211803';
alter database mount;
restore database;
recover database ;
}

Ez a végeredmény :

RMAN> @proba.rcv

RMAN> set dbid=3643492954
executing command: SET DBID

RMAN> connect target *
connected to target database: (not mounted)

RMAN> connect catalog *
connected to recovery catalog database

RMAN> run {
2>
3> allocate channel c1 device type disk format '/opt/oracle/backup/bkup_%U';
4>
5> SET NEWNAME FOR DATAFILE 1 to '+DATA/kamu/datafile/system.256.582211735';
6> SET NEWNAME FOR DATAFILE 2 to '+DATA/kamu/datafile/undotbs1.258.582211737';
7> SET NEWNAME FOR DATAFILE 3 to '+DATA/kamu/datafile/sysaux.257.582211735';
8> SET NEWNAME FOR DATAFILE 4 to '+DATA/kamu/datafile/users.259.582211737';
9> SET NEWNAME FOR DATAFILE 5 to '+DATA/kamu/datafile/example.265.582211835';
10>
11> restore controlfile to '+DATA/kamu/controlfile/current.260.582211803';
12> alter database mount;
13> restore database;
14> recover database ;
15> }
allocated channel: c1
channel c1: sid=156 devtype=DISK

executing command: SET NEWNAME

Starting restore at 26-FEB-06

channel c1: restoring control file
output filename=+DATA/kamu/controlfile/current.260.582211803
channel c1: copied control file copy
input filename=+DATA/k8ndb/controlfile/current.285.583362155
output filename=+DATA/k8ndb/controlfile/current.286.583409687 recid=0 stamp=0
Finished restore at 26-FEB-06

database mounted

Starting restore at 26-FEB-06

channel c1: restoring datafile 00001
input datafile copy recid=11 stamp=583361955 filename=+DATA/k8ndb/datafile/system.280.583361919
destination for restore of datafile 00001: +DATA/kamu/datafile/system.256.582211735
channel c1: copied datafile copy of datafile 00001
output filename=+DATA/k8ndb/datafile/system.287.583409697 recid=13 stamp=583409735
channel c1: restoring datafile 00002
input datafile copy recid=8 stamp=583361926 filename=+DATA/k8ndb/datafile/undotbs1.283.583361921
destination for restore of datafile 00002: +DATA/kamu/datafile/undotbs1.258.582211737
channel c1: copied datafile copy of datafile 00002
output filename=+DATA/k8ndb/datafile/undotbs1.288.583409743 recid=14 stamp=583409744
channel c1: restoring datafile 00003
input datafile copy recid=10 stamp=583361946 filename=+DATA/k8ndb/datafile/sysaux.281.583361919
destination for restore of datafile 00003: +DATA/kamu/datafile/sysaux.257.582211735
channel c1: copied datafile copy of datafile 00003
output filename=+DATA/k8ndb/datafile/sysaux.289.583409745 recid=15 stamp=583409763
channel c1: restoring datafile 00004
input datafile copy recid=7 stamp=583361921 filename=+DATA/k8ndb/datafile/users.284.583361921
destination for restore of datafile 00004: +DATA/kamu/datafile/users.259.582211737
channel c1: copied datafile copy of datafile 00004
output filename=+DATA/k8ndb/datafile/users.290.583409771 recid=16 stamp=583409770
channel c1: restoring datafile 00005
input datafile copy recid=9 stamp=583361934 filename=+DATA/k8ndb/datafile/example.282.583361919
destination for restore of datafile 00005: +DATA/kamu/datafile/example.265.582211835
channel c1: copied datafile copy of datafile 00005
output filename=+DATA/k8ndb/datafile/example.291.583409771 recid=17 stamp=583409779
Finished restore at 26-FEB-06