rman question
Date: Thu, 19 Jan 2012 09:38:29 -0600
Message-ID: <CAJvnOJb9NHBPB=N6+4LA1yZhxx8YnZRxoYeo0yOTfXmeL+0sjw_at_mail.gmail.com>
I am trying to restore a single tablespace in rman. Restoring from asm to 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-lReceived on Thu Jan 19 2012 - 09:38:29 CST