What is the difference between rman and a traditional hotbackup?
Answer Posted / 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 |
Post New Answer View All Answers
What are the various ingredients of sga?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
How would you find total size of database in os level?
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?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
How can you find all the processes on your system?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What are the main benefits of using spfile over pfile?
What are the types of schemas?
How many types of dba are there?
What do you mean by oracle dba and what is its role?
What is the main function of database?
How do you set up tablespaces during an oracle installation?
Which function is used to find the largest integer less than or equal to aspecific value?
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.