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
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.