Re: Newbie: How to Backup Data?

Victoria,

You can use any normal operating system backup utility. If you are on Unix you could use TAR, CPIO, or even third-party packages like Legato Networker or Alexandria.

Most DBA's have a Unix shell script that executes sqlplus and does the BEGIN BACKUP COMMAND for a single tablespace, then does a (TAR/CPIO/...) on the tablespace, then does another sqlplus with END BACKUP.

Don't forget to backup backup up the control files (Alter Database Backup Control file to XXXXX) then use the (TAR/CPIO/...) to copy it also to tape. Backup any Archive Logs you have created (if you have archive logging on).

Also look up the info on the command "Alter database backup controlfile to trace noresetlogs" in Chapter 18-15 of Administrators Guide. This creates a file that is a build script if you ever need to rebuild your database from scratch.

Hope this helps... Received on Mon Jun 12 1995 - 00:00:00 CEST