-
To Change Archive Destination
Hi
I'm using Oracle 10g.When i issued the command Archive log list to determine the Archived destination but the output is
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 90
Next log sequence to archive 92
Current log sequence 92
I changed the Destination but it still remains the same.How can i change now??
LittleAngel
DBA-SQL,Oracle
-
which parameter you changed to reflect the new archive log destination?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
I used "Alter system set log_archive_dest='path' scope=spfile" for changing the destination.
LittleAngel
DBA-SQL,Oracle
-
log_archive_dest parameter is deprecated in favor of log_archive_dest_n. However, if you don't specify any value to log_archive_dest_n parameter then it is valid.
In this case, you need to set the new path to log_archive_dest_1 parameter using alter system.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Thanks,Finally it worked by using "Log_archive_dest_1='location=path'" Parameter.
LittleAngel
DBA-SQL,Oracle
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
|