I face wiht this issue when try to add standby file on standalone 11.2.0.1 database with ASM on AIX operating system:
Symptoms:
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 size 5G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 size 5G
*
ERROR at line 1:
ORA-02236: invalid file name
SQL> show parameter DB_CREATE_FILE_DEST
NAME TYPE VALUE
———————————— ———– ——————————
db_create_file_dest string
Solution:
SQL> alter database add standby logfile size 5G;
Database altered.
Bir Cevap Yazın