Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between user managed backup and rman backup?
- 1 Answers
- 16885 Views
- CTS, I also Faced
- E-Mail Answers
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 can you schedule a job in database?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
who owns the operating system files created by the utl_file package?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
What is fill factor? : sql server DBA
What is replication? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
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
What are statistics, under what circumstances they go out of date, how do you update them?
How do you open a cluster administrator? : sql server DBA
how can you process messages in order asynchronously?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Why would you use sql agent? : sql server DBA
