Bonjour à tous ,
Cela fait 2 semaines que je galère sur la creation de mon environnement dataguard broker.
Je travail sur un environnement (redhat 5 oracle 11G R1).
----------------------------------------------------------------------------------
BASE PRINCIPALE
----------------------------------------------------------------------------------
Procesus de creation
-J'ai créé une base principale que jai appelé PRIMARY.
-Je l'ai mise en ARCHIVELOG
-Je l'ai mise en FORCE_LOGGING
-J'ai crée 4 standby redo lofile à l'ai de :
PRIMARY>alter database add standby logfile '/rep ' size 50M;
J'ai créer aussi un standby controfile à l'aide de:
PRIMARY>Alter Database Create Standby Controlfile as '/rep/control01.ctl';
que j'ai ensuite tranferer sur ma base de secours en temps que fichier de controle.
Ensuite voici mon listener.ora de PRIMARY ma base principale
Ensuite voici mon tnsnames.ora de PRIMARY ma base principaleLISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.159.132)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PRIMARY)
(ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1)
(SID_NAME=PRIMARY)
)
)
--------------------------------------------------------------PRIMARY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.159.132)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PRIMARY)
)
)
SECONDARY=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.159.133)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SECONDARY)
)
)
Jai créer un fichier de paramètre
PRIMARY> CREATE PFILE FROM SPFILE
Voici mon initPRIMARY.ora après modification
-------------------------------------------------------------------------------------------------PRIMARY.__db_cache_size=163577856
PRIMARY.__java_pool_size=12582912
PRIMARY.__large_pool_size=4194304
PRIMARY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
PRIMARY.__pga_aggregate_target=104857600
PRIMARY.__sga_target=318767104
PRIMARY.__shared_io_pool_size=0
PRIMARY.__shared_pool_size=134217728
PRIMARY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/PRIMARY/adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_files='/u01/app/oracle/oradata/PRIMARY/control01.ctl','/u01/app/oracle/oradata/PRIMARY/control02.ctl','/u01/app/oracle/oradata/PRIMARY/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='PRIMARY'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRIMARYXDB)'
*.memory_target=422576128
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
db_unique_name='PRIMARY'
FAL_Client='PRIMARY'
FAL_Server='SECONDARY'
Log_archive_config='DG_CONFIG=(PRIMARY,SECONDARY)'
Log_archive_dest_1='Location=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
Log_archive_dest_2='Service=SECONDARY lgwr async
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
db_unique_name=SECONDARY'
Log_archive_dest_state_1=ENABLE
Log_archive_dest_state_2=DEFER
Service_names='PRIMARY'
Standby_File_Management='AUTO'
BASE DE SECOURS
-------------------------------------------------------------------------------------------------
voici le contenu de mon fichier initSECONDARY.ora
Le fichier listener.oraSECONDARY.__db_cache_size=163577856
SECONDARY.__java_pool_size=12582912
SECONDARY.__large_pool_size=4194304
SECONDARY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
SECONDARY.__pga_aggregate_target=104857600
SECONDARY.__sga_target=318767104
SECONDARY.__shared_io_pool_size=0
SECONDARY.__shared_pool_size=134217728
SECONDARY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/SECONDARY/adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_files='/u01/app/oracle/oradata/SECONDARY/control01.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='PRIMARY'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest='/u01/app/oracle'
*.db_unique_name='SECONDARY'
*.dg_broker_start=TRUE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRIMARYXDB)'
*.Fal_client='SECONDARY'
*.fal_server='PRIMARY'
*.log_archive_config='dg_config=(SECONDARY,PRIMARY)'
*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST','valid_for=(ALL_LOGFILES, ALL_ROLES)'
*.log_archive_dest_2='service="PRIMARY"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name="PRIMARY" net_timeout=30','valid_for=(all_logfiles,primary_role)'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='ARC%S_%R.%T'
*.memory_target=422576128
*.log_archive_max_processes=30
*.log_archive_min_succeed_dest=1
*.log_archive_trace=0
*.log_file_name_convert='PRIMARY','SECONDARY'
*.standby_archive_dest=''
*.standby_file_management='AUTO'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
Pour mon fichier de mot de passe j 'ai dupliqué la pricipale que j'ai renommé.LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.159.133)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=SECONDARY)
(ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1)
(SID_NAME=SECONDARY)
)
)
_____________________________________________________
sur mon système de ma base de secours j'ai fait
Tout a bien fonctionné !!!
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6 $export ORACLE_SID=SECONDARY $SQLPLUS / as sysdba SECONDARY>CREATE SPFILE FROM PFILE; SECONDARY>STARTUP NOMOUNT SECONDARY>alter database mount standby database; SECONDARY>alter database recover managed standby database disconnect from session;
_____________________________________________________
sur mon système de ma base principale j'ai fait
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6 $export ORACLE_SID=PRIMARY $SQLPLUS / as sysdba PRIMARY>ALTER SYSTEM SET dg_broker_start=TRUE SCOPE=spfile; PRIMARY> shutdown abort; PRIMARY> startup; PRIMARY> exit
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12 DGMGRL> connect sys/manager@primary Connected. DGMGRL> CREATE CONFIGURATION sample AS PRIMARY DATABASE IS primary CONNECT IDENTIFIER IS primary; Configuration sample created with primary database primary DGMGRL> show configuration Configuration sample Protection Mode: MaxPerformance Databases: primary Primary database Fast-Start Failover: DISABLED Configuration Status: DISABLED
Merci d'avance pour tous ceux qui voudront bien m'aider.DGMGRL> ADD DATABASE ‘secondary’ AS CONNECT IDENTIFIER IS secondary MAINTAINED A
S PHYSICAL;
Error: ORA-16796: one or more properties could not be imported from the database
Failed. ???
Partager