Hi. Given the scenario that oracle is doing backup and the system was rebooted. Regardless whether i am doing a cold or hot backup, will there be consequences to my oracle database?
Since a cold backup meant that the database is shutdown, therefore, it stands a higher probability of 100% than a hot backup?
no, oracle takes good care of data integrity and consistency during job abortions thats why its the no. 1 db and besiades backing up
does read only to the db
Originally posted by reydp I'm just curious, what will happen to those tablespaces
that still in hot backup mode? ??
I thought of another similar scenario , when doing hot backup, someone goes to start the database . And if so, then we may need to recover the database and hopefully, no data is lost.
Originally posted by yls177 I thought of another similar scenario , when doing hot backup, someone goes to start the database . And if so, then we may need to recover the database and hopefully, no data is lost.
Your opinions?
You're database can't be started, when the instance is already up and running since you're doing a hot backup. So, it can't happen.
if he is then referring to the cold backup.
Then the backup will just become invalid.
And I think, database will still start.
(i.e. if no file locking being made during o.s. backup)
not that sure.
Reply With Quote
and besiades backing up
Bookmarks