RE: DB Refreshes

Gulam,  

Depending on the storage software and hardware that you have, you can implement soft mirroring which can be used to produce this on a daily basis. This works well in a SAN where you will create a soft mirror, put all tablespaces in backup mode, split the mirror, mount the mirror filesystems on the other server and recover the database. This will greatly reduce the time that the original database is in hot backup mode and the whole operation can be easily scripted.  

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Disappointments are inevitable in Life, but discouragement is optional. You decide!

• The opinions and statements above are entirely my own and not those of my employer or clients **

-----Original Message-----
Sent: Monday, August 26, 2002 9:28 AM
To: Multiple recipients of list ORACLE-L

Hello All

I am in need to know/leanr about the database refreshes. Here is my situation. We have OLTP database which is 24/7 and we need to provied to the client a copy of the same OLTP database refreshed daily for their reporting puposes. Any ideas/suggestions how best can I do this, with minimal work? I am currently reading about ORACLE Snapshots. We are running ORACLE 8.1.7.3.0 on Tur64 Unix.

Thanks  

Gulamabbas Sikiladha
1315-2850 Cedarwood Dr
Ottawa, Ontario
Canada
K1V 8Y4
Tel : (613) 260 0336

Do You Yahoo!?
Yahoo! <http://rd.yahoo.com/finance/mailsig/new/*http://finance.yahoo.com> Finance - Get real-time stock quotes

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).