Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

standby database issue

Status
Not open for further replies.

scottgai

Programmer
Dec 12, 2001
11
US
Hi,
I encountered a problem about the ORACLE standby database.
I created a standby database and when I enter the SQL statement "recover standby database" to recover it, I got the following message:
Code:
SVRMGR> connect internal
Connected.
SVRMGR> recover standby database;
ORA-00279: change 253684 generated at 01/10/02 10:23:54 needed for thread 1
ORA-00289: suggestion : /u04/oradata/archive/arch1_85.log
ORA-00280: change 253684 for thread 1 is in sequence #85
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/u04/oradata/archive/arch1_85.log'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Are there any ways to solve this problem without recreating the standby database again?
Thanks a lot
 
The files size is incorrect, try re copying the file to the standby database and try again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top