SQL> startup force;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/orcl2/system01.dbf'
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
Database mounted.
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> @$HOME/recctl_orcl3.sql
CREATE CONTROLFILE REUSE DATABASE "ORCL2" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01100: database already mounted
SQL> startup force nomount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
SQL> @$HOME/recctl_orcl3.sql
Control file created.
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 open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/orcl2/system01.dbf'
SQL> recover database using backup controlfile;
ORA-00279: change 104646296 generated at 03/13/2017 01:04:21 needed for thread
1
ORA-00289: suggestion :
/home/oracle/app/oracle/fast_recovery_area1/ORCL2/log_archive_dest/1_1_938480657
.dbf
ORA-00280: change 104646296 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/home/oracle/app/oracle/oradata/orcl2/redo01.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL>
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/orcl2/system01.dbf'
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
Database mounted.
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> @$HOME/recctl_orcl3.sql
CREATE CONTROLFILE REUSE DATABASE "ORCL2" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01100: database already mounted
SQL> startup force nomount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 296456192 bytes
Fixed Size 2252664 bytes
Variable Size 272629896 bytes
Database Buffers 16777216 bytes
Redo Buffers 4796416 bytes
SQL> @$HOME/recctl_orcl3.sql
Control file created.
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 open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/orcl2/system01.dbf'
SQL> recover database using backup controlfile;
ORA-00279: change 104646296 generated at 03/13/2017 01:04:21 needed for thread
1
ORA-00289: suggestion :
/home/oracle/app/oracle/fast_recovery_area1/ORCL2/log_archive_dest/1_1_938480657
.dbf
ORA-00280: change 104646296 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/home/oracle/app/oracle/oradata/orcl2/redo01.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL>