بتاريخ: 1 نوفمبر 200817 سنة comment_142054 السلام عليكم dear all my name is yusuf and i working in company have 2 database servers the 1- main database server 2-standby serverthe 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 sayORA-00283: recovery session canceled due to errorsORA-01665: control file is not a standby control filei checked for control file and read in some dierction to restor the system tablespace ;ORA-00283: recovery session canceled due to errorsORA-00314: log 6 of thread 1, expected sequence# 22687 doesn't match 14473ORA-00312: online log 6 thread 1:'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC10G\REDO6.LOG'can somebody help me in this probem plzz تقديم بلاغ
بتاريخ: 3 نوفمبر 200817 سنة comment_142166 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 تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.