OraFAQ Forum: Backup & Recovery » apply archived logs to different database

Home » RDBMS Server » Backup & Recovery » apply archived logs to different database

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

apply archived logs to different database [message #215226]

Fri, 19 January 2007 22:53

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

Report message to a moderator

Re: apply archived logs to different database [message #215229 is a reply to message #215226]

Fri, 19 January 2007 23:15

ebrian
Messages: 2794
Registered: April 2006

Senior Member

No.

Report message to a moderator

Re: apply archived logs to different database [message #215349 is a reply to message #215229]

Sun, 21 January 2007 13:21

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.

Report message to a moderator

Re: apply archived logs to different database [message #215374 is a reply to message #215349]

Sun, 21 January 2007 22:00

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

Report message to a moderator