ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 9 11:05:11 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database resetlogs;
alter database resetlogs
                       *
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE


SQL> ALTER DATABASE OPEN NORESETLOGS;
ALTER DATABASE OPEN NORESETLOGS
*
ERROR at line 1:
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL>  recover database using backup controlfile;

SQL>  recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 5: '/u02/oradata/JDA/rman01.dbf'
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u02/oradata/JDA/rman01.dbf'


SQL> recover datafile '/u02/oradata/JDA/rman01.dbf';
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using BACKUP CONTROLFILE;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 5: '/u02/oradata/JDA/rman01.dbf'
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u02/oradata/JDA/rman01.dbf'


SQL>
SQL> alter database resetlogs;
SQL> SP2-0734: unknown command beginning "SQL> alter..." - rest of line ignored.
SQL> alter database resetlogs
  2                         *
  3  ERROR at line 1:
  4  ORA-02231: missing or invalid option to ALTER DATABASE
  5
SQL>
SQL> SQL> ALTER DATABASE OPEN NORESETLOGS;
SP2-0734: unknown command beginning "SQL> ALTER..." - rest of line ignored.
SQL> ALTER DATABASE OPEN NORESETLOGS
  2  *
  3  ERROR at line 1:
  4  ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
  5
SQL>
SQL> SQL>  recover database using backup controlfile;
SP2-0734: unknown command beginning "SQL>  reco..." - rest of line ignored.
SQL>
SQL> SQL>  recover database using backup controlfile;
SP2-0734: unknown command beginning "SQL>  reco..." - rest of line ignored.
SQL> ORA-00283: recovery session canceled due to errors
SP2-0734: unknown command beginning "ORA-00283:..." - rest of line ignored.
SQL> ORA-01110: data file 5: '/u02/oradata/JDA/rman01.dbf'
SP2-0734: unknown command beginning "ORA-01110:..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL> alter database backup controlfile to '/u02/controlnew01.ctl';

Database altered.

SQL> alter database backup controlfile to trace as '/u02/controlfa.ctl';

Database altered.

SQL>
STARTUP NOMOUNTSQL>
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> CREATE CONTROLFILE REUSE DATABASE "JDA" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
  2    3      MAXLOGMEMBERS 3
  4      MAXDATAFILES 100
  5      MAXINSTANCES 8
  6      MAXLOGHISTORY 292
  7  LOGFILE
  8    GROUP 1 '/u02/oradata/JDA/redo01.log'  SIZE 50M BLOCKSIZE 512,
  9    GROUP 2 '/u02/oradata/JDA/redo02.log'  SIZE 50M BLOCKSIZE 512,
 10    GROUP 3 '/u02/oradata/JDA/redo03.log'  SIZE 50M BLOCKSIZE 512
 11  -- STANDBY LOGFILE
 12  DATAFILE
 13    '/u02/oradata/JDA/system01.dbf',
 14    '/u02/oradata/JDA/sysaux01.dbf',
 15    '/u02/oradata/JDA/undotbs01.dbf',
 16    '/u02/oradata/JDA/users01.dbf',
 17    '/u02/oradata/JDA/rman01.dbf'
 18  CHARACTER SET AL32UTF8
 19  ;
CREATE CONTROLFILE REUSE DATABASE "JDA" NORESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01100: database already mounted


SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> STARTUP NOMOUNT
ORACLE instance started.

Total System Global Area 6981558272 bytes
Fixed Size                  2234840 bytes
Variable Size            1191183912 bytes
Database Buffers         5771362304 bytes
Redo Buffers               16777216 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "JDA" NORESETLOGS  ARCHIVELOG
  2      MAXLOGFILES 16
  3      MAXLOGMEMBERS 3
  4      MAXDATAFILES 100
  5      MAXINSTANCES 8
  6      MAXLOGHISTORY 292
  7  LOGFILE
  8    GROUP 1 '/u02/oradata/JDA/redo01.log'  SIZE 50M BLOCKSIZE 512,
  9    GROUP 2 '/u02/oradata/JDA/redo02.log'  SIZE 50M BLOCKSIZE 512,
 10    GROUP 3 '/u02/oradata/JDA/redo03.log'  SIZE 50M BLOCKSIZE 512
 11  -- STANDBY LOGFILE
 12  DATAFILE
 13    '/u02/oradata/JDA/system01.dbf',
 14    '/u02/oradata/JDA/sysaux01.dbf',
 15    '/u02/oradata/JDA/undotbs01.dbf',
 16    '/u02/oradata/JDA/users01.dbf',
 17    '/u02/oradata/JDA/rman01.dbf'
 18  CHARACTER SET AL32UTF8
 19  ;
CREATE CONTROLFILE REUSE DATABASE "JDA" NORESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u02/oradata/JDA/rman01.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


SQL> CREATE CONTROLFILE REUSE DATABASE "JDA" NORESETLOGS  ARCHIVELOG
  2      MAXLOGFILES 16
  3      MAXLOGMEMBERS 3
  4      MAXDATAFILES 100
  5      MAXINSTANCES 8
  6      MAXLOGHISTORY 292
  7  LOGFILE
  8    GROUP 1 '/u02/oradata/JDA/redo01.log'  SIZE 50M BLOCKSIZE 512,
  9    GROUP 2 '/u02/oradata/JDA/redo02.log'  SIZE 50M BLOCKSIZE 512,
 10    GROUP 3 '/u02/oradata/JDA/redo03.log'  SIZE 50M BLOCKSIZE 512
 11  -- STANDBY LOGFILE
 12  DATAFILE
 13    '/u02/oradata/JDA/system01.dbf',
 14    '/u02/oradata/JDA/sysaux01.dbf',
 15    '/u02/oradata/JDA/undotbs01.dbf',
 16    '/u02/oradata/JDA/users01.dbf'
 17    CHARACTER SET AL32UTF8
 18  ;

Control file created.

SQL> VARIABLE RECNO NUMBER;
SQL> EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('RETENTION POLICY','TO REDUNDANCY 1');

PL/SQL procedure successfully completed.

SQL> VARIABLE RECNO NUMBER;
SQL> EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON');

PL/SQL procedure successfully completed.

SQL> VARIABLE RECNO NUMBER;
EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','DEVICE TYPE DISK FORMAT   ''/u02/back/Backup%d_DB_%u_%s_%p''');
SQL>
PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>
SQL> SP2-0042: unknown command "SQL>" - rest of line ignored.
SQL>
SQL>
SQL> SP2-0042: unknown command "SQL>" - rest of line ignored.
SQL> VARIABLE RECNO NUMBER;
EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE','DISK TO 1');
SQL>
PL/SQL procedure successfully completed.

SQL>
SQL> RECOVER DATABASE
Media recovery complete.
SQL> ALTER SYSTEM ARCHIVE LOG ALL;

System altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/u02/oradata/JDA/temp01.dbf' REUSE;

Tablespace altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 6981558272 bytes
Fixed Size                  2234840 bytes
Variable Size            1191183912 bytes
Database Buffers         5771362304 bytes
Redo Buffers               16777216 bytes
Database mounted.
Database opened.
SQL>