Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between user managed backup and rman backup?
- 1 Answers
- 16908 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 communicate with operating system files from oracle?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
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
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.
What types of replication are supported in sql server? : sql server DBA
when does an alert gets signaled?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What purpose does the model database server? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How do you open a cluster administrator? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
