— Change the Init.ora parameter
SQL> create pfile from spfile;
SQL> show parameter pfile;
SQL> show parameter spfile;
# *.log_archive_dest_1=’location=/u01/archive/ORATEST/’
# *.log_archive_format=’log%t_%s_%r.arc’
SQL> shutdown immediate
—-Backup spfile and pfile
SQL> create spfile from pfile;
SQL> connect / as sysdba
SQL> startup mount
SQL> archive log list;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive/ORATEST/
Oldest online log sequence 35
Next log sequence to archive 37
Current log sequence 37
SQL> alter system switch logfile;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive/ORATEST/
Oldest online log sequence 36
Next log sequence to archive 38
Current log sequence 38
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ORATEST dbs]$ cd /u01/archive/ORATEST/
[oracle@ORATEST ORATEST]$ pwd
/u01/archive/ORATEST
[oracle@ORATEST ORATEST]$ ls -ltr
total 24172
-rw-r—– 1 oracle dba 24722432 Jul 16 11:40 log1_37_692113689.arc
[oracle@ORATEST ORATEST]$
Leave a comment
Comments feed for this article