Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Explain the difference between a hot backup and a cold
backup and the benefits associated with each.
by

1 Answer

Answer :

A hot backup is basically taking a backup of the database while it is
still up and running and it must be in archive log mode. A cold backup
is taking a backup of the database while it is shut down and does not
require being in archive log mode. The benefit of taking a hot backup is
that the database is still available for use while the backup is occurring
and you can recover the database to any point in time. The benefit of
taking a cold backup is that it is typically easier to administer the
backup and recovery process. In addition, since you are taking cold
backups the database does not require being in archive log mode and
thus there will be a slight performance gain as the database is not
cutting archive logs to disk.
by

Related questions

What is cold backup and hot backup (in case of Oracle)?

Description : What is cold backup and hot backup (in case of Oracle)?

Last Answer : ∙ Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance is shut down. This is a straight file copy, usually from the disk ... was done. The database is restored to the most consistent state without any loss of committed transactions.

What is hot backup and how it can be taken?

Description : What is hot backup and how it can be taken?

Last Answer : Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files.

Does Oracle write to data files in begin/hot backup mode? (for DBA

Description : Does Oracle write to data files in begin/hot backup mode? (for DBA

Last Answer : Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.In backup mode, Oracle will write out complete changed blocks ... ). Because of this, one should notice increased log activity and archiving during on-line backups.

What is cold backup? What are the elements of it?

Description : What is cold backup? What are the elements of it?

Last Answer : Cold backup is taking backup of all physical files after normal shutdown of database. We need to take. - All Data files. - All Control files. - All on-line redo log files. - The init.ora file (Optional)

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Description : Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Last Answer : ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. ... having to write transactions to an archive log and thus increases the performance of the database slightly.

How does one backup a database using the export utility? (for DBA

Description : How does one backup a database using the export utility? (for DBA

Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.

Why and when should I backup my database? (for DBA

Description : Why and when should I backup my database? (for DBA

Last Answer : Backup and recovery is one of the most important aspects of a DBAs job. If you lose your company's data, you could very well lose your job. Hardware and software can always be ... things that will get you. Most failed recoveries are a result of organizational errors and miscommunications.

What command would you use to create a backup control file?

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Description : You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Last Answer : I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

Can Full Backup be performed when the database is open ?

Description : Can Full Backup be performed when the database is open ?

Last Answer : No.

What utility is used to create a physical backup?

Description : What utility is used to create a physical backup?

Last Answer : Either rman or alter tablespace begin backup will do..

What is a logical backup?

Description : What is a logical backup?

Last Answer : Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup.

My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Description : My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Last Answer : If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the ... : ALTER DATABASE END BACKUP; The above commands need to be issued when the database is mounted.

How does one backup archived log files? (for DBA

Description : How does one backup archived log files? (for DBA

Last Answer : One can backup archived log files using RMAN or any operating system backup utility. Remember to delete files after backing them up to prevent the archive log directory from filling up. If the ... oracle/arch_backup/log_t%t_s%s_p%p' 5> (archivelog all delete input); 6> release channel dev1; 7> }

How does one backup a database using RMAN? (for DBA

Description : How does one backup a database using RMAN? (for DBA

Last Answer : The biggest advantage of RMAN is that it only backup used space in the database. Rman doesn't put tablespaces in backup mode, saving on redo generation overhead. RMAN will re-read database ... directly to tape. Alternatively one can backup to disk and then manually copy the backups to tape.

What is Full Backup ?

Description : What is Full Backup ?

Last Answer : A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter

What is Partial Backup ?

Description : What is Partial Backup ?

Last Answer : A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.

Name two utilities that Oracle provides, which are use for backup and recovery.

Description : Name two utilities that Oracle provides, which are use for backup and recovery.

Last Answer : Along with the RDBMS software, Oracle provides two utilities that you can use to back up and restore the database. These utilities are Export and Import. The Export utility dumps the definitions and data ... best you can do is recover the database to the time when the export was last performed.

Is it possible to backup your database without the use of an RMAN database to store the catalog?

Description : Is it possible to backup your database without the use of an RMAN database to store the catalog?

Last Answer : Yes, but the catalog would be stored in the controlfile.

What is an UTL_FILE.What are different procedures and functions associated with it?

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

What are the triggers associated with a check box?

Description : What are the triggers associated with a check box?

Last Answer : Only When-checkbox-activated Trigger associated with a Check box.

What triggers are associated with the radio group?

Description : What triggers are associated with the radio group?

Last Answer : Only when-radio-changed trigger associated with radio group Visual Attributes.

What are the triggers associated with the image item?

Description : What are the triggers associated with the image item?

Last Answer : When-Image-activated(Fires when the operator double clicks on an image Items) When-image-pressed(fires when the operator selects or deselects the image item)

What are built-ins associated with timers?

Description : What are built-ins associated with timers?

Last Answer : find_timercreate_timerdelete_timer

What are the two repeating frame always associated with matrix object?

Description : What are the two repeating frame always associated with matrix object?

Last Answer : One down repeating frame below one across repeating frame.

What are the trigger associated with image items?

Description : What are the trigger associated with image items?

Last Answer : When-image-activated fires when the operators double clicks on an image itemwhen-image-pressed fires when an operator clicks or double clicks on an image item

What is trigger associated with the timer?

Description : What is trigger associated with the timer?

Last Answer : When-timer-expired.

What is the most important requirement in order to use RMAN to make consistent hot backups

Description : What is the most important requirement in order to use RMAN to make consistent hot backups

Last Answer : Your database has to be in ARCHIVELOG mode.

What are the benefits of distributed options in databases?

Description : What are the benefits of distributed options in databases?

Last Answer : Database on other servers can be updated and those transactions can be grouped together with others in a logical unit. Database uses a two phase commit.

WHAT ARE THE BENEFITS OF FLEXFIELDS?

Description : WHAT ARE THE BENEFITS OF FLEXFIELDS? 

Last Answer : - Configure applications to support your own accounting, product and other codes. - Enable the construction of intelligent keys. - Configure application to capture additional data. - Use ... combinations entered by the user. - Support multiple flexfield structures depending on data context.

What is Enterprise Structure Configurator (ESC) and what are the benefits of using it?

Description : What is Enterprise Structure Configurator (ESC) and what are the benefits of using it?

Last Answer : The ESC is an interview-based tool that guides you through the configuration of your enterprise structures. Use the ESC as part of your set up to define the organization structures and job and position structures of the enterprise.

Which one of the following types of pain is most likely to be associated with craniomandibular disorders: A. Exacerbated pain by hot or cold food B. Keeps patient awake at night C. Associated with muscle tenderness D. Associated with trigger spots related to the trigeminal nerve

Description : Which one of the following types of pain is most likely to be associated with craniomandibular disorders: A. Exacerbated pain by hot or cold food B. Keeps patient awake at night C. Associated with muscle tenderness D. Associated with trigger spots related to the trigeminal nerve

Last Answer : C. Associated with muscle tenderness

What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

Description : What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

Last Answer : CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.

Which of the following is false? a) The more important the data, the greater the need for backing it up b) A backup is as useful as its associated restore strategy c) Storing the backup copy near to its original site is best strategy d) Automated backup and scheduling is preferred over manual operations

Description : Which of the following is false? a) The more important the data, the greater the need for backing it up b) A backup is as useful as its associated restore strategy c) Storing the ... near to its original site is best strategy d) Automated backup and scheduling is preferred over manual operations

Last Answer : Storing the backup copy near to its original site is best strategy

Which of the following is false? a) The more important the data, the greater the need for backing it up b) A backup is as useful as its associated restore strategy c) Storing the backup copy near to its original site is best strategy d) Automated backup and scheduling is preferred over manual operations

Description : Which of the following is false? a) The more important the data, the greater the need for backing it up b) A backup is as useful as its associated restore strategy c) Storing the ... near to its original site is best strategy d) Automated backup and scheduling is preferred over manual operations

Last Answer : Storing the backup copy near to its original site is best strategy

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Description : Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Last Answer : A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any ... functions and procedures that are grouped together based on their commonality to a business function or application.

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Description : Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Last Answer : ORACLE_BASE is the root directory for oracle. ORACLE_HOME located beneath ORACLE_BASE is where the oracle products reside.

Explain the difference between a data block, an extent and a segment.

Description : Explain the difference between a data block, an extent and a segment.

Last Answer : A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings ... that an object takes when grouped together are considered the segment of the database object.

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Description : To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Last Answer : & physical page no.

Difference between SUBSTR and INSTR ?

Description : Difference between SUBSTR and INSTR ?

Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

What is the difference between DBFile Sequential and Scattered Reads?(for DBA

Description : What is the difference between DBFile Sequential and Scattered Reads?(for DBA

Last Answer : Both "db file sequential read" and "db file scattered read" events signify time waited for I/O read requests to complete. Time is reported in 100's of a second for Oracle 8i releases and below, ... v_$system_event b where a.event = 'db file sequential read' and b.event = 'db file scattered read';

What is the difference between static and dynamic lov

Description : What is the difference between static and dynamic lov

Last Answer : The static lov contains the predetermined values while the dynamic lov contains values that come at run time

What is the difference between NAME_IN and COPY ?

Description : What is the difference between NAME_IN and COPY ?

Last Answer : Copy is package procedure and writes values into a field. Name in is a package function and returns the contents of the variable to which you apply.

What is the difference between restoring and recovering? (for DBA

Description : What is the difference between restoring and recovering? (for DBA

Last Answer : Restoring involves copying backup files from secondary storage (backup media) to disk. This can be done to replace damaged files or to copy/move a database to a new location. Recovery is the process ... as SYSDBA Sql> RECOVER DATABASE UNTIL TIME '2001-03-06:16:00:00' USING BACKUP CONTROLFILE;

What is the difference between online and offline backups? (for DBA

Description : What is the difference between online and offline backups? (for DBA

Last Answer : A hot backup is a backup performed while the database is online and available for read/write. Except for Oracle exports, one can only do on- line backups when running in ARCHIVELOG mode. A cold backup is a backup performed while the database is off-line and unavailable to its users.

What is the difference between the SQL*Loader and IMPORT utilities?

Description : What is the difference between the SQL*Loader and IMPORT utilities?

Last Answer : These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced by another Oracle utility EXPORT while the SQL* ... from different data sources just so long as it conforms to ASCII formatted or delimited files.

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

Description : What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

Last Answer : A temporary tablespace is used for temporary objects such as sort structures while permanent tablespaces are used to store those objects meant to be used as the true objects of the database.

What is the Difference between a post query and a pre query

Description : What is the Difference between a post query and a pre query

Last Answer : A post query will fire for every row that is fetched but the pre query will fire only once.

What is the difference between deleting and truncating of tables

Description : What is the difference between deleting and truncating of tables

Last Answer : Deleting a table will not remove the rows from the table but entry is there in the database dictionary and it can be retrieved But truncating a table deletes it completely and it cannot be retrieved.

What is the difference between candidate key, unique key and primary key

Description : What is the difference between candidate key, unique key and primary key

Last Answer : Candidate keys are the columns in the table that could be the primary keys and the primary key is the key that has been selected to identify the rows. Unique key is also useful for identifying the distinct rows in the table.)