Full backups questions.Please help.

[65]

Hi All,
Currently I 've been working on performing consistent full backups for my database. Just wanted to make sure that I can back up my entire database which is valid. Below are step by step what I will do

- Shutdown immediate (Thhe database is closed cleanly.)
- The database is in archieve mode.

I perform full backups into my tape drive. So Here are my command lines:

mt -f /dev/nst0 rewind
tar -Rcvf /dev/nst0 /Disk02/data01.dbf (this datafile belongs to the tablespace DATA)
tar -Rcvf /dev/nst0 /Disk01/control01.ctl (My control file)
tar -Rcvf /dev/nst0 /Disk02/control02.ctl
tar -Rcvf /dev/nst0 /Disk03/control03.ctl
tar -Rcvf /dev/nst0 /Disk04/redo01.dbf
tar -Rcvf /dev/nst0 /Disk04/redo02.dbf
tar -Rcvf /dev/nst0 /Disk05/redo03.dbf
etc...for tablespace (System, indexes, rbs....)
and also I will back up the initialization parameter file and other oracle product initialization files.

Above what I 've planned before performing my consistent backups. Just wondered whether I am on the right track?Anyone please direct me how to have a consitent backups for my entire database
Your help is greatly appreciated.
Thanks in advance.
Th

 

[oracle8]

If your performing a cold back-up you're in the right track, just don't forget to backup your log files also.

 

[65]

Hi,
Thanks for your quick response. I do appreciate it.

Again, thank you very much.
Th