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

最新推荐文章于 2024-02-03 22:13:26 发布
最新推荐文章于 2024-02-03 22:13:26 发布
阅读量443 收藏
点赞数
文章标签： 数据库
问题的提出：






[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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22741583/viewspace-689391/

cqc770206
关注
数据文件采用错误方式删除后的解决办法
cqszpx的博客
09-09 325
问题描述：当采用以下步骤删除数据文件后发现v$datafile视图中仍然有该文件记录,且状态recover，意识到该删除步骤有问题，生产环境中存在此种情况，此时作为dba应该怎么办？此时通过以下语句查询发现users02.dbf状态为recover，v$datafile中仍然有该数据文件记录,意识到操作错误.说明：users02.dbf被成功删除，系统层面及v$datafile中已不存在该文件记录。现在系统层面删除数据文件users02.dbf。实验目标：模拟该异常，并提供解决方案.
oracle丢失redo文件,Oracle在线 redo log文件丢失后的恢复
weixin_42511714的博客
04-04 464
今天一个开发库启动不了了，发过来报错一看是日志文件损坏了(见下图)，接着说了一下前因后果。说是年前服务器掉电了，然后就再没有启动起来过。今天有人用才想到要处理。先说一下大体的思路，如果损坏的redo log是INACTIVE状态的，也就是实例崩溃恢复用不到的redo log，那处理起来比较容易，直接alter database clear logfile group #;或alter databa...
oracle删除表redo,Oracle DataGuard环境增删REDO(最佳实践)
weixin_32340083的博客
04-03 640
整理一份DG环境下增删主备库REDO的最佳实践步骤1. 主库,备库都增加redo步骤说明:主库可正常添加 ORLS(REDO LOG)或SRLS(STANDBY REDO LOG)主库的STANDBY_FILE_MANAGEMENT无论是否auto 或Manuals都不会传播到备库, 但是为了避免主备切换后，redo不足问题，所以建议备库也相应的添加redo .1.1. 主库填加redo:ALTE...
Redo log 的添加与删除
weixin_34186931的博客
01-08 457
1 查看redo 信息 SQL> select group#,type, member from v$logfile;     GROUP# TYPE    MEMBER ---------- ------- -------------------------------------------------------------          3 ONLINE  /u01/ap...
REDO日志的删除添加实验
还不算晕的专栏
09-08 4932
1.重做日志组及MEMBER： 重做日志组可以控制了日志文件不至于太大，提高系统效率。 每个重做日志文件REDOLOG叫做成员 MEMBER，多个重做日志文件为一个重做日志组GROUP，ORACLE数据库正常工作需要至少两个重做日志组，默认一个组只有一个成员。 LGWR在任意时刻只能写一组重做日志组，LGWR后台 进程正在写的重做日志组称当前CURRENT重做日志组，LGWR把完全相同的
达梦数据库REDO日志误删解决方法
daimingw的博客
01-04 1071
达梦数据库REDO日志误删解决方法
删除redo所有日志,数据库无法启动
__Yoon
01-29 1727
OS: Oracle Linux Server release 5.7 DB: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production [oracle@yoon yoon]$ ls control01.ctl redo01.log redo02.log redo03.log sysaux01.d
oracle redo查询,Oracle的REDO和UNDO深入分析（转）
weixin_35741582的博客
04-02 1070
一、REDOOracle维护着两类重做日志文件：在线(online)重做日志文件和归档(archived)重做日志文件。在线重做日志用于在出现电源故障(实例终止)时“修正”数据文件，而归档重做日志用于在出现硬盘故障时或者误操作删除数据时，配合数据文件备份“修正”数据文件。每个Oracle数据库都至少有两个在线重做日志组，每个组中至少有一个成员(重做日志文件)。这些在线重做日志组以循环方式使用。可以...
undo和redo日志
zhangh9172的博客
04-30 706
数据库通常借助日志来实现事务，常见的有undo log、redo log undo/redo log都能保证事务特性，undo log实现事务原子性，redolog实现事务的持久性。 为了最大程度避免数据写入时io瓶颈带来的性能问题，MySQL采用了这样一种缓存机制： 当query修改数据库内数据时，InnoDB先将该数据从磁盘读取到内存中，修改内存中的数据拷贝，并将该修改行为持久化到磁盘上的事务日志（先写redo log buffer，再定期批量写入），而不是每次都直接将修改过的数据记录到硬盘内，等
oracle重启后ogg不能同步了,归档日志缺少导致ogg同步出现问题，解决办法
weixin_32715349的博客
04-05 885
迁移数据库的过程中，最后启动ggs启动完ggs后发现抽取进程报错，查看日志发现报错如下：2016-03-16 00:15:42 INFO OGG-01517 Position of first record processed for Thread 2, Sequence 17643, RBA 793616, SCN 1389.3430888557, Mar 15, 2016 11:18...
删除Oracle Online Redo 测试
weixin_30808693的博客
05-02 108
删除Oracle Online Redo 测试 SQL> select * from v$log; ​ GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS ---------- ---------- ---------- ---------- ---------- -------...
从ORA-00283 ORA-16433报错开始恢复---惜分飞
最新发布
02-03 935
接手一个客户无法正常启动的故障数据库，尝试recover 报ORA-00283 ORA-16433错误。由于redo和数据文件不匹配,无法正常recover库,尝试强制打开库报ORA-600 2662错误。第一次通过其他方法处理,由于计算失误导致数据库启动报ORA-600 2252错误。处理正确的scn值之后,数据库open成功,然后逻辑方式导出数据,恢复工作完成。通过对控制文件进行处理,再次尝试recover库。基于这种错误,尝试oradebug修改scn。
ORA-16433: The database must be opened in read/write mode.
S1156578253的博客
07-27 3369
今天上午刚回到公司，接到开发组同事电话，测试数据库主机被新来的小伙非正常关机了，现在数据库起不来了。 数据库open时，提示需要介质恢复，恢复时就会报ORA-16433错误。 SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/u01/oradata/orcl/system01.dbf'
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
不会写作的码农的博客
06-15 5201
linux安装oracle12c，startup报错ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-16433
喝醉酒的小白
06-06 877
没办法搞定。。。
客户oracle数据库恢复测试
heizistudio的专栏
07-06 754
[oracle@localhost ~]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 6 16:23:05 2017 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to tar
oracle ora 00283,【案例】Oracle报错ORA-16433非归档丢失redo无法启动的恢复过程
weixin_33755379的博客
04-04 3461
天萃荷净Oracle研究中心案例分析：运维DBA反映Oracle数据库处理非归档模式，redo文件损坏常规修复无法正常open数据库。本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客本文链接地址: One recover case!今天ML的群中女神和travel在纠结一个恢复的问题，11.2.0.3版本，非归档，...
MySQL80出现Missing redo log file怎么解决
06-06
如果 MySQL 8.0 出现 Missing redo log file 错误，可能是因为 redo log 文件已经被删除或损坏。要解决这个问题，可以按照以下步骤操作： 1. 找到 MySQL 数据库的数据目录，通常在 /var/lib/mysql 或者 /usr/local/...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值