Tuesday, March 6, 2012

OGG-00529 DDL Replication is enabled but table OGG.GGS_DDL_HIST is not found

OGG-00529  DDL Replication is enabled but table OGG.GGS_DDL_HIST is not found

u must be in the goldengate directory..
 
 
SQL> alter system set recyclebin=off;
System altered.

SQL> @marker_setup
Marker setup script
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:OGG
Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGG
MARKER TABLE
-------------------------------
OK

MARKER SEQUENCE
-------------------------------
OK

Script complete.

SQL> @ddl_setup


OGG-00512

ERROR   OGG-00512  RECYCLEBIN must be turned off. For 10gr2 and up, set RECYCLEBIN in parameter file to OFF. For 10gr1, set _RECYCLEBIN in parameter file to FALSE. Then restart database and extract.

connect with sysdba ;

alter system set recyclebin=off scope=spfile;
  
then restart database
 
SQL> startup force
 
SQL> show parameter recyclebin 

recyclebin                           string      OFF
 
 

Sunday, March 4, 2012

Restore database with rman -- 'exclude tablespace' and fixing RMAN-06054


if u take rman backup with exclude tablespace and restore database with this script 

run {
set until time "to_date('2012-02-28 00:00:00','YYYY-MM-DD HH24:MI:SS')";
restore database;
recover database;
alter database open resetlogs;
}



u will get this error;

RMAN-06054: media recovery requesting unknown log:

u need to perform offline drop for excluded tablespace;

first of all;

rman> alter database open resetlogs;

ORA-01157: cannot identify/lock data file 39 - see DBWR trace file
ORA-01110: data file 39:

as u see data file 39 need to be droped ;

so just drop it offline;

RMAN> sql 'alter database datafile 39 offline drop';

sql statement: alter database datafile 39 offline drop

RMAN> alter database open resetlogs;

database opened


thats it..





Thursday, March 1, 2012

Cifs "mount error 13 = Permission denied"

most of ppl forget to put domainname before username ...
wrong one is
 mount -t cifs //Machinename/folderonwindows /mnt/folderonlinux/ -o username=username,password=password

correct one is
 mount -t cifs //Machinename/folderonwindows /mnt/folderonlinux/ -o username=domainname/username,password=password

and using direct ip instead of Machinename can cause trouble....