You want TDP for Oracle/RMAN. You would be able to backup the query database online. If you are doing Flashcopy NOCOPY you would have little down time.
The other possibility is TDP for Oracle for ESS. The issue is the database flashcopy will be used for real production. I do not know if you can do that timely. And, it is very expensive. -----Original Message----- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 12:52 PM To: [EMAIL PROTECTED] Subject: Searching for a more efficient way to archive/backup Oracle datab ases We have several large Oracle databases (to 500 GB) Presently using TSM we: 1. Flash copy (ESS) databases from a production instance to a query database instance. 2. Archive query databases cold with the database down. 2. Use a script to stream the database archives directly to tape broken down over 4-6 session streams (Use 4-6 drives at a time) 4. Bring up the query database after archive is complete. Details: Oracle 8 AIX 4.3.3 TSM 4.1.3 Library IBM3494 Drives 3590E fiber connect to SAN We would like to find a way that would reduce or eliminate the requirement for the query database downtime. Can we do the backups HOT without production impact, or incrementally? What products would we require to help us with this endeavor (TDP for Oracle, SQL Backtrack etc.???) Any thoughts/information would be greatly appreciated > Jim Taylor > Associate, Technical Services > Enlogix > * E-mail: [EMAIL PROTECTED] > * Office: (416) 496-5264 ext. 286 > * Cell: (416)458-6802 > * Fax: (416) 496-5245 > >
