file system. I am comfortable with the set newname command below, but I am
not sure about the syntax for the restore database skip tablespace section
followed by the logfile section. The old logfiles arent available because
we are on new hardware on a file system instead of asm. Has anyone done
this, or have any idea if this syntax will work?
run{
set newname for datafile 1 to....;
.
.
.
restore database skip tablespace USERS, ts1, ts2, ts3
logfile
GROUP 1 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_01.dbf'
) SIZE 2097152000,
GROUP 2 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_02.dbf'
) SIZE 2097152000,
GROUP 3 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_03.dbf'
) SIZE 2097152000,
GROUP 4 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_04.dbf'
) SIZE 2097152000,
GROUP 5 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_05.dbf'
) SIZE 2097152000,
GROUP 6 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_06.dbf'
) SIZE 2097152000,
GROUP 7 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_07.dbf'
) SIZE 2097152000,
GROUP 8 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_08.dbf'
) SIZE 2097152000,
GROUP 9 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_09.dbf'
) SIZE 2097152000,
GROUP 10 (
'/u01/app/oracle/product/10.2.0/db_1/oradata/redo_10.dbf'
) SIZE 2097152000;
}
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
http://www.freelists.org/webpage/oracle-l