Last login: Sun Feb 9 14:06:37 2014 from 192.168.7.165
[oracle@oracle103 ~]$ env |grep ORA
ORACLE_SID=zghfin
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/11.2.0/db_1
[oracle@oracle103 ~]$ sqlplus /'as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 9 14:09:08 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.0310E+10 bytes
Fixed Size 2212976 bytes
Variable Size 1.9596E+10 bytes
Database Buffers 536870912 bytes
Redo Buffers 175132672 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/oradata/TUOIS_DAT01.dbf'
SQL> recover datafile 5;
ORA-00279: change 888701791 generated at 01/30/2014 14:01:14 needed for thread
1
ORA-00289: suggestion : /oradata/arch/1_75365_821021837.arc
ORA-00280: change 888701791 for thread 1 is in sequence #75365
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00279: change 888715427 generated at 01/30/2014 14:01:47 needed for thread
1
[oracle@oracle103 ~]$ env |grep ORA
ORACLE_SID=zghfin
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/11.2.0/db_1
[oracle@oracle103 ~]$ sqlplus /'as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 9 14:09:08 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.0310E+10 bytes
Fixed Size 2212976 bytes
Variable Size 1.9596E+10 bytes
Database Buffers 536870912 bytes
Redo Buffers 175132672 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/oradata/TUOIS_DAT01.dbf'
SQL> recover datafile 5;
ORA-00279: change 888701791 generated at 01/30/2014 14:01:14 needed for thread
1
ORA-00289: suggestion : /oradata/arch/1_75365_821021837.arc
ORA-00280: change 888701791 for thread 1 is in sequence #75365
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00279: change 888715427 generated at 01/30/2014 14:01:47 needed for thread
1