|
蓝森林 http://www.lslnet.com 2006年8月26日 15:18
 [已解决]设置为归档模式并且关闭实例后无法再装载数据库
问题：设置为归档模式并且关闭实例后无法再装载数据库
提示：ORA-00439: feature not enabled: Managed Standby
环境：Windows 2000 Server，Oracle 9.0.1 for Win32，实例名：quanju
步骤：
1，数据库本来运行在非归档模式
2，作如下操作：
SQL>shutdown immediate;
SQL>startup mount exclusive;
SQL>alter database archivelog;
SQL>archive log start
SQL>alter database open;
3，在$ORACLE_HOME\DATABASE\initquanju.ora 中增加以下语句：
*.log_archive_start = true
*.log_archive_dest_1 = "E:\ORACLEBACKUP\"
*.log_archive_format = "%QUANJU%%T%S.ARC""
4，SQL>ALTER TABLESPACE mytablespace BEGIN BACKUP;
SQL>host copy mysourcepath E:\ORACLEBACKUP\ ; --mysourcepath是数据文件的路径
SQL>ALTER TABLESPACE mytablespace END BACKUP;
5，SQL>ALTER SYSTEM SWITCH LOGFILE;
6，备份所有归档日志文件
SQL>host copy sourcepath E:\ORACLEBACKUP\ --sourcepath是归档日志文件的路径
7，备份控制文件
SQL>ALTER DATABASE BACKUP CONTROLFILE TO 'E:\ORACLEBACKUP\' reuse;
8，拷贝initquanuju.ora文件到备份目录E:\ORACLEBACKUP\
9，SQL>shutdown;
10，SQL> startup;
ORA-00439: feature not enabled: Managed Standby
|
initquanju.ora 的内容：
*.background_dump_dest='D:\oracle\admin\quanju\bdump'
*.compatible='9.0.0'
*.control_files='D:\oracle\oradata\quanju\control01.ctl','D:\oracle\oradata\quanju\control02.ctl','D:\oracle\oradata\quanju\control03.ctl'
*.core_dump_dest='D:\oracle\admin\quanju\cdump'
*.db_block_size=16384
*.db_cache_size=512003200
*.db_domain=''
*.db_name='quanju'
*.fast_start_mttr_target=300
*.instance_name='quanju'
*.java_pool_size='0'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
*.user_dump_dest='D:\oracle\admin\quanju\udump'
*.log_archive_start = true
*.log_archive_dest_1 = "E:\ORACLEBACKUP\"
*.log_archive_format = "%QUANJU%%T%S.ARC"" |
[size=3][color=Blue]奇怪，已经解决。[/color][/size]
purge在网络上google：
http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci976924,00.html
----------------------------------------------------------------------------------------------------------
I replied to this exact question on the SearchDatabase forums today. Your problem lies in the usage of the LOG_ARCHIVE_DEST_n parameter when only one archive destination is used. You also specified the LOCATION parameter. Try using the following instead:
LOG_ARCHIVE_DEST=d:\somedir\archive\
That should clear up your problem. It will get around the known issues of the LOG_ARCHIVE_DEST_n parameter when only one archive destination is used. And it will get around the LOCATION parameter, which is most likely causing the error message you are seeing.
----------------------------------------------------------------------------------------------------------
[color=Blue]然后，照此设置，正常装载并且打开了数据库。
修改了原 initquanju.ora 中的 *.log_archive_dest_1 = "E:\ORACLEBACKUP\"
为 *.LOG_ARCHIVE_DEST = "E:\ORACLEBACKUP\"
希望有经验的朋友指点。[/color]
|
*.log_archive_dest_1 ：这个是为多份归档日志使用
*.LOG_ARCHIVE_DEST ：这个是为单份份归档日志使用
如果设置了这个*.log_archive_dest_1，格式如下：
log_archive_dest_1="LOCATION=/oracle/oracle/archive" |
收到，谢谢。
明白了。 |
| |
