3 Nisan 2013 Çarşamba

[EN] 11G RAC ARCHIVELOG/NOARCHIVELOG MODE TRANSITION

ARCHIVELOG/NOARCHIVELOG mode transition is a little different in a RAC db than a standalone db.

You can see a transition example below;

11G NOARCHIVELOG to ARCHIVELOG mode transition


[DDD1]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> alter system set log_archive_dest_1= 'LOCATION=+ARCHIVE' scope=SPFILE sid='*';
SQL> alter system set log_archive_format = 'ddd_%t_%s_%r.arc' scope=SPFILE sid='*';
[DDD1]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> alter system set cluster_database=false scope=spfile sid = 'DDD1';

[DDD1]/u01/app/oracle/admin $ srvctl stop database -d DDD

[DDD1]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter system set cluster_database=true scope=spfile sid='DDD1';
SQL> shutdown immediate;

[DDD1]/u01/app/oracle/admin $ srvctl start database -d DDD

[DDD1]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> archive log list;

[DDD2]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> archive log list;

[DDD1]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> alter system switch logfile;

[DDD2]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> alter system switch logfile;

[+ASM1]/u01/app/oracle/admin/+ASM1 $ asmcmd -p
ASMCMD [+] > cd +ARCHIVE/DDD/ARCHIVELOG/*
ASMCMD [+ARCHIVE/DDD/ARCHIVELOG/2013_04_02] > ls
thread_1_seq_48988.329.811685445
thread_2_seq_48989.292.811685925

11G ARCHIVELOG to NOARCHIVELOG mode transition


[DDD1]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> alter system reset log_archive_dest_1 scope=SPFILE sid='*';
-- SQL> alter system reset log_archive_format scope=SPFILE sid='*'; (this command is optional)

[DDD1]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> alter system set cluster_database=false scope=spfile sid = 'DDD1';

[DDD1]/u01/app/oracle/admin $ srvctl stop database -d DDD

[DDD1]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter system set cluster_database=true scope=spfile sid='DDD1';
SQL> shutdown immediate;

[DDD1]/u01/app/oracle/admin $ srvctl start database -d DDD

[DDD1]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> archive log list;

[DDD2]/u01/app/oracle/admin $ sqlplus / as sysdba
SQL> archive log list;

Hiç yorum yok:

Yorum Gönder