Re: recover rman backup

From: Oliver <ofabelo_at_gmail.com>
Date: Wed, 21 Aug 2013 10:41:09 +0100
Message-ID: <CALQkqm-vPxqFjaBPAKQ4SHgGdAJPrsT_wncBi=hf58gNTjgHfw_at_mail.gmail.com>

Hi list,
I have restored all datafiles now correctly (I've had many problems for space issues).
I'm trying recover database now, but I have problems, I run: run {
SET UNTIL TIME "to_date('13 AUG 2013 22:00:00','DD MON YYYY hh24:mi:ss')"; recover database;
}

I have warning rman-03031 (I do copy/paste over rman prompt of above lines). The backup that I'm trying recover is done starting 13 AUG 23:00 .. It fails because asks about an archivelog file .. I only want recover database until backup start, I don't need recover data later of that. I think that I don't need archivelog files :-? Thanks beforehand.

Regards..

2013/8/13 Oliver <ofabelo_at_gmail.com>

> Ok, thank you very much Marcin, understood.
>
> Regards...
>
>
> 2013/8/12 Marcin Przepiorowski <pioro1_at_gmail.com>
>
>> Hi,
>>
>> As mentioned early you can restore ASM DB into file system but RMAN
>> backup is physical one so you can restore particular tablespace (plus
>> couple of mandatory ones) but you can not restore single table or schema.
>> If you want one table only you need to restore whole tablespace and then
>> export table using Data Pump export/import.
>>
>> regards,
>> Marcin
>>
>>
>> On Mon, Aug 12, 2013 at 9:31 AM, Oliver <ofabelo_at_gmail.com> wrote:
>>
>>> Hi,
>>> I'm a newbie, so I'm sorry if question is very easy for yours or it isn't
>>> possible ..
>>> I have a production database in Oracle RAC 10g, and a test database in
>>> simple oracle 10g instance. Production is using ASM, and test using
>>> normal
>>> filesystem, for storing datafiles.
>>> Is it possible to use a rman backup of production for recovering some
>>> schemas in test database? (question is because productions uses ASM and
>>> test normal filesystem). Both use same operating system (AIX) and same
>>> Oracle 10g version (10.2.0.5.0).
>>> If it is possible, could you indicate me some manual/tutorial where it
>>> explains how to do it please?
>>> Thanks beforehand.
>>> Regards...
>>>
>>>
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>>
>> --
>> Marcin Przepiorowski
>> http://oracleprof.blogspot.com
>>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 21 2013 - 11:41:09 CEST