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

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

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

Vinovidhupriya

 Profile Answers by Vinovidhupriya Questions by Vinovidhupriya

• Dec 12th, 2008

One difference between NT Backup and full-blown, third-party backup utilities is the lack of an internal backup job scheduler. While most backup utilities can be set to run automatically at a certain ...

Answer Question  Select Best Answer

How we you identify if a table was exported in its life time?

rajesh_rd

 Profile Answers by rajesh_rd Questions by rajesh_rd

• Mar 23rd, 2009

Refer cumulative or an incremental backup (export )we have a parameter (RECORD) & the default parameter is yes & is to track the incremental backup of a table so those backup (export...

Answer Question  Select Best Answer

Omi

• Mar 12th, 2014

To protect from fractured block corruption during begin backup mode oracle copies the whole block into redo record , So the size if redo increases . In this context more redo is generated .

Answer Question  Select Best Answer

What parameters do you specify/define while scheduling back-up using RMAN?

SIMON AYOMPE

• Aug 13th, 2014

RMAN attaches a character string called a tag to every backup it creates, as a way of identifying the backup. You can either accept the default tag or specify your own with the TAG parameter of the BA...

Answer Question  Select Best Answer

Gajendra mourya

• Jun 27th, 2015

Hello friends, Data guard is very important concept for disaster recovery, in data guard we have one primary database or one or more up to nine standby database for our database safety, now first w...

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

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