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
ORA-00289: suggestion : /oradata/arch/1_75366_821021837.arc
ORA-00280: change 888715427 for thread 1 is in sequence #75366

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 888718275 generated at 01/30/2014 14:01:50 needed for thread
1
ORA-00289: suggestion : /oradata/arch/1_75367_821021837.arc
ORA-00280: change 888718275 for thread 1 is in sequence #75367

Log applied.
Media recovery complete.
SQL> alter database open;

Database altered.

SQL> select *from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 zghfin
oracle103
11.2.0.1.0 09-FEB-14 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@oracle103 ~]$ ls
arch1.txt Documents Music Pictures start.sh Templates zgh21031127.html
Desktop Downloads oradiag_oracle Public stop.sh Videos
[oracle@oracle103 ~]$ ls
arch1.txt Documents Music Pictures start.sh Templates zgh21031127.html
Desktop Downloads oradiag_oracle Public stop.sh Videos
[oracle@oracle103 ~]$ ./stop.sh
****************************************
stop listener
****************************************

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-FEB-2014 14:11:55

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6.103)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
****************************************
stop oracle database instance
****************************************

SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 9 14:11:55 2014

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

SQL> Connected.
SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
*******************************************
stop oracle database instance successfully

[oracle@oracle103 ~]$ ./start.sh
start listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-FEB-2014 14:12:15

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /u01/app/oracle/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/oracle103/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.6.103)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6.103)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 09-FEB-2014 14:12:15
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oracle103/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.6.103)(PORT=1521)))
Services Summary...
Service "zghfin" has 1 instance(s).
Instance "zghfin", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
***************************************
start oracle database instance
****************************************

SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 9 14:12:15 2014

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

SQL> Connected to an idle instance.
SQL> 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.
Database opened.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
****************************************
start oracle database instance successfully
****************************************
[oracle@oracle103 ~]$ 2014/2/9

ITPub博客

ORA-01113: file 5 needs media recovery ORA-01110: data file 5

最新文章