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
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is a system database and what is a user database? : sql server DBA
Can you redefine a table online?
what are the types of connection load-balancing?
what is the role of dip user in our database?
What is the difference between dropping a database and taking a database offline? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is grd?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are statistics, under what circumstances they go out of date, how do you update them?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Explain materialized views and how they are used.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?