oracle 10g archvie

生成文本格式配置文件
SQL> create pfile from spfile;

File created.

修改pfile配置文件，加入*.log_archive_dest='/u01/app/oracle/oradata/arch/'内容，并且将原来的spfileora10g.ora更名为old.spfileora10g.ora
-bash-3.00$ more initora10g.ora
ora10g.__db_cache_size=96468992
ora10g.__java_pool_size=4194304
ora10g.__large_pool_size=4194304
ora10g.__shared_pool_size=100663296
ora10g.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/ora10g/adump'
*.background_dump_dest='/u01/app/oracle/admin/ora10g/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/ora10g/control01.ctl','/u01/app/oracle/oradata/ora10g/control0
2.ctl','/u01/app/oracle/oradata/ora10g/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/ora10g/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ora10g'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ora10gXDB)'
*.job_queue_processes=10
*.log_archive_dest='/u01/app/oracle/oradata/arch/'
*.open_cursors=300
*.pga_aggregate_target=69206016
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=209715200
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/ora10g/udump'


重启数据库到MOUNT状态。
SQL> startup mount
ORACLE instance started.

Total System Global Area  209715200 bytes
Fixed Size                  1977528 bytes
Variable Size             109056840 bytes
Database Buffers           96468992 bytes
Redo Buffers                2211840 bytes
Database mounted.
开启归档模式
SQL>  alter  database archivelog;

Database altered.
QL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     25
Next log sequence to archive   27
Current log sequence           27
打开数据库到OPEN状态
SQL> alter database open
生成二进制配置文件

SQL> create spfile from pfile;

File created.


删除临时文件initora10g.org和old.spfileora10g.ora