How should I take a Hot Backup on NT server? HOw do I schedule backups and maintenance jobs on NT server?
Hot backups are taken on the tablespace level.
At SQL plus or Server manager prompt: issue the command:
ALTER TABLESPACE ts_name start backup;
Now assuming you are not using RMAN, use the OS utilities to copy all the datafiles belonging to that particular tablespace. Once you do that issue the command:
ALTER TABLESPACE ts_name END backup;
The Command is
Alter Tablespace <TABLESPACE NAME> Begin backup;
Alter Tablespace <TABLESPACE NAME> End Backup;
I am sorry about that mistake. Meant BEGIN.
As mentioned above , hot backup is taken tablespace by tablespace:
1. take a list of tablespaces and corresponding datafiles you want to take backup.
2. Issue the command ALTER TABLESPACE tablespace name BEGIN BACKUP;
3. Copy all the datafiles corresponding to this tablespace to the backup drive.
4. Issue the command ALTER TABLESPACE tablespace name END BACKUP;
Repeat the above for all the tablespaces. It's advisable to take backup at the time of low db activity..
Just a not that this can only be performed on databases in archivelog mode.
thanks for the info.
thanks mr.pandian for for giving a detailed note. really helpful.
Click Here to Expand Forum to Full Width