Ans:-
sql> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/database
Oldest online log sequence 1
Current log sequence 3
sql>
alter system set log_archive_dest_1='LOCATION=/u01/archivelog
' scope=spfile;
sql>
show parameter log_archive_format;
System altered.
sql> show parameter log_archive_format;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.dbf
sql>alter system set log_archive_format='arch_%t_%s_%r_%d.arc' SCOPE=spfile;
System altered.
sql>shut immediate;
sql> startup mount;
ORACLE instance started.
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 260049280 bytes
Database Buffers 155189248 bytes
Redo Buffers 6094848 bytes
Database mounted.
sql>alter database archivelog;
sql> alter database open;
sql> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/database
Oldest online log sequence 1
Next log sequence to archive 3
Current log sequence 3
sql> alter system switch logfile;
sql> alter system switch logfile;
sql> alter system switch logfile;
sql> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/database
Oldest online log sequence 3
Next log sequence to archive 3
Current log sequence 5
No comments:
Post a Comment