Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between user managed backup and rman backup?
- 1 Answers
- 16754 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?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
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 is the difference between dropping a database and taking a database offline? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
What is dbcc? : sql server DBA
when does an alert gets signaled?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you communicate with operating system files from oracle?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how to restore files with rman?
What the different types of replication and why are they used? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
