Here is the script I use which definitely works:
Code:
CONNECT CATALOG RMANCAT/ThePW@RCAT
CONNECT TARGET /
STARTUP NOMOUNT PFILE=init.ora;
RUN {
ALLOCATE CHANNEL CH1 TYPE DISK;
SET UNTIL SCN={you need an scn (or thread/seq#);
RESTORE CONTROLFILE;
}
SQL ‘ALTER DATABASE MOUNT’;
RUN {
ALLOCATE CHANNEL CH0 TYPE DISK;
ALLOCATE CHANNEL CH1 TYPE DISK;
ALLOCATE CHANNEL CH2 TYPE DISK;
ALLOCATE CHANNEL CH3 TYPE DISK;
###
SET NEWNAME FOR DATAFILE 1 TO '{new data name 1)';
SET NEWNAME FOR DATAFILE 2 TO '{new data name 2}';
### Etc ...
SET UNTIL SCN={you need an scn (or thread/seq#);
RESTORE DATABASE;
SWITCH DATAFILE ALL;
RECOVER DATABASE;
}
Good luck!
PS: Change channels from disk to tape.
Last edited by LKBrwn_DBA; 09-12-2007 at 08:40 PM.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb