Home » Server Options » Data Guard » Log shipping not happening
Log shipping not happening [message #641093] Mon, 10 August 2015 09:14 Go to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

We are having Primary (two node 11gr2) and standby (two node 11gr2) READ ONLY state databases.

Observed that log shipping is not happening properly. Everytime I want to move the archivelogs manually from primary and apply to the standby.

I dont see any issues with the parameter settings.

What could be the problem on this ? Any suggestions.

Thanks
Prashanth
Re: Log shipping not happening [message #641096 is a reply to message #641093] Mon, 10 August 2015 09:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It could be anything. Could be bad juju.
Please post something for us to start. Else it will be one huge (pointless ) list to troubleshoot.
How about the alert log (both sites) ? Parameters (Though you find 'em alright).
Re: Log shipping not happening [message #641101 is a reply to message #641096] Mon, 10 August 2015 10:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

... and query gv$dataguard_status on both sides.

Re: Log shipping not happening [message #641153 is a reply to message #641101] Tue, 11 August 2015 05:09 Go to previous message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

Below is the only message thrown in standby alert log. Primary database not throwing any error messages.

#### Submitted all GCS remote-cache requests

Fix write in gcs resources

Reconfiguration complete

Parallel Media Recovery started with 32 slaves

Waiting for all non-current ORLs to be archived...

All non-current ORLs have been archived.

Mon Aug 10 08:30:56 2015

Media Recovery Waiting for thread 1 sequence 1063

##########

If I move the archive sequence 1063 from primary to standby and registered it, it starts applying and it will wait for next sequence.

gv$dataguard_status (Primary database server)

INST_ID FACILITY SEVERITY DEST_ID MESSAGE_NUM ERROR_CODE CAL TIMESTAMP MESSAGE
---------- ------------------------ ------------- ---------- ----------- ---------- --- --------- ------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------
2 Log Transport Services Control 0 1458 0 YES 10-AUG-15 ARC7: Completed archiving thread 2 sequence 1154 (1031025973-1031970821)
2 Log Transport Services Control 0 1459 0 YES 10-AUG-15 ARC0: Beginning to archive thread 2 sequence 1155 (1031970821-1032045088)
2 Log Transport Services Control 0 1460 0 YES 10-AUG-15 ARC0: Completed archiving thread 2 sequence 1155 (1031970821-1032045088)
2 Log Transport Services Control 0 1461 0 YES 10-AUG-15 ARC2: Beginning to archive thread 2 sequence 1156 (1032045088-1032047355)
2 Log Transport Services Control 0 1462 0 YES 10-AUG-15 ARC2: Completed archiving thread 2 sequence 1156 (1032045088-1032047355)
2 Log Transport Services Control 0 1463 0 YES 10-AUG-15 ARC3: Beginning to archive thread 2 sequence 1157 (1032047355-1033156898)
2 Log Transport Services Control 0 1464 0 YES 10-AUG-15 ARC3: Completed archiving thread 2 sequence 1157 (1032047355-1033156898)
2 Log Transport Services Control 0 1465 0 YES 11-AUG-15 ARC4: Beginning to archive thread 2 sequence 1158 (1033156898-1034312676)
2 Log Transport Services Control 0 1466 0 YES 11-AUG-15 ARC4: Completed archiving thread 2 sequence 1158 (1033156898-1034312676)
2 Log Transport Services Control 0 1467 0 YES 11-AUG-15 ARC5: Beginning to archive thread 2 sequence 1159 (1034312676-1035414212)
2 Log Transport Services Control 0 1468 0 YES 11-AUG-15 ARC5: Completed archiving thread 2 sequence 1159 (1034312676-1035414212)
2 Log Transport Services Control 0 1469 0 YES 11-AUG-15 ARC6: Beginning to archive thread 2 sequence 1160 (1035414212-1036525068)
2 Log Transport Services Control 0 1470 0 YES 11-AUG-15 ARC6: Completed archiving thread 2 sequence 1160 (1035414212-1036525068)
2 Log Transport Services Control 0 1471 0 YES 11-AUG-15 ARC7: Beginning to archive thread 2 sequence 1161 (1036525068-1037493871)
2 Log Transport Services Control 0 1472 0 YES 11-AUG-15 ARC7: Completed archiving thread 2 sequence 1161 (1036525068-1037493871)

512 rows selected.

gv$dataguard_status (standby server):


INST_ID FACILITY SEVERITY DEST_ID MESSAGE_NUM ERROR_CODE CAL TIMESTAMP MESSAGE
---------- ------------------------ ------------- ---------- ----------- ---------- --- --------- ------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------
1 Log Apply Services Warning 0 1579 16037 NO 10-AUG-15 MRP0: Background Media Recovery cancelled with status 16037
1 Log Apply Services Control 0 1580 0 YES 10-AUG-15 MRP0: Background Media Recovery process shutdown
1 Log Apply Services Control 0 1581 0 YES 10-AUG-15 Managed Standby Recovery Canceled
1 Log Apply Services Control 0 1582 0 YES 10-AUG-15 Attempt to start background Managed Standby Recovery process
1 Log Apply Services Control 0 1583 0 YES 10-AUG-15 MRP0: Background Managed Standby Recovery process started
1 Log Apply Services Informational 0 1584 0 NO 10-AUG-15 Managed Standby Recovery not using Real Time Apply
1 Log Apply Services Warning 0 1585 0 NO 10-AUG-15 Media Recovery Waiting for thread 1 sequence 1062
1 Log Apply Services Informational 0 1586 0 NO 10-AUG-15 Media Recovery Log /home/grid/stage/temp_restore/thread_1_seq_1062.953.887032591
1 Log Apply Services Informational 0 1587 0 NO 10-AUG-15 Media Recovery Log /home/grid/stage/temp_restore/thread_2_seq_1048.955.887032595
1 Log Apply Services Warning 0 1588 0 NO 10-AUG-15 Media Recovery Waiting for thread 1 sequence 1063
1 Log Apply Services Warning 0 1589 16037 NO 10-AUG-15 MRP0: Background Media Recovery cancelled with status 16037

INST_ID FACILITY SEVERITY DEST_ID MESSAGE_NUM ERROR_CODE CAL TIMESTAMP MESSAGE
---------- ------------------------ ------------- ---------- ----------- ---------- --- --------- ------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------
1 Log Apply Services Control 0 1590 0 YES 10-AUG-15 MRP0: Background Media Recovery process shutdown
1 Log Apply Services Control 0 1591 0 YES 10-AUG-15 Managed Standby Recovery Canceled
1 Log Apply Services Control 0 1592 0 YES 10-AUG-15 Attempt to start background Managed Standby Recovery process
1 Log Apply Services Control 0 1593 0 YES 10-AUG-15 MRP0: Background Managed Standby Recovery process started
1 Log Apply Services Informational 0 1594 0 NO 10-AUG-15 Managed Standby Recovery not using Real Time Apply
1 Log Apply Services Warning 0 1595 0 NO 10-AUG-15 Media Recovery Waiting for thread 1 sequence 1063

369 rows selected.

Thanks


Previous Topic: Standby Database (merged)
Next Topic: Configuring Switchover
Goto Forum:
  


Current Time: Thu Mar 28 03:48:05 CDT 2024