rman question

From: Andrew Kerber <andrew.kerber_at_gmail.com>
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-l
Received on Thu Jan 19 2012 - 09:38:29 CST

Original text of this message