0
Who is responsible for the recovery of a database after a crash or major error has occurred?
Wiki User
∙ 8y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is Instance Recovery in oracle dba 10g?
instance recovery means getting the database to a normal functioning state. the recovery is needed when the database server crashes. the crash may be due to sudden power off.or somebody given the shutdown abort command in this cases what ever the changes that should happen with the database are not happened in a regular manner. so again when the database starts a process called instance recovery happens such as rolling forward the committed transactions and rolling backward the uncommitted transactons the set of transactions are already recorded in the files are called online redo log files this is called instance recovery in oracle 10g hope this helped
Can YouTube crash your computer?
Yotube uses Flash plug-in. If the plug-in is broken or buggy then, yes. It might cause a crash of the browser. This crashed browser might have repercussions on your system stability and eventually crash your computer. Is youtube responsible for the crash? No. Is flash responsible for the crash? It contributed to it Is the browser responsible for the crash? Well, it didn't handle the crash of the plug-in, so yeah, it is partly to blame as well Is the OS responsible for the crash? Well it didn't handle a crashed browser well, so it is also partly responsible.
What event triggered the great?
The Stock Market crash that occurred on October 29, 1929 is primarily responsible. It soon led to the worldwide economic downturn known as the Great Depression.
What day of the week was the Wall Street Crash on?
The Wall Street Crash occurred on a Tuesday. It is most commonly referred to as Black Tuesday. It occurred on October 29th, 1929.
Who was the president during the crash of the great depression?
Herbert Hoover was the president when the stock market crash of October 24,1929 occurred.
What are the Advantage of running 2 separate database?
it reduces downtime incase of any crash
The stock market crash which began the great depression occurred when?
It was in October of 1929.
What is Aries recovery algorithm.?
three main principles lie behind ARIES: - Write ahead logging: Any change to an object is first recorded in the log, and the log must be written to stable storage before changes to the object are written to disk. - Repeating history during Redo: On restart after a crash, ARIES retraces the actions of a database before the crash and brings the system back to the exact state that it was in before the crash. Then it undo the transactions still active at crash time. - Logging changes during Undo: Changes made to the database while undoing transactions are logged to ensure such an action isn't repeated in the event of repeated restarts. The ARIES recovery procedure consists of three main steps : - Analysis : It identifies the dirty (updated) pages in the buffer and the set of transactions active at the time of crash. The appropriate point in the log where REDO operation should start is also determined. - REDO phase : It actually reapplies updates from the log to the database. Generally the REDO operation is applied to only committed transactions. However, in ARIES, this is not the case. Certain information in the ARIES log will provide the start point for REDO, from which REDO operations are applied until the end of the log is reached. Thus only the necessary REDO operations are applied during recovery. - UNDO phase : The log is scanned backwards and the operations of transactions that were active at the time of the crash are undone in reverse order. The information needed for ARIES to accomplish its recovery procedure includes the log, the transaction table, and the dirty page table. In addition, checkpointing is used.
Where can I get more information about hard drive recovery?
To get more information on hard drive recovery for a hard drive crash, you might want to look into www.salvagedata.com as they specialize in hard drive recovery for iso systems.
Define a stateful server?
A stateful server loses all its volatile state in a crash. * Restore state using a recovery protocol based on a dialog with clients, or abort operations that were underway when the crash occurred. * Server needs to be aware of client failures in order to reclaim space allocated to record the state of crashed client processes (orphan detection and elimination).
What enables the smooth recovery of the file system following a system crash or disk failure?
NTFS
What are the problems are encountered by the database?
system crash Large Data set Cannot be storedMathew John 9495350350
