What is Instance Recovery?

What is Instance Recovery?
by

1 Answer

Answer :

While Oracle instance fails, Oracle performs an Instance Recovery when the associated database is being re started.
Instance recovery occurs in two steps:
Cache recovery:
Changes being made to a database are recorded in the database buffer cache.
These changes are also recorded in online redo log files simultaneously. When there are enough data in the  database buffer cache,they are written to data files.
If an Oracle instance fails before the data in the database buffer cache are written to data files, Oracle uses the  data recorded in the online redo log files to recover the lost data when the associated database is re-started. This process is called cache recovery.
Transaction recovery:
When a transaction modifies data in a database, the before image of the modified data is stored in an undo  segment.
The data stored in the undo segment is used to restore the original values in case a transaction is rolled back. At the time of an instance failure, the database may have uncommitted transactions. It is possible that changes  made by these uncommitted transactions have gotten saved in data files.
To maintain read consistency, Oracle rolls back all uncommitted transactions when the associated database is re started.
Oracle uses the undo data stored in undo segments to accomplish this.
This process is called transaction recovery.
by

Related questions

Give the stages of instance startup to a usable state where normal users may access it.

Description : Give the stages of instance startup to a usable state where normal users may access it.

Last Answer : STARTUP NOMOUNT - Instance startup STARTUP MOUNT - The database is mounted STARTUP OPEN - The database is opened

What is Restricted Mode of Instance Startup ?

Description : What is Restricted Mode of Instance Startup ?

Last Answer : An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.

What is a Database instance ? Explain

Description : What is a Database instance ? Explain

Last Answer : A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The memory structure that are ... helps up to improve database performance by decreasing the amount of I/O performed against data file.

What is an Oracle Instance?

Description : What is an Oracle Instance?

Last Answer : The Oracle system processes, also known as Oracle background processes, provide functions for the user processes-functions that would otherwise be done by the user processes themselves Oracle database- ... combination of the SGA and the Oracle background processes is known as an Oracle instance

What is an Instance?

Description : What is an Instance?

Last Answer : a) The term instance is typically used to describe a complete database environment, including the RDBMS software, table structure, stored procedures and other functionality. It is most commonly used ... just collection of background processes and memory structures, used to tap in to the database.

What is an Oracle Instance?

Description : What is an Oracle Instance?

Last Answer : An Oracle database server consists of an Oracle database and an Oracle instance. Every time a database is started, a system global area (SGA) is allocated and Oracle background processes are started. The combination of ... (LOCAL=NO) 10254 oracle 15 0 744m 14m 12m S 0.0 1.0 0:00.10 ora_w000_DB1_SID

What are the steps involved in Instance Recovery?

Description : What are the steps involved in Instance Recovery?

Last Answer : Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling back ... held by transactions in process at the time of the failure. Resolving any pending distributed transact

How does one create a RMAN recovery catalog? (for DBA

Description : How does one create a RMAN recovery catalog? (for DBA

Last Answer : Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner role. Look at this example: sqlplus sys SQL>create user ... . Look at this example: rman catalog rman/rman target backdba/backdba RMAN> register database;

Name two utilities that Oracle provides, which are use for backup and recovery.

Description : Name two utilities that Oracle provides, which are use for backup and recovery.

Last Answer : Along with the RDBMS software, Oracle provides two utilities that you can use to back up and restore the database. These utilities are Export and Import. The Export utility dumps the definitions and data ... best you can do is recover the database to the time when the export was last performed.

Tip question #1: In this instance, would you give the body shop owner a tip?

Description : Tip question #1: In this instance, would you give the body shop owner a tip?

Last Answer : No tip. Unless you tip the actual guy who did the work. And if you do, do it in cash. The guy will appreciate it more.

Do you consider Gospel as legitimate of a musical style as, for instance, jazz and classical?

Description : Do you consider Gospel as legitimate of a musical style as, for instance, jazz and classical?

Last Answer : Yes. Why would it not be?

Are there ever cases of people feeling they were born in the wrong body regarding a quality other than gender - for instance, race?

Description : Are there ever cases of people feeling they were born in the wrong body regarding a quality other than gender - for instance, race?

Last Answer : I'm not sure that it is widely recognized, but is sometimes referred to as racial identity disorder, or ethnic identity disorder. Although it is not the reason behind all cases, a common behavior that you ... other responses before taking my word for it. I'm just going on what little I've heard.

Is there any proof of life having developed in more than one instance on Earth?

Description : Is there any proof of life having developed in more than one instance on Earth?

Last Answer : answer:I’m afraid not. “One isn’t such a lonely number. All life on Earth shares a single common ancestor, a new statistical analysis confirms. A universal common ancestor is at least 102,860 times more probable than having multiple ancestors, Theobald calculates.” Science News

Do you ever laugh so much that you cry & what triggered the most recent instance of this?

Description : Do you ever laugh so much that you cry & what triggered the most recent instance of this?

Last Answer : There was a girl at work with some passion marks on her neck…and we were poking fun at her…

I know that suffixes "ez" and "es" denotes "son of" in the Spanish language; but, why the different endings? For instance, you may see the surname Gonzales or Gonzalez?

Description : I know that suffixes "ez" and "es" denotes "son of" in the Spanish language; but, why the different endings? For instance, you may see the surname Gonzales or Gonzalez?

Last Answer : It has to do with the government taking a census. this practice started in B.C. (or b.c.e. for the heathens) and names were subject to the census takers who knew how to write, but not always ... . Some of these were like Johnson/Johnston, Gib/Gibb/Gibbs, White/Waite/Wit/Witt, and hundreds of others.

How can Darwinism explain the reason of the existance of so many creatures for instance numerous types of birds?

Description : How can Darwinism explain the reason of the existance of so many creatures for instance numerous types of birds?

Last Answer : Darwin provided a theory, not an all encompassing explanation.

Is there value in resisting a new technology (genetically modified foods, for instance), which, while potentially harmful in the short term, could save millions of lives in the future?

Description : Is there value in resisting a new technology (genetically modified foods, for instance), which, while potentially harmful in the short term, could save millions of lives in the future?

Last Answer : There’s really no point of resisting anything. If it happens it will happen.

What’s a “go with your gut” instance you are thankful for because your instincts served you well?

Description : What’s a “go with your gut” instance you are thankful for because your instincts served you well?

Last Answer : Need Answer

you have the ability to control your emotions while driving. for instance, ________. -General Knowledge

Description : you have the ability to control your emotions while driving. for instance, ________. -General Knowledge

Last Answer : You have the ability to control your emotions while driving. For instance, Don't take the aggressive actions of other drivers personally.

Define prolog and data instance. -Technology

Description : Define prolog and data instance. -Technology

Last Answer : The prolog is a preface or introduction to XML document. It can contain upto five optional components. The grammar structure of the XML document is defined under prolog. The data instance consists of real data and its description through elements. It is also known as body of XML document.

PI is a component of (a) prolog (b) data instance -Technology

Description : PI is a component of (a) prolog (b) data instance -Technology

Last Answer : (a) PI is a component of prolog.

The root element is a parent element of all other elements in data instance. -Technology

Description : The root element is a parent element of all other elements in data instance. -Technology

Last Answer : True The root element is an element that contains all other elements in XML document.

At the instance of which rular was the Kallashanath Temple at Ellora excavated? -Do You Know?

Description : At the instance of which rular was the Kallashanath Temple at Ellora excavated? -Do You Know?

Last Answer : answer:

For howmany month can the proclamation of emergency at the first instance be restricted? -Do You Know?

Description : For howmany month can the proclamation of emergency at the first instance be restricted? -Do You Know?

Last Answer : answer:

For howmany month can the proclamation of emergency at the first instance be restricted? -Do You Know?

Description : For howmany month can the proclamation of emergency at the first instance be restricted? -Do You Know?

Last Answer : answer:

What does instance mean ?

Description : What does instance mean ?

Last Answer : Instance means instance.

How can we break any word into its prefix, root, and suffix if we do not know them? For instance, lets break the word 'pride'?

Description : How can we break any word into its prefix, root, and suffix if we do not know them? For instance, lets break the word 'pride'?

Last Answer : Need Answer

What is a first instance warrant?

Description : What is a first instance warrant?

Last Answer : Feel Free to Answer

For howmany month can the proclamation of emergency at the first instance be restricted?

Description : For howmany month can the proclamation of emergency at the first instance be restricted?

Last Answer : 6 months

For howmany month can the proclamation of emergency at the first instance be restricted?

Description : For howmany month can the proclamation of emergency at the first instance be restricted?

Last Answer : 6 months

Which will be the instance of the class datalog knowledge bases? a) Variables b) No function symbols c) First-order definite clauses d) None of the mentioned

Description : Which will be the instance of the class datalog knowledge bases? a) Variables b) No function symbols c) First-order definite clauses d) None of the mentioned

Last Answer : b) No function symbols

Consider an instance of TCP’s Additive Increase Multiplicative Decrease (AIMD) algorithm where the window size at the start of the slow start phase is 2 MSS and the threshold at the start of the first transmission is 8 MSS. Assume that a timeout occurs during the fifth transmission. Find the congestion window size at the end of the tenth transmission. a. 8 MSS b. 14 MSS c. 7 MSS d. 12 MSS

Description : Consider an instance of TCP's Additive Increase Multiplicative Decrease (AIMD) algorithm where the window size at the start of the slow start phase is 2 MSS and the threshold at the start of the first transmission is ... the end of the tenth transmission. a. 8 MSS b. 14 MSS c. 7 MSS d. 12 MSS

Last Answer : c. 7 MSS

Point out the correct statement. a) A client can request access to a cloud service from any location b) A cloud has multiple application instances and directs requests to an instance based on conditions c) Computers can be partitioned into a set of virtual machines with each machine being assigned a workload d) All of the mentioned

Description : Point out the correct statement. a) A client can request access to a cloud service from any location b) A cloud has multiple application instances and directs requests to an instance based on ... a set of virtual machines with each machine being assigned a workload d) All of the mentioned

Last Answer : All of the mentioned

SaaS supports multiple users and provides a shared data model through _________ model. a) single-tenancy b) multi-tenancy c) multiple-instance d) all of the mentioned

Description : SaaS supports multiple users and provides a shared data model through _________ model. a) single-tenancy b) multi-tenancy c) multiple-instance d) all of the mentioned

Last Answer : multi-tenancy

A group of users within a particular instance is called ______________ a) suser b) pod c) superuser d) all of the mentioned

Description : A group of users within a particular instance is called ______________ a) suser b) pod c) superuser d) all of the mentioned

Last Answer : pod

Point out the correct statement. a) A standard machine instance (virtual computer) might cost $0.10 or less an hour b) A typical storage charge might be $0.10 per GB/month c) Outsourcing shifts the burden of capital expenditures onto the service provider d) All of the mentioned

Description : Point out the correct statement. a) A standard machine instance (virtual computer) might cost $0.10 or less an hour b) A typical storage charge might be $0.10 per GB/month c) Outsourcing shifts the burden of capital expenditures onto the service provider d) All of the mentioned

Last Answer : All of the mentioned

Which statement best describes the relationship between application, server, and client in a multitenancy environment? A. Single instance of software running on a server and serves one client. B. Single instance of software running on a server and serves multiple clients. C. Multiple instances of software running on a server and serves multiple clients. D. Multiple instances of software running on multiple servers and serves one client.

Description : Which statement best describes the relationship between application, server, and client in a multitenancy environment? A. Single instance of software running on a server and serves one client. B ... clients. D. Multiple instances of software running on multiple servers and serves one client.

Last Answer : Single instance of software running on a server and serves multiple clients.

SaaS supports multiple users and provides a shared data model through _________ model. A. single-tenancy B. multi-tenancy C. multiple-instance D. None of the above

Description : SaaS supports multiple users and provides a shared data model through _________ model. A. single-tenancy B. multi-tenancy C. multiple-instance D. None of the above

Last Answer : multi-tenancy

_____________ is a technique, which allows to share single physical instance of an application or resource among multiple organizations or tenants (customers). A. Virtualization B. Service-Oriented Architecture C. Grid Computing D. Utility Computing

Description : _____________ is a technique, which allows to share single physical instance of an application or resource among multiple organizations or tenants (customers). A. Virtualization B. Service-Oriented Architecture C. Grid Computing D. Utility Computing

Last Answer : Virtualization

SaaS supports multiple users and provides a shared data model through _________ model. a) single-tenancy b) multi-tenancy c) multiple-instance d) all of the mentioned

Description : SaaS supports multiple users and provides a shared data model through _________ model. a) single-tenancy b) multi-tenancy c) multiple-instance d) all of the mentioned

Last Answer : multi-tenancy

Point out the correct statement. a) A client can request access to a cloud service from any location b) A cloud has multiple application instances and directs requests to an instance based on conditions c) Computers can be partitioned into a set of virtual machines with each machine being assigned a workload d) All of the mentioned

Description : Point out the correct statement. a) A client can request access to a cloud service from any location b) A cloud has multiple application instances and directs requests to an instance based on ... a set of virtual machines with each machine being assigned a workload d) All of the mentioned

Last Answer : All of the mentioned

Point out the correct statement. a) A client can request access to a cloud service from any location b) A cloud has multiple application instances and directs requests to an instance based on conditions c) Computers can be partitioned into a set of virtual machines with each machine being assigned a workload d) All of the mentioned

Description : Point out the correct statement. a) A client can request access to a cloud service from any location b) A cloud has multiple application instances and directs requests to an instance based on ... a set of virtual machines with each machine being assigned a workload d) All of the mentioned

Last Answer : All of the mentioned

How would you use java & App Engine to write to the file system? a. Disconnect from the internet and Google App Engine automatically writes to the disk. b. Edit the configuration file accordingly c. You cannot write t the file system with the exception of resources files. d. Invoke an instance of Google App Engine within the sandbox and it will then write to the disk.

Description : How would you use java & App Engine to write to the file system? a. Disconnect from the internet and Google App Engine automatically writes to the disk. b. Edit the configuration file accordingly c. ... Invoke an instance of Google App Engine within the sandbox and it will then write to the disk.

Last Answer : You cannot write t the file system with the exception of resources files.

How would you use java & App Engine to write to the file system? a. Disconnect from the internet and Google App Engine automatically writes to the disk. b. Edit the configuration file accordingly c. You cannot write t the file system with the exception of resources files. d. Invoke an instance of Google App Engine within the sandbox and it will then write to the disk.

Description : How would you use java & App Engine to write to the file system? a. Disconnect from the internet and Google App Engine automatically writes to the disk. b. Edit the configuration file accordingly c. ... Invoke an instance of Google App Engine within the sandbox and it will then write to the disk.

Last Answer : You cannot write t the file system with the exception of resources files.

Point out the correct statement. a) A client can request access to a cloud service from any location b) A cloud has multiple application instances and directs requests to an instance based on conditions c) Computers can be partitioned into a set of virtual machines with each machine being assigned a workload d) All of the mentioned

Description : Point out the correct statement. a) A client can request access to a cloud service from any location b) A cloud has multiple application instances and directs requests to an instance based on ... a set of virtual machines with each machine being assigned a workload d) All of the mentioned

Last Answer : All of the mentioned

Can you create an instance of an interface?

Description : Can you create an instance of an interface?

Last Answer : No, you cannot create an instance of an interface.

Define what is the difference between static and instance methods?

Description : Define what is the difference between static and instance methods?

Last Answer : A method declared with a static modifier is a static method. A static method does not operate on a specific instance and can only access static members. A method declared without a static modifier is an ... can be explicitly accessed as this. It is an error to refer to this in a static method.

Describe an instance when you had to think on your feet to extricate yourself from a dicult situation.

Description : Describe an instance when you had to think on your feet to extricate yourself from a dicult situation.

Last Answer : Only give examples of where the end result was good, not an example of where it didn't work out or you had to lie yourself out of situation. This question will see how you act under pressure. Paint yourself in a good light when it comes to handling pressure.

Can static method access instance variables ?

Description : Can static method access instance variables ?

Last Answer : Ans. Though Static methods cannot access the instance variables directly, They can access them using instance handler.

At the instance of which rular was the Kallashanath Temple at Ellora excavated?

Description : At the instance of which rular was the Kallashanath Temple at Ellora excavated?

Last Answer : Krishna I