-
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;
Nizar
-
The Command is
Alter Tablespace <TABLESPACE NAME> Begin backup;
Alter Tablespace <TABLESPACE NAME> End Backup;
Suvashish
-
I am sorry about that mistake. Meant BEGIN.
Nizar
-
As mentioned above , hot backup is taken tablespace by tablespace:
steps:
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..
Pands
-
Just a not that this can only be performed on databases in archivelog mode.
Nirasha
-
hi all,
thanks for the info.
thanks mr.pandian for for giving a detailed note. really helpful.
regards
ravi kumar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|