If database crashed during hotback up, do you loss any data? Can you bring your db to the point of failure? Is incomplete recovery a must?
Thanks
Printable View
If database crashed during hotback up, do you loss any data? Can you bring your db to the point of failure? Is incomplete recovery a must?
Thanks
hi gingbo
1. data is not gonna lose
2. mount the database
3. issue "alter database datafile end backup"
4. then take the datafile offline and restore and/or recover it
5. Then bring the datafile online.
Depends on what died. If you have lost a datafile, then you can follow the above procedure. If you have lost a control file, then it is probably an incomplete recovery.
When a tablespace is in hot backup mode, and the database crashes, start up the database in mount mode. Query from V$BACKUP to find out which data files (also tabelspace) are in backup mode, then issue ALTER TABLESPACEEND BACKUP; then ALTER DATABASE OPEN;
You do not need to recover the database/datafile.