ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 删除redo出现的错误及解决办法。

删除redo出现的错误及解决办法。

原创 Linux操作系统 作者:jasoname 时间:2011-03-14 15:16:10 0 删除 编辑
问题的提出:






[oracle@server ORCL]$ ls
archivelog  autobackup  backupset  onlinelog
[oracle@server ORCL]$ cd autobackup/
[oracle@server autobackup]$ ls
2011_02_24
[oracle@server autobackup]$ cd 2011_02_24/
[oracle@server 2011_02_24]$ ls
o1_mf_s_743908358_6pbj07cn_.bkp
[oracle@server 2011_02_24]$ cd ..
[oracle@server autobackup]$ cd ..
[oracle@server ORCL]$ ls
archivelog  autobackup  backupset  onlinelog
[oracle@server ORCL]$ cd backupset/
[oracle@server backupset]$ ls
2011_02_24
[oracle@server backupset]$ cd ..
[oracle@server ORCL]$ pwd
/oracle/flash_recovery_area/ORCL
[oracle@server ORCL]$ ls
archivelog  autobackup  backupset  onlinelog
[oracle@server ORCL]$ ls
archivelog  autobackup  backupset  onlinelog
[oracle@server ORCL]$ cd ,,
-bash: cd: ,,: No such file or directory
[oracle@server ORCL]$ cd ..
[oracle@server flash_recovery_area]$ cd ..
[oracle@server ~]$ cleaqr
-bash: cleaqr: command not found
[oracle@server ~]$ clear




























[oracle@server ~]$ ls
admin    database             oradata       product
databak  flash_recovery_area  oraInventory  report.txt
[oracle@server ~]$ mv flash_recovery_area flash_recovery_area_bak
[oracle@server ~]$ ls -l
total 108
drwxr-x---  3 oracle oinstall  4096 Jan 25 23:51 admin
drwxr-xr-x  2 oracle oinstall  4096 Mar 11 05:50 databak
drwxr-xr-x  6 oracle oinstall  4096 Jul  3  2005 database
drwxr-x---  3 oracle oinstall  4096 Jan 25 23:52 flash_recovery_area_bak
drwxr-x---  3 oracle oinstall  4096 Jan 25 23:51 oradata
drwxrwx---  6 oracle oinstall  4096 Jan 25 23:51 oraInventory
drwxrwx---  3 oracle oinstall  4096 Jan 25 23:49 product
-rw-r--r--  1 oracle oinstall 75370 Feb 24 01:04 report.txt
[oracle@server ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 13 23:18:54 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immeidate
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux Error: 2: No such file or directory
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@server ~]$ rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Mar 13 23:19:45 2011

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

connected to target database (not started)

RMAN> startup mount

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 03/13/2011 23:19:49
RMAN-04014: startup failed: ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux Error: 2: No such file or directory

RMAN> exit


Recovery Manager complete.
[oracle@server ~]$ ls
admin    database                 oradata       product
databak  flash_recovery_area_bak  oraInventory  report.txt
[oracle@server ~]$ clear

[oracle@server ~]$ ls
admin    database                 oradata       product
databak  flash_recovery_area_bak  oraInventory  report.txt
[oracle@server ~]$ mv flash_recovery_area_bak flash_recovery_area
[oracle@server ~]$ ls
admin    database             oradata       product
databak  flash_recovery_area  oraInventory  report.txt
[oracle@server ~]$ rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Mar 13 23:20:31 2011

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

connected to target database (not started)

RMAN> startup

Oracle instance started
database mounted
database opened

Total System Global Area     285212672 bytes

Fixed Size                     1218968 bytes
Variable Size                 67110504 bytes
Database Buffers             209715200 bytes
Redo Buffers                   7168000 bytes

RMAN> exit


Recovery Manager complete.
[oracle@server ~]$ clear
























[oracle@server ~]$ ls -l
total 108
drwxr-x---  3 oracle oinstall  4096 Jan 25 23:51 admin
drwxr-xr-x  2 oracle oinstall  4096 Mar 11 05:50 databak
drwxr-xr-x  6 oracle oinstall  4096 Jul  3  2005 database
drwxr-x---  3 oracle oinstall  4096 Jan 25 23:52 flash_recovery_area
drwxr-x---  3 oracle oinstall  4096 Jan 25 23:51 oradata
drwxrwx---  6 oracle oinstall  4096 Jan 25 23:51 oraInventory
drwxrwx---  3 oracle oinstall  4096 Jan 25 23:49 product
-rw-r--r--  1 oracle oinstall 75370 Feb 24 01:04 report.txt
[oracle@server ~]$ cd oradata/
[oracle@server oradata]$ ls
orcl
[oracle@server oradata]$ cd orcl/
[oracle@server orcl]$ ls -l
total 3159456
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:20 control01.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:20 control02.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:20 control03.ctl
-rw-r-----  1 oracle oinstall  104865792 Mar 13 23:20 example01.dbf
-rw-r-----  1 oracle oinstall 2097160192 Mar 13 23:20 perfstat.dbf
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo01.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo02.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo03.log
-rw-r-----  1 oracle oinstall  283123712 Mar 13 23:20 sysaux01.dbf
-rw-r-----  1 oracle oinstall  513810432 Mar 13 23:20 system01.dbf
-rw-r-----  1 oracle oinstall   20979712 Mar 13 22:34 temp01.dbf
-rw-r-----  1 oracle oinstall   31465472 Mar 13 23:20 undotbs01.dbf
-rw-r-----  1 oracle oinstall    5251072 Mar 13 23:20 users01.dbf
[oracle@server orcl]$ mv redo01.log redo01
[oracle@server orcl]$ ls -l
total 3159456
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:21 control01.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:21 control02.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:21 control03.ctl
-rw-r-----  1 oracle oinstall  104865792 Mar 13 23:20 example01.dbf
-rw-r-----  1 oracle oinstall 2097160192 Mar 13 23:20 perfstat.dbf
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo01
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo02.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo03.log
-rw-r-----  1 oracle oinstall  283123712 Mar 13 23:20 sysaux01.dbf
-rw-r-----  1 oracle oinstall  513810432 Mar 13 23:20 system01.dbf
-rw-r-----  1 oracle oinstall   20979712 Mar 13 22:34 temp01.dbf
-rw-r-----  1 oracle oinstall   31465472 Mar 13 23:20 undotbs01.dbf
-rw-r-----  1 oracle oinstall    5251072 Mar 13 23:20 users01.dbf
[oracle@server orcl]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 13 23:21:20 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

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

Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size              67110504 bytes
Database Buffers          209715200 bytes
Redo Buffers                7168000 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/oradata/orcl/redo01.log'


SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> startup   
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/oradata/orcl/redo01.log'


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SQL> clear screen

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@server orcl]$ rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Mar 13 23:23:07 2011

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

connected to target database: ORCL (DBID=1269178685, not open)

RMAN> mount database;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/13/2011 23:23:13
ORA-01100: database already mounted

RMAN> restore database;

Starting restore at 13-MAR-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=152 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to /oracle/oradata/orcl/example01.dbf
restoring datafile 00006 to /oracle/oradata/orcl/perfstat.dbf
channel ORA_DISK_1: reading from backup piece /oracle/flash_recovery_area/ORCL/backupset/2011_02_24/o1_mf_nnndf_TAG20110224T011121_6pbhxsj7_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/flash_recovery_area/ORCL/backupset/2011_02_24/o1_mf_nnndf_TAG20110224T011121_6pbhxsj7_.bkp tag=TAG20110224T011121
channel ORA_DISK_1: restore complete, elapsed time: 00:01:16
Finished restore at 13-MAR-11

RMAN> recover database;

Starting recover at 13-MAR-11
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 11 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2011_02_24/o1_mf_1_11_6pds3hf3_.arc
archive log thread 1 sequence 12 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2011_02_25/o1_mf_1_12_6ph6hyyn_.arc
archive log thread 1 sequence 13 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2011_02_26/o1_mf_1_13_6pj9wrqr_.arc
archive log thread 1 sequence 14 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2011_03_10/o1_mf_1_14_6qhfvysn_.arc
archive log thread 1 sequence 15 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2011_03_11/o1_mf_1_15_6qlk9cqp_.arc
archive log thread 1 sequence 16 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2011_03_13/o1_mf_1_16_6qsohwcy_.arc
archive log thread 1 sequence 17 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2011_03_13/o1_mf_1_17_6qsppx74_.arc
archive log thread 1 sequence 18 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2011_03_13/o1_mf_1_18_6qsq8z08_.arc
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=10
channel ORA_DISK_1: reading from backup piece /oracle/flash_recovery_area/ORCL/backupset/2011_02_24/o1_mf_annnn_TAG20110224T011236_6pbj05tk_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/flash_recovery_area/ORCL/backupset/2011_02_24/o1_mf_annnn_TAG20110224T011236_6pbj05tk_.bkp tag=TAG20110224T011236
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2011_03_13/o1_mf_1_10_6qsrg1ro_.arc thread=1 sequence=10
channel default: deleting archive log(s)
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2011_03_13/o1_mf_1_10_6qsrg1ro_.arc recid=20 stamp=745716289
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2011_02_24/o1_mf_1_11_6pds3hf3_.arc thread=1 sequence=11
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2011_02_25/o1_mf_1_12_6ph6hyyn_.arc thread=1 sequence=12
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2011_02_26/o1_mf_1_13_6pj9wrqr_.arc thread=1 sequence=13
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2011_03_10/o1_mf_1_14_6qhfvysn_.arc thread=1 sequence=14
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2011_03_11/o1_mf_1_15_6qlk9cqp_.arc thread=1 sequence=15
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2011_03_13/o1_mf_1_16_6qsohwcy_.arc thread=1 sequence=16
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/13/2011 23:25:34
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/oracle/flash_recovery_area/ORCL/archivelog/2011_03_13/o1_mf_1_16_6qsohwcy_.arc'
ORA-00283: recovery session canceled due to errors
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/oradata/orcl/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

RMAN> exitr

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01008: the bad identifier was: exitr
RMAN-01007: at line 1 column 1 file: standard input

RMAN> exit


Recovery Manager complete.
[oracle@server orcl]$ clear

[oracle@server orcl]$ ls -l
total 3149204
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:26 control01.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:26 control02.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:26 control03.ctl
-rw-r-----  1 oracle oinstall  104865792 Mar 13 23:25 example01.dbf
-rw-r-----  1 oracle oinstall 2097160192 Mar 13 23:25 perfstat.dbf
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo01
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo02.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:21 redo03.log
-rw-r-----  1 oracle oinstall  272637952 Mar 13 23:25 sysaux01.dbf
-rw-r-----  1 oracle oinstall  513810432 Mar 13 23:25 system01.dbf
-rw-r-----  1 oracle oinstall   20979712 Mar 13 22:34 temp01.dbf
-rw-r-----  1 oracle oinstall   31465472 Mar 13 23:25 undotbs01.dbf
-rw-r-----  1 oracle oinstall    5251072 Mar 13 23:25 users01.dbf
[oracle@server orcl]$ cp redo02.log redo01.log
[oracle@server orcl]$ ls -l
total 3200464
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:26 control01.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:26 control02.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:26 control03.ctl
-rw-r-----  1 oracle oinstall  104865792 Mar 13 23:25 example01.dbf
-rw-r-----  1 oracle oinstall 2097160192 Mar 13 23:25 perfstat.dbf
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo01
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:26 redo01.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo02.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:21 redo03.log
-rw-r-----  1 oracle oinstall  272637952 Mar 13 23:25 sysaux01.dbf
-rw-r-----  1 oracle oinstall  513810432 Mar 13 23:25 system01.dbf
-rw-r-----  1 oracle oinstall   20979712 Mar 13 22:34 temp01.dbf
-rw-r-----  1 oracle oinstall   31465472 Mar 13 23:25 undotbs01.dbf
-rw-r-----  1 oracle oinstall    5251072 Mar 13 23:25 users01.dbf
[oracle@server orcl]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 13 23:26:31 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/oradata/orcl/system01.dbf'


SQL> recover datafile datafile1
ORA-02236: invalid file name


SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-00341: log 1 of thread 1, wrong log # 2 in header
ORA-00312: online log 1 thread 1: '/oracle/oradata/orcl/redo01.log'


SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@server orcl]$ ls -l
total 3200464
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:27 control01.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:27 control02.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:27 control03.ctl
-rw-r-----  1 oracle oinstall  104865792 Mar 13 23:25 example01.dbf
-rw-r-----  1 oracle oinstall 2097160192 Mar 13 23:25 perfstat.dbf
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo01
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:26 redo01.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo02.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:21 redo03.log
-rw-r-----  1 oracle oinstall  272637952 Mar 13 23:25 sysaux01.dbf
-rw-r-----  1 oracle oinstall  513810432 Mar 13 23:27 system01.dbf
-rw-r-----  1 oracle oinstall   20979712 Mar 13 22:34 temp01.dbf
-rw-r-----  1 oracle oinstall   31465472 Mar 13 23:25 undotbs01.dbf
-rw-r-----  1 oracle oinstall    5251072 Mar 13 23:25 users01.dbf
[oracle@server orcl]$ rm redo01.log
[oracle@server orcl]$ mv redo01 redo01.log
[oracle@server orcl]$ clear

[oracle@server orcl]$ ls -l
total 3149204
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:27 control01.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:27 control02.ctl
-rw-r-----  1 oracle oinstall    7061504 Mar 13 23:27 control03.ctl
-rw-r-----  1 oracle oinstall  104865792 Mar 13 23:25 example01.dbf
-rw-r-----  1 oracle oinstall 2097160192 Mar 13 23:25 perfstat.dbf
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo01.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:20 redo02.log
-rw-r-----  1 oracle oinstall   52429312 Mar 13 23:21 redo03.log
-rw-r-----  1 oracle oinstall  272637952 Mar 13 23:25 sysaux01.dbf
-rw-r-----  1 oracle oinstall  513810432 Mar 13 23:27 system01.dbf
-rw-r-----  1 oracle oinstall   20979712 Mar 13 22:34 temp01.dbf
-rw-r-----  1 oracle oinstall   31465472 Mar 13 23:25 undotbs01.dbf
-rw-r-----  1 oracle oinstall    5251072 Mar 13 23:25 users01.dbf
[oracle@server orcl]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 13 23:28:03 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/oradata/orcl/system01.dbf'


SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size              67110504 bytes
Database Buffers          209715200 bytes
Redo Buffers                7168000 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/oradata/orcl/system01.dbf'

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22741583/viewspace-689391/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-01-22

  • 博文量
    146
  • 访问量
    236460