[Fwd: backup problem]
Woop! Dumb question. Never mind. Original Message Date: Tue, 16 Sep 2003 12:02:54 -0500 To: ORACLE-L ORACLE-L [EMAIL PROTECTED] All - I am implementing RMAN on my unix boxes. The dbs are already in archivelog mode for about a year. The system admin was backing up the files from cold backups. Today we realize the backups are no good. The tape is unreadable. Most of the archived logs (.arc) files have been removed from the system. Now I have no way to put them back! How can I set rman to start backing up from today forward? Hoping to get a good backup and dependable from rman. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Fwd: A problem
Hi ! May be this will help you (I hope). This solution is for Windows (X) but with some work it will do also in UNIX. A procedure called BackupOSC is created by the DBA in his schema. A job is created with at command, invoking the batch command file backup_OSC.cmd wich in turn calls SQLPLUSW to run the above procedure. The outcome is a batch command file called exp_OSC.cmd wich is invoked by the firts batch file to perform the real export. The secret is to use the SQL to create the second file since DOS hasn't the ability to handle strings. The example files are within an attached zip file. The file exp_Ora.ftp is a parameter file for to FTP the DMP files to other machine. If you find some strange words in the files, they are Portuguese. Hope it helps. Dias Costa P.S.: My apologies for I have sent the files unziped. Jared Still wrote: -- Forwarded Message -- Date: Wed, 21 Nov 2001 15:34:27 +0100 I have created a job to export a user shema How can I tell Oracle each time it make the export to use lets say namedate.dmp I mean for example if today is 21.11.2001 the exported file whoud have name21112001.dmp or something like this... --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Dias Costa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Fwd: A problem
Hi ! May be this will help you (I hope). This solution is for Windows (X) but with some work it will do also in UNIX. A procedure called BackupOSC is created by the DBA in his schema. A job is created with at command, invoking the batch command file backup_OSC.cmd wich in turn calls SQLPLUSW to run the above procedure. The outcome is a batch command file called exp_OSC.cmd wich is invoked by the firts batch file to perform the real export. The secret is to use the SQL to create the second file since DOS hasn't the ability to handle strings. Hope it helps. Dias Costa P.S.: The files are attached. The file exp_Ora.ftp is a parameter file for to FTP the DMP files to other machine. If you find some strange words in the files, they are Portuguese. Jared Still wrote: -- Forwarded Message -- Date: Wed, 21 Nov 2001 15:34:27 +0100 I have created a job to export a user shema How can I tell Oracle each time it make the export to use lets say namedate.dmp I mean for example if today is 21.11.2001 the exported file whoud have name21112001.dmp or something like this... --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). exp_OSC.cmd Description: application/unknown-content-type-cmdfile The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. -- file: backupSmartUser.sql -- - set linesize 300 set echo on set feed off set serveroutput on size 1 set sqlprompt 'REM ' spool D:\Export_Oracle\exp_OSC.cmd execute system.BackupOSC; spool off exit -- file: cp_BackupOSC.sql -- -- -- -- procedure invoked for the backup of schema: OSC -- -- create or replace procedure BackupOSC as -- Linha0 varchar2 (20); Linha1 varchar2 (100); Linha2 varchar2 (200); Linha3 varchar2 (30); Linha4 varchar2 (40); Linha5 varchar2 (250); Linha6 varchar2 (250); Linha7 varchar2 (10); begin Linha0 := 'ECHO ON'; -- SELECT 'ECHO ' into Linha1 FROM DUAL; -- SELECT 'ECHO Backing up the OSC user (Instance DC8i) done on: ' || TO_CHAR(SYSDATE,'/MM/DD') || ' starting time ' || TO_CHAR(SYSDATE,'hh:mm:ss') into Linha2 FROM DUAL; -- Linha3 := 'SET ORACLE_SID=DC8i'; Linha4 := 'SET ORACLE_HOME=E:\ORACLE\ORA81'; -- SELECT 'exp USERID=system/manager owner=OSC FILE=d:\Export_Oracle\OSC_' || TO_CHAR(SYSDATE,'MMDD_HHMI') || ' LOG=d:\Export_Oracle\OSC_' || TO_CHAR(SYSDATE,'MMDD_HHMI') || ' BUFFER=40 COMPRESS=y' into Linha5 FROM DUAL; -- SELECT 'ECHO Backup finished: ' || TO_CHAR(SYSDATE,'hh:mi:ss') || ' d:\Export_Oracle\OSC_backups.log' into Linha6 FROM DUAL; -- Linha7 := 'EXIT'; -- dbms_output.put_line(linha0); dbms_output.put_line(linha1); dbms_output.put_line(linha2); --dbms_output.put_line(Linha3); not needed --dbms_output.put_line(Linha4); not needed dbms_output.put_line(linha5); dbms_output.put_line(linha6); --dbms_output.put_line(linha7); will see end BackupOSC; / oracle01 franca4 binary prompt no cd /usr/oraexp mput d:\Export_Oracle\*.DMP bye backup_OSC.cmd Description: application/unknown-content-type-cmdfile
Re: Fwd: A problem
Try sumthin' like:
EDATE=$(date +%C%y%m%d)
FILENAME=name${EDATE}.dmp
exp / file=${FILENAME} ...
Do a 'man date' to see the different formatting options.
HTH,
Scott Shafer
San Antonio, TX
Jared Still wrote:
-- Forwarded Message --
Date: Wed, 21 Nov 2001 15:34:27 +0100
I have created a job to export a user shema
How can I tell Oracle each time it make the export to use lets say
namedate.dmp
I mean for example if today is 21.11.2001
the exported file whoud have name21112001.dmp or something like this...
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Fwd: A problem
-- Forwarded Message -- Date: Wed, 21 Nov 2001 15:34:27 +0100 I have created a job to export a user shema How can I tell Oracle each time it make the export to use lets say namedate.dmp I mean for example if today is 21.11.2001 the exported file whoud have name21112001.dmp or something like this... --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Fwd: Extproc problem...
Try: ld -m /data1/dev/uexit/test/extproc.so
-Original Message-
Sent: Sunday, November 18, 2001 10:45 PM
To: Multiple recipients of list ORACLE-L
Hi,
Pl use the equivalent of DLL walker of NT in Unix to find the exact name of
the shared object that you have created. The shared object created by you
will have some name appended during the compilation of the program. Pl use
this name and ref the same in Oracle.
HTH
--
On Sun, 18 Nov 2001 16:25:17
Jared Still wrote:
-- Forwarded Message --
Date: Sun, 18 Nov 2001 22:47:09 -
To: 'Jared Still' [EMAIL PROTECTED]
Hi Jared,
I am sure you can help me on this.
I am encountering problems to run an O/S command from a stored
procedure/procedure.
The error log is as follows...
SQLcreate library shell_lib as '/data1/dev/uexit/test/extproc.so';
SQL create or replace function sysrun (syscomm in varchar2)
2 return binary_integer
3 as external
4 name sysrun
5 library shell_lib
6 parameters(syscomm string);
7 /
Function created.
SQL declare rc number;
2 begin rc := sysrun('/bin/ls -l');
3 dbms_output.put_line('Return Code='||rc);
4 end;
5 /
declare rc number;
*
ERROR at line 1:
ORA-06521: PL/SQL: Error mapping function
ORA-06522: ld.so.1: extprocextproc: fatal: sysrun: can't find symbol
ORA-06512: at UEXIT.SYSRUN, line 0
ORA-06512: at line 2
Could you please help on this.
Thanks a lot.
Baral
***
**
This message is confidential and for use by the addressee only. If you
are not the intended recipient, you must not use, disclose, distribute,
copy, print, or rely on this message. Please notify the sender by
return email and then delete the message from your computer. Royal Skandia
accepts no responsibility for changes made to this message after it was
sent nor for any loss or damage from receipt or use.
Royal Skandia Life Assurance Limited - a member of the Skandia Group of
Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia
House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated
by the Personal Investment Authority for UK Investment Business -
Member of the Association of International Life Offices.
Internet: http://www.royalskandia.com
***
**
---
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: C.S.Venkata Subramanian
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Khedr, Waleed
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Re: Fwd: Extproc problem...
Khedr, Waleed wrote:
Try: ld -m /data1/dev/uexit/test/extproc.so
-Original Message-
Sent: Sunday, November 18, 2001 10:45 PM
To: Multiple recipients of list ORACLE-L
Hi,
Pl use the equivalent of DLL walker of NT in Unix to find the exact name of
the shared object that you have created. The shared object created by you
will have some name appended during the compilation of the program. Pl use
this name and ref the same in Oracle.
HTH
--
On Sun, 18 Nov 2001 16:25:17
Jared Still wrote:
-- Forwarded Message --
Date: Sun, 18 Nov 2001 22:47:09 -
To: 'Jared Still' [EMAIL PROTECTED]
Hi Jared,
I am sure you can help me on this.
I am encountering problems to run an O/S command from a stored
procedure/procedure.
The error log is as follows...
SQLcreate library shell_lib as '/data1/dev/uexit/test/extproc.so';
SQL create or replace function sysrun (syscomm in varchar2)
2 return binary_integer
3 as external
4 name sysrun
5 library shell_lib
6 parameters(syscomm string);
7 /
Function created.
SQL declare rc number;
2 begin rc := sysrun('/bin/ls -l');
3 dbms_output.put_line('Return Code='||rc);
4 end;
5 /
declare rc number;
*
ERROR at line 1:
ORA-06521: PL/SQL: Error mapping function
ORA-06522: ld.so.1: extprocextproc: fatal: sysrun: can't find symbol
ORA-06512: at UEXIT.SYSRUN, line 0
ORA-06512: at line 2
Could you please help on this.
Thanks a lot.
Baral
Innocent question : is LD_LIBRARY_PATH correctly set to include the
directory where the .so is located ?
--
Regards,
Stephane Faroult
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax:+44 (0) 7050-696-449
Performance Tools Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Fwd: Extproc problem...
-- Forwarded Message --
Date: Sun, 18 Nov 2001 22:47:09 -
To: 'Jared Still' [EMAIL PROTECTED]
Hi Jared,
I am sure you can help me on this.
I am encountering problems to run an O/S command from a stored
procedure/procedure.
The error log is as follows...
SQLcreate library shell_lib as '/data1/dev/uexit/test/extproc.so';
SQL create or replace function sysrun (syscomm in varchar2)
2 return binary_integer
3 as external
4 name sysrun
5 library shell_lib
6 parameters(syscomm string);
7 /
Function created.
SQL declare rc number;
2 begin rc := sysrun('/bin/ls -l');
3 dbms_output.put_line('Return Code='||rc);
4 end;
5 /
declare rc number;
*
ERROR at line 1:
ORA-06521: PL/SQL: Error mapping function
ORA-06522: ld.so.1: extprocextproc: fatal: sysrun: can't find symbol
ORA-06512: at UEXIT.SYSRUN, line 0
ORA-06512: at line 2
Could you please help on this.
Thanks a lot.
Baral
*
This message is confidential and for use by the addressee only. If you
are not the intended recipient, you must not use, disclose, distribute,
copy, print, or rely on this message. Please notify the sender by
return email and then delete the message from your computer. Royal Skandia
accepts no responsibility for changes made to this message after it was
sent nor for any loss or damage from receipt or use.
Royal Skandia Life Assurance Limited - a member of the Skandia Group of
Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia
House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated
by the Personal Investment Authority for UK Investment Business -
Member of the Association of International Life Offices.
Internet: http://www.royalskandia.com
*
---
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
