In the latest post, I documented how to copy/move high table data volume using GoldenGate Initial Load (with SPECIALRUN option).
Sometimes, we (dba/sysadmins) need to move HIGH data (tables with billion rows), in shortest time possible.
So, sharing useful tips, that helps to reach this goal.
Making GoldenGate Initial load work as PARALLEL:
More“How to sincronize high data volume with GoldenGate – Part II”
Due to ease in which we can go to the future or return to the past using Goldengate, it becomes increasingly necessary recover archives from backup, sometimes it is necessary to recover a several days.
To do it, generally we need large disk space, at this time, starts a searching for storage disks.
After finding a disk, is need to mount it, i performed with simply mount options in AIX.
ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors
A database is raising stack below on alertlog:
Errors in file /db/u7011/oracle/admin/MYDB/trace/MYDB_j002_22935.trc: ORA-12012: error on auto execute of job "SYS"."DRA_REEVALUATE_OPEN_FAILURES" ORA-48168: the ADR sub-system is not initialized ORA-06512: at "SYS.DBMS_IR", line 522
More“ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors”
Hi all!
After add a datafile in PRIMARY database, the STANDBY MRP stopped. An “ALTER DATABASE RECOVER MANAGED STANDBY DATABASE” does not solved te problem, as you see:
SQL> SELECT SEQUENCE#, Name, APPLIED FROM V$ARCHIVED_LOG where APPLIED 'YES' and SEQUENCE# ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; Database altered. SQL> SELECT SEQUENCE#, Name, APPLIED FROM V$ARCHIVED_LOG where APPLIED 'YES' and SEQUENCE# < (select max(SEQUENCE#) -1 from V$ARCHIVED_LOG); SEQUENCE# NAME APPLIED ---------- -------------------------------------------------------------------------------- --------- 15075 /db/u1004/oracle/admin/MYDB/arch/arch_1_823102978_15075.arc NO
More“After adding Datafile in Primary the MRP Stopped in Physical Standby (Dataguard)”
Problem:
In weblogic 11G, there are several JFR files in /tmp directory:
root@app1wsora3 tmp]# pwd; find . -name *.jfr |xargs ls -tlhr
/tmp
-rw——- 1 oracle oinstall 0 Aug 11 18:41 ./2016_06_02_13_50_22_4317/2016_08_11_18_41_43_4317.jfr
-rw——- 1 oracle oinstall 37M Aug 11 18:41 ./2016_06_02_13_50_22_4317/2016_08_01_11_22_51_4317.jfr
-rw——- 1 oracle oinstall 14M Aug 16 09:25 ./2016_06_02_13_50_15_4341/2016_08_16_03_24_12_4341.jfr
-rw——- 1 oracle oinstall 0 Aug 16 12:02 ./2016_06_02_13_50_15_4341/2016_08_16_12_02_02_4341.jfr
-rw——- 1 oracle oinstall 14M Aug 16 12:02 ./2016_06_02_13_50_15_4341/2016_08_16_09_25_39_4341.jfr
-rw——- 1 oracle oinstall 0 Aug 16 12:43 ./2016_06_02_13_50_24_4344/2016_08_16_12_43_28_4344.jfr
-rw——- 1 oracle oinstall 150M Aug 16 12:43 ./2016_06_02_13_50_24_4344/2016_08_16_12_17_36_4344.jfr
These files are from DMS (Dynamic Monitoring Service) and they are created when application server is running.
Hey everyone,
Finally, the last part of our flashback posts, FLASHBACK DATA ARCHIVE! If you didn’t have a chance to check the previous posts, please do not hesitate to take a look if you need or if you just get curious.
Flashback – Part 1 (Flashback Drop)
Flashback – Part 2 (Flashback Query)
Flashback – Part 3 (Flashback Versions Query)
Flashback – Part 4 (Flashback Transaction Query)
Flashback – Part 5 (Flashback Table)
Flashback – Part 6 (Flashback Database)
Well, there we go then 🙂
I was taking high workload with data load methods, so I decided to move out of comfort zone and fortunately discovered a excellent way to copy/move high data volume with GoldenGate Initial Load.
It’s well documented by Oracle and gavinsoorma.com (best and simple one).
# On source GoldenGate (ggsci>):
GGSCI> ADD EXTRACT load1, SOURCEISTABLE GGSCI> EDIT PARAMS load1 EXTRACT load1 userid ggate@goldengate RMTHOST target-mgr.grepora.com, MGRPORT 7809 RMTTASK replicat, GROUP load2 FORMAT LEVEL 4 ---Loading tables map CUSTOMER.TABLE1;
After migrating database to another host, port or SID, the error below started to happen when running a scenario.
“Of course” all mapped connection was right setted on Topology… But environment is complex, it’s possible something is missing…
java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:361) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:151) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595) at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java) at com.sunopsis.sql.SnpsConnection.c(SnpsConnection.java) at com.sunopsis.sql.h.run(h.java)
Ok, so something really is missing… But where?
Try to check this:
More“ODI 10gR1: Connection to Repository Failed after Database Descriptor Change”
Hi,
Today, as in another normal days, I found a problem with ODI schedule in the newly created enviroment. While creating a schedule to scenario execution, then clicked in update schedule in Topology > Agents > OracleDIAgent, I received an exception:
ODI-1274: Agent Exception Caused by: Could not find the AgentScheduler instance in order to process 'OdiComputePlanning' request
Oracle support has a solution for this exception, but only for ODI 12c, it happens that my enviroment is ODI 11.1.1.6, in community oracle, has the same question, but, without answer.
Hi guys!
As you know, last week I was in 7th edition of GUOB Tech Day, in São Paulo/Brazil, part of OTN LA Tour. As it use to be, it was a great experience. As usual, after an opening with Oracle and OTN speech we had some parallel sessions, so I unfortunately had to choose only a few of them. But it think I made a good selection. Here is the list: