Topic: Database Administration >> ORA-16019...........
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ORA-16019........... |
| Navi |
Posted: Aug 16, 2007 07:16:48 AM |
Total Post: 60
Joined: Jun, 2007
|
Hi,
First i like to thank all of you for helping me when i was in trouble.
Here i am with one more question.
I wanted to set 3 archive detination which is LOCAL, so i setted it using ALTER SYSTEM as follows:-
SQL> alter system set log_archive_dest='C:\oracle\admin\Chandu\Arch';
System altered.
SQL> sho parameter log_archive_dest;
NAME TYPE VALUE
------------------------------------------------------------------------
log_archive_dest string C:\oracle\admin\Chandu\Arch
SQL> alter system set log_archive_duplex_dest='F:\Archived';
System altered.
SQL> sho parameter log_archive_duplex_dest;
NAME TYPE VALUE
-------------------------- -------------- ------------------------
log_archive_duplex_dest string F:\Archived
But when i tried to set 3rd Archive destination i got ORA-16019 Error.
SQL> alter system set log_archive_dest_1='E:\Archived';
alter system set log_archive_dest_1='E:\Archived'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST
Question:-
1) I think according to the error i cant use LOG_ARCHIVE_DEST_n with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST, why cant i use it with those two of them, then how can i set the 3rd archive destination?
2) How to set MANDATORY or OPTIONAL for:-
LOG_ARCHIVE_DEST, LOG_ARCHIVE_DUPLEX_DEST, LOG_ARCHIVE_DEST_n
Regards,
Naveen |
|
|
 Ratnaker |
| Posted: Aug 17, 2007 03:40:43 AM |  |
|
Total Post: 136
Joined: Apr, 2007
|
Hi navi,
Cause: One of the following events caused an incompatibility: 1) Parameter LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST was in use when the specified LOG_ARCHIVE_DEST_n (n = 1...10) or DB_RECOVERY_FILE_DEST parameter was encountered while fetching initialization parameters. 2) Parameter LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST was in use when an attempt was made to use an ALTER SYSTEM or ALTER SESSION command to define a value for the specified LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST parameter. 3) An ALTER SYSTEM ARCHIVE LOG START TO command was in effect when the specified LOG_ARCHIVE_DEST_n parameter was encountered while fetching initialization parameters. 4) An ALTER SYSTEM ARCHIVE LOG START TO command was in effect when an attempt was made to use an ALTER SYSTEM or ALTER SESSION command to define a value for the specified LOG_ARCHIVE_DEST_n parameter.
Action: Eliminate any incompatible parameter definitions
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
