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 -> Datapump and read only database

Datapump and read only database

From: Lothar Armbrüster <lothar.armbruester_at_t-online.de>
Date: Mon, 28 Aug 2006 22:28:39 +0200
Message-ID: <877j0sr4eg.fsf@prometeus.none.local>


Hello Experts,

I'm trying to figure out how to use datapump after an upgrade of our databases (Oracle 9.2 on W2k) to 10.2.
Currently, we have a phyical standby database (using Dataguard) that is made read only during daytime for reporting purposes. On this database we are also running a dayly full export. This one writes some complaints into the log but besides that runs fine.

I'm reading the manual for datapump which states that datapump is much faster than imp so I'm considering using datapump after the upgrade. But the manual also states that datapump does not work with read only databases. Now the question is what can I do?

I could stick with exp/imp or set up a second small instance on the standby server which will be read/write and just exist to do the datapump remotely on the standby database. I also could do the datapump remotely on the primary site but that would run over the network and put some load on the primaray database which I want to avoid.

What would you recommend?

Regards,
Lothar

-- 
Lothar Armbrüster  | lothar.armbruester_at_t-online.de
Hauptstr. 26       |
65346 Eltville     |
Received on Mon Aug 28 2006 - 15:28:39 CDT

Original text of this message

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