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
how does an oracle clusterware manage crs resources?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what is the diffrence between core dba and apps dba?
What is a correlated sub-query? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
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 types of connection load-balancing?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Explain materialized views and how they are used.