Questions tagged [archive]
The archive tag has no usage guidance.
113
questions
1
vote
1
answer
2k
views
DB2 - Archive Mode - on what values to set LOGPRIMARY,LOGSECOND,LOGFILSIZ?
we must set our database from CIRCULAR to ARCHIVE mode in order to enable ONLINE backups.
Backups will be done every 1 day.
Database is now almost 30GB.
Database grows approximately 1GB per month.
...
- 675
0
votes
1
answer
481
views
Connection problem after a big impdp
This morning i had a weird problem just opening the SQL developer i cannot connect to my database. I checked the log file of the impdp operation launched before (14G), all the data is imported without ...
2
votes
2
answers
34k
views
Extract Archived Log Files from RMAN Backupset
I have an RMAN backup that is taken on 19th january with: BACKUP DATABASE PLUS ARCHIVELOG command. Now I need to restore Archived logs from that backupset to some other OS directory. Is there any way ...
- 75
3
votes
2
answers
37k
views
What is the Difference between Archiving and Purging in Oracle database?
I would like to know the main difference between Archiving and Purging in any database we use.
Ramesh
0
votes
2
answers
2k
views
Inserting into mysql table with archive engine "duplicate key" error
I am trying to archive some files using mysql archive engine. I am using this query to insert file contents:
insert into test_table (id,arch) values (123,'FILE_CONTENT')
After inserting 2 records, I ...
- 1,749
1
vote
1
answer
3k
views
How does Postgres know which logs have been archived?
I'm asking this because Postgres was hard-stopped yesterday, and I fear that there could be partial / corrupt data in one of my archived log segments. I'd like to simply delete the logs from my slave ...
- 1,169
0
votes
2
answers
773
views
Using MySQL InnoDB as an Archive
My site has a main MySQL InnoDB table that it does most of its work on. New rows get inserted at a rate of 1 million per week, and rows older than a week gets moved over to an archive table on a daily ...
- 1,121
1
vote
1
answer
5k
views
Delete and archive old data from several related tables
Our schema looks like this:
table tblTrip: stores start and end trip date and time
table tblTripData: keeps all the trip data
table tblTripEvent: stores events related to the particular trip.
Then ...
- 969
1
vote
3
answers
1k
views
Design for archiving a sorted list (with ability for a few INSERT)
I have a somewhat static sorted list of words which I want to save in a database table:
-- simplified!
-- Note: the rank/order of each item is NOT calculable from other values!
CREATE table words (
...
- 111
2
votes
2
answers
723
views
Support ticket system - when/how to move old tickets?
I don't have access to the partitioning feature, but consider a support ticket system with tens of thousands of tickets being opened everyday and taking about a week to a couple of months in getting ...
- 75
2
votes
1
answer
3k
views
Archive database on Postgres
I have a table with more than 60mio records, where every month I have to add about 2-4 milions. It's not insert only table, I need to read from it and update recently added rows (status changes, etc.)....
- 163
18
votes
1
answer
12k
views
Database archive solutions
In continuation to a question posted by me on Is it a good idea to move high-volume and highly-accessed tables to a separate database?, am looking out for different techniques/solutions available for ...
- 977
3
votes
1
answer
3k
views
Data archival strategy that handles schema changes?
I am working with a legacy application that has about ten years of customer data. A majority of this data is not used in day-to-day operations but there is a business requirement to have the data ...
- 2,619