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
Hi experts, When we use lot-sizing procedures PK, I have a problem about it. Can you please kindly help me. The problem is. When we run MRP and get the release date as past date in purchase requisition. I would not like system to propose release date [More]
Hi , I want to know that is Hyperion MDM is contrained by Operating System to support no more than 2 GB of memory? Does it true for DRM 9.3.2 and Version 11 also? If yes...Can it still support more than 80,000 member data into a single verion of DRM [More]
all of a sudden my itunes will not open... i've folllowed ALL of the steps to fix it... no results... my safari keeps giving me a webkit2process.exe error and quicktime does not work!!! help!!!! "C:\Program Files\Common Files\Apple\Apple Application [More]
Hi, In FB60, I have booked the two expenses with tax code separately.  While simulating the entry the tax lines are not showing separately as per expenses.  For example: Suppose my tax code = AB which is equal to 10% maintained in FTXP. At present en [More]
Hello I am required to create a payment terms as follows: 50% advance,50% after 30 days of delivery. How can I create this, pl. help me to do.HI, If you know the shipment date you can mention shipment date as either doc date or posting date, I guess [More]
Dear Gurus, I am exploring interface of t code MIRO , there i can see three functions of this tcode. Invoice, subsequent debit and credit.. I am clear about invoice. I searched SDN but couldnt really find any answer with example that in which situati [More]
Is there a way to tell if someone is spying on your I phone?Big Mac 2 wrote: As long as I have a Passcode and the phone isn't jailbroken no software is loaded on my phone I should be safe?? To quote from my previous post in this thread: " if you don' [More]
I don't want autoplay for my slideshow DVD, but I seem to get it no matter what. I have a cool menu and I want the menu to be the 1st thing a viewer sees when they put the DVD in. But as soon as I pop in the DVD, it always goes straight to the full s [More]
Hello @ all, I wanted to refresh the CPA CACHE with the PIDIRUSER but i had this Message Error: Couldn't parse Configuration Data cache update XML string from Directory So i have seen also in Forum. i have also registred manuelly  all the PI componen [More]
I'm looking for a formula that extracts the first word out of text in a cell and displays it in another cell. Eg, in Cell A1 I have the text "Bob likes to swim". I want "Bob" to appear in another cell. I've found a solution for Excel, [More]