备用数据库的奇怪问题

firefeathe · 发表于 2005-1-18 11:31

1、在主数据库启动的情况下，备用数据库无法启动：
SQL> startup nomount;
ORACLE 例程已经启动。

Total System Global Area  126950220 bytes
Fixed Size                453452 bytes
Variable Size          109051904 bytes
Database Buffers          16777216 bytes
Redo Buffers                667648 bytes
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR 位于第 1 行:
ORA-01102: ??? EXCLUSIVE ????????

2、在主数据库关闭的情况下，备用数据库能正常启动
SQL> startup nomount;
ORACLE 例程已经启动。

Total System Global Area  126950220 bytes
Fixed Size                453452 bytes
Variable Size          109051904 bytes
Database Buffers          16777216 bytes
Redo Buffers                667648 bytes
SQL> alter database mount standby database;

数据库已更改。

3、备用数据库启动后能进行手工恢复，但是却会显示乱码
SQL> recover standby database;
ORA-00279: ?? 2169024 (? 01/18/2005 11:08:00 ??) ???? 1 ????
ORA-00289: ??: F:\DATABASE\ORADATA\STANDBY\ARCHIVELOG\1_41.LOG
ORA-00280: ?? 2169024 ???? 1 ???? # 41 ???

指定日志: {<RET>=suggested | filename | AUTO | CANCEL}

4、备用数据库启动后，主数据库就无法正常启动了
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  126950220 bytes
Fixed Size                453452 bytes
Variable Size          109051904 bytes
Database Buffers          16777216 bytes
Redo Buffers                667648 bytes
ORA-01102: ??? EXCLUSIVE ????????

附上备用数据库pfile内容：
*.aq_tm_processes=1
*.archive_lag_target=0
*.background_dump_dest='F:\Database\admin\standby\bdump'
*.compatible='9.2.0.0.0'
*.control_files='F:\Database\oradata\standby\standby.CTL'
*.core_dump_dest='F:\Database\admin\standby\cdump'
*.db_block_size=8192
*.db_cache_size=16777216
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_name='test'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=standbyXDB)'
*.fast_start_mttr_target=300
*.hash_area_size=1048576
*.hash_join_enabled=TRUE
*.instance_name='standby'
*.service_names='standby'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_archive_dest_1='location=F:\Database\oradata\standby\archivelog'
*.standby_archive_dest='location=F:\Database\oradata\standby\archivelog'
*.log_archive_format='%t_%s.log'
*.log_archive_start=TRUE
*.open_cursors=300
*.pga_aggregate_target=33554432
*.processes=150
*.query_rewrite_enabled='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=1048576
*.star_transformation_enabled='TRUE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='F:\Database\admin\standby\udump'
*.utl_file_dir='f:\database\archlog\'
*.db_file_name_convert='F:\Database\oradata\test','F:\Database\oradata\standby'
*.log_file_name_convert='F:\Database\oradata\test','F:\Database\oradata\standby'

花好月不圆 · 发表于 2005-1-18 11:55

重做一个

firefeather · 发表于 2005-1-18 11:58

主数据库和备用数据库不能同时启动的问题已经找到了，原因是两个数据库在同一台电脑上，只要在pfile后加*.lock_name_space=standby
就能解决该问题，但是备用数据库在恢复时还是会有乱码出现，请各位高手指点，谢谢！
SQL> alter database mount standby database;

数据库已更改。

SQL> recover standby database;
ORA-00279: ?? 2169024 (? 01/18/2005 11:08:00 ??) ???? 1 ????
ORA-00289: ??: F:\DATABASE\ORADATA\STANDBY\ARCHIVELOG\1_41.LOG
ORA-00280: ?? 2169024 ???? 1 ???? # 41 ???

指定日志: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00279: ?? 2169857 (? 01/18/2005 11:46:04 ??) ???? 1 ????
ORA-00289: ??: F:\DATABASE\ORADATA\STANDBY\ARCHIVELOG\1_42.LOG
ORA-00280: ?? 2169857 ???? 1 ???? # 42 ???
ORA-00278: ??????????? 'F:\DATABASE\ORADATA\STANDBY\ARCHIVELOG\1_41.LOG'

指定日志: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00279: ?? 2169859 (? 01/18/2005 11:46:05 ??) ???? 1 ????
ORA-00289: ??: F:\DATABASE\ORADATA\STANDBY\ARCHIVELOG\1_43.LOG
ORA-00280: ?? 2169859 ???? 1 ???? # 43 ???
ORA-00278: ??????????? 'F:\DATABASE\ORADATA\STANDBY\ARCHIVELOG\1_42.LOG'

指定日志: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: ???????? 'F:\DATABASE\ORADATA\STANDBY\ARCHIVELOG\1_43.LOG'
ORA-27041: ??????
OSD-04002: N^7(4r?*ND<~
O/S-Error: (OS 2) O5M3UR2;5=V86(5DND<~!#