-
Hi All,
I ma using 8.1.6 on Sun 5.8.
I am just tring to set log parameters..
log_archive_start = true
log_archive_dest_1 = "location=/opt/oracle/data2/ora4/arch"
log_archive_format = arch_%t_%s.arc
But when I start instance I get
ORA-00439: feature not enabled: Managed Standby
When I comment log_archive_dest_1 I can able to start the instance
Then where my logs will get arched?
Why I am geeting error while setting log_archive_dest_1
Please help
Thanks
Sameer
-
You can only archive logs to a remote database when applying them to a standby database - not in normal operation
-
Originally posted by fraze
You can only archive logs to a remote database when applying them to a standby database - not in normal operation
I am not setting stand by database at the moment..
Just trying to set location for my arch logs
-
Take a look at this exchange on metalink. This may indicate something for you:
http://metalink.oracle.com/metalink/...1&p_showHelp=1
Check to make sure that you have Oracle Enterprise installed as the log_archive_dest_n parameter is only available with the enterprise. In Standard you can only set it as log_archive_dest.
This may be part of what is happening with the issues you have mentioned in your other thread.
[Edited by ramaral on 08-07-2002 at 09:46 AM]
-
Hi ramaral,
If the document is nto big then will you please copy paste here because I don't have access to Metalink
or Is it possible for you to send it to me at sameer_deshpande@hotmail.com
Thanks
Sameer
-
hi Sameer,
you need to set the log_archive_dest parameter, not the log_archive_dest_1.
Cheers.
-
Okay. Here it is. Note: it's not really an article but an exchange with someone who was having the exact same problem that your are encountering right now:
Thread Status: Closed
From: JD Smith 25-Jan-02 14:08
Subject: Getting Managed Standby error when creating database
RDBMS Version: 8.1.7
Operating System and Version: Sun Solaris 5.8
Error Number (if applicable): 01034 and 00439
Product (i.e. SQL*Loader, Import, etc.): Database Configuration Assistant and svrmgrl
Product Version:
Getting Managed Standby error when creating database
Installed Standard Edition, now trying to create a database instance that is using the Archive Redo Logs feature, so hot backups can happen. Getting error ORA-00439 in svrmgrl when starting the database with a init.ora file that has log archive turned on:
log_archive_start = true
log_archive_dest_1 = "location=/u01/app/oracle/admin/CTVW/arch"
log_archive_format = arch_%t_%s.arc
When creating from within Database Configuration Assistant I get the generic error ORA-01034 that says Oracle is not available.
Does Standard Edition support archiving redo log files? Is there a patch to fix this, or a syntax change required in the init.ora file?
From: Oracle, Kalpana Malligere 25-Jan-02 17:09
Subject: Re : Getting Managed Standby error when creating database
Hello,
You should use LOG_ARCHIVE_DEST instead of LOG_ARCHIVE_DEST_n, which is valid only if you have installed Oracle Enterprise Edition.
136921.1 ORA-439 Creating Database with DBASSISTANT
1078962.6 ORA-00439: STARTING PRIMARY OR STANDBY DATABASE
101543.1 ORA-00439 when Creating a Standby Database
68537.1 Init.ora Parameter "LOG_ARCHIVE_DEST_n" Reference Note
66433.1 Oracle8i - Multiple Archive Destinations and Remote Archival
FYI: If you are using 8.1.x Standard Edition, then you are limited to maintaining the standby database in manual Recovery Mode.
112591.1 Differences Between Standard Edition and Enterprise Edition in 8i
Thanks!
Kalpana
Oracle Technical Support
From: JD Smith 25-Jan-02 17:28
Subject: Re : Re : Getting Managed Standby error when creating database
I did as you suggested, but now get these errors:
SVRMGR> startup nomount pfile = "/u01/app/oracle/admin/CTVW/pfile/initCTVW.ora"
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
SVR4 Error: 2: No such file or directory
I verified that the directory indeed does exist:
/u01/app/oracle/product/8.1.7/assistants/dbca>cd /u01/app/oracle/admin/CTVW/arch
/u01/app/oracle/admin/CTVW/arch>
/u01/app/oracle/admin/CTVW/arch>
/u01/app/oracle/admin/CTVW/arch>ls
total 4
drwxr-xr-x 2 oracle oinstall 512 Jan 22 16:06 .
drwxr-xr-x 10 oracle oinstall 512 Jan 22 16:06 ..
/u01/app/oracle/admin/CTVW/arch>
From: Oracle, Kalpana Malligere 28-Jan-02 21:01
Subject: Re : Re : Re : Getting Managed Standby error when creating database
Hello,
Looks like in your init.ora file, log_archive_start parameter is set to "false" or remarked out, so archive logging is NOT enabled. Suggest to set to true or enable and set log_archive_dest to the directory you wish to write to. If there are any extraneous characters included in this setting (such as single quotes) remove them and let us know if you need assistance.
Thanks!
Kalpana
Oracle Technical Support
-
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device
Thanks ramaral for the post... But still fighting :-(
Now I am using log_archive_dest and I get the above error. As said in the docs I have to set log_archive_start = true
which is set to TRUE and also directory exists which appropriate rights
Sameer
-
Just something to try at this point. use single quotes so that the parameter reads something like:
log_archive_dest='location=/u01/app/oracle/admin/CTVW/arch'
-
:-) It worked
log_archive_dest = "location=/u01/app/oracle/admin/CTVW/arch"
There is no need to specify location word while specified value in dest. It worked and also archs logs to specified directory.. It gives error if you mention "location" word
Thanks
Sameer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|