国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

RMAN> run { set until time "to_date('20081125 19:50:44','yyyymmdd HH24:MI:SS')";recover database;}

executing command: SET until clause

Starting recover at 25-NOV-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1082 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1085 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=1086 devtype=DISK

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 3 needs more recovery to be consistent
ORA-01110: data file 3: '+DATA/oradata/fdcd/sysaux.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/25/2008 19:53:15
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 1861 lowscn 2061909090 found to restore

 

這個問題還沒有解決,0級備份后，backup archivelog all;但是沒有備份當前日志，也就是未執(zhí)行

alter system log archive current ;

在這種情況下，recover 不能使數(shù)據(jù)庫保持一致，如何解決呢？

 

-----------------------------------------------------------------

2008-11-25日解決這個問題

alter system set "_allow_resetlogs_corruption"=true scope=spfile;

startup force;

recover database using backup controlfile until cancel;

CANCEL

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> startup force;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup force;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@dg_fdct rman]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 25 20:01:43 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 7516192768 bytes
Fixed Size                  2084432 bytes
Variable Size             872415664 bytes
Database Buffers         6627000320 bytes
Redo Buffers               14692352 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> startup force;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@dg_fdct rman]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 25 20:02:18 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup force;
ORACLE instance started.

Total System Global Area 7516192768 bytes
Fixed Size                  2084432 bytes
Variable Size             872415664 bytes
Database Buffers         6627000320 bytes
Redo Buffers               14692352 bytes
Database mounted.
Database opened.

 

 

具體說來 "_allow_resetlogs_corruption參數(shù)的作用很大,在很多系統(tǒng)中都是靠參數(shù)來改變的

oracel 更加依賴參數(shù)

本站僅提供存儲服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請點擊舉報。