help
RE: RMAN list command doesn't show any backupsets although backup goe
what RMAN version? i'm using 8.1.6 for several months, to backup 5 remote db's. Never heard something like that. Do you unregister using packagedbms_rcvcat.unregisterdatabase ?? And then new registration?, did you make any backups after new registration? It seems a kinda bug. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 20, 2001 8:20 AM Hi, I'm having a problem with the recovery manager after registering the database for the second time with the same recovery catalog: RMAN list command doesn't show any backupsets although backup goes without any errors. The problems started when i made a mistake and i did an incremental backup level 1 after after i added the second datafile to one the tablespaces. The problem then was that i couldn't see any backupset for the first datafile of that tablespace with the list command. Then I thought that unregistering and re-registering the database could solve the problem, but it didn't... now i can't see any backupsets at all although they exist in the recovery catalog database and there are backupsets with the status is 'A'(active). I also tried to validate the backupset of the controlfile (restore controlfile to '/disk/contolfile' validate) and it worked ok and used the recent backupset. has anyone experienced such problem? Thanks Ghenadie Zvizdenco Junior DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zvizdenco, Ghenadie 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: Claudio Roca 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: Need Help.
You have to ru explain plan for that statement.
You first have to create the PLAN_TABLE, you can do that running the script
$ORACLE_HOME/rdbms/admin/utlxplan.sql
Then, login to sql and run th following statement:
SQL explain plan for your-sql ;
then, run the following statement to obtan the execution plan:
select lpad (' ',2*(level-1))
||operation||' '||options||' '||
object_name||' '||decode
(id,0,'cost= '||cost||' Optimizer= '||optimizer||' Bytes= '||bytes) "QUERY
PLAN"
from plan_table
start with id=0
connect by prior id=parent_id
It will tell you the indexes being used.
Best luck
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 19, 2001 4:31 PM
Hi All,
Recently we moved the database(Oracle 8.0.5) from NT to Sun machine. Now
this database is going online very soon. When we were testing we
observed
that, the application (select statement) is running very slow. (I don't
know
how fast it was earlier). I have a feeling that it is not using indexes
properly. I have created 6 indexes on that table on each columns. also
created a composite indexes. How do I know that the sql is using which
index
for select statement.? Is there any other ways to improve the
performance?
Thanks
Uday
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Claudio Roca
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: RMAN doubts
Never mind, i could fix it. I had to configure Legato to use device /dev/rmt/0hbn instead of /dev/rmt/0 Thank you - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 1:31 PM What is your problem? I use 816. There is problem with sbttest in 816. But backups and recovery work fine. You need to relink the libobk.so file. I you provide details, I would try to answer. -Rahul - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 2:15 PM Sorry to bother you, i was using RMAN to backup to disk for over 1 year, but we need to backup to tape, so, i had to install Legato. I'm having some troubles, and i only want to know if you also experienced the same troubles. I can do backup to sbt_tape, but i can't read the saved files. I created a TAR in Metalink, and checked Legato Site out.but they still didn't anwer me back.. so, i'll appreciate any feed backup. Thank you. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 6:40 PM The database 'may' be in NOARCHIVELOG mode 1. Its a 300 GB database and RMAN picks up only the USED blocks to might save time and disk space for disk backup 2. We back up directly to tape. So if done through RMAN, we need not keep inventory of tapes as RMAN/Legato would maintain it internally 3. I understand that with RMAN, even if database is in NOARCHIVELOG mode still it would allow incremental backups which would mean saving of time. -Rahul - Original Message - To: "LazyDBA mailing list" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 5:19 PM If you are in NOARCHIVELOG mode you have to shutdown the Db (either within or out of RMAN) before a backup. There's no real benefit using RMAN for cold backups. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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: Claudio Roca 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: Rahul Dandekar 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: Claudio Roca 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 s
RE: move schema away from system table space
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: Claudio Roca 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).
rman change delete
how to automate CHANGE BACKUPSET key DELETE ? Any ideas? I'm trying to obtain the backupset key with LIST BACKUPSET, and then, i'll need to make some script to build a rman script with several CHANGE BACKUPSET DELETE statements. Am i wrong? Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Claudio Roca 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: RMAN
Try $rman TARGET system/manager@tar RCVCAT rman/rman@cat - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 13, 2001 7:05 PM I am trying to setup rman.The catalog database(cat) and target database(tar) are running on Oracle 8.1.5. I am following the Note from Metalink No.106432.1 and 109223.1.I am following all the steps as given in the note but I am facing errors. When REgistering the Target database I did the following steps $ORACLE_SID=tar $rman TARGET system/manager / RCVCAT rman/rman@cat Recovery Manager: Release 8.1.6.0.0 - Production RMAN-06193: connected to target database (not started) RMAN-06008: connected to recovery catalog database The Target database has been started and open for use. $sqlplus system/manager@tar will connect me to the target database. I checked some docs on metalink which tells that the target database should started(which is TRUE in mycase). The other doc says that the password file must be create and the init.ora file should have REMOTE_LOGIN_PASSWORD=exclusive(which is also TRUE in my case for both the database). $TNSPING tar TNS Ping Utility for Solaris: Version 8.1.6.0.0 - Production on 13-APR-2001 14:03:55 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=venus)(PORT=1521)) OK (10 msec) Can anyone tell me how to complete the set up successfully.Why am i getting RMAN-06193: connected to target database (not started) error. Pls advice Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: Claudio Roca 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: RMAN doubts
Sorry to bother you, i was using RMAN to backup to disk for over 1 year, but we need to backup to tape, so, i had to install Legato. I'm having some troubles, and i only want to know if you also experienced the same troubles. I can do backup to sbt_tape, but i can't read the saved files. I created a TAR in Metalink, and checked Legato Site out.but they still didn't anwer me back.. so, i'll appreciate any feed backup. Thank you. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 6:40 PM The database 'may' be in NOARCHIVELOG mode 1. Its a 300 GB database and RMAN picks up only the USED blocks to might save time and disk space for disk backup 2. We back up directly to tape. So if done through RMAN, we need not keep inventory of tapes as RMAN/Legato would maintain it internally 3. I understand that with RMAN, even if database is in NOARCHIVELOG mode still it would allow incremental backups which would mean saving of time. -Rahul - Original Message - To: "LazyDBA mailing list" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 5:19 PM If you are in NOARCHIVELOG mode you have to shutdown the Db (either within or out of RMAN) before a backup. There's no real benefit using RMAN for cold backups. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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: Claudio Roca 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: Very Urgent -- Please Help
I did over 10 V7 databases to V8.1.6 upgrade, no matter database size, it always tooked me 40 minutes to upgrade plus catalog and catproc scripts runtime. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 2:51 PM Hi Everybody I need to know that how much time will be taken by Oracle Database Upgradation from 815 to [ 816 and 817 ] with Oracle 816 and 817 both Oracle s/w already installed on the system. I had two database running on 815 and planning to move one of them to Oracle 816 and second to 817 Database size is between 75-100G Also Is there any issue for MTS on 816 and 817 as mine bothe database is having MTS and somebody told that 816 is still having some problem with MTS and not sure about 817 Thank you very much in advance NavBir __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Navtej B 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: Claudio Roca 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: Urgent - Migration
i migrated 10 oracle 7.3 to 8.1.6 and no need to do al that.. i only run ODMA, and checked an Oracle documentation out . It took me 40minutes to migrate, becaz Odma only create a new oracle 8 dictionary, and then populates the old v7 dict to the new v8 dict. If you have v7 backup, you could try to migrate the way i did. I had no problems. Best luck - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 16, 2001 6:00 PM Hello People! I migrate the Oracle 7.3.4.5 to Oracle 8.1.6.0.0, in the following way: 1) I exported the data 2) I removed off Oracle 7 3) I installed Oracle 8 4) I imported the data The problem is that began to appear the following error in the alert.log: --- Mon Apr 16 15:43:19 2001 Errors in file /u01/app/oracle/admin/sun/bdump/sun_s001_1065.trc: ORA-07445: exception found: core dump[kxscdv()+180] [SIGSEGV] [Address not mapped to object] [4] [] [] Mon Apr 16 15:43:54 2001 found dead multi-threaded server 'S001', pid = (13, 2) --- and in the client applications appears: ORA-03113 end-of-file on communication channel. Does anybody can help me? Platform: SUN Enterprise 3000 with 1.5Gb RAM Solaris 2.6 --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Brazil [EMAIL PROTECTED] http://www.upf.tche.br --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert 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: Claudio Roca 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: Migrate Oracle 7.3.4 to 8.1.7 with BAAN
I think that raw devices got nothing to with migration. I migrated 6 oracle 7.3 db to 8.1.6 on solaris. What migration assistant does (basically) is: creates a new catalog on your existing db, then, inserts all the info you have on your 7.3 catalog tables to the tables belonging to the new V8 catalog, and, finally, you must create a new controlfile. It is simple. The migration assistant does not modify your current data blocks, it only modifies the tablespace headers. There is a document on metalink that explains in a full detailed fashion all the steps Migration Assistant do. So, as ODMA only creates a new catalog, no matter your db size is. it always took me 40 minutes to migrate, plus the time to run catalog and catproc again. Best luck - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 10, 2001 3:01 PM One suggestion. Carefully read the entire Migration manual and create a plan for migrating that takes into consideration everything you found in the migration manual that applies to your system. Not everything will apply, but you will need to know what does and what doesn't. Jared On Tuesday 10 April 2001 01:25, [EMAIL PROTECTED] wrote: Hi All, We are about to migrate from Oracle 7.3.4 to 8.1.7 We use RAW devices and are on DEC-UX Anybody done this before and want to share their knowledge? What steps to take? What pitfalls to watch out for? Any tricks? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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: Claudio Roca 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
RE: 7.3.4 svrmgrl requiring password if called by root user
Are you using password files? 1) Check if some orapwSID file exists. if exists, then, internal user will always be required to authenticate in order to login. (except that 'dba' group is granted at os level. 2) Check $ORACLE_HOME/rdbms/lib/config.s file for some string like: /* 0x0008 15 */ .ascii "dba\0" The 'dba' string indicates that group DBA must be asigned to the user that will be used to connect as internal. If other string is used, then, you must use that os group as DBA role, and you must grant that group at os level. Hope it helps - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 5:23 PM My database backup scripts are failing when run by the root user. I have just had the requirment to add a dump of all filesystems to my regular database backup routine. Upon running my modified scripts as the root user, required for the dump, I am greeted by a request for a password in response to the connect internal command. I can duplicate this by simply running svrmgrl from a prompt as the root user. Again this is for Oracle 7.3.4 on DG/UX. We are not using OS authentication, and I svrmgrl does NOT require a password for the other OS users I have tried to use. I added the root user to the dba and oper groups in hopes that might solve my problem, but was still prompted for a password. Any help with this is appreciated. Thanks, Steve McClure __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: steve mcclure 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: Claudio Roca 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).
automated delete obsolete w/RMAN
Any way to automate delete obsolete backuppieces? I'm doing backup to disk with RMAN, and want to delete backuppieces from obsolete backupsets. If i do a crosscheck, it won't mark files as expired because files are still on disk. Cannot also use CHANGE DELETE command, because i need to know the obsolete pieces firstthat's what i'm trying to automate. Besides, we have 142 remote db being backed up with a local RMAN catalog, and it's a lil' complex to manually monitor all the obsolete backupsets. Any script/idea willbe appreciated. RDBMS 8.1.6.0 RMAN 8.1.6.0 Solaris 2.6 Thank you. Ing. Claudio RocaCertified Oracle DBAemail [EMAIL PROTECTED]Soporte Tecnico bases de datos OracleTe.: (54-11) 4-347-3953AFIP-DGI
