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
4296 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

How would you determine who has added a row to a table?

4 Answers

What are the different sql server versions you have worked on? : sql server DBA

1 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers

what is logical system in sap basis

1 Answers

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

which background process invoke at the time of upgradation tell me???

1 Answers iGate,

How to make a replica of existing oracle server to another server?

3 Answers

why do we give pctfree and pctused in create table statement?

1 Answers CTS,

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?