Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem starting database

703490Sep 5 2009 — edited Sep 5 2009
TOday morning standby server closed (due to power problem). and now having problem starting standby database with the following error message
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/product/10.2.0/db_1/dbs/init/alpabkcp.ora'

SQL> startup pfile='/oracle/product/10.2.0/db_1/admin/alpaorcl/pfile/initalpabkcp.ora';
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09967: unable to create or open lock file
Linux-x86_64 Error: 2: No such file or directory

my alert log file line

RFS[1]: Archived Log: '/alphabkcp/alpharch/alpaorcl_1_2903_656011503.arch'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: No standby redo logfiles of size 512000 blocks exist
Fri Sep 4 07:23:04 2009
Media Recovery Log /alphabkcp/alpharch/alpaorcl_1_2903_656011503.arch
Fri Sep 4 07:23:18 2009
Media Recovery Waiting for thread 1 sequence 2904 (in transit)
Fri Sep 4 12:40:32 2009
RFS[1]: Archived Log: '/alphabkcp/alpharch/alpaorcl_1_2904_656011503.arch'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: No standby redo logfiles of size 512000 blocks exist
Fri Sep 4 12:40:34 2009
Media Recovery Log /alphabkcp/alpharch/alpaorcl_1_2904_656011503.arch
Fri Sep 4 12:41:08 2009
Media Recovery Waiting for thread 1 sequence 2905 (in transit)
Fri Sep 4 23:27:22 2009
RFS[1]: Archived Log: '/alphabkcp/alpharch/alpaorcl_1_2905_656011503.arch'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: No standby redo logfiles of size 512000 blocks exist
Fri Sep 4 23:27:24 2009
Media Recovery Log /alphabkcp/alpharch/alpaorcl_1_2905_656011503.arch
Fri Sep 4 23:27:44 2009
Media Recovery Waiting for thread 1 sequence 2906 (in transit)


After close server i was restart server two time but my alert file show same error.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 3 2009
Added on Sep 5 2009
5 comments
1,176 views