See this example:
ORA-17502: ksfdcre:4 Failed to create file +FRA/ngp01/controlfile/c-1446976194-20121210-02 CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
The directory structure to store AUTOBACKUP using FRA is
SQL> show parameter db_recover NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string +FRA db_recovery_file_dest_size big integer 4977M RMAN> show all; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; RMAN> backup current controlfile; Starting backup at 11-DEC-12 using channel ORA_DISK_1 using channel ORA_DISK_2 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 11-DEC-12 channel ORA_DISK_1: finished piece 1 at 11-DEC-12 piece handle=+FRA/prod/backupset/2012_12_11/ncnnf0_tag20121211t102929_0.278.8 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 11-DEC-12 Starting Control File and SPFILE Autobackup at 11-DEC-12 piece handle=+FRA/prod/autobackup/2012_12_11/s_801743371.275.801743371 commen Finished Control File and SPFILE Autobackup at 11-DEC-12
user13420250 wrote:I think you are confused about the error.
Thnx levi !
But the backup is no longer a problem.
That part we already solved. The question is now, how the database can continue to run without controlfiles.
The current controlfiles are not were they are supposed to be.
I was wondering if anybody has experienced this same issue. A database that keeps running normal without its controlfiles.
Database abort if any failure occur on Controlfile.
ORA-19504: failed to create file "+FRA/ngp01/controlfile/c-1446976194-20121210-02" ORA-17502: ksfdcre:4 Failed to create file +FRA/ngp01/controlfile/c-1446976194-20121210-02 ORA-15173: entry 'ngp01' does not exist in directory '/' SQL> select name from v$controlfile; NAME +FRA/ngp01/controlfile/current.3434.796827271
Please don't mix database ( eg. ngp01 and npg02i)
RMAN-03009: failure of validate command on ORA_DISK_1 channel at 12/11/2012 14:23:05 ORA-19962: compression algorithm +NGPDATA/ngp01/controlfile/current.263.796827271 is not valid with release ORA-15173: entry 'ngp01' does not exist in directory '/' ASMCMD> cd NGPDATA ASMCMD> cd ngp01 ASMCMD-08002: entry 'ngp01' does not exist in directory '+NGPDATA/'
$ export ORACLE_SID=ngp01 $ sqlpus / as sysdba SQL> show parameter db_recover SQL> select open_mode from v$database; SQL> select name,status from v$controlfile; $ rman target / RMAN > show all; RMAN> validate current controlfile; RMAN> backup current controlfile; $ export ORACLE_HOME=<GRID_HOME> $ export ORACLE_SID=+ASM $ asmcmd lsof |grep controlfile |grep ngp01