Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle recovery what is the best way

Oracle recovery what is the best way

From: Teresa <tpreto7_at_sapo.pt>
Date: 7 Jan 2003 18:02:33 -0800
Message-ID: <6dabc692.0301071802.3ede8e3b@posting.google.com>


Hi There
I'm working on recovery of oracle in case of a disaster and I have the following question:
I have a database in which most of the tables are with nologing, also I'm working on partition of one of the tables, can someone please tell me what is the best way of recover the database? for backup we do a ctas from one schema to other on daily basis and on weekends we do a degrag. This is oracle 8174 on sun. I have been told that the best way is just to have a clean export, do to the nologing at table level which they are unrecoverable Any help would be great

Thanks

Teresa Received on Tue Jan 07 2003 - 20:02:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US