- 이상해서 찾아봤는데 Dataguard Real-time Redo Apply 명령어가 바뀜..한참 되었네..

  근데 옛날꺼랑 반대라 헷갈림..사용할수는 있으나 using current logfile 은 deprecated 됨...


 

Oracle 11.2 까지

Oracle 12.1 부터

Non Real-time Redo Apply (Dataguard)

alter database mount;

alter database recover managed standby database disconnect;

alter database mount;

alter database recover managed standby database using archived logfile disconnect;

Real-time Redo Apply (Active Dataguard)

alter database open;

alter database recover managed standby database using current logfile disconnect;

alter database open;

alter database recover managed standby database disconnect;


Posted by pat98

01-10 20:25
Flag Counter
Yesterday
Today
Total

글 보관함

최근에 올라온 글

달력

 « |  » 2025.1
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31

최근에 달린 댓글