Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between user managed backup and rman backup?
- 1 Answers
- 16898 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
who owns the operating system files created by the utl_file package?
what is ora 24313?what is the procedure to exclude that error?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what do you understand by fine-grained auditing?
What are the commands used in dcl? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What authentication modes does sql server support? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
how can a session indicate its interest in receiving alerts?
What purpose does the model database server? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
