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
suppose i have declared parameter on selection screen for carrid and  i want to validate it like this. suppose when i am putting valid carrid then i am getting the list but if i put another value for carrid and if no values exist in database for carr [More]
HELP!! I recently purchase a itune album, the purchase went through ok and it proceeded to tell me it was processiimg the information, after 30/40mins it had completed three tracks .. i left it overnight as it was taking so long!! this morning it had [More]
How do I re-downlaod previously purchased songs from iTunes. The last part of the song did not download on 2 of my 4 last purchases.Just download them again.  There is no charge if you follow these steps: iTunes 10 for Windows: Download previous purc [More]
Dear all, I've created a class with characteristics for my vendor master. How can I make this classification assignment mandatory upon vendor master creation via XK01, MK01 and FK01? So that users would have to assign a vendor to a class thus enterin [More]
Hi Experts In Portal are there any chances to maintain user based on company codes.   Is there any possibility to monitor the Portal USER activities (what are the transactions or reports & etc).  Points will be revert back. Rgds PriyaHi Priya, Pl che [More]
I have one scenario:- I want to have procurement of one semi FG as X i.e both in house as well as external procurement. If order quantity is less than 100, system should create planned orders to be converted to production orders. If order qty is more [More]
Hi all, I wanted to check about how well SAP copes with a manufacturing environment where there are many parts for many product lines, with small production quantities being the norm. In this case, you would see many BOMs, High quantity of POs, Suppl [More]
Dear all, I had a problem in service based invoice in Purchase Order. When i created a po without checked service based invoice. When I SES then i revoke it. I cant checked service based invoice in ME22N. its become grey field. But GR-Based Invoice n [More]
Hi All, I am unable to start the two oc4j servers as it is giving the following exception Starting OC4J from C:\oc4j\j2ee\home ... 2009-01-21 11:38:34.015 NOTIFICATION JMSServer[]: OC4J JMS server recovering tra nsactions (commit 0) (rollback 0) (pre [More]
I have the Master Collection installed on a Z800 dual quad core with 36 GB of RAM with a Quadro 3800 and everything runs in Master Collection fairly well so far, but when I am in bridge trying to play AVCHD files either from my Canon HF30 or my HMC15 [More]