Cette page vous affiche les différences entre la révision choisie et la version actuelle de la page.
dataguard_oracle_10g [2011/12/16 08:50] admin créée |
dataguard_oracle_10g [2011/12/17 10:18] (Version actuelle) admin |
||
---|---|---|---|
Ligne 13: | Ligne 13: | ||
Sur la base primaire YODA | Sur la base primaire YODA | ||
- | Mettre la base en archivelog | + | Configurer le fichier de mot de passe |
+ | <code> | ||
+ | cd $ORACLE_HOME/dbs | ||
+ | orapwd file=orapwYODA password=manager10 | ||
+ | </code> | ||
- | Forcer le mode logging | + | Mettre la base en archivelog |
<code> | <code> | ||
export ORACLE_SID=YODA | export ORACLE_SID=YODA | ||
sqlplus "/ as sysdba" | sqlplus "/ as sysdba" | ||
+ | SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archlog/YODA' scope = both; | ||
+ | SQL> alter system set log_archive_dest_state_1=enable scope=both; | ||
+ | SQL> alter system set log_archive_format='%t_%s_%r.dbf' scope=spfile; | ||
+ | SQL> shutdown immediate; | ||
+ | SQL> startup mount; | ||
+ | SQL> alter database archivelog; | ||
+ | SQL> alter database open; | ||
+ | </code> | ||
+ | Forcer le mode logging | ||
+ | <code> | ||
SQL> alter database force logging; | SQL> alter database force logging; | ||
SQL> select dbid, name, log_mode, force_logging from v$database; | SQL> select dbid, name, log_mode, force_logging from v$database; | ||
+ | |||
DBID NAME LOG_MODE FOR | DBID NAME LOG_MODE FOR | ||
---------- --------- ------------ --- | ---------- --------- ------------ --- | ||
4127263456 YODA ARCHIVELOG YES | 4127263456 YODA ARCHIVELOG YES | ||
SQL> exit; | SQL> exit; | ||
+ | </code> | ||
+ | |||
+ | Modifier certains paramètre du spfile | ||
+ | <code> | ||
+ | alter system set standby_file_management=auto scope=both; | ||
+ | alter system set archive_lag_target=900 scope=both; | ||
+ | alter system set db_unique_name=YODA scope=spfile; | ||
+ | shutdown immediate; | ||
+ | startup; | ||
+ | </code> | ||
+ | Créer un initLUKE.ora depuis le spfile de YODA | ||
+ | <code> | ||
+ | create pfile='$HOME/initLUKE.ora' from spfile; | ||
+ | </code> | ||
+ | Editer initLUKE.ora et changer toute occurence de YODA en LUKE **sauf pour db_name où il faut laisser YODA** | ||
+ | |||
+ | Ajouter les lignes suivants à initLUKE.ora | ||
+ | <code> | ||
+ | db_file_name_convert=('YODA','LUKE') | ||
+ | log_file_name_convert=('YODA','LUKE') | ||
+ | </code> | ||
+ | Exemple de fichier initLUKE.ora | ||
+ | <code> | ||
+ | archive_lag_target=900 | ||
+ | audit_file_dest='/u01/app/oracle/admin/LUKE/adump' | ||
+ | background_dump_dest='/u01/app/oracle/admin/LUKE/bdump' | ||
+ | control_files='/u01/app/oracle/oradata/LUKE/control01.ctl' | ||
+ | core_dump_dest='/u01/app/oracle/admin/LUKE/cdump' | ||
+ | db_block_size=8192 | ||
+ | db_name='YODA' | ||
+ | db_unique_name='LUKE' | ||
+ | log_archive_dest_1='LOCATION=/u01/app/oracle/archlog/LUKE' | ||
+ | log_archive_dest_state_1='ENABLE' | ||
+ | log_archive_format='%t_%s_%r.dbf' | ||
+ | pga_aggregate_target=160M | ||
+ | sga_target=640M | ||
+ | standby_file_management='AUTO' | ||
+ | undo_management='auto' | ||
+ | user_dump_dest='/u01/app/oracle/admin/LUKE/udump' | ||
+ | db_file_name_convert=('YODA','LUKE') | ||
+ | log_file_name_convert=('YODA','LUKE') | ||
+ | </code> | ||
+ | |||
+ | Il faut aussi vérifier que le remote password est en mode exclusive. | ||
+ | <code> | ||
+ | SQL> show parameter password | ||
+ | |||
+ | NAME TYPE VALUE | ||
+ | ------------------------------------ ----------- ------------------------------ | ||
+ | remote_login_passwordfile string EXCLUSIVE | ||
+ | </code> | ||
+ | |||
+ | Sauvegarde RMAN | ||
+ | <code> | ||
+ | rman target / nocatalog | ||
+ | configure default device type to disk; | ||
+ | configure device type disk backup type to compressed backupset; | ||
+ | configure channel device type disk format '/u01/app/oracle/backup/YODA/bck_%U'; | ||
+ | backup current controlfile for standby; | ||
+ | backup database plus archivelog; | ||
+ | </code> | ||
+ | Copier l'ensemble de la sauvegarde sur la base LUKE | ||
+ | <code> | ||
+ | cd /u01/app/oracle/backup/YODA | ||
+ | scp * oracle@192.168.1.102:/u01/app/oracle/backup/YODA | ||
+ | </code> | ||
+ | |||
+ | Sur la base secondaire, mettre en place les répertoires | ||
+ | <code> | ||
+ | mkdir -p /u01/app/oracle/admin/LUKE/adump | ||
+ | mkdir -p /u01/app/oracle/admin/LUKE/bdump | ||
+ | mkdir -p /u01/app/oracle/admin/LUKE/cdump | ||
+ | mkdir -p /u01/app/oracle/admin/LUKE/udump | ||
+ | mkdir -p /u01/app/oracle/admin/LUKE/pfile | ||
+ | mkdir -p /u01/app/oracle/oradata/LUKE | ||
+ | </code> | ||
+ | Mettre en place le fichier de mot de passe | ||
+ | <code> | ||
+ | cd $ORACLE_HOME/dbs | ||
+ | orapwd file=orapwLUKE password=manager10 | ||
</code> | </code> |