Oracle 9i no archive mode archive mode
Oracle9i ʹ ʱ Ķ ϴ initSID.ora file ܿ Server Parameter File̶ Ҹ spfileSID.ora ϴ. ̿ϸ DB ߿ Parameter ְ Ǹ鼭 Parameter ͺ̽ ٽ ϴ ֽϴ.
̷ 氡 ʱ Ķʹ Ȯ մϴ.
SQL> select name, issys_modifiable from v$parameter;
NAME ISSYS_MOD
---------------------------------------------------------------- ---------
tracefile_identifier FALSE
processes FALSE
sessions FALSE
timed_statistics IMMEDIATE
timed_os_statistics IMMEDIATE
resource_limit IMMEDIATE
license_max_sessions IMMEDIATE
license_sessions_warning IMMEDIATE
cpu_count FALSE
instance_groups FALSE
event FALSE
shared_pool_size IMMEDIATE
sga_max_size FALSE
shared_pool_reserved_size FALSE
large_pool_size IMMEDIATE
java_pool_size FALSE
java_soft_sessionspace_limit FALSE
java_max_sessionspace_size FALSE
pre_page_sga FALSE
shared_memory_address FALSE
hi_shared_memory_address FALSE
use_indirect_data_buffers FALSE
߷
..
issys_modifiable Ʒ 3 ǥõǴµ ǹ̴ ϴ.
FLASE : static parameter scope=spfileθ ϴ. ص DB ٽ ġ ˴ϴ.
IMMEDIATE : ϸ session ٷ Ĩϴ.
DEFERRED : ĺ ӵǴ session ϴ.
alter system 3 DB ٷ ִ IMMEDIATE, DEFERRED Դϴ.
-------------------------------------------------------------
No Archive Mode DB Archive Log Mode մϴ.
-------------------------------------------------------------
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string %ORACLE_HOME%DATABASESPFILE%
ORACLE_SID%.ORA
SQL> alter system set log_archive_start=true scope=spfile;
System altered.
SQL> alter system set log_archive_dest = 'C:oracleora92databasearchive' scop
e=spfile;
System altered.
SQL> alter system set log_archive_format='%T_%S.ARC' scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> -- Ʒ alter database mount øϴ١
SQL> startup mount
ORACLE instance started.
Total System Global Area 76618332 bytes
Fixed Size 453212 bytes
Variable Size 62914560 bytes
Database Buffers 12582912 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:oracleora92databasearchive
Oldest online log sequence 285
Next log sequence to archive 287
Current log sequence 287
SQL> alter database open;
Database altered.
SQL> -- Archive Log ̴ Ȯϱ Ϻη α ġ մϴ. ̷ log_archive_dest 丮 ø ī̺ α ̴ϴ.
SQL> alter system switch logfile;
System altered.
SQL> -- DB ߿ Parameter ϰ init.ora ϰ spfile ȭ
ʾҴٸ Parameter Ұ ǹǷ Ʒ ȭ ϵ մϴ.
SQL> create pfile from spfile;
File created.
spfile scope 3 ִµ ϴ.
memory : ¿ ġ ͺ̽ ٽ ۵Ǹ ݿ ʰ · ưϴ.
spfile : spfile ǰ ¿ ġ ʽϴ. ߿ ٷ Ͽ ٽ ۾̴ ݿ Ұ Դϴ.
both : ǿ ٷ ݿϰ spfile ݿ DB ÿ ġ մϴ.