Opinion on Changing Names
Hi list, Every night I update the development DB through a cron job, now I have the requirement of change or scramble the names of our customers to protect and privacy of information. I have been thinking of adding a procedure to the script that update all the names using a REPLACE clause and change some letters. Is there any way or a better one to accomplish that ? Scenario 8.1.7.4 from HP-UX (Prod) to RH AS 1.2 8.1.7.4 (lab). TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 winmail.dat
RE: RMAN Retention Policy
Thomas, You are right it's new in 9i Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Thursday, December 18, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Ian, I think retention policy is new in 9i. I purge my repository of backups that are older than 90 days (because our tape systems rotates and reuses tapes after that time) using the change backuppiece 330783 delete; command. I run a sql script againts the rman repository looking for pieces that satisfy this requirement. The sql looks like this: select 'change backuppiece bp.bp_key delete;' from rc_backup_piece bp,rc_database db where db.name = upper('ORACLE_SID') and bp.db_id = db.dbid and bp.start_time sysdate-90 / This is in an 8i database. Hope this is what you were looking for. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, December 17, 2003 5:04 PM To: Multiple recipients of list ORACLE-L How is this set on 8.1.7 and 8.1.6 databases RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found identifier: expecting one of: compatible RMAN-01008: the bad identifier was: RETENTION RMAN-01007: at line 1 column 11 file: standard input I looked at commands such as crosscheck backup of database completed before 'SYSDATE-7'; delete expired backup of database completed before 'SYSDATE-7'; But crosscheck only expires backups which are in the catalog, but not available on the backup media. Do I have to use the change command and designate each backup piece? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?Q?Ram=F3n_Estevez?= 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: How to refresh
I do that every night, but I drop the user to be refresh in the test db, is not a big DB. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Tuesday, December 16, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hi Ron, For just testdata you might take a look at http://www.databee.com/main.htm, this can help you. Dennis' method will work, but doesn't answer your question, because a production copy will overwrite all new functionality as well. However, his suggestion isn't as bad as it might seem on a first sight. How is the user/developer gonig to install all new functionality/triggers/functions etc? He might wan't to test his installation procedures as well, and otherwise you might want him to. So, wrap up all the new functionality in neat installations scripts, take a copy of the production database and start testing the installation scripts. It's the only way to be sure that what's tested in your test databaes will actually get installed in your production database. At 06:54 16-12-03 -0800, you wrote: I need to do a refresh of a test database using production data. We use import for this. In the past we have always dropped the schemas (4 or 5), recreated the schemas, and then did a full import with ignore=n. This time the user does not want to lose any of the new functions and procedures that are in test, but not in prod. Instead, they would like to just refresh the table data. Last time we tried this we had all kinds of trouble with functions, triggers, constraints, etc... and ended up doing a full import. Is there a tried and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?Q?Ram=F3n_Estevez?= 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).
FW: RMAN Script
Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed it and the same error. run { allocate channel c1 type disk format '/u08/backups/rman/BD_%d_%U'; allocate channel c2 type disk format '/u08/backups/rman/ARCH_%d_%U'; set limit channel c1 kbytes=200; set limit channel c2 kbytes=200; setsize=2000; filesperset=2; backup database include current controlfile tag 'Backup Full'; release channel c1; backup archivelog all tag 'Backup Archives'; release channel c2; } TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 winmail.dat
RMAN Script
Title: RMAN Script Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed it and the same error. run { allocate channel c1 type disk format '/u08/backups/rman/BD_%d_%U'; allocate channel c2 type disk format '/u08/backups/rman/ARCH_%d_%U'; set limit channel c1 kbytes=200; set limit channel c2 kbytes=200; setsize=2000; filesperset=2; backup database include current controlfile tag 'Backup Full'; release channel c1; backup archivelog all tag 'Backup Archives'; release channel c2; } TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
RMAN Script
Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed and the same error. run { allocate channel c1 type disk format '/u08/backups/rman/BD_%d_%U'; allocate channel c2 type disk format '/u08/backups/rman/ARCH_%d_%U'; set limit channel c1 kbytes=200; set limit channel c2 kbytes=200; setsize=2000; filesperset=2; backup database include current controlfile tag 'Backup Full'; release channel c1; backup archivelog all tag 'Backup Archives'; release channel c2; } TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 winmail.dat
RE: redhat/oracle
Agree with you Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Tuesday, November 04, 2003 10:55 AM To: Multiple recipients of list ORACLE-L I suspect that Oracle will continue to support RH AS. That is the only version they ever supported officially. So the pay status of RH and Oracle is a moot point. However, those of us who play with it knew that with a couple of adjustments it would run on the free version. What will happen there?? I'll probably try and swing my support towards SuSE. It's a well put together distro. I've worked with 8.1 and 8.2. Both installed Oracle flawlessly without needing the RH tweaks. Rodd On Tue, 2003-11-04 at 08:19, Ron Rogers wrote: For the time being there are Linux ISO'S at http://www.linuxiso.org/ including the RED HAT consumer linux. Ron [EMAIL PROTECTED] 11/03/2003 10:44:27 PM Well, if RedHat starts exhibitting tendencies of becoming another Microsoft, there are Mandrake, Debian , SuSE and (don't shoot, I'm just kidding) SCO. (duck, and quickly) On 2003.11.03 20:54, Joe Testa wrote: Well with RH latest ordeal of jumping out of simple ISOs and basically no more free software, what is oracle's stand on running on RH?, the paid version only from now on and those linux users out there, what are WE going to do? Looking to see if i need to spend money before end of year for tax write-off :) joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodd Holman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?Q?Ram=F3n_Estevez?= 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).
ORA-06401 NETCMN INVALID DRIVER
Hi list, I just installed 9IAS R2, the J2EE and Web Cache option. Before creating a DAD I'm trying to connect to a DB in a linux server, from the APP Server, with SQL Plus using host:port:orcl and get this error. In metalink direct me to modify the TNSNAMES.ORA file but the installation didn't created it, Do I need it a TNSNAMES.ORA to connect using this method? What should I do ? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 winmail.dat
FW: ORA-06401 NETCMN INVALID DRIVER
Hi list, I just installed 9IAS R2, the J2EE and Web Cache option. Before creating a DAD I'm trying to connect to a DB in a linux server, from the APP Server, with SQL Plus using host:port:orcl and get this error. In metalink direct me to modify the TNSNAMES.ORA file but the installation didn't created it, Do I need it a TNSNAMES.ORA to connect using this method? What should I do ? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 winmail.dat
RE: ORA-06401 NETCMN INVALID DRIVER
Problem solved, had to include the domain name in the hostname Hostname.domain:1521:orcl Tks anyway Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Thursday, October 02, 2003 4:15 PM To: Multiple recipients of list ORACLE-L Hi list, I just installed 9IAS R2, the J2EE and Web Cache option. Before creating a DAD I'm trying to connect to a DB in a linux server, from the APP Server, with SQL Plus using host:port:orcl and get this error. In metalink direct me to modify the TNSNAMES.ORA file but the installation didn't created it, Do I need it a TNSNAMES.ORA to connect using this method? What should I do ? TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?Q?Ram=F3n_Estevez?= 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).