- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Archivelog and the purpose
Operating System - HP-UX
1753925
Members
8938
Online
108810
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО06-19-2007 09:26 PM
тАО06-19-2007 09:26 PM
Archivelog and the purpose
Hi all,
Allow me ask this simple question.
What is archivelog for in oracle Data Guard?
Can we all delete this file? What is the impact? If db crash can it be restored?
Is it normal it will create 3GB archivelog daily?
Thanks,
Fauziah
Allow me ask this simple question.
What is archivelog for in oracle Data Guard?
Can we all delete this file? What is the impact? If db crash can it be restored?
Is it normal it will create 3GB archivelog daily?
Thanks,
Fauziah
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-19-2007 10:05 PM
тАО06-19-2007 10:05 PM
Re: Archivelog and the purpose
The archivelogs are a way to get online backups.
When Oracle is configured for online backups, it will produce an archivelog of all database changes.
To completely recover a database, you'll need the latest full dump of the database *and* an unbroken series of archivelogs from the time of the last dump up to the present. This way you can return the database to the exact state it was just before the problem that caused the need to recover.
If you take a full dump of the database and are sure you don't need to restore the database to a point in time before the dump, you're then free to delete all the archivelogs from the time before the dump.
3GB of archivelog daily means that you get about 3GB worth of changes to your database. Of course the archivelog is a bit bigger than the actual sum of changes, because it includes change timestamps and some other metadata.
MK
When Oracle is configured for online backups, it will produce an archivelog of all database changes.
To completely recover a database, you'll need the latest full dump of the database *and* an unbroken series of archivelogs from the time of the last dump up to the present. This way you can return the database to the exact state it was just before the problem that caused the need to recover.
If you take a full dump of the database and are sure you don't need to restore the database to a point in time before the dump, you're then free to delete all the archivelogs from the time before the dump.
3GB of archivelog daily means that you get about 3GB worth of changes to your database. Of course the archivelog is a bit bigger than the actual sum of changes, because it includes change timestamps and some other metadata.
MK
MK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-20-2007 01:02 AM
тАО06-20-2007 01:02 AM
Re: Archivelog and the purpose
hi,
As Matti mentions above, your database is generating archiving log files with respect to the amount of transaction occurring on it.
In a standby database condition, these archived log files are copied from the Primary database to the Standby database where they are applied. The log files make the Standby database more current of the primary database.
In cases of major crashes, you may be required to provide some of the archived log files during the recovery process. Of course, the full backup + archived log files relative to last full backup.
If you have RMAN configured, "management" of these archived redologs are much easier. All you have to do is scheduled RMAN backup of archived redologs at different point in time during day. The backup process can be configured to automatically delete the archived redolog files that have already been backed up.
if you need further clarification, please let us know.
kind regards
yogeeraj
As Matti mentions above, your database is generating archiving log files with respect to the amount of transaction occurring on it.
In a standby database condition, these archived log files are copied from the Primary database to the Standby database where they are applied. The log files make the Standby database more current of the primary database.
In cases of major crashes, you may be required to provide some of the archived log files during the recovery process. Of course, the full backup + archived log files relative to last full backup.
If you have RMAN configured, "management" of these archived redologs are much easier. All you have to do is scheduled RMAN backup of archived redologs at different point in time during day. The backup process can be configured to automatically delete the archived redolog files that have already been backed up.
if you need further clarification, please let us know.
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP