DB Parameters Validate

 

1.1.1.1         Verify StandBy and FlasBack Parameters

On Primary Database Node as oracle,

$ sqlplus / as sysdba

select NAME ||'='||VALUE from v$parameter

 where NAME in ('db_unique_name',

                'log_archive_config',

                'log_archive_dest_2',

                'log_archive_min_succeed_dest',

                'log_archive_dest_state_1',

                'log_archive_dest_state_2',

                'remote_login_passwordfile',

                'fal_server',

                'standby_file_management');

 

SQL>alter database flashback on;

SQL> select NAME,FLASHBACK_ON from v$database;

SQL> archive log list

select NAME ||'='||VALUE from v$parameter

 where NAME in ('undo_retention',

                'undo_management',

                'db_flashback_retention_target',

                'db_recovery_file_dest',

                'db_recovery_file_dest_size');