11g physical standby database 讓其固定在特定的scn number

11g physical standby database 讓其固定在特定的scn number

主要是方便拿來做testing/ 或是OGG initial使用, 不會造成primary db loading.

 

alter database recover managed standby database cancel;

 

--where scn is the value of the CURRENT_SCN field of V$DATABASE plus 1.

--所以在primary db查到的current_scn 會是9606671794378

alter database recover automatic standby database until change 9606671794379;