rman question

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-l


Other related posts: