-
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.
Jeff Hunter
-
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 TABLESPACE END BACKUP; then ALTER DATABASE OPEN;
You do not need to recover the database/datafile.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|