把9i设置为自动归档模式是改哪个文件啊?

text2002

SQL>; conn / as sysdba
Connected to an idle instance.
SQL>; startup
ORACLE instance started.

Total System Global Area  235999352 bytes
Fixed Size                   450680 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
SQL>; archive log list;
Database log mode              Archive Mode
Automatic archival             Disabled
Archive destination            /opt/oracle9i/product/9.2.0/dbs/arch
Oldest online log sequence     4
Next log sequence to archive   5
Current log sequence           6

text2002

在init.ora里面设置了下面的参数.
LOG_ARCHIVE_START = TRUE
LOG_ARCHIVE_DEST = /opt/oracle9i/oradata/arch
LOG_ARCHIVE_FORMAT = ARC%s.ARC

ps:我的/dbs目录下面没有initTEXT.ora文件.只有init.ora文件??
[oracle@Text dbs]$ ls
\  initdw.ora  init.ora  lkTEXT  orapwTEXT  spfileTEXT.ora

keanu_wang

数据库要以ArchiveLog模式启动

text2002

[oracle@Text oracle]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 23 10:36:48 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>; conn / as sysdba
Connected to an idle instance.


SQL>; startup mount
ORACLE instance started.

Total System Global Area  235999352 bytes
Fixed Size                   450680 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL>; alter database archivelog;

Database altered.

SQL>; alter database open;

Database altered.

SQL>; archive log list;
Database log mode              Archive Mode
Automatic archival             Disabled
Archive destination            /opt/oracle9i/oradata/ARCH
Oldest online log sequence     5
Next log sequence to archive   5
Current log sequence           7

还是不行啊??

hubb-1

你修改的文件可能没对！你仔细看看你启动数据库时实际用的哪一个INIT文件，因为9.2有一个SPFILE之类的！

text2002

[oracle@Text dbs]$ ls
\ initdw.ora init.ora lkTEXT orapwTEXT spfileTEXT.ora

我只建立了一个实例...

SQL>; archive log start;
Statement processed.
SQL>; archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /opt/oracle9i/oradata/ARCH
Oldest online log sequence     5
Next log sequence to archive   7
Current log sequence           7

然后
SQL>; shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>; startup
ORACLE instance started.

Total System Global Area  235999352 bytes
Fixed Size                   450680 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
SQL>; archive log list;
Database log mode              Archive Mode
Automatic archival             Disabled
Archive destination            /opt/oracle9i/oradata/ARCH
Oldest online log sequence     5
Next log sequence to archive   7
Current log sequence           7


非要执行这句吗?
SQL>; archive log start;

hubb-1

你改一下这个文件应该spfileTEXT.ora就对了

text2002

spfileTEXT.ora里面没有这个参数啊??
[oracle@Text dbs]$ cat spfileTEXT.ora
*.background_dump_dest='/opt/oracle9i/admin/TEXT/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/opt/oracle9i/oradata/TEXT/control01.ctl','/opt/oracle9i/oradata/TEXT/control02.ctl','/opt/oracle9i/oradata/TEXT/control03.ctl'
*.core_dump_dest='/opt/oracle9i/admin/TEXT/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain='world'
*.db_file_multiblock_read_count=16
*.db_name='TEXT'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TEXTXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='TEXT'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.log_archive_dest_1='LOCATION=/opt/oracle9i/oradata/ARCH'
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle9i/admin/TEXT/udump'
[oracle@Text dbs]$

hubb-1

你改了INIT.ora文件吧！
然后要运行：
create spfile='spfiletext.ora' from pfile='init.ora'
这样的SPFILE就生效了！
你再重启动一下数据库看行不？

text2002

SQL>; shutdown;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL>; create spfile='spfileTEXT.ora' from pfile='init.ora';

File created.

SQL>; startup open;
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07217: sltln: environment variable cannot be evaluated.