What is the difference between rman and a traditional hotbackup?
Answer / bandaru naga gopal
rman will take the backup of only used blocks where as in traditional hot backup 1.tablespace will put in offline , 2, physical files will backup, 3, exessive redo's will generate , 4, once physical backup is over tablespace's will be back to online.
| Is This Answer Correct ? | 1 Yes | 0 No |
Discuss row chaining, how does it happen? How do you correct it?
What is the difference between truncate and delete? Why is one faster?
Explain procedure to change characterset of a database.
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
what does the no logging option do? Why would we use it?
How long does it take to learn database administration?
Which dba certification is best?
What does dba stand for in technology?
You see multiple extents in the temporary tablespace. Is this a problem?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
How do you analyze table partition using oracle provided package?
How many control files should you have? Where should they be located?