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: 341
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: 54685
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: 341
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: Wed Jun 19 02:15:34 CDT 2013

Total time taken to generate the page: 0.15068 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.