-none-

Mailing List

Home

Forum Home

Oracle List - by freelists.org

Oracle on SUSE Linux - Runing Oracle on SUSE Linux

Oracle database error code ...

www.freelists.org

Subjects

•	ORA 12540: TNS:internal limit restriction exceeded
•	ORA 12838 please : Is possible to append two times to the same table befo
•	ORA 12838 please : Is possible to append two times to the same table before
•	ora 04031
•	ora 12500 on windows
•	ORA 32004: obsolete and/or deprecated parameter(s) specified
•	ORA 01925: maximum of 30 enabled roles exceeded
•	ORA 01925: maximum of 30 enabled roles exceeded
•	ora 12500 on windows
•	ORA 01650, one idea
•	ORA 01650
•	ORA 4030
•	ORA 12838 please : Is possible to append two times to thesametable before do
•	ORA 12838 please : Is possible to append two times to thesame table before d
•	ORA 01536
•	ORA 03113 end of file on communication channel
•	ORA 32004: obsolete and/or deprecated parameter(s) specified
•	ORA 00600:
•	ORA 00020: maximum number of processes (%s) exceeded
•	ORA 01925: maximum of 30 enabled roles exceeded
•	ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
•	ora 12500 on windows
•	ora 12500 on windows
•	ora 12500 on windows
•	ORA 01650, one idea
•	ora 12500 on windows
•	ora 12500 on windows
•	ora 12500 on windows
•	ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
•	ORA 01650, one idea
•	ORA 01650, one idea
•	ORA 01650, one idea
•	ORA 01650
•	ORA 01650
•	Subject: ora 01031
•	ORA 4030
•	ORA 4030
•	ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
•	Subject: Re: ORA 01722 invalid number

-none-

-none-

2007-10-31 - By -not available-

Back
Spool Off

Exit
-- ---- ---- ---- ---- ---- ---- ---

Jack C. Applewhite - Database Administrator
Austin I.S.D.
414.9715 (phone) / 935.5929 (pager)

"David Barbour" <david.barbour1@(protected)>
10/31/2007 04:09 PM

To
"Elliott, Patrick" <patrick.elliott@(protected)>
cc
"JApplewhite@(protected)" <JApplewhite@(protected)>, oracle-l
<oracle-l@(protected)>
Subject
Re: Data Guard Delete Applied ArcLogs

Hmmm....I'm using a catalog and don't think I'd want to do that. I think
(from experience) if you're using a recovery catalog and run that command
from the standby, you're going to risk deleting logs on the primary as
well as potentially deleting logs that haven't been applied (what if your
managed recovery process crashes for some reason?).

On 10/31/07, Elliott, Patrick <patrick.elliott@(protected)> wrote:
You could just write an RMAN script to do it. Add the command below to
delete the archivelogs up until yesterday. You can connect with nocatalog
if you don't have an RMAN catalog.

DELETE ARCHIVELOG UNTIL TIME = sysdate -1;
Pat

From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of David Barbour
Sent: Wednesday, October 31, 2007 12:59 PM
To: JApplewhite@(protected)
Cc: oracle-l
Subject: Re: Data Guard Delete Applied ArcLogs

Hi Jack,

In 9i, unless you're backing up from the standby and specify delete all
input(which has pitfalls and perils all its own), you're going to have to
script something.

On 10/31/07, JApplewhite@(protected) < JApplewhite@(protected)> wrote:

Oracle9i ( 9.2.0.8) on HPUX.

Am I just missing it or is there no way to configure a Physical Standby
and/or Data Guard Broker to automatically delete archived redo logs after
they are successfully applied? I've searched the docs and can't find that
it's possible. I also checked to see if RMan could do it - no luck.

Will I just have to cron a script to periodically query V$Archived_Log and
generate the rm commands?

Thanks.

Jack C. Applewhite - Database Administrator
Austin I.S.D.
414.9715 (phone) / 935.5929 (pager)

--=_alternative 00755F5486257385_=
Content-Type: text/html; charset="US-ASCII"

 Thanks to everyone.  I decided
to do something like what I used to do with my 8i Standby - create and
run a shell script every hour using the following (called from a cron'd
shell script).  I know it'll produce error messages for the logs already
removed, but those get directed to /dev/null.
 -- ---- ---- ---- ---- ---- ---- ---
 Set PageSize 0
 Set Time     Off
 Set Timing   Off
 Set Feedback Off
 
 Connect / As SysDBA
 
 Spool rm_applied_arclogs_run.sh
 
 Select 'rm ' || Name
 From   V$Archived_Log
 Where  Completion_Time > SysDate
- 1
 And    Applied    
    = 'YES'
 Order By Sequence#
 /
 
 Spool Off
 
 Exit
 
-- ---- ---- ---- ---- ---- ---- ---
 
Jack C. Applewhite - Database Administrator 
Austin I.S.D. 
414.9715 (phone) / 935.5929 (pager) 

 
 
 
<table width=100%>
<tr valign=top>
<td width=40%>"David Barbour"
<david.barbour1@(protected)> 
10/31/2007 04:09 PM
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right>To</div>
<td>"Elliott, Patrick" <patrick
.elliott@(protected)>
<tr valign=top>
<td>
<div align=right>cc</div>
<td>"JApplewhite@(protected)"
<JApplewhite@(protected)>, oracle-l <oracle-l@(protected)>
<tr valign=top>
<td>
<div align=right>Subject</div>
<td>Re: Data Guard Delete Applied ArcLogs
</table>
 
<table>
<tr valign=top>
<td>
<td></table>
 </table>
 Hmmm....I'm using a catalog and don't think I'd want to
do that.  I think (from experience) if you're using a recovery catalog
and run that command from the standby, you're going to risk deleting logs
on the primary as well as potentially deleting logs that haven't been applied
(what if your managed recovery process crashes for some reason?).   

 On 10/31/07, Elliott, Patrick <<a href=mailto
:patrick.elliott@(protected)>patrick.elliott
@(protected)</a>>
wrote:
 You could just write an RMAN script
to do it.  Add the command below to delete the archivelogs up until
yesterday.  You can connect with nocatalog if you don't have an RMAN
catalog.
  
 DELETE ARCHIVELOG UNTIL TIME =
sysdate -1; 
Pat 
 
 
<hr>From: <a href="mailto:oracle-l
-bounce@(protected)" target=_blank>oracle-l-bounce@(protected)</a>
[mailto:<a href="mailto:oracle-l-bounce@(protected)" target=_blank>
oracle-l-bounce@(protected)</a>]
On Behalf Of David Barbour 
Sent: Wednesday, October 31, 2007 12:59 PM 
To: <a href=mailto:JApplewhite@(protected) target=_blank>JApplewhite@(protected)</a>
 
Cc: oracle-l 
Subject: Re: Data Guard Delete Applied ArcLogs 

 Hi Jack, 
 
In 9i, unless you're backing up from the standby and specify delete all
input(which has pitfalls and perils all its own), you're going to have
to script something.   

 On 10/31/07, <a href=mailto:JApplewhite@(protected)
target=_blank>JApplewhite@(protected)</a>
< <a href=mailto:JApplewhite@(protected) target=_blank>JApplewhite@(protected)</a>>
wrote: 
 
Oracle9i (<a href=http://9..2.0.8/ target=_blank>
9.2.0.8</a>) on HPUX.
 
 
Am I just missing it or is there no way to configure a Physical Standby
and/or Data Guard Broker to automatically delete archived redo logs after
they are successfully applied?  I've searched the docs and can't find
that it's possible.  I also checked to see if RMan could do it - no
luck. 
 
Will I just have to cron a script to periodically query V$Archived_Log
and generate the rm commands? 
 
Thanks. 
 
Jack C. Applewhite - Database Administrator 
Austin I.S.D. 
414.9715 (phone) / 935.5929 (pager)
 
<table width=100%>
<tr>
<td width=100% bgcolor=white></table>
 
 
--=_alternative 00755F5486257385_=--
--
http://www.freelists.org/webpage/oracle-l