Home » RDBMS Server » Backup & Recovery » FLASHBACK of a table but with a SCN of another table (Oracle 11.g)
FLASHBACK of a table but with a SCN of another table [message #624841] Fri, 26 September 2014 08:57 Go to next message
OReiLeao
Messages: 2
Registered: September 2014
Junior Member
Hello everyone,

First at all thank you for your help and your time.

Here is my problem:

I have an instance (PROD) when I perform daily backups with RMAN.
I have an instance (DEV) where I have to update it with the values ​​of PROD at a specific given time (ie not necessarily the values ​​of the same day).

Is it possible to do this? Ie do a FLASHBACK table but with another source table?
If not, there is another way with my RMAN backups?

Thank you in advance,

OReiLeao

Report message to a moderator

Re: FLASHBACK of a table but with a SCN of another table [message #624842 is a reply to message #624841] Fri, 26 September 2014 09:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You should use duplicate option or just restore/recover the DEV instance to a particular point in time using RMAN backups.
also look into Active Duplication


Edit: added links
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#BRADV010
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#BRADV908

[Updated on: Fri, 26 September 2014 09:06]

Report message to a moderator

Re: FLASHBACK of a table but with a SCN of another table [message #624843 is a reply to message #624841] Fri, 26 September 2014 09:01 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Does database have ARCHIVED REDO enabled?

>I have an instance (PROD) when I perform daily backups with RMAN.
>I have an instance (DEV) where I have to update it with the values ​​of PROD at a specific given time (ie not necessarily the values ​​of the same day).

Is this "specific time" before, after, or concurrent with when RMAN backup was initiated?

Report message to a moderator

Previous Topic: RMAN-06571: datafile 1 does not have recoverable copy
Next Topic: rman restore failure rdba: 0x01c00001
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Mar 31 05:20:14 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.