what is the difference between hot backup n rman backup?
Answer Posted / ramakrishnachallapalli
To take both backups we should keep database in archive log
mode.
Neither cold backup nor hot backup identify the corrupted
blocks in backup where as rman can identify
RMAN will take the backup of database used block only where as
hot backup will take physical existing database files
completely
| Is This Answer Correct ? | 27 Yes | 3 No |
Post New Answer View All Answers
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
who owns the operating system files created by the utl_file package?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
internal architecture
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What the different components in replication and what is their use? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the different types of indexes available in sql server? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA