Oracle Dataguard - Configuring Snapshot StandbySQL> show parameter flashback NAME TYPE VALUE --------------------------- -------- -------------- db_flashback_retention_target integer 1440 SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ NOCancel the MRP process : SQL> recover managed standby database cancel; Media recovery complete.Close the database connection : SQL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 532676608 bytes Fixed Size 8622720 bytes Variable Size 297799040 bytes Database Buffers 218103808 bytes Redo Buffers 8151040 bytes Database mounted.Apply the snapshot convert command : SQL> alter database convert to snapshot standby; Database altered.Open the database connection : SQL> alter database open; Database altered.To check the database role : SQL> select status,instance_name,database_role,open_mode from v$database,v$Instance; STATUS INSTANCE_NAME DATABASE_ROLE OPEN_MODE ------------ ---------------- ---------------- -------------------- OPEN tesstand SNAPSHOT STANDBY READ WRITE Create user and connect to it: SQL> create user tes identified by tes; User created. SQL> grant connect,resource,unlimited tablespace to tes; Grant succeeded. SQL> conn tes/tes Connected. Create table SQL> create table t1(id int,name varchar2(20)); Table created. SQL> insert into t1 values(1,'aa'); 1 row created. SQL> insert into t1 values(2,'bb'); 1 row created. SQL> commit; Commit complete CONNECT AS SYSDBA SQL> conn / as sysdba Connected. SQL> SQL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 532676608 bytes Fixed Size 8622720 bytes Variable Size 297799040 bytes Database Buffers 218103808 bytes Redo Buffers 8151040 bytes Database mounted.Convert the database to physical standby : SQL> alter database convert to physical standby; Database altered. SQL> Select name,db_unique_name,dbid,open_mode,database_role from V$database; NAME DB_UNIQUE_NAME DBID OPEN_MODE DATABASE_ROLE ----- ------------- ------- --------- ------------- TESPRIM1 tesstand 3121411717 MOUNTED PHYSICAL STANDBYOpen the database connection : SQL> alter database open; apply the MRP process: SQL> alter database recover managed standby database disconnect from session; Database altered. « Previous Next Topic » (Oracle Dataguard - Configuring Active dataguardy) |