Re: rman question

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 19 Jan 2012 11:30:49 -0600
Message-ID: <CAJvnOJYgrtLg7O-YH3ztig-wYkiKxbj7ZVFDGYhvDF9S5qNdKw_at_mail.gmail.com>



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 <cichomitiko_at_gmail.com>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
Received on Thu Jan 19 2012 - 11:30:49 CST

Original text of this message