First  |  Prev |  Next  |  Last
Pages: 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
backup recovery / oracle 10.2.0.4/ backup controlfile
I need to understand what event/ sequence of events requires the use of the ' using backup controlfile' syntax when effecting recovery I am trying to build my own recovery scenario cases for our specific set-up regards Chris B ... 26 Mar 2010 17:52
Cross architecture Data Guard
We currently use Oracle 10.2.0.4 on HPUX with data guard and logical standby. SQL Apply is used to replicate data to 2 other standby machines/databases. We are interested adding Redhat linux box into the mix running 11gR2. Would it be possible to replicate data from HPUX to Redhat linux? Thanks for any hint. ... 26 Mar 2010 15:34
CPU and memory metrics for databases in Oracle RAC
Hi, I have been tasked to provide some cpu and memory metrics for the individual databases in our Oracle RAC prior to and after the installation of the third database node installed recently. Would it be possible to extract this information from the tables in the PERFSTAT schema for each database where we have... 26 Mar 2010 09:07
Query : Understand and Re-write
Hi, I cant understand what they are trying to fetch in the below query. Can anyone please explain me ? Also, Can anyone help me to re-write the following query, to understand better and get good performance : SELECT * FROM (SELECT NULL table_catalog, decode(owner, 'PUBLIC', NULL, owner) TABL... 27 Mar 2010 10:49
HA Problem with ORA-02019
On 24 Mar, 09:29, Jia Lu <roka...(a)gmail.com> wrote: Hi all  I created 2 multi master DBs and using materialize views to synchronize them.  The relation is Main - Sub, and when I insert/commit to either one , another site's table will be updated. My problem is when DB link failed, I cannot insert da... 24 Mar 2010 09:58
[Materialized Views over DB links]HA Problem with ORA-02019
Hi all I created 2 multi master DBs and using materialize views to synchronize them. The relation is Main - Sub, and when I insert/commit to either one , another site's table will be updated. My problem is when DB link failed, I cannot insert data into the normal DB it said ORA-02019. That will be a high a... 24 Mar 2010 06:34
best tutorial for installing oracle 10 for Solaris 10 x86
I am searching the net for the installation steps of Oracle 10g for Solaris 10 x86 but with big differencies. Can anybody guide me to the accurate one ? ... 23 Mar 2010 14:45
SQL Function call does not fail on no_data_found ?
10gR2: given a function (in package "test") like this: FUNCTION get_ename (p_empno IN NUMBER) RETURN VARCHAR2 IS l_ename VARCHAR2(90); BEGIN SELECT ename INTO l_ename FROM emp WHERE empno = p_empno ; RETURN l_ename ; END ; And a SQL function calls: select test.get_ename(7499) from ... 26 Mar 2010 11:55
oracle 10g disaster recoveries
I am interested in covering dr scenarios where two sister databases need to be rebuilt using backups and archivelogs 1) Database with archivelog backups going to least forward point in time I would like to know if i use recover until cancel command ...& then open database is there a way I can work out ( from a... 23 Mar 2010 15:55
Add second instance to EM database control
Hi, I have a server with one Oracle 10g database instance, and I configured the local Enterprise Manager database control for it. Now I added a second instance on the server, using the same Oracle home. Can I manage this new instance using the existing database control or do I have to configure a second database... 23 Mar 2010 11:16
First  |  Prev |  Next  |  Last
Pages: 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37