RE: RMAN scripts - archived logs

the control file. -Original Message- > Would somenone share their scripts used to backup > archived logs disk_backup_arch.rcv Description: Binary data tape_backup_arch.rcv Description: Binary data

RMAN scripts - archived logs

Good day to everyone   Would somenone share their scripts used to backup archived logs using RMAN 8.1.7? The more complex, the better...   Thanks, Vladimir Barac

Re: Archived logs backup

copies of the archive logs on tape, in case one of the copies has an error. You have the last day of archived logs online for speedy recovery and no problems with archive logs that were created just as you copy them.   Yechiel AdarMehish - Original Message - From: Vladimir Barac

Re: Archived logs backup

if it's not just running ... ... bur i agree it's MOST portable yr way kr mr >>> [EMAIL PROTECTED] 12/05/02 15:48 PM >>> more portable to query V$ARCHIVED_LOG after runninig ARCHIVE LOG ALL instead of using OS utilities... - Original Message - To: "Multiple recipients of list ORACLE-L" <[

RE: Archived logs backup

-Original Message- I want to write unix script to automate archved logs backup to tape ... After hot backup of data files is completed... Within script how do I skip archived log file that is being written by oracle? --- Here is my cron

RE: Archived logs backup

-Original Message- Within script how do I skip archived log file that is being written by oracle? - I took another look at this and figured out what you were really asking. The commands: "ls -1rt" or "ls -1t" will list the files in the d

Re: Archived logs backup

more portable to query V$ARCHIVED_LOG after runninig ARCHIVE LOG ALL instead of using OS utilities... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 5:18 AM > must be currently reserved/open for writing. try lsof to f

Re: Archived logs backup

must be currently reserved/open for writing. try lsof to find out yr file to be excluded. kr mr >>> [EMAIL PROTECTED] 12/05/02 12:32 PM >>> Hi! I want to write unix script to automate archved logs backup to tape ... After hot backup of data files is completed... Within script how do I skip arc

Archived logs backup

Hi!   I want to write unix script to automate archved logs backup to tape ... After hot backup of data files is completed...   Within script how do I skip archived log file that is being written by oracle?   Thanks, Vladimir Barac  

Re: how to identify what sql statements are generating archived logs

ou have the SID of the culprit(s), it is easy identify the SQL involved. David Jones wrote: > > Dear Listers: > > Any way (other than LogMiner) to easily identify what sql statements running > now are generaing > archived logs ? I have suddenly a lots of archived logs generate

how to identify what sql statements are generating archived logs

Dear Listers: Any way (other than LogMiner) to easily identify what sql statements running now are generaing archived logs ? I have suddenly a lots of archived logs generated and almost fillup my file system. TIA --David Jones

RE: buffer writes vs. archived logs generation

o: Multiple recipients of list ORACLE-L > Subject: buffer writes vs. archived logs generation > > > FYI, > > I just compared audit trail data for buffer writes against > the number of > archived logs generated per day. > > Although there appears to be a vague corr

buffer writes vs. archived logs generation

FYI, I just compared audit trail data for buffer writes against the number of archived logs generated per day. Although there appears to be a vague correspondence between the two, it is not always the case. I would have thought that the relationship would have been more direct. Would anyone

Re: Archived logs

On Tue, Aug 21, 2001 at 01:53:07PM -0800, Aldi Barco wrote: > Hi, > > My database generated so many archived log now, let say 20 archived log per > minute. The application and the number of rows in the database is not too > much different with few days ago. How did you determine this to be tr

Re: Archived logs

Barco" com> cc: Sent by: Subject:

Re: Archived logs

Check for code doing insert,delete,update etc in v$sqlarea.. you may run following script to check for active sessions resulting lot of DML's select substr(username,1,10)"USER",process,sid,substr(sql_text,1,200),disk_reads,buffer_gets,rows_processed from v$session,v$sqlarea where sql_address=add

Archived logs

Hi, My database generated so many archived log now, let say 20 archived log per minute. The application and the number of rows in the database is not too much different with few days ago. I'm just wondering why. Is it any parameter we need to set to reduce the number of this archived log files

Archived logs

Hi, My database generated so many archived log now, let say 20 archived log per minute. The application and the number of rows in the database is not too much different with few days ago. I'm just wondering why. Is it any parameter we need to set to reduce the number of this archived log files

Re: Archived logs Miss Rate?

- To: "LazyDBA mailing list" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 12:16 PM > > Here is our archivelog house keeping strategy: > Archived logs are backed up approximately every 30 minutes and are then > moved to a different filesystem ARCDATA. A Unix shell

Re: Monitoring Archived Logs

Lindsay, Here are some points to ponder to help you develop a strategy for maintaining archive logs. If you use 3rd party backup software, does it make provision for maintaining archive logs? This will influence your decisions. Do you have a SLA? ( service level agreement ) If so, this will h

Monitoring Archived Logs

Hi, Does anyone have a monitoring script and/or strategy for maintaining current archived redo log files and deleting old ones? Thanks, Lindsay ACS Governement Services -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lindsay Stoddard INET: [EMAIL PROTECTED] Fat C