RE: what's wrong with this...DBMS

From: Norrell, Brian <BNorrell_at_QuadraMed.com>
Date: Mon, 11 Jun 2001 13:55:53 -0700
Message-ID: <F001.00324912.20010611133111@fatcity.com>

The DBMS_SQL is executed inside a package, so the owner of the package must be granted the ability to switch log files directly. More than likely, he only has this privilege through a role.

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600

-----Original Message-----
Sent: Monday, June 11, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L

Hi List,

As the part of developing hot backup strategy, I am testing the following piece of code
to take care of arch files to be made avaialable along with backup set.

SQL> create or replace procedure log_switch as   2 cursor1 integer;
  3 begin
  4 cur1 := dbms_sql.open_cursor;
  5 dbms_sql.parse(cur1,'ALTER SYSTEM SWITCH LOGFILE', dbms_sql.v7);   6 dbms_sql.close_cursor(cur1);
  7 end;
  8 /

Procedure created.

SQL> execute log_switch;

PL/SQL procedure successfully completed.

But, I have observed several times that the above code is not forcing a log switch.
FYI, I want to track the sequence# of logfiles before and after the hot backup, so that
I can backup the files in that range.

Am I properly using the DBMS_SQL?
Any help is highly appreciated

TIA,
Suren
Oracle DBA
Sony
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tirumala, Surendra
INET: Surendra.Tirumala_at_am.sony.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Norrell, Brian
INET: BNorrell_at_QuadraMed.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

RE: what's wrong with this...DBMS_SQL