All entries for Thursday 14 April 2005

April 14, 2005

Various tests on standby database

Follow-up to Standby Db from Oracle/Java/Others

1. After database restart,"alter database start logical standby apply" is needed to start the ora_p00_

builder process P001 started with pid=13 OS id=1378
preparer process P002 started with pid=14 OS id=1380
Fetch Slave process P003 started with pid=10 OS id=1384
Apply Slave process P004 started with pid=15 OS id=1386
Apply Slave process P005 started with pid=16 OS id=1388

So even if stop logical standyb apply, the process is still there. p003 will talk to primary arch or lgwr and fetch the archive log.

2. Even if the previous log is not archived to standby db, after the fech process is started, it will fetch the current one and previous missed ones.

Invoking non-expedited destination LOG_ARCHIVE_DEST_2 thread 1 sequence 133 host ecaz ….

3. the processes(RFS and Arch/Lgwr) will initailly use listener to establishe connection Aafter that , no listerner is needed.

Search this blog

Search Warwick Blogs



Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder