What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail.

joshanil

 Profile Answers by joshanil Questions by joshanil

• Sep 12th, 2008

1. Hot, inconsistance and online backup are same2. Cold, close consistance and offline backup are sameFor 1. db must be archive mode, inconsistance mean the SCN are not sameFor 2. db may be archive mo...

suchoudh

 Profile Answers by suchoudh Questions by suchoudh

• May 1st, 2008

Logical backups are export dumps

Answer Question  Select Best Answer

What is recovery catalog? Why do you need this?

mkguduru

 Profile Answers by mkguduru Questions by mkguduru

• Aug 12th, 2008

When we specify Catalog - RMAN uses recovery catalog database to store RMAN metadata.

jkrish.sharma

 Profile Answers by jkrish.sharma Questions by jkrish.sharma

• Jul 27th, 2008

Recovery catalog contains metadata of control file of target database, whenever we take backup by RMAN it contains information and location of backup.

Answer Question  Select Best Answer

 Exclusive  Mode  If  the  first  instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel  Mode   If the first instance that mounts a database is started in parallel  mode,  other instances that are started in parallel mode can also mount the database.

szubair

 Profile Answers by szubair Questions by szubair

• Jan 7th, 2008

Shared mode and exclusive mode

Answer Question  Select Best Answer

Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?

sp_sarang

 Profile Answers by sp_sarang Questions by sp_sarang

• Dec 21st, 2007

It lets you to view and repair historical data.They  query the database by TIME or user specified SCN.    It do not UNDO anything .It is only a query mechanism.You can take o/p fro...

Answer Question  Select Best Answer

The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.

nitanjandial

 Profile Answers by nitanjandial Questions by nitanjandial

• Dec 8th, 2007

log switch occurs when current redo logfile gets full and lgwr writes redo to next redo logfile.Even we can perform log switch with the command alsobefore we execute the sql execute following statemen...

Mohammed Abdul Afroze

• Sep 28th, 2007

The point at which oracle ends writing from one redo log and begins writing to another is called as a log switch.

Answer Question  Select Best Answer

hemant

• Oct 23rd, 2007

The basic diff between the media and crash recovery is that , media recovery is performed by the user or dba with the helps of backups while the crash recovery is performed by the oracle itself by using his sman background process.

shabirwani

 Profile Answers by shabirwani Questions by shabirwani

• Sep 17th, 2006

oracle never accepts the inconsistency of the database. so when oracle goes down due to power outage or aborted manually, next time once the database base is opened it goes mainly to the three states ...

Answer Question  Select Best Answer

Archived  Redo  Log  consists  of Redo Log files that have         archived before being reused.

Mohammed Abdul Afroze

• Mar 25th, 2007

Answer:  The archived redo log  consists of archived redo logfile copies that have archived before being reused.

rush

• Nov 13th, 2006

Hi,              Filled groups of online redo log files stores to one or more offline destinations. These destinations  called arc...

Answer Question  Select Best Answer

venkat

• Feb 10th, 2006

Disk migration is noting but, migration of data from one OS dependent database to another Dependent database. The steps involved in this are- first go to your target database and export all your data ...

Answer Question  Select Best Answer

A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members.

nagabhushan reddy

 Profile Answers by nagabhushan reddy Questions by nagabhushan reddy

• Jan 30th, 2006

mirrored redologfile is the same copy of redologfile,when lgwr writes in the redologfile the same will be in the mirrored redofile.it is useful when original redo is corrupt database  can recover from mirrored redologfile.

devesh

• Jan 20th, 2006

When your database is in archive log mode and you have to set the parameter of pfile that archive files are going on the two seperate disk. It is called on- line Redo Log mirrored.

Answer Question  Select Best Answer

A   Partial  Backup  is any operating system backup short of a full backup, taken while the database is open or shut down.

Lalit Vasuja

• Jan 3rd, 2006

A partial backup is an operating system backup of part of a database. The backup of an individual tablespace's datafiles or the backup of a control file are examples of partial backups. Partial backups are useful only when the database is in ARCHIVELOG mode.

Answer Question  Select Best Answer