Home » Server Options » Data Guard » Copying Archived log file From Primary to DR (oracle version 10g Windows XP)
Copying Archived log file From Primary to DR [message #524037] Wed, 21 September 2011 08:17 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

1) How to copy the ARCHIVED LOG FILE from Primary to DR location. Where if the DR is having the file already, how to SKIP that Particular Archived log file?

2) I have Checked with the FILE_TRANSFER DBMS package, but it gives the error if any file existing already.

Regards:
Muktha

Report message to a moderator

Re: Copying Archived log file From Primary to DR [message #524141 is a reply to message #524037] Thu, 22 September 2011 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use UTL_FILE.FGETATTR to know if the file exists or not before transfering it.

Regards
Michel

Report message to a moderator

Re: Copying Archived log file From Primary to DR [message #524154 is a reply to message #524141] Thu, 22 September 2011 01:30 Go to previous message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Thanks for the reply.

Regards:
Muktha

Report message to a moderator

Previous Topic: Finding Unapplied Archived log file in DR
Next Topic: standby FAL help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Mar 31 07:17:54 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.