2011-10-31

Oracle GoldenGate how to

Unlike Active Data Guard, GoldenGate captures primary database changes by reading redo records from disk, transforming those records into a platform independent trail file format, and transmitting the trail file to the target database. GoldenGate maintains a logical replica by converting the trail file into SQL and applying SQL to the target database. The target database is open read-write while synchronization occurs.  While this provides substantial flexibility as a replication solution when compared to Data Guard, care must be taken to insure that the target database is not modified independent of the source, unless it is explicitly desired to do so. 

http://gavinsoorma.com/2010/02/goldengate-concepts-and-architecture/

NFS and Oracle GoldenGate

Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate [ID 1232303.1]

2011-10-26

Job AUTO_SPACE_ADVISOR_JOB takes too long

The Job AUTO_SPACE_ADVISOR_JOB Takes Long Time And Result In Status STOPPED [ID 1069782.1]

11G password in DBA_USERS

User Passwords Are No Longer Visible In DBA_USERS As Of 11g [ID 735651.1]

2011-10-06

timp

'Ai puţin timp la dispoziţie, aşa ca nu îl irosi trăind vieţile altora'
Steve Jobs

ORA-19587 ORA-27091 ORA-27067




Can RMAN restore from Backupset Copied From Tape? [ID 1111603.1]