Home » RDBMS Server » Server Administration » cannot activate a standby database
cannot activate a standby database [message #204553] Tue, 21 November 2006 04:17 Go to next message
dirish
Messages: 205
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
Re: cannot activate a standby database [message #204571 is a reply to message #204553] Tue, 21 November 2006 05:27 Go to previous messageGo to next message
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
Re: cannot activate a standby database [message #204576 is a reply to message #204571] Tue, 21 November 2006 05:36 Go to previous messageGo to next message
dirish
Messages: 205
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
Re: cannot activate a standby database [message #204579 is a reply to message #204553] Tue, 21 November 2006 05:42 Go to previous messageGo to next message
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.
Re: cannot activate a standby database [message #204581 is a reply to message #204579] Tue, 21 November 2006 05:47 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
i think that the error is caused by the control file
Re: cannot activate a standby database [message #204584 is a reply to message #204553] Tue, 21 November 2006 05:58 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Check this out
http://www.idevelopment.info/data/Oracle/DBA_tips/Data_Guard_9i/DG_80.shtml

Have you done everthing correctly ?
Previous Topic: deleted backupset
Next Topic: UNDO vs. Rollback Segments
Goto Forum:
  


Current Time: Sat Dec 03 18:09:00 CST 2016

Total time taken to generate the page: 0.29237 seconds