OraFAQ Forum: Backup & Recovery » rollforward issue

Home » RDBMS Server » Backup & Recovery » rollforward issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rollforward issue [message #394490]

Fri, 27 March 2009 07:10

tjay
Messages: 37
Registered: September 2008

Member

Hi
Assume I have two identical databases.They both have same datafiles,controlfiles, structure is exactly same, except data..
The name of the first db is "AA" which is in archivelogmode (production database)
The name of the second db is "BB" which is in noarchivelogmode.

If I restore from "BB" db`s backup, can I apply archivelogs of "AA"? so that both have the same data..

Report message to a moderator

Re: rollforward issue [message #394493 is a reply to message #394490]

Fri, 27 March 2009 07:48

ebrian
Messages: 2794
Registered: April 2006

Senior Member

No, you can't apply another database's archivelogs to a different database.

Report message to a moderator

Re: rollforward issue [message #394630 is a reply to message #394493]

Sat, 28 March 2009 21:11

tjay
Messages: 37
Registered: September 2008

Member

Hmmm

Let me try to explain again

if I restore BB from ALL of AA's backup, then AA becomes BB . . . .

Therefore, BB has same SCN of last AA backup. and so that I can apply AA`s archivelogs.

Little bit complicated to explain, but I hope you get me.

[Updated on: Sat, 28 March 2009 21:12]

Report message to a moderator

Re: rollforward issue [message #394631 is a reply to message #394490]

Sat, 28 March 2009 21:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.dbforums.com/oracle/1640301-rollforward-issue.html

Did you read & follow the bouncing RED ball advice as stated in URL below?
http://www.orafaq.com/forum/f/1/136107/
Did you read & follow Posting Guidelines as contained in URL below?
http://www.orafaq.com/forum/t/88153/0/

>if I restore BB from ALL of AA's backup
It depends upon how the backup of AA was accomplished.

By the way, why are you spending time here instead of simply doing what you are asking about?

From were I sit BB never is involved, except perhaps in your imagination.

Report message to a moderator

Re: rollforward issue [message #394644 is a reply to message #394631]

Sun, 29 March 2009 03:43

tjay
Messages: 37
Registered: September 2008

Member

because I dont have enough memory to install two databases.

Report message to a moderator

Previous Topic:	Restore controlfile problem
Next Topic:	import problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 07:38:26 CST 2024