oracle dg snapshot,DG测试—Snapshot standby

SYS@SBDB1> show parameter recover;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest                string      /home/oracle/flash

db_recovery_file_dest_size           big integer 4G

db_unrecoverable_scn_tracking        boolean     TRUE

recovery_parallelism                 integer     0

SYS@SBDB1> select FLASHBACK_ON from v$database;

FLASHBACK_ON

------------------

NO

SYS@SBDB1> alter database flashback on;

alter database flashback on

*

ERROR at line 1:

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

ORA-38788: More standby database recovery is needed

SYS@SBDB1> recover managed standby database cancel;

Database altered.

SYS@SBDB1> alter database flashback on;

Database altered.

SYS@SBDB1> alter database convert to snapshot standby;

Database altered.

SYS@SBDB1> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SYS@SBDB1> startup

ORACLE instance started.

Total System Global Area  523108352 bytes

Fixed Size                  1346052 bytes

Variable Size             318768636 bytes

Database Buffers          197132288 bytes

Redo Buffers                5861376 bytes

Database mounted.

Database opened.

SYS@SBDB1> select open_mode from v$database;

OPEN_MODE

--------------------

READ WRITE

SYS@SBDB1> create table TEST(D_ID NUMBER);

insert into TEST VALUES(1);

commit;

insert into TEST VALUES(2);

commit;

Table created.

SYS@SBDB1>

1 row created.

SYS@SBDB1>

Commit complete.

SYS@SBDB1>

1 row created.

SYS@SBDB1>

Commit complete.

SYS@SBDB1> select * from test;

D_ID

----------

1

2

备库：snapshot转回physical standby

SYS@SBDB1> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS@SBDB1> startup mount;

ORACLE instance started.

Total System Global Area  523108352 bytes

Fixed Size                  1346052 bytes

Variable Size             314574332 bytes

Database Buffers          201326592 bytes

Redo Buffers                5861376 bytes

Database mounted.

SYS@SBDB1> alter database convert to physical standby;

Database altered.

SYS@SBDB1> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SYS@SBDB1> startup

ORACLE instance started.

Total System Global Area  523108352 bytes

Fixed Size                  1346052 bytes

Variable Size             314574332 bytes

Database Buffers          201326592 bytes

Redo Buffers                5861376 bytes

Database mounted.

Database opened.

SYS@SBDB1> recover managed standby database using current logfile disconnect from session;

Media recovery complete.

SYS@SBDB1> select database_role from v$database;

DATABASE_ROLE

----------------

PHYSICAL STANDBY

SYS@SBDB1> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY WITH APPLY