What is hot backup and how it can be taken?

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.

Interview Candidate
Sep 7th, 2004
1
1853

Memory Management

Answer

Showing Answers 1 - 1 of 1 Answers

cmanne
Profile Answers by cmanne

Jan 4th, 2006

The database should be in Archive log mode to take hot backups.Step1: Shutdown the database gracefullyStep2: Take full backup of the databaseStep3: Edit the following intialization parameters likelog_archive_destlog_archive_formatlog_archive_startStep4: Mount the databaseSQL>startup mount pfile=''SQL>Alter database archivelog;SQL>alter database openNow check for the status of the database usingSQL>archive log list;SQL>alter system switch logfile;Now the database is in archive log modeQuery dba_tablespaces, dba_data_files to get the list of tablespaces and datafilesKeep each and every tablespace begin backup mode usingSQl>alter tablespace begin backup;now using the OS copy command copy all the datafilesSQL>alter tablespace end backup;SQL>alter database backup controlfile to