0
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
What else can I help you with?
What r the differences between 9i 10g oracle in respective of dba?
in 10g sysaux is new tablespace is present in 9i it is now present while in import and export any database in 10g impdp and expdp (data pump ) like facility is present
Where can one purchase a remote Oracle DBA?
One can purchase a remote Oracle DBA from several different locations. Some of the places that one could go to purchase a remote Oracle DBA are: Oracle, eBay, and Amazon.
Who is oracle developer?
who can manage the DBA, he is a oracle developer
Who develop oracle?
who can manage the DBA, he is a oracle developer
Is there a prerequisite to oracle DBA training?
There are no specified prerequisites for the Oracle DBA training, if you do not have prior knowledge individuals will be given additional course work to complete.
What are the Linux commands used by Oracle DBA?
ls
Full form of dba in oracle?
Data base Administrator
What is the difference between oracle dba and Oracle Production DBA?
Development database is where you allow your developers to develop their applications and SQL and to test it out. If you lose your development database, you generally just rebuild it. Your production database is where your end-users will be using this system. Production databases contain core data that must be safeguarded and protected. Some companies, such as AMAZON.COM and EBAY.COM uses a production database that must be available 24 hours / 7 days a week. One cannot afford to lose or have their production databases go down for extended periods of time. Generally, the databases should look similar. The code base is developed in your developer database and, at some point, promoted to your production database. Your production database is your controlled environment
Which graphical DBA administration tool would be used to tune an oracle database?
oracle database configuration assistant.
What is oracle DBA?
An Oracle database administrator (DBA) is a professional responsible for the design, implementation, maintenance, and performance of an Oracle database system. They handle tasks such as user management, security, backup and recovery, and tuning the database for optimal performance. Additionally, they play a crucial role in troubleshooting and resolving any issues that may arise in the database environment.
Why did you choose a career in Oracle DBA?
I had always found DBA job very challenging and interseting. Another reason is lot of opportunities.
What skills are commonly required for a person desiring an Oracle DBA job?
There are a number of skills desired for a person wishing to undertake an Oracle DBA job. These include a sound knowledge of Oracle and Database management. One should also have knowledge of Unix, Linux and SQL.
