Convert Physical Standby into Snapshot Standby

 Convirtiendo una BD Standby en una Snapshot para pruebas.

Paso 0 

Asgurate que tengas suficiente espacio en el area de RECO para guardar los ARC que la producctiva generar durante la ventana

select * FROM V$FLASH_RECOVERY_AREA_USAGE;

select space_limit/1024/1024/1024 maxGB,space_used/1024/1024/1024 usedGB from v$recovery_file_dest;

On Primary:

Genera un par de ARC y valida que sean aplicados correctamente en tu Standby

alter system archive log current;

On standby:
===========
alter database recover managed standby database cancel;
select name, open_mode from v$database; ----make sure its mounted
select log_mode,flashback_on from v$database;
CREATE RESTORE POINT RESTORE_PRE_SNAPSHOT GUARANTEE FLASHBACK DATABASE;
alter database convert to snapshot standby;
alter database open;  
select name, open_mode, database_role from v$database;


On standby:
===========
Do TESTS

On standby:
===========
select name, open_mode, database_role from v$database;
shut immediate;
startup mount;
alter database convert to physical standby;
shutdown immediate
startup mount;
select name, open_mode from v$database; 
DROP RESTORE POINT RESTORE_PRE_SNAPSHOT;  --borra los puntos de fashback
alter database recover managed standby database disconnect; or alter database recover managed standby database using current logfile disconnect from session;