in Technology by

What is the difference between hot backup and cold backup in Oracle? Tell about their benefits also.

1 Answer

0 votes
by

Hot backup (Online Backup): A hot backup is also known as online backup because it is done while the database is active. Some sites can not shut down their database while making a backup copy, they are used for 24 hour a day, 7 days a week.

Cold backup (Offline Backup): A cold backup is also known as offline backup because it is done while the database has been shutdown using the SHUTDOWN normal command. If the database is suddenly shutdown with a uncertain condition it should be restarted with RESTRICT mode and then shutdown with NORMAL option.

For a complete cold backup the following files must be backed up.

All datafiles, All control files, All online redo log files(optional) and the init.ora file (you can recreate it manually).

Related questions

0 votes
    What is Logical backup in Oracle?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
    Tell the difference between Domain and Data Element?...
asked Jan 5, 2021 in Technology by JackTerrance
0 votes
    Difference between Floor division and Division operator? please tell fast and correct Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
    If you decided to open a media house and you planned to hire workers for financial, graphic design and ... 50% Identification 50% Select the correct answer from above options...
asked Dec 5, 2021 in Education by JackTerrance
0 votes
    how big organisations take backup their data to be revived after any disaster. Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance
0 votes
    The remote backup site is sometimes also called the (a) Primary Site (b) Secondary Site (c) Tertiary ... Backup Systems topic in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    Which of the following refers to stealing one's idea or invention of others and use it for their own benefits? Piracy Plagiarism Intellectual property rights All of the above...
asked Mar 4, 2021 in Technology by JackTerrance
0 votes
    What is the Difference Between Interfaces and Conversions in Oracle apps?...
asked Dec 22, 2020 in Technology by JackTerrance
0 votes
    What is the difference between TRANSLATE and REPLACE in Oracle?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
    Can you tell something about Azure Cloud Service?...
asked Sep 26, 2021 in Technology by Editorial Staff
0 votes
    Tell something about the query language used in Cassandra Database....
asked Dec 13, 2020 in Technology by JackTerrance
0 votes
    TLS vulnerability is also known as Return of Bleichenbacher's Oracle Threat. (a) True (b) False The question was ... Security questions and answers pdf, mcq on Cyber Security pdf,...
asked Nov 3, 2021 in Education by JackTerrance
0 votes
    write a program to input three integers and find the difference between their sum and difference Select the correct answer from above options...
asked Dec 20, 2021 in Education by JackTerrance
...