-
system reboot during backup
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?
Please advise
-
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
-
I'm just curious, what will happen to those tablespaces
that still in hot backup mode?
??
---------------
-
well i guess, its still tagged as in 'backup mode' state and u have to manually 'end backup' it
-
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.
Your opinions?
-
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.
---------------
-
kuya, he is referring to coldbackup
Well, if someone made updates then u have to run the hotbackup, if not
then the coldbackup is just fine
Last edited by mganda2005; 05-26-2005 at 04:06 AM.
-
-
he just made a typo error
-
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.
---------------
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
|