12、Open Read Only standby数据库并且开启实时日志应用
SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 1188511744 bytes Fixed Size 1364228 bytes Variable Size 754978556 bytes Database Buffers 419430400 bytes Redo Buffers 12738560 bytes Database mounted. Database opened. SQL> select database_role,protection_mode,protection_level,open_mode from v$database; DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL OPEN_MODE ---------------- -------------------- -------------------- -------------------- PHYSICAL STANDBY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE READ ONLY SQL>select process,client_process,sequence#,status from v$managed_standby; PROCESS CLIENT_P SEQUENCE# STATUS --------- -------- ---------- ------------ ARCH ARCH 0 CONNECTED ARCH ARCH 0 CONNECTED ARCH ARCH 0 CONNECTED ARCH ARCH 26 CLOSING RFS ARCH 0 IDLE RFS UNKNOWN 0 IDLE RFS LGWR 27 IDLE 7 rows selected. SQL> recover managed standby database using current logfile disconnect from session; Media recovery complete. SQL> select process,client_process,sequence#,status from v$managed_standby; PROCESS CLIENT_P SEQUENCE# STATUS --------- -------- ---------- ------------ ARCH ARCH 0 CONNECTED ARCH ARCH 0 CONNECTED ARCH ARCH 0 CONNECTED ARCH ARCH 26 CLOSING RFS ARCH 0 IDLE RFS UNKNOWN 0 IDLE RFS LGWR 27 IDLE MRP0 N/A 27 APPLYING_LOG 8 rows selected.
13、解锁scott用户，添加数据，验证数据是否能同步：
#在primary端创建解锁scott用户并创建测试表，插入10000行数据 #primary 端操作如下内容 SQL> set line 200 SQL> select username,default_tablespace,account_status from dba_users where username='SCOTT'; USERNAME DEFAULT_TABLESPACE ACCOUNT_STATUS ------------------------------ ------------------------------ -------------------------------- SCOTT USERS EXPIRED & LOCKED SQL> alter user scott account unlock; User altered. SQL> conn scott/tiger; ERROR: ORA-28001: the password has expired Changing password for scott New password: Retype new password: Password changed Connected. SQL> show user USER is "SCOTT" SQL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- BONUS TABLE DEPT TABLE EMP TABLE SALGRADE TABLE SQL> SQL> create table test001 (id number(10),name varchar2(20)); Table created. SQL> begin 2 for i in 1..10000 loop