Oracle Database Discussions

Hi all,

11.2.0.1

Aix 6.1

I am thinking that there is always a default FRA directory in 11g.

But when I enable archive log on, it defaulted to $ORACLE_HOME/dbs

Do I need to set it manually to the FRA directory? Where do I find it?

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 6196547584 bytes

Fixed Size                  2232952 bytes

Variable Size            3724545416 bytes

Database Buffers         2449473536 bytes

Redo Buffers               20295680 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> show parameter recovery

NAME                                 TYPE        VALUE

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

db_recovery_file_dest                string

db_recovery_file_dest_size           big integer 0

recovery_parallelism                 integer     0

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /oracle/product/11.2.0.3/dbhome_1/dbs/arch

Oldest online log sequence     8357

Next log sequence to archive   8359

Current log sequence           8359

SQL> show parameter pfile

Please help...

Thanks a lot,

zxy