My database was terminated while in BACKUP MODE, do I need to recover?
My database was terminated while in BACKUP MODE, do I need to recover?
My database was terminated while in BACKUP MODE, do I need to recover?
-
- Posts: 824
- Joined: Wed Oct 05, 2016 2:40 pm
Re: My database was terminated while in BACKUP MODE, do I need to recover?
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.
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.
Who is online
Users browsing this forum: No registered users and 0 guests