1月11日，oracle恢复过程记录

2008-01-11 19:34:19

OCICPP Lib Exception: ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/DB_Data/oradata/nvs/nvsdata03.dbf'

ResetAllLensStatus or ResetAllMasterStatus error
OCICPP Lib Exception: ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/DB_Data/oradata/nvs/nvsdata03.dbf'

OCICPP Lib Exception: ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/DB_Data/oradata/nvs/nvsdata03.dbf'

linux:/usr/local/NVS # su - oracle

oracle@linux:~> sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 11 17:30:00 2008

Connected to:
Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production

SQL> select file#,status from v$datafile;

     FILE# STATUS
---------- -------
         1 SYSTEM
         2 ONLINE
         3 ONLINE
         4 ONLINE
         5 ONLINE
         6 ONLINE
         7 ONLINE
         8 ONLINE
         9 ONLINE
        10 ONLINE
        11 RECOVER

     FILE# STATUS
---------- -------
        12 RECOVER
        13 RECOVER

13 rows selected.

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

Total System Global Area 236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> recover datafile
ORA-02236: invalid file name

SQL>
SQL> recover datafile 11
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 11: '/DB_Data/oradata/nvs/nvsdata01.dbf'
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/DB_Data/oradata/nvs/nvsdata01.dbf'

SQL> recover datafile '/DB_Data/oradata/nvs/nvsdata01.dbf';
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 11: '/DB_Data/oradata/nvs/nvsdata01.dbf'
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/DB_Data/oradata/nvs/nvsdata01.dbf'

SQL> recover datafile '/DB_Data/oradata/nvs/nvsdata03.dbf";
ORA-01756: quoted string not properly terminated

SQL> alter database datafile '/DB_Data/oradata/nvs/nvsdata01.dbf' online;
alter database datafile '/DB_Data/oradata/nvs/nvsdata01.dbf' online
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/DB_Data/oradata/nvs/nvsdata01.dbf'

SQL> alter datafile '/DB_Data/oradata/nvs/nvsdata03.dbf';
alter datafile '/DB_Data/oradata/nvs/nvsdata03.dbf'
*
ERROR at line 1:
ORA-00940: invalid ALTER command

SQL> alter datafile '/DB_Data/oradata/nvs/nvsdata03.dbf' online;
alter datafile '/DB_Data/oradata/nvs/nvsdata03.dbf' online
*
ERROR at line 1:
ORA-00940: invalid ALTER command

SQL> select file#,status from v$datafile;

     FILE# STATUS
---------- -------
        12 RECOVER
        13 RECOVER

13 rows selected.

SQL> select * from dba_tablespaces;
select * from dba_tablespaces
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> recover datafile 13
Media recovery complete.
SQL> recover datafile 12
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 12: '/DB_Data/oradata/nvs/nvsdata02.dbf'
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: '/DB_Data/oradata/nvs/nvsdata02.dbf'

SQL> select file*,status from v$datafile;
select file*,status from v$datafile
*
ERROR at line 1:
ORA-00936: missing expression

SQL> select file#,status from v$datafile;

     FILE# STATUS
---------- -------
        12 RECOVER
        13 OFFLINE

13 rows selected.

SQL> recover dadafile 11
ORA-00905: missing keyword

SQL> recover datafile 11
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 11: '/DB_Data/oradata/nvs/nvsdata01.dbf'
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/DB_Data/oradata/nvs/nvsdata01.dbf'

SQL> alter database datafile 11 online;
alter database datafile 11 online
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/DB_Data/oradata/nvs/nvsdata01.dbf'

SQL> alter database create datafile 11;

Database altered.

SQL> select file#,status from v$datafile;

     FILE# STATUS
---------- -------
        12 RECOVER
        13 OFFLINE

13 rows selected.

SQL> recover datafile 11
Media recovery complete.
SQL>
SQL> alter database datafile 12;
alter database datafile 12
*
ERROR at line 1:
ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

SQL> alter database create datafile 12;

Database altered.

SQL>
SQL> recover datafile 12;
Media recovery complete.
SQL> select file#,status from v$datafile;

     FILE# STATUS
---------- -------
         1 SYSTEM
         2 ONLINE
         3 ONLINE
         4 ONLINE
         5 ONLINE
         6 ONLINE
         7 ONLINE
         8 ONLINE
         9 ONLINE
        10 ONLINE
        11 OFFLINE

     FILE# STATUS
---------- -------
        12 OFFLINE
        13 OFFLINE

13 rows selected.

SQL> alter
2 database datafile 11 online;

Database altered.

SQL> alter database datafile 12 online;

Database altered.

SQL> alter database datafile 13 online;

Database altered.

SQL> select file#,status from v$datafile;

     FILE# STATUS
---------- -------
         1 SYSTEM
         2 ONLINE
         3 ONLINE
         4 ONLINE
         5 ONLINE
         6 ONLINE
         7 ONLINE
         8 ONLINE
         9 ONLINE
        10 ONLINE
        11 ONLINE

     FILE# STATUS
---------- -------
        12 ONLINE
        13 ONLINE

13 rows selected.

SQL>
SQL>

本文出自 “知识大杂烩--龙道” 博客，请务必保留此出处http://skythanks.blog.51cto.com/6996/58908

昵称：
验证码：		点击图片可刷新验证码　　博客过2级，无需填写验证码
内容：