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

 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

What are the steps to creating a password authentication file?

ashokbabugaddipati

 Profile Answers by ashokbabugaddipati Questions by ashokbabugaddipati

• Jun 2nd, 2011

1.set the remote_login_passwordfile='EXCLUSIVE'2.orapwd ?file=pwdsid.ora password=xxxxxx? force=ywe have to check the password file is?created or not using the following querySQL> select * from v$pwfile_users;

g.mrunalini

 Profile Answers by g.mrunalini Questions by g.mrunalini

• Jul 22nd, 2008

There are two types of authenticationsOS levelDB levelFor OS level authentication:1. Shutdown the database2. Set OS_AUTHENT_PREFIX=' '    in init.ora file3.$ connect  '...

Answer Question  Select Best Answer

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Steps for Physical standby for Oracle 9i in LINUX.On Primary Side 1. Take rman fullbackup with controlfile and spfile.2. Take standby controlfile backup as SQL> ALTER DATABASE CREATE STANDBY CONTRO...

naveen5555

 Profile Answers by naveen5555 Questions by naveen5555

• Sep 22nd, 2007

Creating a physical standby using RMAN

Answer Question  Select Best Answer

Sajeev123

 Profile Answers by Sajeev123 Questions by Sajeev123

• Jan 8th, 2009

Cold backup we can perform using OS commands after shutting down the database.In DB running position we can take hot backup using the following commans;alter database begin backup;

JOY

• Jun 12th, 2007

We can perform cold backup in unix by shutting down the database in proper mode so the control file will in consistent state and after that u can perform backing up all database files.I hot back we ca...

Answer Question  Select Best Answer

My database is in archive mode. when log switch occur that log file is archiving . what happens when log switch occurs

rupiy2k

 Profile Answers by rupiy2k Questions by rupiy2k

• Dec 20th, 2008

After logswitch checkpoint accour.It update the hedder of datafile and controlfile with new SCN no. and checkpoint position.it also give the signal to dbwr to writ dirty buffer to datafile.

naveen5555

 Profile Answers by naveen5555 Questions by naveen5555

• Sep 22nd, 2007

Log switch event will take place. But the status of the log file which is archiving will be ACTIVE  till it finish archiving. 

Answer Question  Select Best Answer

Detail script of backup using RMAN in both mode catalog and nocatalog

MUNNU2U

 Profile Answers by MUNNU2U Questions by MUNNU2U

• Nov 26th, 2008

Full Backup in the sense taking up the whole database backup into a specific folder or a path but we cant take any jobs as?backup and SQL Server logins?also we cant take.

subhash.terdale

 Profile Answers by subhash.terdale Questions by subhash.terdale

• Oct 2nd, 2008

Rman is backup and recovery tool of oracleeasy to perform

Answer Question  Select Best Answer

Which processes will run when we take online backup?

narendra05

 Profile Answers by narendra05 Questions by narendra05

• Aug 16th, 2010

The rman process runs in case of backup running in parallel multiple such processes would run. select sid,program,osuser,status from v$session where program like '%rman%' query will give the status of such sessions.

slavaostapenko

 Profile Answers by slavaostapenko Questions by slavaostapenko

• Jul 13th, 2010

I suppose no other database background process is performed. RMAN appears as usual client for database. So, there are only several RMAN processes launched in OS, but no database background processes.

Answer Question  Select Best Answer

How will you recover database if OS is corrupted. Assume you have hot backup on same hard drive.

vasantksaxena

 Profile Answers by vasantksaxena Questions by vasantksaxena

• Oct 10th, 2010

OS Corruption doen't mean hard disk crashed.?Connect this hard disk as secondary device in a working system, copy the back files/folder to other location, and proceed.

ramshon

 Profile Answers by ramshon Questions by ramshon

• Sep 9th, 2010

Cannot be recovered.

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

prahlad_786

 Profile Answers by prahlad_786 Questions by prahlad_786

• Jun 23rd, 2010

Whenever you have competing DML running against the same data, you run the risk of a deadlock.Tune the application - Single-threading related updates and other application changes can often remove dea...

naveen5555

 Profile Answers by naveen5555 Questions by naveen5555

• Sep 22nd, 2007

A deadlock occurs when two or more users are waiting for data locked by each other(Not commited by user01).To fix this, recreate the segment with higher INITTRANS and/or PCTFREE values. This will allo...

Answer Question  Select Best Answer

chetan.ind

 Profile Answers by chetan.ind Questions by chetan.ind

• Mar 18th, 2009

If this is the situation, simple process is :1.?Take a trace of control file from clone do the changes in that like database name and datafile name and location.2. Save it as < name >.ora3. Run the f...

sanjayoracle

 Profile Answers by sanjayoracle Questions by sanjayoracle

• Apr 25th, 2008

If we don;t have any backup of Controlfile...then we have to use create controlfile command..

Answer Question  Select Best Answer