2 Replies Latest reply: Aug 15, 2013 11:58 PM by Red8 RSS

    unable to register database

    Red8

      Hi All,

       

      RMAN> register database;

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of register command at 08/15/2013 19:48:59

      RMAN-03014: implicit resync of recovery catalog failed

      RMAN-03009: failure of full resync command on default channel at 08/15/2013 19:48:59

      ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.f

      ORA-17502: ksfdcre:3 Failed to create file +ORALIN_RECO/snapcf_oralin.f

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted

       

      RMAN>

       

           I am facing this weird problem, here is how it happened i accidentally entered configure snapshot controlfile name to '+ORALIN_RECO/snapcf_oralin.f';

      and the disk entered group does not exist. So i tried to reset the snapshot control file location to the default but no luck. And here is the out put i am seeing

       

      RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of configure command at 08/15/2013 19:12:25       

      RMAN-03014: implicit resync of recovery catalog failed                

      RMAN-03009: failure of full resync command on default channel at 08/15/2013 19:12:25

      ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.f         

      ORA-17502: ksfdcre:3 Failed to create file +ORALIN_RECO/snapcf_oralin.f            

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

       

      RMAN>

       

      even tried to recreate the catalog, the user, tablespace, unregistered the database but nothing seems to be working

       

      Please see what i have tried

       

      RMAN> register database;

       

      database registered in recovery catalog

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03008: error while performing automatic resync of recovery catalog

      ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.f

      ORA-17502: ksfdcre:3 Failed to create file +ORALIN_RECO/snapcf_oralin.f  

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted      

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted      

       

      RMAN> configure channel 1 DEVICE TYPE DISK CLEAR;

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of configure command at 08/15/2013 18:55:32       

      RMAN-03014: implicit resync of recovery catalog failed                

      RMAN-03009: failure of full resync command on default channel at 08/15/2013 18:55:32

      ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.f         

      ORA-17502: ksfdcre:3 Failed to create file +ORALIN_RECO/snapcf_oralin.f            

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

       

      RMAN> configure channel DEVICE TYPE DISK CLEAR;

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of configure command at 08/15/2013 18:56:19       

      RMAN-03014: implicit resync of recovery catalog failed                

      RMAN-03009: failure of full resync command on default channel at 08/15/2013 18:56:19

      ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.f         

      ORA-17502: ksfdcre:3 Failed to create file +ORALIN_RECO/snapcf_oralin.f            

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

       

      RMAN> show snapshot controlfile name;     

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of show command at 08/15/2013 19:00:48            

      RMAN-03014: implicit resync of recovery catalog failed                

      RMAN-03009: failure of full resync command on default channel at 08/15/2013 19:00:48

      ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.f         

      ORA-17502: ksfdcre:3 Failed to create file +ORALIN_RECO/snapcf_oralin.f            

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

       

      RMAN> configure snapshot controlfile name to '++DB_DATA/ubsracdb/snapcf_ubsracdb.f' # default;

      2> ;                                                                                         

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of configure command at 08/15/2013 19:11:00       

      RMAN-03014: implicit resync of recovery catalog failed                

      RMAN-03009: failure of full resync command on default channel at 08/15/2013 19:11:00

      ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.f         

      ORA-17502: ksfdcre:3 Failed to create file +ORALIN_RECO/snapcf_oralin.f            

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

      ORA-15001: diskgroup "ORALIN_RECO" does not exist or is not mounted                

       

      RMAN>        Please help i really need ur expertise.

       

       

      thank you