tag:blogger.com,1999:blog-5794742462833718439.post2147975488288347547..comments2024-03-26T16:41:52.813+06:00Comments on ORACLE: DBA's day out: Changing Archive Log DestinationMohammad Hasan Shaharearhttp://www.blogger.com/profile/16334901749628047963noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5794742462833718439.post-76964136101234535242012-07-25T15:07:51.168+06:002012-07-25T15:07:51.168+06:00You say:
"To change the size of archive log
...You say:<br /><br />"To change the size of archive log<br /><br />SQL> alter system SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='orca';<br /><br />System altered."<br /><br />Don't you mean "To change the size of the Flash Recovery Area"?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-69421452281009946352011-04-18T23:48:44.681+06:002011-04-18T23:48:44.681+06:00Is the "LOCATION" keyword case sensitive...Is the "LOCATION" keyword case sensitive in <br /><br />ALTER SYSTEM SET log_archive_dest_1='LOCATION=/p1/local/oracle/inst/instdb/9.2.0/dbs'Aarati Shttps://www.blogger.com/profile/10746878013588514414noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-16316316622776112892009-09-24T09:33:12.819+07:002009-09-24T09:33:12.819+07:00If you set log_archive_dest_1 and log_archive_dest...If you set log_archive_dest_1 and log_archive_dest_2, it will store same log file in both locations.Mohammad Hasan Shaharearhttps://www.blogger.com/profile/16334901749628047963noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-76063715318481393482009-09-24T09:30:39.042+07:002009-09-24T09:30:39.042+07:00This comment has been removed by the author.Mohammad Hasan Shaharearhttps://www.blogger.com/profile/16334901749628047963noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-20121239781536243442009-09-24T08:45:22.857+07:002009-09-24T08:45:22.857+07:00What if i have multiple archive log destinations
...What if i have multiple archive log destinations <br />log_archive_dest_1 location=/prod1_archredo1/CSCPROD1/arch<br />log_archive_dest_2 location=/prod1_archredo2/CSCPROD1/arch<br /><br />will it change only in the single location or both ,if single location is changed which one is change dest_1 or dest_2shahabnoreply@blogger.com