what is difference between user managed backup and rman backup?
Answer / 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 |
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is grd?
Give two examples of referential integrity constraints.
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
what is the role of dip user in our database?
How will u copy the objects of one schema to another schema in datapump & export/import?
how can you initialize log miner?
What is fill factor? : sql server DBA
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is the dataguard background process??