Oracle Dataguard - Configuring Snapshot Standby

Check in the standby database if flashback is open : 
	SQL> show parameter flashback

		NAME				TYPE		VALUE
		---------------------------	--------	--------------
		db_flashback_retention_target	integer		1440

		SQL> select flashback_on from v$database;

		FLASHBACK_ON
		------------------
		NO
Cancel 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 STANDBY
Open the database connection : 
	SQL> alter database open;

	apply the MRP process:
	SQL> alter database recover managed standby database disconnect from session;
	Database altered.


(Oracle Dataguard - Configuring Active dataguardy)