- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- archive log deleted
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
тАО05-19-2009 05:48 AM
тАО05-19-2009 05:48 AM
archive log deleted
Database is in archivelog mode , i have errors in alert.log :
ORA-27072: File I/O error
HPUX-ia64 Error: 2: No such file or directory
Additional information: 4
Additional information: 5121
Additional information: 405504
ORA-19502: write error on file "/pcard15/oradata/pcard/arch/1_135_681813764.dbf", blockno 5121 (blocksize=1024)
Tue May 19 15:00:07 2009
ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/pcard15/oradata/pcard/arch/1_135_681813764.dbf' (error 19502)
Tue May 19 15:00:07 2009.....archive log files have been deleted from the location.Databse is running , should i shutdown the DB with shutdown immediate or shutdown normal command ?On startup will the DB require recovery .I am not a DBA , please help .will restarting the DB , make DB normal and in archive log mode .
Regards ,
DeafFrog.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2009 07:16 AM
тАО05-19-2009 07:16 AM
Re: archive log deleted
No need to shut the database down, though this will do the trick.
1) Make sure there is sufficient space for the file, you may have run out of archive log space.
2) Any database checkpoint is sufficient to set up a restore point, along with a hot backup.
That being said, I'd go for a shutdown, full backup and database start. Cold backups are much easier to work with.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2009 09:32 PM
тАО05-19-2009 09:32 PM
Re: archive log deleted
db dont need any recovery for archive logs...also for archive files deletion dont need any DB reboot..if for other cause you want to shut DB's then use shut immediate
archive logs are copy of the redo log files..if redo log deleted then we need recovery
archivelog is not must for database we can run the database in no archive mode also
archive files are not the part of the DB
startup will require recovery if we shutdown?
no recovery is needed.
recovery require only if datafiles,redo log files and control files deleted from databases
for archive no need..its just like backup redo log files thats All,
let me know if you have any other query,
thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2009 10:27 PM
тАО05-19-2009 10:27 PM
Re: archive log deleted
Thanks for the help. This weekend i will shutdown the DB take a cold backup and then start it again. everything goes fine, i will update the this thread and close it.Once again thanks a lot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-02-2009 02:32 AM
тАО07-02-2009 02:32 AM