RE: Yet Another Export Question

From: syed jaffar hussain <sjaffarhussain_at_hotmail.com>
Date: Thu, 22 Apr 2004 13:54:26 +0300
Message-ID: <002e01c42858$2e152fb0$840a010a@app02test>

If your db runs in archivelog mode then why don't you take only online backups (RMAN). Taking offline backup every month won't be a good idea as once you shutdown your db you will loose everything from the buffers like from shared_pool and db_buffers and when you startup the db all your queries will be expensive.
While exporting you can use consistent=y to solve your problem. Generally, people keep database is restricted mode while taking full export to avoid other users being modifying data.

Best Regards,

Syed Jaffar Hussain
Sr Oracle DBA
Sejel Technology Ltd.
+966 2 6064971 x 324

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fahd Mirza Sent: Thursday, April 22, 2004 1:48 PM
To: oracle-l_at_freelists.org
Subject: Re: Yet Another Export Question

Hi,

I am utilizing three methods for backup. Exp/Imp (Daily), Online (Weekly), Luxurious Offline (monthly). Justin, I am exploring your suggestion of separate tablespace for my picture table. Would somebody tell
me that my current backup strategy is ok or not? I have got one more question.
If an export of database is in operation and some users are using some tables in database, then does export utility also export currently-in-use
tables or it just skips them?
regards,
Fahd
----- Original Message -----

From: "Justin Cave (DDBC)" <jcave_at_ddbcinc.com> To: <oracle-l_at_freelists.org>
Sent: Thursday, April 22, 2004 12:06 PM
Subject: RE: Yet Another Export Question

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu Apr 22 2004 - 05:53:13 CDT