oracle back log,Oracle10g已经废弃log_archive_start参数

Oracle10g已经废弃log_archive_start参数

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 13 09:53:25 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production

With the Partitioning and Data Mining options

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 25

Current log sequence 27

SQL> show parameter log_archive_start

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_start boolean FALSE

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 3204448256 bytes

Fixed Size 1304912 bytes

Variable Size 651957936 bytes

Database Buffers 2550136832 bytes

Redo Buffers 1048576 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 Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 25

Next log sequence to archive 27

Current log sequence 27

SQL>

By eygle on 2005-04-13 09:48 |

Comments (10) |

Backup&Recovery | 253 |

10 Comments

今天我读ORACLE 10g：high availability with RAC,Flashback & Data guard刚好也看到了，并进行了实际操作，果然如此。

那存放归档日志的目录用那个参数定义？

USE_DB_RECOVERY_FILE_DEST是否为log_archive_dest

请问eygle,OS为solaris,DB为10.2g

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 11

Next log sequence to archive 13

Current log sequence 13

是否每次shutdown后archive会自动enable 呢????

问题是一旦set log_archive_start=true scope=spfile,之后,每次重新启动oracle都会报ORA-32004: obsolete and/or deprecated parameter(s) specified

怎么样去掉该参数?

可以

create pfile from spfile;

修改参数，再

create spfile from pfile;

SQL>ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';

但是alter database archivelog manual;后查看archive log list

自动归档怎么还是Enabled？？？？