Oracle Hot Backups

[angelshark]

Hello,


Is there a way to perform hot backups of Oracle databases in a Unix environment without using the NetWorker modules?

Thanks for your help.

 

[jimbopalmer]

We alter each tablespace offline, copy the data files to a scratch disk, alter the tablespace online, and use networker to back up the scratch disk, then repeat for the next tablespace.

I tried to remain child-like, all I acheived was childish.

 

[jimbopalmer]

Alter Tablespace my_space Begin Backup;

Alter Tablespace my_space End Backup;

I tried to remain child-like, all I acheived was childish.

 

[angelshark]

Thanks for your reply, jimbo. Do you have a sample shell script for doing this?