what is the difference between hot backup n rman backup?
Answer / 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 |
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
when does an alert gets signaled?
Explain how you would restore a database using RMAN to Point in Time?
Explain the use of table functions.
In oracle 10g export, import if we declare rows=y/n what would be the output?
Name two files used for network connection to a database.
If we issue alter database begin backup. What happens to database?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
what is a user-defined lock?
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
what r the types of backup?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)