To check parameters
SQL> select inst_id, NAME, substr(value, 0,20) from gv$parameter where value like '%DATA%';
INST_ID NAME SUBSTR(VALUE,0,20)
---------- ------------------------- --------------------
1 spfile +DATA_GRUP/AGAP/PARA
1 control_files +DATA_GRUP/AGAP/CONT
1 db_create_file_dest +DATA
1 db_create_online_log_dest +DATA
_1
1 db_create_online_log_dest +DATA
_2
1 db_recovery_file_dest +DATA
6 rows selected.
Setting Parameters of database
alter system set db_create_file_dest='+DATA_GRUP' scope=both sid='*';
alter system set db_create_online_log_dest_1='+DATA_GRUP' scope=both sid='*';
alter system set db_create_online_log_dest_2='+DATA_GRUP' scope=both sid='*';
or
alter system set db_create_online_log_dest_2='+FRA' scope=both sid='*';
alter system set db_recovery_file_dest='+DATA_GRUP' scope=both sid='*';
To check the parameters
select inst_id, NAME, substr(value, 0,20) from gv$parameter where value like '%DATA%';
INST_ID NAME SUBSTR(VALUE,0,20)
---------- ------------------------- --------------------
1 spfile +DATA_GRUP/AGAP/PARA
1 control_files +DATA_GRUP/AGAP/CONT
1 db_create_file_dest +DATA_GRUP
1 db_create_online_log_dest +DATA_GRUP
_1
1 db_create_online_log_dest +DATA_GRUP
_2
1 db_recovery_file_dest +DATA_GRUP