mar 01 2011
Passer une base Oracle en archivelog mode.
Truc de base, mais j’arrive jamais à me souvenir….
- Vérifier l’etat de la base.
SQL> select name,log_mode from v$database; NAME LOG_MODE --------- ------------ MODEFRR1 NOARCHIVELOG
- Définir la destination des archives.
SQL> alter system set log_archive_dest_1='location=+DCLICDGR' scope=both sid='*'; System altered. SQL> show parameter log_archive_dest_1 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_1 string location=+DCLICDGR log_archive_dest_10 string ...
- Arrêt de la base.
$ srvctl stop database -d MODEFRR1
- Passage en mode archive.
$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Tue Mar 1 12:03:41 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2188072 bytes Variable Size 683674840 bytes Database Buffers 377487360 bytes Redo Buffers 5586944 bytes SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered.
- Démarrage 2eme instances.
$ srvctl start database -d MODEFRR1
- Vérification.
SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +DCLICDGR Oldest online log sequence 4 Next log sequence to archive 5 Current log sequence 5
- Commande (que j’oublie à chaque fois) pour générer des logs.
SQL> alter system archive log current; System altered. SQL> alter system switch logfile; System altered.