what is difference between user managed backup and rman backup?
Answer Posted / iliyas ali
1.To take both the bkp the db should be in Archive log
2.Rman doesn't put tablespace in bkp mode.
3.the biggest advantage of Rman is that it takes the bkp of the used space/blocks of database.where user managed bkp takes the bkp of complete data file.
4.Rman will automatically detect block corruption,which is not possible in Hot bkp.
5.In Rman we can take incremental bkp,which is not possible in User managed bkp.
6.Rman is FRA aware.We can perform table space point in time recovery,as block change tracking also which is not possible in user managed backup.
7.Most importantly,Rman will re-read the data block until it gets the consistent image of it.
Is This Answer Correct ? | 25 Yes | 3 No |
Post New Answer View All Answers
Which autogrowth database setting is good? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
Explain materialized views and how they are used.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how does an oracle clusterware manage crs resources?
What is the default port no on which sql server listens? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What is transparent data encryption? : sql server DBA
how to restore files with rman?
What types of replication are supported in sql server? : sql server DBA
Query processing is slow(eg select query)how will u solve that
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is dcl? : sql server DBA