All entries for Thursday 14 April 2005
April 14, 2005
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.