achampav

l_view := 'create or replace view ' || l_table_schema || '.' || l_table_name || ' as select oid,' || l_view_select || ' from ' || l_exemple_table_name; 
raise notice '%',l_view;
execute l_view;

/* Création de la fonction trigger qui traitera à la volée les insert, update et delete */
l_function_view := 'create or replace function ' || l_table_schema || '.tf_' || l_table_name || '() returns trigger AS $FC$ 
begin
	if tg_op = ''INSERT'' then 
		insert into ' || l_exemple_table_name || l_insert_columns || ' values ' || l_insert_values || ';
		return new;

achampav

Tue Dec 06 17:10:26 2016
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Assigned to RFS process 23900
RFS[3]: Selected log 4 for thread 1 sequence 17 dbid -1432246771 branch 929889243
Tue Dec 06 17:10:26 2016
Media Recovery Waiting for thread 1 sequence 17 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 17 Reading mem 0
Mem# 0: +HISTO/testdg_dg03/onlinelog/group_4.260.929898091

achampav

SQL> alter system set log_archive_dest_state_2 = enable scope = both;

System altered.

SQL> alter system archive log current;

System altered.

achampav

SQL> alter database recover managed standby database cancel;

System altered.

SQL> alter database recover managed standby database using current logfile disconnect;

System altered.

achampav

SQL> alter system set fal_server = 'testdg_dg02' scope = both;

System altered.

achampav

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fal_client                           string      testdg_dg03_dg
fal_server                           string      testdg_dg01_dg

achampav

SQL> alter system set log_archive_dest_state_3 = defer scope = both;

System altered.

SQL> alter system set fal_client = 'testdg_dg02' scope = both;

System altered.

achampav

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_3                   string      service="testdg_dg03_dg", LGWR
                                                 ASYNC NOAFFIRM delay=0 option
                                                 al compression=disable max_fai
                                                 lure=0 max_connections=1 reope
                                                 n=300 db_unique_name="testdg_d
                                                 g03" net_timeout=30, valid_for
                                                 =(all_logfiles,primary_role)
fal_client                           string      testdg_dg02_dg,testdg_dg03_dg

achampav

SQL> alter system set log_archive_dest_2 = 'service=testdg_dg03_dg lgwr async noaffirm db_unique_name=testdg_dg03 valid_for=(all_logfiles,standby_role)' scope=both;

System altered.

SQL> show parameter fal

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fal_client                           string      TESTDG_DG02
fal_server                           string      testdg_dg01_dg

achampav

DGMGRL> add database testdg_dg03 as connect identifier is testdg_dg03_dg maintained as physical;
Database "testdg_dg03" added
DGMGRL> enable database testdg_dg03
Enabled.