- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9i and Redo log
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
тАО04-28-2005 06:45 PM
тАО04-28-2005 06:45 PM
Re: Oracle 9i and Redo log
Make sure the logfiles are not in stale mode.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 09:56 PM
тАО04-28-2005 09:56 PM
Re: Oracle 9i and Redo log
a glance at the alert.log and the status of logfiles (select * from v$log; ) would have helped us in the diagnosis...
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-01-2005 05:03 AM
тАО05-01-2005 05:03 AM
Re: Oracle 9i and Redo log
reasons for archiver stuck :
1) one or more archive destination(s) out of space
check in sqlplus "show parameter archive"
Watch it, if you have configured several destinations all of them need to be checked!
2) archive destination(s) not writable (check permission or (!) filesystem quota for db-user)
3) archiver process died "ps -ef | grep arc"
for whatever reason.
4) alert.log file in background_dump_dest can not grow. This one is not well known and I never faced it myself in real life. But if you have no errors in there, it would be a good explanation. Watch for space and permissions in this case!
5) one of the controlfiles can not grow dynamicly to update the archive log history upon a logswitch. -> This one should be logged in the alert file, with message indicating write failure to controlfile.
Pretty sure you will find what is defective, if you "tail -f" the alertfile while doing the logswitches that bring the DB to stopp. If you have no messages at all, check reason 4)
Good hunting
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-01-2005 07:29 AM
тАО05-01-2005 07:29 AM
Re: Oracle 9i and Redo log
additionally you might want to check the ownership of all your oracle files, especially the alert-log, the online-redologs, the offline-redologs (and the directory containing those), the datafiles, and the codefiles "oracle" and "tnslsnr". All should be owned by your "oracle" user and the "dba" group (well, use the names your installation is done with).
Show us the "ls -ld" output of those, please.
Maybe you are using "quotas" on those filesystems?
Or an "ulimit" is set from within your "/etc/profile" or your "oracle" user's profile scripts (.profile, .shrc, and such)?
FWIW,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-02-2005 04:41 AM
тАО05-02-2005 04:41 AM
Re: Oracle 9i and Redo log
LOCATION='/u01/maximus/admin/archive'
and after exporting it a pfile and trying to recompile it as a spfile it balked. The correct format for 9i is:
log_archive_dest_1:
'/u01/maximus/admin/archive'
after dropping the word 'LOCATION' from the file, it compiled fine and it works :) THank you for all of your help and points will be assigned :)
Darren
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-02-2005 04:44 AM
тАО05-02-2005 04:44 AM
Re: Oracle 9i and Redo log
ORACLE 8 pfile:
log_archive_start = true
log_archive_dest_1 = "location=/u10/tech/arch"
log_archive_format = arch_%t_%s.arc
ORACLE 9i pfile:
*.log_archive_dest='/u10/tech/arch'
*.log_archive_format = 'arch_%t_%s.arc'
*.log_archive_start=true
Shutdown Immediate;
startup mount ;
alter database archivelog;
archive log start;
alter database open;
archive log list ;
alter system switch logfile ;
alter system archive log start to '/u10/tech/arch' ;
- « Previous
-
- 1
- 2
- Next »