kkshankar_05yahomailcom's blog

Oracle 11g CONVERTING PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE

CONVERTING PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE

Step 1: Check if Flashback is enabled. If not, enable in mount state in Physical Standby database

i) SQL> Show parameter db_recovery_file_dest
NAME TYPE VALUE
--------------------------------------------------------------- ----------- ------------------------------
db_recovery_file_dest string u03/oradata/ODSP1/flash_recovery_area/
db_recovery_file_dest_size big integer 2G

Subscribe to RSS - kkshankar_05yahomailcom's blog