Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> In need of Oracle DBA to solve Redo log file problem.

In need of Oracle DBA to solve Redo log file problem.

From: Paul S. <spider_at_magma.ca>
Date: 1998/03/17
Message-ID: <SYCP.224$N4.5207624@news.magma.ca>#1/1

I am currently writing an automated Oracle 7.1 script that

  1. Creates two temporary redo log files
  2. Deletes the eight 2MB original log files
  3. Creates eight 10MB new log files
  4. Deletes the two temporary log files
  5. Exit Oracle

The problem that I am having is when I switch log files (in order to delete the eight redo log files),
 it switches to the next unused log file,which 80% of the time is the first new temporary log file that I created.
But the issue is what if the script ran successfully then was executed 10 or 15 minutes later for a second time
it would fail because the eight new log files that you created have been set to a status of unused and not inactive. Does anyone know if I can switch to a specific group# or set the log file to inactive when I create them.

If anyone can help please e-mail me at spider_at_magma.ca .

Thanks,

Paul S. Received on Tue Mar 17 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US