FAQ
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

Search Discussions

  • Radoulov, Dimitre at Jan 19, 2012 at 4:27 pm

    On 19/01/2012 16:38, Andrew Kerber wrote:
    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.
    If I understand the question correctly, you need just to rename the
    logfiles (alter database rename file ...
    via sqlplus or via rman sql '...'; command) and they will get
    automatically recreated when you try to open the database.




    Regards
    Dimitre
  • Andrew Kerber at Jan 19, 2012 at 5:36 pm
    Are you saying just rename the log files after the restore database command
    before doing the recovery and opening the database with resetlogs? Hmm,
    sounds like that might work...
    On Thu, Jan 19, 2012 at 10:24 AM, Radoulov, Dimitre
    wrote:
    On 19/01/2012 16:38, Andrew Kerber wrote:

    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.
    If I understand the question correctly, you need just to rename the
    logfiles (alter database rename file ...
    via sqlplus or via rman sql '...'; command) and they will get
    automatically recreated when you try to open the database.




    Regards
    Dimitre


    --
    Andrew W. Kerber

    'If at first you dont succeed, dont take up skydiving.'


    --
    http://www.freelists.org/webpage/oracle-l
  • Radoulov, Dimitre at Jan 19, 2012 at 5:41 pm

    On 19/01/2012 18:30, Andrew Kerber wrote:
    Are you saying just rename the log files after the restore database
    command before doing the recovery and opening the database with
    resetlogs? Hmm, sounds like that might work...
    You could do it whenever you prefer, there are only two constraints:

    - the database should be in mount state
    - you need to do it before the open resetlogs command


    Regards
    Dimitre

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 19, '12 at 3:39p
activeJan 19, '12 at 5:41p
posts4
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase