Changing DB Recovery File destination

Please note that database must be in archivelog mode before proceeding


SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +RECO
Oldest online log sequence     36640
Next log sequence to archive   36644
Current log sequence           36645


SQL> alter system set db_recovery_file_dest_size=40959G scope=both sid='*';

System altered.

SQL> show parameter reco
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 40959G
db_unrecoverable_scn_tracking        boolean     TRUE
recovery_parallelism                 integer     0

SQL> alter system set db_recovery_file_dest='+RECO'  scope=both sid='*';

System altered.


SQL> show parameter reco
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
db_recovery_file_dest                string      +RECO
db_recovery_file_dest_size           big integer 40959G
db_unrecoverable_scn_tracking        boolean     TRUE
recovery_parallelism                 integer     0

SQL> alter system set  log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST';

System altered.



No Database bounce is required.