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

How do you tell what your machine name is and what is its IP address?

4 Answers  

How would you go about generating an EXPLAIN plan?

2 Answers  

how will you see when the database was started using sql prompt?

2 Answers   IBM,

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

how can you connect from 10g user to 11g user??

0 Answers   HP,

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories