My database was terminated while in BACKUP MODE, do I need to recover?

santosh
Posts: 1311
Joined: Wed Sep 07, 2016 4:43 pm

My database was terminated while in BACKUP MODE, do I need to recover?

Postby santosh » Sat Nov 12, 2016 3:02 pm

My database was terminated while in BACKUP MODE, do I need to recover?

raoneel2016
Posts: 824
Joined: Wed Oct 05, 2016 2:40 pm

Re: My database was terminated while in BACKUP MODE, do I need to recover?

Postby raoneel2016 » Sat Nov 12, 2016 3:02 pm

If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE ... BEGIN BACKUP;), it will tell you that media recovery is needed when you attempt to start it up. The DBA is then required to recover the database and apply all archived logs to the database.
However, from Oracle7.2, you can simply take the individual datafiles out of backup mode. Eg: ALTER DATABASE DATAFILE '...' END BACKUP; and restart the database. You can do a select from V$BACKUP to see which datafiles were in backup mode. This will save a significant amount of database downtime.


Return to “Oracle”

Who is online

Users browsing this forum: Google [Bot] and 0 guests