RE: recover rman backup
- From: "Patterson, Joel" <jpatterson@xxxxxxxxxx>
- To: "ofabelo@xxxxxxxxx" <ofabelo@xxxxxxxxx>, Marcin Przepiorowski <pioro1@xxxxxxxxx>, Justin Mungal <justin@xxxxxxx>
- Date: Wed, 21 Aug 2013 07:49:44 -0400
Late to the party. Did you backup end after 22:00?
Joel Patterson
Database Administrator
904 928-2790
--
Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790 | Fax: 904-733-4916
http://www.entint.com/
http://www.entint.com/
http://www.facebook.com/pages/Enterprise-Integration/212351215444231
http://twitter.com/#!/entint http://www.linkedin.com/company/18276?trk=tyah
http://www.youtube.com/user/ValueofIT
This message (and any associated files) is intended only for the use
of the addressee and may contain information that is confidential,
subject to copyright or constitutes a trade secret. If you are not the
intended recipient, you are hereby notified that any dissemination,
copying or distribution of this message, or files associated with this
message, is strictly prohibited. If you have received this message in
error, please notify us immediately by replying to the message and
deleting it from your computer. Messages sent to and from us may be
monitored. Any views or opinions presented are solely those of the
author and do not necessarily represent those of the company. [v.1.1]
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Oliver
Sent: Wednesday, August 21, 2013 5:41 AM
To: Marcin Przepiorowski; Justin Mungal
Cc: oracle-l
Subject: Re: recover rman backup
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@xxxxxxxxx>
> Ok, thank you very much Marcin, understood.
>
> Regards...
>
>
> 2013/8/12 Marcin Przepiorowski <pioro1@xxxxxxxxx>
>
>> 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@xxxxxxxxx> 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...
>>>
>>>
>>> --
>>> //www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>>
>> --
>> Marcin Przepiorowski
>> http://oracleprof.blogspot.com
>>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
