if monday take full backup and tuesday it was cumulative
backup and wednesday we taken incremental backup, thursday
some disaster happen then what type of recovery and how it
will take?
Answer Posted / braj123
--> Restore the monday full backup+tuesday cumulative
backup+wednesday Incremental backup.(bcz cumulative and
incremental clears the archives every backup).
--> Recover the database
--> reset the logs
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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.
What the different topologies in which replication can be configured? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What the different types of replication and why are they used? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what is ora 24313?what is the procedure to exclude that error?
What purpose does the model database server? : sql server DBA
What is transparent data encryption? : sql server DBA