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 |
How can you determine if an oracle instance is up from the operating system level?
How do you analyze table partition using oracle provided package?
What is the difference between sga and pga?
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
List five most important parameter in 9i affecting performance?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What does the no logging option do? Why would we be careful of using it?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
What is difference between logical standby database and physical standby database?
Discuss row chaining, how does it happen? How can you reduce it?