From: Mario Andres Yepes Cifuentes (marioy@upb.edu.co)
Date: Fri Jun 18 2004 - 08:54:51 EDT
As some people has pointed out I've missed a couple of facts on my
question, so here is an update to ma last email.
I've been backing up an Oracle database with tar and dd trough a shell
script in order to save time. The script takes care of shutting down the
database, issuing the tar an dd commands and then starting up the
database. What the script does is:
- First it stops the database
- Backsup the datafiles with tar in the filesystem : tar cbf 126
PROD.tar u04/oradata/PROD (notice that it doesnt uses a leading slash)
- It starts up the database
- Then I stores the archive in tape using : dd if=PROD.tar
of=/dev/rmt/0cn bs=63k
The reason for not writing directly on tape is to minimize the downtime
of the database. Wiriting the file to disk works really fast. It takes
just a couple of minutes to write the backup to the filesystem
Backing up a 2.5G database takes just 15 minutes in the machine.
The problem is that when I need to restore the back up it just take
tooo long. As an example, it took almost 6 hours to unpack an archive
from tape to the filesystem ( I used tar xbf 126 /dev/rmt/0cn).
The question is: Is there a way to speed the process? If I use a smaller
block size would it take less time to restore?
The reason for no using ufsdump is because in the same filesystem there
are more datafiles of test databases that should'nt be backed up
Tanks in advance.
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:28:54 EDT