Home » RDBMS Server » Backup & Recovery » standby recovery help please
standby recovery help please [message #356732] Sat, 01 November 2008 11:33 Go to next message
Messages: 1
Registered: November 2008
Junior Member

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 transfered 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 direction 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:

can somebody help me in this probem plzz
Re: standby recovery help please [message #356858 is a reply to message #356732] Sun, 02 November 2008 21:58 Go to previous message
Messages: 696
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
1/ Shutdown Primary database
2/ Recreate standby control file, and take it to the right location which was configured in standby_init_pfile.
3/ Recopy the REDO (or if necessary, copy all of datafiles) datafile to the standby_machine's.
4/ Startup Primary database
5/ Startup NoMount Physical Standby Database, re-check your standby database's pfile to check if Fal_server/Fal_client/standby_management_auto/db_unique_name initialization parameters were configured well, create spfile from exist pfile.
6/Mount Physical Standby Database, invoke your REDO_OR_REAL_TIME_APPLY.
Previous Topic: Backup fails: "error writing input to command"
Next Topic: mount data files
Goto Forum:

Current Time: Sat Aug 19 02:28:02 CDT 2017

Total time taken to generate the page: 0.03393 seconds