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
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is replication? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Why would you use sql agent? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the commands you'd issue to show the explain plan for "select * from dual"?
how can you create a user-defined lock?
how can you get actual data change values from previous transactions in oracle?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
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 is dcl? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
how can you find out if a table can be redefined?