Re: recover rman backup

From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Mon, 12 Aug 2013 16:14:43 +0100
Message-ID: <CAGdek=ytqM_Q5V_zYESVKN+WYQQ2NvVFf5E7mL0mQ5FLPJTQoA_at_mail.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 Mon Aug 12 2013 - 17:14:43 CEST