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
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How to start SQL Server in minimal configuration mode?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is dbcc? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the different ways you can create databases in sql server? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Can you redefine a table online?
What is transparent data encryption? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you process messages in order asynchronously?
what functionality does oracle provide to secure sensitive information?
What types of replication are supported in sql server? : sql server DBA