[Provision] has been resolved after the case closed for archiving model and can no longer carry database Question : After setting up examples for archiving closed mode and can no longer carry database Suggested : ORA-00439 not enabled : Managed Standby feature : Environment : Windows 2000 Server, Oracle 9.0.1 for Win32, quanju examples were : Steps : 1, the database originally filed in the mode of operation 2, the following operations : SQL>shutdown immediate; SQL>startup mount exclusive; SQL>alter database archivelog; SQL>archive log start SQL>alter database open;           3, add the following lines : $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 data file is the path SQL>ALTER TABLESPACE mytablespace left BACKUP;    5, SQL>ALTER SYSTEM SWITCH and the FORTRAN computational GOTO etc. LOGFILE;           6, the backup log file all documents Sourcepath E:\ORACLEBACKUP\ --sourcepath SQL>host copy of the log files are archived Path 7, backup control document SQL>ALTER CONTROLFILE TO BACKUP DATABASE 'E:\ORACLEBACKUP\' reuse;           8, backup copy documents to the list E:\ORACLEBACKUP\ initquanuju.ora        9 SQL>shutdown;        10, SQL> startup; ORA-00439 not enabled : Managed Standby feature : Initquanju.ora contents : *.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' and '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] Strange, has been resolved. [/color][/size] Purge on the Web : Google Http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199, sid63_gci976924,00.html ---------------------------------------------------------------------------------------------------------- I replied to this question on the exact SearchDatabase forums today. Your problem lies in the usage of the LOG_ARCHIVE_DEST_n parameter is used when only one archive destination. 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 archive destination LOG_ARCHIVE_DEST_n parameter when only one is used. And it will get around the LOCATION parameter. which is most likely causing the error message you are seeing. ---------------------------------------------------------------------------------------------------------- [color=Blue] Then, if installed, the normal loading and open a database. The revision of the original initquanju.ora *.log_archive_dest_1 = "E:\ORACLEBACKUP\" To *.LOG_ARCHIVE_DEST = "E:\ORACLEBACKUP\" Want to have the guidance of friends experience. [/color] *.log_archive_dest_1 : This log file is used for a number of *.LOG_ARCHIVE_DEST : This log file is used for individual applications *.log_archive_dest_1 Installation of the following form : Log_archive_dest_1= "LOCATION=/oracle/oracle/archive" Received, thank you. Understand. [ Closed window ]