if monday take full backup and tuesday it was cumulative backup and wednesday w

if monday take full backup and tuesday it was cumulative
backup and wednesday we taken incremental backup, thursday
some disaster happen then what type of recovery and how it
will take?

Question Posted / anuradha

1 Answers
3925 Views
I also Faced
E-Mail Answers

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental ..

Answer / braj123

--> Restore the monday full backup+tuesday cumulative
backup+wednesday Incremental backup.(bcz cumulative and
incremental clears the archives every backup).

--> Recover the database
--> reset the logs

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB Administration Interview Questions

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers

Explain the use of table functions.

1 Answers

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers Value Labs,

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers

How do you open a cluster administrator? : sql server DBA

0 Answers

what is a user-defined lock?

0 Answers Oracle,

What is RAID and what are different types of RAID configurations?

1 Answers

how can you initialize log miner?

0 Answers Oracle,

What command would you use to encrypt a PL/SQL application?

1 Answers

For more DB Administration Interview Questions Click Here