我成功配置了一备用数据库,与主库连上了,可是主库坏了,我怎么打不开备用库啊?
我成功配置了一备用数据库,与主库连上了,可是主库坏了,我怎么打不开备用库啊?
我配了个备用数据库
1 从主库中备份出一个用于备份数据库的控制文件
SQL>alter database create standby controlfile as ‘e:\shared\back\stby_ctl.ctl’;
2 在主库配置NET服务名
4 主库init.ora文件配置
log_archive_dest_1 = “location=e:\log\ mandatory reopen=2”
log_archive_dest_state_1 = enable
log_archive_dest_2 = “service=stby1 mandatory reopen=15”
log_archive_dest_state_2 = enable
log_archive_min_succeed_dest = 1
3 备用库配置监听程序
5 备用库init.ora文件配置:删除原有的日志归档目录项,并添加
log_archive_dest = e:\log
log_archive_trace = 6 #定义日志跟踪层次
standby_archive_dest = e:\log
control_files = (“d:\oracle\oradata\orcl\stby_ctl.ctl”)
6 启动备用库
SQL>connect internal/oracle as sysdba
SQL>startup nomount
SQL>alter database mount standby database
SQL>recover standby database until cancel;
SQL>recover managed standby database;
之后我把主库弄歇菜了,去开备用库
SQL>startup pfile='d:\oracle\admin\tsdb\pfile\init.ora' mount;
ORACLE 例程已经启动。
Total System Global Area 613490348 bytes
Fixed Size 454316 bytes
Variable Size 402653184 bytes
Database Buffers 209715200 bytes
Redo Buffers 667648 bytes
ORA-01666: ???????????
ORA-01666: controlfile is a standby database
各位大虾,这是咋回事啊?