Backup

[rktbhotla]

How should I take a Hot Backup on NT server? HOw do I schedule backups and maintenance jobs on NT server?

[nabaig]

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

[dsuva]

The Command is

Alter Tablespace <TABLESPACE NAME> Begin backup;

Alter Tablespace <TABLESPACE NAME> End Backup;

[nabaig]

I am sorry about that mistake. Meant BEGIN.

Nizar

[s_pandian]

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

[nirasha]

Just a not that this can only be performed on databases in archivelog mode.

Nirasha

[rktbhotla]

hi all,

thanks for the info.

thanks mr.pandian for for giving a detailed note. really helpful.

regards
ravi kumar