SQL> alter database recover managed standby database disconnect from session SQL> alter database convert to physical standby SQL> flashback database to restore point restore_point_readonly SQL> flashback database to timestamp sysdate- 5/1440 You can select sysdate- 5/1440 from dual determine the time needed for flashback Total System Global Area 4.2758E + 10 bytes SQL> create table scott.t as select * from dba_objects Īfter the test is completed, return to a certain point in time. NAME OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME SQL> select name, open_mode, database_role, db_unique_name from v $ database SQL> alter database activate standby database SQL> alter system set log_archive_dest_state_2 = defer Master library log switch, temporary log synchronization SQL> create restore point restore_point_readonly guarantee flashback database ORA-16136: Managed Standby Recovery not active SQL> alter database recover managed standby database cancel Īlter database recover managed standby database cancel SQL> show parameter db_recovery_file_destĭb_recovery_file_dest string / u01 / app / oracle / fast_recovery_areaĭb_recovery_file_dest_size big integer 167280MĬancel log application, just canceled in advance SQL> SELECT FLASHBACK_ON FROM V $ DATABASE įlashback recovery area setting, where the size is estimated based on the size of the short-term generated log Testdb PHYSICAL STANDBY MOUNTED NOT ALLOWED NAME DATABASE_ROLE OPEN_MODE SWITCHOVER_STATUS SQL> SELECT NAME, DATABASE_ROLE, OPEN_MODE, SWITCHOVER_STATUS FROM V $ DATABASE Most of the following are performed in STANDBY, and the main library (twice) will prompt

Fonepaw android data recovery rooted but no popup