OraFAQ Forum: Server Administration » cannot activate a standby database

Home » RDBMS Server » Server Administration » cannot activate a standby database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cannot activate a standby database [message #204553]

Tue, 21 November 2006 04:17

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi,
I have a standby database in which i usually apply the archive logs.
I have decided to open the database to do some testing.
Am using this command which worked well with another server:

SVRMGR> alter database activate standby database;
alter database activate standby database
*
ORA-07360: sfifi: stat error, unable to obtain information about file.
IBM AIX RISC System/6000 Error: 2: No such file or directory

can you please help.

Thanks,

Dirish

Report message to a moderator

Re: cannot activate a standby database [message #204571 is a reply to message #204553]

Tue, 21 November 2006 05:27

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi,

Please check this link.
It might be useful for u.
http://www.mcse.ms/message1621872.html

Report message to a moderator

Re: cannot activate a standby database [message #204576 is a reply to message #204571]

Tue, 21 November 2006 05:36

dirish
Messages: 232
Registered: November 2006

Senior Member

hi dear,
thanks for the help
unfortunately this hasn't help me
am trying to use the control file from the live server instrad of using the standby control file,
wats yr views?

dirish

Report message to a moderator

Re: cannot activate a standby database [message #204579 is a reply to message #204553]

Tue, 21 November 2006 05:42

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

ORA-01157 errors are usually followed by ORA-01110 and possibly an Oracle operating system layer error such as ORA-07360. A DBWR trace file is generated in the background_dump_dest directory.

Report message to a moderator