الانتقال إلى المحتوى
View in the app

A better way to browse. Learn more.

مجموعة مستخدمي أوراكل العربية

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Recover Standby Database Help

Featured Replies

بتاريخ:

السلام عليكم
dear all
my name is yusuf and i working in company have 2 database servers the
1- main database server
2-standby server

the standby server archive all files transfared from the main database server the files in folder "D:\oracle\product\10.2.0\db_1\database\archive"
for ex: file name is "ARC25500_0617551162.001" to be sure that the standby working good i check from sqlplus /nolog and connecting by sys as sysdba; and
select max(recid) from v$log_history; the resultes retrev number for ex: 22691 this is for me not working good cus not give me 25500 and i run the recover standby database ;
an erorr massage to say
ORA-00283: recovery session canceled due to errors
ORA-01665: control file is not a standby control file

i checked for control file and read in some dierction to restor the system tablespace ;

ORA-00283: recovery session canceled due to errors
ORA-00314: log 6 of thread 1, expected sequence# 22687 doesn't match 14473
ORA-00312: online log 6 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC10G\REDO6.LOG'


can somebody help me in this probem plzz

بتاريخ:

it seems that you activated the standby database before applying all archives from primary instance ..so it resulted the error of controlfile is not for standby
so if u need to solve this problem u need to create another standby controlfile from the primary instance and then try to recover managed standby database disconnect from session
and try to check the redolog apply service
otherwise u can use archive backup from RMAN from the primary instance and start RMAN in standby instance then recover using RMAN ..
note : be sure to put all archives in the same path as the primary server so as to avoid any recovery errors
hope it could help
waiting for your response
regards

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية

Account

Navigation

البحث

إعداد إشعارات المتصفح الفورية

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.