Error messeges when implementing Archiving [message #74513] |
Wed, 22 December 2004 18:12 |
khawar
Messages: 4 Registered: September 2004
|
Junior Member |
|
|
Hi,
1- I already transfer database into archive log mode and automatic archival is also enabled
but when I want to implement multiple destination for archiving it gives error.
2- I want to give drive and folder location with SERVICE parameter is there any option to add alter system set log_archive_dest_2='SERVICE=db01'(in this command I want to add drive specification/letter)
Below are some of the details.
SQL> alter system set log_archive_dest_1='service=mnbsll';
alter system set log_archive_dest_1='service=mnbsll'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00439: feature not enabled: Managed Standby
SQL> alter system set log_archive_dest_1='local=d:oracle';
alter system set log_archive_dest_1='local=d:oracle'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00439: feature not enabled: Managed Standby
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination d:oracle
Oldest online log sequence 188
Next log sequence to archive 190
Current log sequence 190
Thanks in advance
|
|
|
|