| standby recovery help please [message #356732] |
Sat, 01 November 2008 11:33  |
yusufmohamed
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:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC10G\REDO6.LOG'
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  |
trantuananh24hg
Messages: 744
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
