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 ALL, I've Created a package to notify report in email  as excel, which is using a path to render report and save it as excel. This package was need to be schedule every first day of month and on every Friday even at morning 7 AM. So logically thes [More]
Let's say two people share one computer and person A likes what he hears about iTunes 9 and wants to down it, but person B hates it and wants to keep iTunes 8 on the computer. I know it can't be done with one account but can it be done with two accou [More]
I got the update message and I usually immediately download and install the update, but this day I ignored the message.  A few days later I got this POP Up stating that a C++ runtime Microsoft Visual app is attempting to load a program in the wrong p [More]
I have been using X Pro for 2 months following installation of CS5.5 Premium. I used to be able to print-to-file using the Adobe PDF printer in the print dialog box from within apps such as Word and Finale. Suddenly that option is absent from my prin [More]
I have an XSLT file that an xml file is referring to. The XML file calls the XSLT with this line: <?xml-stylesheet href="page.xslt" type="text/xsl"?> The "page.xslt" then includes another xslt file called "widgets. [More]
i'm trying to connect my apple tv to a JBL on-stage dock with a 3.5mm audio jack via the Belkin 6' Digital Toslink Optical Audio Cable with Line-Out Adapter but I'm not having any luck. can anyone help?From an iPad can you stream music other than iTu [More]
How do I authorize my computer for previous purchasesPress the Alt and S keys and choose Authorize this Computer, or click here, follow the instructions, click on Store in the menu bar, and choose Authorize this Computer. (81190)Read other 2 answers [More]
382: Design Validation generated 1 warning(s). You may save invalid definitions but they should not be used in running process. 352: Process must contain a start activity with no 'in' transitions. What it mean ???Does the activity that you have marke [More]
How can I tell if I have the latest firmware for my airport card? I have a G4 15" Powerbook. When I query about this Mac, it show this as the latest firmware: : 404.2 (3.90.34.0.p16) The latest update is AirPort Extreme Firmware Update 5.7 for Mac OS [More]
good wishes sapgurus, while creating PO via requisition assignment using t.co.me58.   I am getting this error    *Document number range (i.e PR no.)is not within the defined number ranges*. I have followed all the steps in this method of creating PO. [More]