physical standby to snapshot standby database for Oracle 10g

standby snapshot for Oracle 10g
================================


Snapshot standby for 10g



create restore point Apr23 guarantee flashback database;

select name, time, storage_size,GUARANTEE_FLASHBACK_DATABASE from V$restore_point;

alter database activate standby database;

select name, open_mode, controlfile_type from V$database;

alter database open;

select name, open_mode, controlfile_type from V$database;


need to create one table(for confirmation)



5.Revert to standby setup
Now we finished testing and want to revert to the original state.

SQL> shutdown 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 217157632 bytes
Fixed Size 2209600 bytes
Variable Size 159385792 bytes
Database Buffers 50331648 bytes
Redo Buffers 5230592 bytes
Database mounted.

SQL> flashback database to restore point PRE_ACTIV_SNAP;

SQL> alter database convert to physical standby;

SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 217157632 bytes
Fixed Size 2209600 bytes
Variable Size 159385792 bytes
Database Buffers 50331648 bytes
Redo Buffers 5230592 bytes
Database mounted.

SQL> select name, open_mode, controlfile_type from V$database;

NAME OPEN_MODE CONTROL
-------------------------------------------------- -------------------- -------
 MOUNTED STANDBY

Now the standby database is back again in MOUNT mode after revert.

https://varunyadav27.blogspot.com/2019/06/physical-standby-database-to-snapshot.html