When there is a failure in adding a datafile on standby database due to space constraints we see these errors.
On standby server sufficeint disk space is not available to create new datafile.
If you are using standby_file_management = auto, when oracle adds a datafile
to the primary, it does correctly add it to the standby database.
Below steps help to fix the issue:
1. Make sure you have sufficient disk space now.
2. Use following options :
I : Delete the files at the OS level and oracle will re-try to create the same datafile on recovery.
II : If step one doesn’t work then
Set STANDBY_FILE_MANAGEMENT = MANUAL and:
Recreate the missing datafile. To do this, select the relevant filename from v$datafile
SQL> select name from v$datafile where file#=<ID>;
SQL> alter database create datafile ‘MISSING01.dbf’ as ‘<original file name>’ <size> ;
- Now you can re-set Set STANDBY_FILE_MANAGEMENT to AUTO.
- Restart recovery