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
Where would you look for errors from the database engine?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you process messages in order asynchronously?
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?
What the different topologies in which replication can be configured? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are statistics, under what circumstances they go out of date, how do you update them?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How do you open a cluster administrator? : sql server DBA
what is grd?
How to start SQL Server in minimal configuration mode?
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?
when does an alert gets signaled?