1. set old Oracle SID:
set ORACLE_SID=(SID)
or
export ORACLE=(SID);
2. RMAN
rman
connect target /
connect catalog user/pw@catalogdb
set DBID;
startup force nomount
@re1.rcv
re1.rcv:
run{
allocate channel t1 type ‘SBT_TAPE’
PARMS ‘ENV=(NSR_SERVER=<backup-server>,NSR_DATA_VOLUME_POOL=<poolname>)’;
set command id to ‘bkrs’;
restore spfile;
release channel t1;
}
@re2.rcv
re2.rcv:
run{
allocate channel t1 type ‘SBT_TAPE’
PARMS ‘ENV=(NSR_SERVER=<backup-server>,NSR_DATA_VOLUME_POOL=<poolname>)’;
set command id to ‘bkrs’;restore controlfile;
release channel t1;
}
shutdown
sqlplus “/ as sysdba”
create pfile from spfile;
edit pfile and change path and name of controlfile:
source for controlfile […]