How to Shutdown and Startup Oracle Database on OGG

Target Database

Shutdown:

SQL> alter system set job_queue_processes=0;

~]$ lsnrctl stop

~]# ps -ef | grep 'LOCAL=NO' | grep orcl | kill -9 `awk '{print $2}'`

GGSCI> stop rept00
GGSCI> stop mgr

SQL> alter system switch logfile;
SQL> alter system checkpoint;
SQL> shutdown immediate

Startup:

SQL> startup

GGSCI> start mgr
GGSCI> start rept00

SQL> alter system set job_queue_processes=1000;

~]$ lsnrctl start

Source Database

SQL> alter system set job_queue_processes=0;

~]$ lsnrctl stop

GGSCI> info capt00, showch

SQL> SELECT 'ALTER SYSTEM KILL SESSION ''' || s.SID || ',' || s.SERIAL# || '''' || ';','kill -9 ' || p.spid,
s.status,
s.osuser,
s.machine,
t.xidusn,
t.XIDSLOT,
t.xidsqn,
t.used_ublk,
t.USED_UREC
FROM v$session s, v$process p, v$transaction t
where t.addr = s.taddr
and s.PADDR = p.ADDR
and s.username not in ('GOLDENGATE');

~]# ps -ef | grep 'LOCAL=NO' | grep orcl | kill -9 `awk '{print $2}'`

GGSCI> stop capt00
GGSCI> stop pump00
GGSCI> stop mgr

SQL> alter system switch logfile;
SQL> alter system checkpoint;
SQL> shutdown immediate

Startup:

SQL> startup

GGSCI> start mgr
GGSCI> start capt00
GGSCI> start pump00

SQL> alter system set job_queue_processes=1000;

~]$ lsnrctl start