Sitemap

Amicuk Programming Answers

Archive log not shipped to standby.

-0001-11-30   Views:0

Advertisement

Dear Experts, We have are using oracle 10.2.0.4.0 on AIX. And we have configured physical standby database which was working fine till date. suddenly i found that the MRP process is waiting for gap. i have all the archive logs on the primary system a

Dear Experts,
We have are using oracle 10.2.0.4.0 on AIX.
And we have configured physical standby database which was working fine till date.
suddenly i found that the MRP process is waiting for gap.
i have all the archive logs on the primary system and all the logs are getting shipped to standby database expect one file.
/oracle/PRD/saparch/PRDarch1_46811_755493268.dbf only this file is not getting shipped to standby database....due to which the standby is waiting for this log.
log applied till 46810
other logs are getting shipped.
However i tried to manually copy this log to standby but it didnt start applying this log.
and i heard that if i copy the log file manually then i need to register it...please let me know how to register it if it is the correct method.
Please help to overcome this issue....
Thanks,
Shankar.
Edited by: Shankar Viji on Jun 19, 2012 10:34 PM

The replay answer
Advertisement
Shankar Viji wrote:
Dear Mesberg,
Is there any way to over come this bug.
Bug 6851669 - ORA-308 / ORA-27037 from Dataguard GAP resolution [ID 6851669.8]
if not i am planing to take offline backup of my primary and restore it on standby and start the DR again.
Please suggest is that the correct way to do it r not.
Thanks,
Shankar.
Edited by: Shankar Viji on Jun 21, 2012 10:51 PMHi,
It looks for me that archive unable to read, it may be because of any header verification or corrupted blocks.
Now do you have backup of archives ?
If so restore it and retry again.
If not, I suggest you to go with incremental scn for standby instead of recreation whole DR.
Check this link http://www.oracle-ckpt.com/rman-incremental-backups-to-roll-forward-a-physical-standby-database-2/

Go to See the other 10 answers

Archive log not shipped to standby.

Category:DefaultRelease time:-0001-11-30Views:130

Dear Experts, We have are using oracle 10.2.0.4.0 on AIX. And we have configured physical standby database which was working fine till date. suddenly i found that the MRP process is waiting for gap. i have all the archive logs on the primary system a[More]

Will RMAN delete archive log files on a Standby server?

Category:DefaultRelease time:2015-10-11Views:130

Environment: Oracle 11.2.0.3 EE on Solaris 10.5 I am currently NOT using an RMAN repository (coming soon). I have a Primary database sending log files to a Standby. My Retention Policy is set to 'RECOVERY WINDOW OF 8 DAYS'. Question: Will RMAN delete[More]

How to monitor the successful archive log shipment to the standby database

Category:DefaultRelease time:-0001-11-30Views:130

Hello, From the primary database, which data dictionary do I view to get information whether the standby database has received and processed the archive logs from the primary database. Both databases are 11202 on linux. Another question, which views[More]

Data guard real time apply vs archived log apply on physical standby

Category:DefaultRelease time:-0001-11-30Views:130

Dear DBA's, last week i configuared DR , now the phyiscal stanby database is archive apply mode, i want to confirm is it better to apply the archived log or should i cahnge it to real time apply . give me sugesstions. Thanks and Regards Raja...One qu[More]

Delete archive log files on physical standby

Category:DefaultRelease time:-0001-11-30Views:130

I want to delete the archive log files on the phsical standby database when they were applied. The archive log files are in the flash recovery area. So i used CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; in rman. My question: Does rman[More]

Archive logs not applied on standby!!

Category:DefaultRelease time:-0001-11-30Views:130

Hi Guys, I am trying to set up physical standby on windows 2003 server. I am using oracle 10.2.0.4.0. I get the following error in my alert file on standby Failed to request gap sequence Following is the results of some queries : SQL> SELECT PROCESS,[More]

Logical standby | archive log deleted | how to remove gap ???

Category:DefaultRelease time:2015-10-11Views:130

hi gurus... i have problem on logical standby by mistake standby log coming to logical standby has been deleted , now how to fill up the gap ??? ON STANDBY SEQUENCE# FIRST_CHANGE# NEXT_CHANGE# APPLIED 228 674847 674872 YES 229 674872 674973 CURRENT 2[More]

Archive log can not ship to GAP logfiles to standby DB automatically

Category:DefaultRelease time:-0001-11-30Views:130

we have a non-real time standby database, which will receive the archive file from the primary database server most of the time, and will apply the logfiles only at one point of time daily. Some times, we need to shutdown the Standby DB server for a[More]

10gr2 standard edition standby question - archive log shipping

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I have 2 servers with 10gr2 standard edition, one is production(primary) and secondary is standby on windows platform. To keep standby synchronized i use a script to copy archived logs from primary to standby and applying manually (with script[More]

Manually apply archived log to standby database.

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I am working on oracle 10g EE(10.2.0.4).I am having a very difficult database switchover case in my hand. 1.> There are two database .one primary(prim) and another standby(standby). 2.> Initially both of them was configured as oracle data gu[More]

Archives are not being able to ship to standby

Category:DefaultRelease time:-0001-11-30Views:130

Dear Friends i have installed oracle 9i on linux 4 i have made primary and standby behavior both database's listeners are up primary database is running in read right while standby is in mounted state. both servers are pinging to each other's service[More]

Hot
Whenever i have a mozilla browser on and i try to open another mozilla window browser it work pull up a new window. When close the browser that was on, it will still show up on Task Manager. Whats going on with this?There are other things that need a [More]
While there are some things that I like about iOS 7, there is one long term gripe that I have that's been made worse by iOS 7.  I have an iPad 3, and usually close (exit) all the apps that I've used that day at the end of the day, then put the iPad o [More]
Hi! I'm working with an entirely new system here from the ground up. New computer with Windows 7, Eizo ColorEdge CG245W monitor and Photoshop CS5 (I had previously been using CS3 on my old system/monitor). Everything was hooked up within the last cou [More]
Hi, I have to name the target file dynamically but  i don want the filename to come in the file. SO i am trying to use an UDF with the following code    //write your code here DynamicConfiguration conf = (DynamicConfiguration) container.getTransforma [More]
Hi,,, I would like to use "Find My Friends" app as both my wife and i have iPhones. Ive put the app on both phones ,,, We have one Apple ID for all our devices,,, It doesnt seem to work ??? I just want to to use to see our locations ,, not every [More]
Is anyone else having issues creating a ringtone? I cant seem to actually create a ringtone. I have a song that has the little bell, but when i try to download and create the clip I receive and error message? Any suggestions?This may be related. I ge [More]
Hi All, Is is possible to call a function or method before JVM exits where System.exit() is used. I am calling a program where System.exit is used. i need to call a function before the JVM exits. Please help me. Thanks, J.KathirHow to call the method [More]
on a Mac OS 10.9 (Mavericks) using CS6 (not creative cloud) whenever there's an update, the AAM puts an icon in my menubar. i have to click it & tell it to go ahead with an update. is it possible to set this to just DO the updates without the icon or [More]
I am a long time Illustrator occasional user and have not seen this issue before. I have some type set in a .ai file and suddenly I can't select/highlight any live type with the type tool, I can place the tool between letters and do some kerning, but [More]
Hi everyone, and thank you in advance for any support you may be able to provide. I have been plagued by this issue for some time and it is truly infuriating. If I have not provided enough information please say so and I would be happy to add more in [More]