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
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
when does an alert gets signaled?
What is the default port no on which sql server listens? : sql server DBA
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
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.
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
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
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
what are the performance views in an oracle rac environment?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Where would you look for errors from the database engine?
What is dcl? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?