Hello
i used hot backup in this database for few years
and since last week this error is occered.
Errors in file /path/{db_name}_ora_31596.trc:
ORA-01580: error creating control backup file /path/control.bak
ORA-27044: unable to write the header block of file
Linux-x86_64 Error: 28: No space left on device
Additional information : 3
Ora-1580 signalled during: alter database backup controlfile to ‘/path/control.bak’ reuse
i checked that trace file and i found this message
….
Linux-x64 Error 2: No suchfile or directory
So i checked hotbackup.sh file.
alter database backup controlfile to '/path/`date +%y%m%d`/control.bak' reuse;
- this part can be problem?
- I have another db in same ip and it's still working well what is reason?
- that code was working for many years, why suddenly this is happened?
- If i change code like this, can i fix it?
backup_date=$(date +%y%m%d)
alter database backup controlfile to '/path/$backup_date/control.bak' reuse;