hi, how can i check all backups are exist to restore? I.e. i forget to take ba

hi, how can i check all backups are exist to restore? I.e.
i forget to take backup on one day. But now i want to check
that all backups are there to restore now. I know the
answer of through timestamps we know how to check. But i
need any other way?

Question Posted / shravan

1 Answers
4173 Views
I also Faced
E-Mail Answers

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But..

Answer / kamal

if full backup has been taken , you can restore at any
time . if differential has been taken checkup the last full
backup date then verify diff. backup has been taken
immediate after that or not if not find the date & time for
which it was left and take diff. backup of that .

Is This Answer Correct ?

4 Yes

0 No

Post New Answer

More DB Administration Interview Questions

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

0 Answers

how can you implement fine-grained auditing?

0 Answers Oracle,

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers

what functionality does oracle provide to secure sensitive information?

0 Answers Oracle,

How would you begin to troubleshoot an ORA-3113 error?

1 Answers

What is the importance of a recovery model? : sql server DBA

0 Answers

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers

Explain an ORA-01555

2 Answers

What is the difference between clustered and non-clustered index? : sql server DBA