1 person found this helpful
Even you can give LOG_ARCHIVE_DEST_1 in standby init file, So whenever you start standby/auxiliary instance automatically the dest_1 will refer to /u08/orcl(whereever you want). So you can have archive destination any where but should have proper permissions and location should be available.
If you want to assign one by one destinations, then still you can use "ALTERNATE" clause so that when the primary location unavailable or unable to archive, then of course it writes into alternate location you have specified from pfile.
You can check this
Thank you very much, CKPT. I created pysical standby database, then set LOG_ARCHIVE_DEST_1 to fast_recovery_area which is reside under /u08.
Best regards, Azer Imamaliyev