I am trying to take the hot backup of the oracle 8.0.5 . All the documentary reference gives a very laborous steps in doing so(They give a batch program to do so).
Before making a batch program, I would like to execute each steps manually(For the understanding purpose)
Would someone help me in taking a step by step -hot backup. This is my
DB name : oracle
Directory : d:\orant\database
Archiver log : Enabled and Archiving is in progres.
Copy Init.ora file.
SVMRGL> Alter system switch logfile
SVMGRL> alter database backup controlfile to trace;
SVRGRL> alter tablespace tablespace name begin backup
copy all the files of that TABLESPACE to disk by OS command.
SVRMGRL> Alter tablespace end backup
Repeat the steps until you complete all Tablespaces
SVRMGRL> alter system switch logfile
Copy the all log files and copy all Archive Logfiles generated from Begning the backup to Ending the backup
I hope it is clear now.
Thanks Kishore for giving the steps in taking the hot backup.
However, How do I know the number of arch files and the redolog files created while the db was in backup mode.
So which are the logfiles and redolog files I have to copy?
Redo logfiles are not created separately at backup mode. And Archive logs are the once which gets created. So note down the time when the backup is started and when it is stoped. And copy those Archive Logfiles to the backup directory. Ingenral you need to copy only ONE ARCHIVE LOG FILE. But it depends if there is any transaction in between which is big enough to fill up the Logfile then only the Archive will be created. At time it could be more than one.
before the start of backup issue "archive log list" command in svrmgr. This will give you the current log number. At the end of the backup issue this command again to get the log number.
You have to backup all these logs in order to do a successful recovery.
Could you answer can i make this procedure to do hot backup on another server?
Click Here to Expand Forum to Full Width