Don't know which version of Oracle this is but you can if you want set
the Standby_file_management parameter. This will ensure that whenever
you create a datafile/tablespace on the LIVE box, this is replicated to
the Standby box. This is in 9i upwards.
D
-----Original Message-----
From: Garikai Gondo
[mailto:oracledba-ezmlmshield-x6542904.[Email address protected]
Sent: 24 August 2006 13:05
To: LazyDBA Discussion
Subject: RE: Standby dataase fails.
Did you extend a table space or carried out some structural changes on
the
primary database. If so the log is trying to write to the DRP but the
Standby control files does not have the information.
-----Original Message-----
From: Unsal Onder
[mailto:oracledba-ezmlmshield-x76934740.[Email address protected]
Sent: Wednesday, August 23, 2006 10:51 AM
To: LazyDBA Discussion
Subject: Standby dataase fails.
Hi Everybody,
We are facing the foloowing error messages in alert log of standby
oracle server.
How can we recover from this error, Any comment ?
Regards,
Unsal Onder
Wed Aug 23 11:45:16 2006
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Attempt to start background Managed Standby Recovery process
MRP0 started with pid=11
MRP0: Background Managed Standby Recovery process started
Media Recovery Log D:\ORACLE\YBB\ORAARCH_STDBY\YBBARCHARC12143.001
Wed Aug 23 11:45:22 2006
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DI
Wed Aug 23 11:45:23 2006
Errors in file d:\oracle\ybb\saptrace\background\ybb_mrp0_1768.trc:
ORA-00600: internal error code, arguments: [4553], [2], [0], [], [], [],
[], []
Wed Aug 23 11:45:25 2006
Errors in file d:\oracle\ybb\saptrace\background\ybb_mrp0_1768.trc:
ORA-00308: cannot open archived log
'D:\ORACLE\YBB\ORIGLOGB\LOG_G18M1.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00600: internal error code, arguments: [4553], [2], [0], [], [], [],
[], []
Wed Aug 23 11:45:25 2006
MRP0: Background Media Recovery terminated with error 10562
Wed Aug 23 11:45:25 2006
Errors in file d:\oracle\ybb\saptrace\background\ybb_mrp0_1768.trc:
ORA-10562: Error occurred while applying redo to data block (file# 29,
block# 535511)
ORA-10564: tablespace PSAPYBB
ORA-01110: data file 29: 'E:\ORACLE\YBB\SAPDATA4\YBB_12\YBB.DATA12'
ORA-00600: internal error code, arguments: [4553], [2], [0], [], [], [],
[], []
Recovery interrupted.
Recovered data files restored to a consistent state at change 186346315
MRP0: Background Media Recovery process shutdown
Bu elektronik postada bulunan tum fikir ve gorusler ve ekindeki dosyalar
sadece adres sahip/sahiplerine ait olup, Yasar Toplulugu Sirketleri bu
mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul
etmez.
Eger gonderilmesi dusunulen kisi veya kurulus degilseniz, lutfen
gonderen
kisiyi derhal haberdar ediniz ve mesaji sisteminizden siliniz.The
information contained in this e-mail and any files transmitted with it
are
intended solely for the use of the individual or entity to whom they are
addressed and Yasar Group Companies do not accept legal responsibility
for
the contents. If you are not the intended recipient, please immediately
notify the sender and delete it from your system.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [Email address protected] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd unless otherwise expressly stated.
Oracle LazyDBA home page