Printable View
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:D
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.Quote:
Originally posted by reydp
I'm just curious, what will happen to those tablespaces
that still in hot backup mode?
??
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.Quote:
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?
kuya, he is referring to coldbackup:D
Well, if someone made updates then u have to run the hotbackup, if not
then the coldbackup is just fine
pls read the post again.
he just made a typo error:D
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.
hi kris123, just visiting?Quote:
Originally posted by mganda2005
kuya, he is referring to coldbackup:D
Well, if someone made updates then u have to run the hotbackup, if not
then the coldbackup is just fine
Quote:
Originally posted by marist89
hi kris123, just visiting?
hahahahah....:D :D :D :D
you really are a super-g.:cool:
Or he has the ability to look at someone's ip address.Quote:
Originally posted by reydp
hahahahah....:D :D :D :D
you really are a super-g.:cool:
admins will see the posting IP.
Save us from the clot!
:)
It was the "kuya" remark that gave it away for me... Theres no need to see his/her IP address to work out that it was kris123.