Home » RDBMS Server » Backup & Recovery » apply archived logs to different database
apply archived logs to different database [message #215226] Fri, 19 January 2007 22:53 Go to next message
sajut
Messages: 69
Registered: January 2007
Member
Hi

Can the archived logs generated in one database be applied to a different database with the datafile names

Thanking you in advance
Re: apply archived logs to different database [message #215229 is a reply to message #215226] Fri, 19 January 2007 23:15 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
No.
Re: apply archived logs to different database [message #215349 is a reply to message #215229] Sun, 21 January 2007 13:21 Go to previous messageGo to next message
cbruhn2
Messages: 41
Registered: January 2007
Member
What do you expect from doing this.
Are you thinking about standby database on a different node?.
Then they should be applied Smile .
I you want to extract information from the archived logfiles you should think about using logminer.
Look in the utilities about logmining if you want to extract information on another database.
But as ebrian states you will normally not be able to apply the redologs on another database.
Re: apply archived logs to different database [message #215374 is a reply to message #215349] Sun, 21 January 2007 22:00 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
Thanks for your reply
What I exactly want is to have a Backup database of our production database, at a remote location few kilometers away. Onto this I want to apply the redo logs generated by the main production database
Regards
Re: apply archived logs to different database [message #215496 is a reply to message #215374] Mon, 22 January 2007 09:38 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
For that, you should consider Data Guard.
Re: apply archived logs to different database [message #215560 is a reply to message #215496] Mon, 22 January 2007 22:25 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
Thanks,
But I use Oracle 9.2, where data guard feature is not available
Re: apply archived logs to different database [message #215626 is a reply to message #215560] Tue, 23 January 2007 04:51 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Sure 9i has Data Guard too. Check here.
Previous Topic: restoring DB to previous stage
Next Topic: RMAN installation question
Goto Forum:
  


Current Time: Thu Dec 08 22:02:15 CST 2016

Total time taken to generate the page: 0.29363 seconds