Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Datapump and read only database
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