RE: 11g Archive Logs?
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 18 Aug 2007 20:33:24 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of LS Cheng
Sent: Saturday, August 18, 2007 7:31 PM
To: robertgfreeman@xxxxxxxxx
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
