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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

514


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

552


What are the operating modes in which database mirroring runs? : sql server DBA

612


when does an alert gets signaled?

578


What is the default port no on which sql server listens? : sql server DBA

557






How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

656


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2059


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1836


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1965


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1724


what are the performance views in an oracle rac environment?

557


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

3942


Where would you look for errors from the database engine?

2354


What is dcl? : sql server DBA

646


Why does Oracle not permit the use of PCTUSED with indexes?

2327