Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6613
  • Last Modified:

how do i set my archive log dest to USE_DB_RECOVERY_FILE_DEST

how do i set my archive log dest to USE_DB_RECOVERY_FILE_DEST currently it is set as follows


SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u02/flash_recovery_area/CGCEMGCP/archivelog
Oldest online log sequence     4245
Next log sequence to archive   4247
Current log sequence           4248
SQL>
0
hraja77
Asked:
hraja77
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if you have a pfile, change the init<SID>.ora file accordingly, and restart the database
if you have a spfile, change the setting archive_log_dest (scope=pfile), and restart the database
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now