Dear All,
Mas-Mas yang terhormat...
Contoh-contoh error dibawah ini bagaimana ya....cara menangani nya
Kasus I
--------
RMAN> recover database;
Starting recover at 08-FEB-06
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/08/2006 22:32:33
ORA-00283 : recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter
database reco
ver if needed start
ORA-00283 : recovery session canceled due to errors
ORA-19909 : datafile 1 belongs to an orphan incarnation
ORA-01110 : data file 1:
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\OP\SYSTEM01.DBF'
Apa yang harus dilakukan untuk masalah diatas?
Apa yang harus dilakukan biar tidak terulang lagi error yang diatas?
######################################################################
######################################################################
Kasus II
--------
RMAN> run{
2> set until time="TO_DATE('01/08/06:15:10:00','MM/DD/YY:HH24:MI:SS')";
3> restore database;
4> recover database;
5> alter database open resetlogs;
6> }
RMAN-03002: failure of recover command at 01/08/2006 22:52:01
ORA-00283 : recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter
database reco
ver logfile
'C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\OP\ARCHIVELOG\2006_02_
08\O1_MF_1_1_1YKT1LB7_.ARC'
ORA-00283 : recovery session canceled due to errors
ORA-00600 : internal error code, arguments: [3021], [1], [2], [2],
[0], [3564256]
, [0], [3562239]
Apa yang harus dilakukan untuk masalah diatas?
Apa yang harus dilakukan biar tidak terulang lagi error yang diatas?
######################################################################
######################################################################
Kasus III
---------
RMAN> run{
2> set until time="TO_DATE('11/08/05:15:10:00','MM/DD/YY:HH24:MI:SS')";
3> restore database;
4> recover database;
5> alter database open resetlogs;
6> }
RMAN-03002 : failure of recover command at 11/08/2005 22:32:33
RMAN-20207 : Until Time or Recovery window is before resetlogs time
Apa yang harus dilakukan untuk masalah diatas?
Apa yang harus dilakukan biar tidak terulang lagi error yang diatas?
######################################################################
######################################################################
Kasus IV
--------
RMAN> alter database open resetlogs;
RMAN-03002: failure of recover command at 02/08/2005 22:32:33
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\OP\SYSTEM01.DBF'
Apa yang harus dilakukan untuk masalah diatas?
Apa yang harus dilakukan biar tidak terulang lagi error yang diatas?
Makasih banyak sebelumnya....:)
Regards,
Ifen
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
