Generating more archive logs

Advertisement
Hi all,,
my env is Oracle 10gR2,RHEL4.0,
In my dev Db one of user table contain more than 10Lac Records .in that some duplicate are present.
I am deleting record by record it is generating more Archive log file.due to that my is database hanged.
can you tell me what are the possible reasons for gen of more arch file.
Regards,
kk
Advertisement

Replay

Hi,
If the answer is not in previous post and if you're deleting (much) more than you're keeping (i mean very large volumes) i suggest :
(create a backup table as the one you're deleting in (same structure-> not constraints))
- backup the rows you want to keep in an other table
- truncate the original table
- re-insert the backuped rows
- truncate the backuped table

More archive logs

Hello All, we are on 11.1.0.6 on AIX On our database side, finding "excessive redo log generation" at a specific time only (between 11 -12 midnight) How to find what exactly going on at that time whos causing so much redo generation. ThanksThnak

Archive log generating views

our database is running in archive log mode. i want to know which are the sessions generated/generating(sysdate and sysdate -2) more archive log . can i get it from the database view???855516 wrote: our database is running in archive log mode. i want

Recovery using Full BCV backup & archive logs

Hello DBA's , I have Last Sunday's Full BCV (Buisness Copy Volume) backup (i.e. ..... the tablespaces were taken into Backup mode then Sync the BCV, then split the BCV , take the backup of BCV and take the tabespaces in normal mode in short what we c

Best way of deleting archive logs on standby when backup taken on primary

Hello, I have a 11gr2 dataguard configuration without the broker. main problem in my particular situation arises from my FRA size on primary much more than on standby (90Gb vs 30Gb) and in some situations I'm constrained with FRA space on standby....

Archive log generation

Hai all, In My production environment, some times archives log are generating 5-6 logs a min.. very less no of users are connected to the database now.. rw-r----- 1 oraprod dba 10484224 Jan 12 14:10 prod_arch_4810.arc -rw-r----- 1 oraprod dba 1048422

Validation failed for archived log

Hi, oracle database version 11.2.0.4 OS centOS 6.5 Recently i have set rman backup scripy on production Database, As we are using dbvisit for standby database for that we have set cron which run in every 10 minutesĀ  it generates archive and copy it t

Oracle archive log move

Dear All, Please help me at the time of Netvault RMAN backup how i move the archive log file another location. Normal case if i moved the archive log file Netvault RMAN backup fail, so please suggest. Thanks, ManasHi; You have to login https://suppor

Archive log generation in standby

Dear all, DB: 11.1.0.7 We are configuring physical standby for our production system.we have the same file system and configuration for both the servers.. now primary archive destination is d:/arch and the standby server also have d:/arch .Now archiv

When to delete Archive Log files ? and is safe to delete ?

Hi all, I have a question, my DB is running in Archive Log mode and is growing day by day, so should I delete archive log files and where i find that my which files are old and how to delete theses files, for info I also take full RMAN and export bac

Managing ARCHIVE Logs in Oracle 10.2.0.3

I am working with a customer who seems to think there is a way of controling the database other than a custom JOB, script or RMAN in how it creates, manages and deletes its archive logs while running in archivelog mode. He wants the database to autom

How to find out which archived logs needed to recover a hot backup?

I'm using Oracle 11gR2 (11.2.0.1.0). I have backed up a database when it is online using the following backup script through RMAN connect target / run { allocate channel d1 type disk; backup incremental level=0 cumulative filesperset 4 format '/san/u

Archive Log vs Full Backup Concept

Hi, I just need some clarification on how backups and archive logs work. Lets say starting at 1PM I have archive logs 1,2,3,4,5 and then I perform a full backup at 6PM. Then I resume generating archive logs at 6PM to get logs 6,7,8,9,10. I then stop

RMAN failure for "archive-log ... not found in controlfile"

Recovery Manager: Release 8.1.6.0.0 - Production RMAN> connect target sys/[email protected]; 2> connect catalog rman/[email protected]; 3> 4> resync catalog; 5> 6> # Backup the database 7> run { 8> allocate channel ch1 type disk; 9> backup i

Backup archive logs problem using RMAN

Hi guys I got failure when using RMAN to backup archive log files: Starting backup at 20-APR-06 current log archived released channel: c1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAG

Archive log mode Turn off

Hi all DBA guys, Have a Nice day all If i change archive log mode to no archive log mode, internally whats happen my database?. Is this old archive log backup use for future if again convert no archive to archive log mode? What's happen flashback if

Archive gap in 9.2, archive logs are gone

Hi all, I've got an old 9.2.0.6 DataGuard setup, it's been running fine for years. We recently had to move our DR server to a new datacenter, so it got shut down, shipped and brought back up. The database came up fine, but now I see that I've got a g

How to find thead 2 archive log when i recover from 2-node RAC to single

I backup 2-ndoe RAC and restore to single - node Control file created. SQL> recover database iuckup controlfile SQL> recover database using backup controlfIle; ORA-00279: change 12100176131169 generated at 07/06/2013 16:36:57 needed for thread 1 ORA

Archive log mode in oracle 10g

Hi, I would like to know the archive log mode in oracle 10g and I use this code in SQLPlus select log_mode from v$database But it displayed: "2" not : NOARCHIVELOG or ARCHIVELOG It displayed a number, not a String. How could I know this? ThanksH

Archive Log file size

I am using Oracle database 9.2.0.1.0, My OS is Linux AS4 Update version. My database is in archive log mode, the archive file size generated on disk is 100 MB. I want to monitor the reason that why the size of redo generated is too big. Kindly sugges