Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

what is difference between user managed backup and rman backup?

Question Posted / skr


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

Post New Answer

More DB Administration Interview Questions

What are the recovery models for a database? : sql server DBA

0 Answers  

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

How would you extract DDL of a table without using a GUI tool?

0 Answers  

what is rebuild index??

2 Answers   IBM, Sapient,

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

how can you find out if a table can be redefined?

0 Answers   Oracle,

what is the use of ocr?

0 Answers   Oracle,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories