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>
