Hot Backups

Hi,

I need information about hot backups.
after I giver alter tablespace tablespacename begin backup

How it is functioning, If anybody knows

How i can take hot backups plz tell me the steps and details.

I am confused with this.

Thanking You,

my id is [email protected]

G.Shankar.

Following are the minimum steps to a hot backup:

1) Make sure the database is in ARCHIVELOG mode.

2) Prepare the database for a hot backup:
SQL> ALTER TABLESPACE tablespace_name BEGIN BACKUP;

3) Obtain the oldest online log sequence #:
SQL> ARCHIVE LOG LIST;

4) Back up the database using a system command:
UNIX: obackup, tar, dd, etc...
NT: backup manager, etc..

5) Set the tablespace to no hot backup mode:
SQL> ALTER TABLESPACE tablespace_name END BACKUP;

6) Obtain the current online log sequence #:
SQL> ARCHIVE LOG LIST;

7) Force a log switch:
SQL> ALTER SYSTEM SWITCH LOGFILE;


Good luck
R

Quote:

---

Originally posted by rlowe
Following are the minimum steps to a hot backup:
.....

---

A final step is missing from your backup scenario for this backup to be usable:

8.) Back up all the archived logs that have been created during the backup procedure - all archlogs with sequences between (and including) numbers obtained in steps 3.) and 6.)

details... :)