Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Oracle 11gR2 RAC Enable Archive log Mode.

  1. #1
    Oracle Administrator
    Join Date
    Dec 2011
    Posts
    92

    Oracle 11gR2 RAC Enable Archive log Mode.

    In the cluster log in from anyone of the instances.

    In my case it is DELL1

    [oracle@rac1 ~]$ export ORACLE_SID=dell1
    [oracle@rac1 ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 4 16:38:15 2012

    Copyright (c) 1982, 2009, Oracle. All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options

    # Remove this instance from the cluster.

    SQL> alter system set cluster_database=false scope=spfile sid='dell1';

    System altered.


    # Stop the whole database.

    [oracle@rac1 ~]$ srvctl stop database -d dell


    # Start this instance in mount mode and enable archive log mode.

    [oracle@rac1 ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 4 16:41:08 2012

    Copyright (c) 1982, 2009, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL> startup mount
    ORACLE instance started.

    Total System Global Area 535662592 bytes
    Fixed Size 1337720 bytes
    Variable Size 390071944 bytes
    Database Buffers 138412032 bytes
    Redo Buffers 5840896 bytes
    Database mounted.



    SQL> alter database archivelog;

    Database altered.

    SQL> alter system set cluster_database=true scope=spfile sid='dell1';

    System altered.

    SQL> shutdown immediate
    ORA-01109: database not open


    Database dismounted.
    ORACLE instance shut down.

    # Start the whole database.

    [oracle@rac1 ~]$ srvctl start database -d dell

    [oracle@rac1 ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 4 16:44:49 2012

    Copyright (c) 1982, 2009, Oracle. All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options

    SQL> archive log list;
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 1
    Next log sequence to archive 2
    Current log sequence 2
    Last edited by ajaychandi; 11-25-2012 at 12:15 PM.

+ Reply to Thread

Similar Threads

  1. Enable block change tracking in Oracle for RMAN backups
    By Amit in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 2
    Last Post: 02-03-2012, 02:04 PM
  2. Oracle 10g Enable Read Write On Physical Standby Database.
    By ajaychandi in forum DataGuard Setup and Management
    Replies: 0
    Last Post: 01-25-2012, 02:45 PM
  3. how check which object genrating how much archive
    By deviilm17 in forum Core Database Administration and Monitoring
    Replies: 2
    Last Post: 11-20-2011, 09:10 AM
  4. Start ,Stop,Enable,Disable Clusterware Processes / Daemons in Oracle RAC
    By Hemant in forum RAC Concepts and Administration
    Replies: 0
    Last Post: 11-04-2011, 01:01 PM
  5. Oracle Applications R12 - Enable and Collect Debug for HTTP, OC4J and OPMN
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-29-2011, 08:45 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics