使用Active database duplicate建立dataguard(三)
-------- ------------------------------
spfile string /u01/oracle/product/11.2/db_1/
dbs/spfiletgg.ora
SQL>alter database recover managed standby database cancel;
转为ACTIVEDATAGUARD,可以作为只读库
SQL>alter database open;
SQL>alter database recover managed standby database disconnect;
开启实时应用
alterdatabase recover managed standby database using current logfiledisconnect from session;