- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Confused about archiving Oracle 10g
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2008 04:00 PM
тАО07-03-2008 04:00 PM
Confused about archiving Oracle 10g
# Uncommenting the line below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
log_archive_start = true
log_archive_dest = /u11/oradata/odb
log_archive_format = "T%TS%S.ARC"
But I have nothing there!
But I do have alot of arch1####.dbf files in a different directory that does not make sense.
And it is actually filling up our slice.
Why are they there?
/u01/app/oracle/product/10.2.0.2/DB1/dbs
arch1_44_658249860.dbf
yada yada
I have not done any backups, this is a brand new database with no activity so far. Empty tables.
What do I need to do?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2008 04:10 PM
тАО07-03-2008 04:10 PM
Re: Confused about archiving Oracle 10g
SQL> show parameter log_archive
Note. The format you show does not look correct. It will trigger error:
ORA-19905: log_archive_format must contain %%s, %%t and %%r
Cause: log_archive_format is missing a mandatory format element. Starting with Oracle 10i, archived log file names must contain each of the elements %s(sequence), %t(thread), and %r(resetlogs id) to ensure that all archived log file names are unique.
If there is nothing much in the DB, then I suggest that for now you
- shut down DB;
- Purge the out those ARC files;
- Create a fresh physical backup;
- Restart with newly selceted archive destination and file naming.
ARC files are only useful in conjuction with a solid physical/rman backup. Time to hit the books!
Good luck,
Hein van den Heuvel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2008 04:11 PM
тАО07-03-2008 04:11 PM
Re: Confused about archiving Oracle 10g
http://www.orafaq.com/parms/parm1163.htm
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2008 05:45 PM
тАО07-03-2008 05:45 PM
Re: Confused about archiving Oracle 10g
I have no errors about formating.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/product/10.2.0.2/DB1/dbs/arch
Oldest online log sequence 98
Next log sequence to archive 100
Current log sequence 100
This is not where I stated in the init.ora file.
SQL> show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2008 06:06 PM
тАО07-03-2008 06:06 PM
Re: Confused about archiving Oracle 10g
well, obviously the init.ora file is not being interpreted. If it was, then you woudl get the error and some value in the active parameter: "log_archive_dest string
Now the init file typically would NOT be called init.ora but rather init
There may also be a confusion whether and parameter file (PFILE, like init.ora) or an Oracle server file (SFILE) is being used.
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2008 06:49 PM
тАО07-03-2008 06:49 PM
Re: Confused about archiving Oracle 10g
Now to correct this...
Shutdown Database
remove arch*.dbf files.
Make changes to the CORRECT initodb.ora file
Restart the database.
Bingo-bango done...