This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Dec 13, 2012 12:45 AM by user13420250 Go to original post RSS
  • 15. Re: Controlfile not present in ASM
    user13420250 Newbie
    Currently Being Moderated
    SQL> show parameter db_recover

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    db_recovery_file_dest string +FRA
    db_recovery_file_dest_size big integer 60G
    SQL> select open_mode from v$database;

    OPEN_MODE
    --------------------
    READ WRITE

    SQL> select name, status from v$controlfile;

    NAME
    --------------------------------------------------------------------------------
    STATUS
    -------
    +NGPDATA/ngp01/controlfile/current.263.796827271


    +FRA/ngp01/controlfile/current.3434.796827271



    connected to recovery catalog database

    RMAN> show all;

    RMAN configuration parameters for database with db_unique_name NGP01I are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/usr/local/oracle/11.2.0/dbs/snapcf_NGP01i4.f'; # default

    The lsof command shows to much. What do you want with that ?

    Edited by: user13420250 on 12-dec-2012 5:53
  • 16. Re: Controlfile not present in ASM
    Levi-Pereira Guru
    Currently Being Moderated
    Hi,
    The info provided here is not enough to identify your issue.

    But my conclusion is:
    Database doesn't archivelog or allow you connect with RMAN if one or more controlfile is missing while database was started:
    $ rman target /
    
    Recovery Manager: Release 11.2.0.3.0 - Production on Wed Dec 12 13:53:36 2012
    
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-06003: ORACLE error from target database:
    ORA-00210: cannot open the specified control file
    ORA-00202: control file:  <path>/<controlfilename>
    ORA-27041: unable to open file
    So, I think you are doing something wrong.
  • 17. Re: Controlfile not present in ASM
    user13420250 Newbie
    Currently Being Moderated
    I think the database was started with the controlfiles present
    Thats why it's running fine now.
    I can connect with rman, thats no problem.

    I only thougt, that now the caontrolfiles are not in place anymore, the database would show some errors or something. But it seems the db doesn't care the controlfiles are not there anymore.
    Only when stopping and starting it again I guess
    But once running, the controlfile is in memory ?
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points