Home » RDBMS Server » Backup & Recovery » rollforward issue
rollforward issue [message #394490] Fri, 27 March 2009 07:10 Go to next message
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..
Re: rollforward issue [message #394493 is a reply to message #394490] Fri, 27 March 2009 07:48 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
No, you can't apply another database's archivelogs to a different database.
Re: rollforward issue [message #394630 is a reply to message #394493] Sat, 28 March 2009 21:11 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: rollforward issue [message #394644 is a reply to message #394631] Sun, 29 March 2009 03:43 Go to previous message
tjay
Messages: 37
Registered: September 2008
Member
because I dont have enough memory to install two databases.

Previous Topic: Restore controlfile problem
Next Topic: import problem
Goto Forum:
  


Current Time: Mon Dec 05 03:11:02 CST 2016

Total time taken to generate the page: 0.06462 seconds