RE: 11g Archive Logs?

Sorry, let me clarify...

10g (in WIN, sorry don't have a 10g UNIX setup at the moment):

SQL> show parameter log_archive_dest

NAME TYPE VALUE

• -----------------

log_archive_dest string

log_archive_dest_1 string

log_archive_dest_10 string

log_archive_dest_2 string

log_archive_dest_3 string

log_archive_dest_4 string

log_archive_dest_5 string

log_archive_dest_6 string

log_archive_dest_7 string

log_archive_dest_8 string

log_archive_dest_9 string

SQL> show parameter recover

NAME TYPE VALUE

• -----------

db_recovery_file_dest string c:\oracle\rob10gr2_backup

db_recovery_file_dest_size big integer 2G

SQL> select dest_name, destination from

v$archive_dest;

DEST_NAME DESTINATION

• -------------------------

LOG_ARCHIVE_DEST_1 LOG_ARCHIVE_DEST_2 LOG_ARCHIVE_DEST_3 LOG_ARCHIVE_DEST_4 LOG_ARCHIVE_DEST_5 LOG_ARCHIVE_DEST_6 LOG_ARCHIVE_DEST_7 LOG_ARCHIVE_DEST_8 LOG_ARCHIVE_DEST_9 LOG_ARCHIVE_DEST_10 USE_DB_RECOVERY_FILE_DEST

• Look at pertenant directories
• flash recovery area, has an archived redo log (just did a log switch).

Directory of C:\oracle\rob10gr2_backup\ROB10GR2\ARCHIVELOG\2007_08_18

08/18/2007 08:09 PM <DIR> .

08/18/2007 08:09 PM <DIR> ..

08/18/2007 08:09 PM 5,275,136

O1_MF_1_139_3DH9MMTK_.ARC

• NO archivelogs in $OH/dbs or $OH/database

Now, look at 11g, something look out of wack here...?:

NAME TYPE VALUE

• -----------

log_archive_dest string

log_archive_dest_1 string

log_archive_dest_10 string

log_archive_dest_2 string

log_archive_dest_3 string

log_archive_dest_4 string

log_archive_dest_5 string

log_archive_dest_6 string

log_archive_dest_7 string

log_archive_dest_8 string

log_archive_dest_9 string

log_archive_dest_state_1 string

enable

log_archive_dest_state_10 string

enable

log_archive_dest_state_2 string

enable

log_archive_dest_state_3 string

enable

log_archive_dest_state_4 string

enable

log_archive_dest_state_5 string

enable

log_archive_dest_state_6 string

enable

log_archive_dest_state_7 string

enable

log_archive_dest_state_8 string

enable

log_archive_dest_state_9 string

enable

SQL> show parameter db_recover

NAME TYPE VALUE

• -----------

db_recovery_file_dest string /oracle01/flash_recovery_area

db_recovery_file_dest_size big integer 2G

--

• what is log_archive_dest_1 doing set?????

--

select dest_name, destination from v$archive_dest;

DEST_NAME DESTINATION

LOG_ARCHIVE_DEST_1 /oracle/app/oracle/product/11.1.0/db_1/dbs/arch

LOG_ARCHIVE_DEST_2 LOG_ARCHIVE_DEST_3 LOG_ARCHIVE_DEST_4 LOG_ARCHIVE_DEST_5 LOG_ARCHIVE_DEST_6 LOG_ARCHIVE_DEST_7 LOG_ARCHIVE_DEST_8 LOG_ARCHIVE_DEST_9 LOG_ARCHIVE_DEST_10 USE_DB_RECOVERY_FILE_DEST It is archiving to both locations ...

Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com! BLOG: http://robertgfreeman.blogspot.com/ Sig V1.2

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of LS Cheng   Sent: Saturday, August 18, 2007 7:31 PM   To: robertgfreeman_at_yahoo.com
  Cc: oracle-l
  Subject: Re: 11g Archive Logs?

  Hi Robert

  By default if we dont specify log_archive_dest the archved logs goes to $ORACLE_HOME/dbs, is that what you mean?

  Thanks

  --
  LSC   On 8/19/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:     Any of you fine people install 11g yet and find that your new 11g database

    was creating archived redo logs in $ORACLE_HOME/dbs?? I've got a database

    that I created with the DBCA that is doing just that, and I'll be darned if

    I can figure out why.

    RF

    Robert G. Freeman
    Oracle Consultant/DBA/Author
    Principal Engineer/Team Manager
    The Church of Jesus Christ of Latter-Day Saints     Father of Five, Husband of One,
    Author of various geeky computer titles     from Osborne/McGraw Hill (Oracle Press)     Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!

    BLOG: http://robertgfreeman.blogspot.com/     Sig V1.2

    --
    http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Sat Aug 18 2007 - 21:33:24 CDT