Re: Rman, Duplicating without set untill.... cloning with

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Rman, Duplicating without set untill.... cloning with

AIX. Robin Jay Hostetter wrote: My experience has been that RMAN will try to restore the database right up to the current point-in-time of the production database. So if you are on a remote system, it will be looking for data in the current redo logs (or logs that were archived since the backup

No DBAs needed on AS400

that doesn't even begin to compare to Oracle. For those of you who know AS400s, I would appreciate some insight that would demonstrate why he needs to keep me as a DBA. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat

RE: No DBAs needed on AS400

-- Author: Jay Hostetter 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

RE: No DBAs needed on AS400

-- Author: Jay Hostetter 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

Foreign Objects in the System Tablespace.

://www.orafaq.com -- Author: Jay Hostetter 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

Re: RE: Oracle vs. MS SQL

? Thanks, Gene PS. Do I move on to another Oracle shop or switch to SQLserver? OMG, the thought of working only on windoze makes me puke. I know this answer! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services

Re: Another RMAN Problem --- Urgent !!

Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter

Re: two listeners problem ???

listeners is for running databases in a cluster. Depending on how you have your cluster configured, you will need at least one listener per node. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 04/08/02 12:16PM Please excuse my idiotic curiosity. Why do you need 2

RE: two listeners problem ???

you have your cluster configured, you will need at least one listener per node. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 04/08/02 12:16PM Please excuse my idiotic curiosity. Why do you need 2 listeners on the same machine? I always install the listener

Re: RMAN madness !!

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: RMAN madness !!

don't set NLS_LANG, then NLS_DATE_FORMAT is ignored (at least in 8.1.7 on Tru64). Don't forget to shutdown your auxiliary db, delete it's files, then start it up again, NOMOUNT. Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED

RE: Oracle Wants Users to Hand over Apps Management

, Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Oracle Gold Support/ iTARs

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: DBMS Job vs C Daemon

facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Offtopic: www.lonyx.com ????

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: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Oracle Hungry for Money

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: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Snapshots VS Materialized Views

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Table Partitioning - Opinions

+ million records, 54 Gb) Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 03/12/02 12:45PM We are in the process of deciding whether to purchase a license for the partitioning option of Oracle. We are developing a data warehouse, with our largest tables being

Re: Do you use RMAN?

: 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: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: get out of command without leaving RMAN ???

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: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: RMAN Question

as well, otherwise NLS_DATE_FORMAT is ignored (at least on 8.1.7 on Tru64). Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 02/21/02 04:58PM Ashoke If I understand you correctly, you are using RMAN to backup to disk, rather than to a media manager. You

Oracle Licensing vs. The Others

. Thank you, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Oracle Licensing - Concurrent users

and Processor licensing. If we are missing something, I would like to avoid a nasty licensing surprise. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services

Re: Fw: Just got back from SQL*Server 2000 training...

of backups! Valid point here. But I'd rather not trust my backup to a compression scheme anyways. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: TFM

- creating users, monitoring the concurrent managers, assisting users with problems, applying patches, etc. We have a dba dedicated to backups, tuning, assisting with patches, assisting with client issues, etc. Welcome to hell. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA

RE: Limiting RMAN backup size

depending on how much space is available in those volumes. For e.g if i want to limit /disk1 to 40GB /disk2 to 10GB /disk3 to 10GB /disk4 to 10Gb How would i do this in RMAN? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat

RE: Mirroring REDO logs to an nfs drive

, Steve McClure Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: More Rman q's

to it with a connect string no problem. Another point is. Did you mean that the auxilliary database is the database that needs to be cloned (source)? Jack Jay Hostetter [EMAIL PROTECTED] on 23-01-2002 15:41:35 To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cc: John and Jack

RE: Oracle 8.1.7 install failure on Compaq Tru64

jre-taso - ../opt/java118/bin/jre-taso lrwxrwxrwx 1 root system29 Mar 13 2001 jre-taso_g - ../opt/java118/bin/jre-taso_g lrwxrwxrwx 1 root system24 Mar 13 2001 jre_g - ../opt/java118/bin/jre_g Regarding chipsets, we are using EV6.7. Jay Hostetter Oracle DBA D. E

Re: More Rman q's

You need to have the auxiliary database started nomount. All you need is the init.ora to do this. The duplicate will create the control, data, and redo log files. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 01/22/02 09:20AM Hi All, Trying my first

RE: Oracle 8.1.7 install failure on Compaq Tru64

to be removed from). You may also send the HELP command for other information (like subscribing). Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services

Re: Using RMAN

are in noarchivelog mode: # Check which backups are available on disk. allocate channel for maintenance type disk; crosscheck backup of database; crosscheck backup of controlfile; release channel; Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 01/17/02 12:45PM See

Re: RMAN backup and restore Q?

the archivelogs: run { allocate channel ch1 type disk format '/bkup1/oracle/%d/arc_s%s_p%p_%t'; set limit channel ch1 kbytes=100; # Limit sets to 1 Gb. backup archivelog until time 'sysdate-1/24' delete input; backup archivelog from time 'sysdate-1/24'; } Jay Hostetter Oracle DBA D. E

Re: Unix question

(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: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Analyze vs. DBMS_STATS

or things that I should watch out for? Thanks, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Analyze vs. DBMS_STATS

convinces me otherwise. Any comments or things that I should watch out for? Thanks, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] -- Please see the official

Re: EXPORT WITH QUERY CLAUSE in win NT

the escape character. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 01/08/02 01:00AM Hi list I want to export few tables with a common column in all. My OS is WinNT and db version is Oracle 8.1.6 I am using the folling command exp username/password@nts7 tables

RE: How to stop access to prod instance ...

the username/password of the person accessing the link. This would require you to maintain the user's login in both databases. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 01/04/02 11:50AM Thanks all ... The problem doesn't end here ... the requirements (loosely

Re: Redo Logs Question

the last checkpoint). This site has plenty of links to keep you busy until you get to a tuning class: http://home.earthlink.net/~bmehta/ Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 12/31/01 10:20AM Here is the background of the stiuation I am facing. We

Re: Data Archiving

any major implications. Both servers are oracle7.3.1. running on VAX/VMS. Thanks. Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Oracle Client Installation.

} [oracle.p2k_8.1.6.0.0] DEPENDENCY_LIST={ oracle.p2k.devtools } [oracle.p2k.devtools_8.1.6.0.0] DEPENDENCY_LIST={ oracle.p2k.oo4o,8.1.6.3.6 } [oracle.networking.netca_8.1.6.0.0] OPTIONAL_CONFIG_TOOLS={} Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 12/26/01 05

Sql to create 'ALTER USER...'

USER command. The type of output I am looking for is: alter user him default role role1,role4,role7; alter user her default role role4,role5,role7; etc... Maybe this is easy and I am just having trouble concentrating this afternoon... Thank you, Jay Hostetter Oracle DBA D. E. Communications

RE: Logical Backup for a large database

') 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). Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official

RMAN problem after Duplicate

duplicate the database I'll trash my production db. Anybody ever been here before? Thanks, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network

Re: Listener Security !!

Set a password for listener administration to prevent this. PASSWORDS_LISTENER=(mysecretpassword) Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/23/01 10:11AM Hi All !! Today I came across a typical Hole in Listener Security. If you have lsnrctl

Re: RMAN

going through the school of hard knocks here, so I would love to hear from others. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/23/01 11:28AM Well looks like i've held off learning RMAN long enough, any pointers, good RTFM, etc. thanks, joe -- Please see

Re: WinNT / 8.0.5 / Import anomaly, or is it?

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: New Listener Question

With 8i, the databases automatically register with the listener. You can disable it by pointing to a port that is not used by a listener. In the initSID.ora put the following entry: local_listener = (address = (protocol = tcp)(host = mymachine.mydomain.com)(port = 1522)) Jay Hostetter

Re: rman question

Joan, RMAN does not backup online redo files. If you take a cold backup, then restore it, you need to issue an 'open database resetlogs'. These documents on MetaLink may be helpful: Note: 61801.1 and Note: 106432.1. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA

Re: Installation oracle through responsefile

Has ANYBODY ever been able to successfully use a response file? Please share the secret with us! Thanks, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/10/01 04:35PM With WWS help, we have tried the non-interactive installation. We have NEVER gotten

Re: Legato NetWorker RMAN: A troublesome pair?

to backup to disk seems to save us a lot of headaches and gray hairs. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 06/26/01 02:35PM The subject line may be overstating things a bit, but I'm pretty frustrated at the moment. Backups are working fine when I run

Re: Partition Elimination

(SINGLE) TABLE ACCESS (BY LOCAL INDEX ROWID) OF DMS_AMA_RECORDS (Cost=1.69535189333285 Card=32 Bytes=3488) BITMAP CONVERSION (TO ROWIDS) BITMAP INDEX (SINGLE VALUE) OF DMS_AMA_RECORDS_UI1 Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 05/31

Re: storage area networks

Jeff, We are using a Compaq SAN. It was running great for two months. Just last week we began having some issues with databases hanging on our cluster. We haven't nailed down the problem yet, so I am witholding my opinion. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA

RE: Issues with Oracle on a Compaq Tru64 5.1 Cluster

Lee, Be sure to check the alerts on Metalink for Tru64 (Product Lifecycle, Alerts). There are OS level patches requried for nonclustered systems. See Note 132391.1. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 03/28/01 03:00AM Is this problem

RE: . . .Compaq Tru64 5.1 Cluster / SAN?

Message- Sent: Wednesday, March 28, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Lee, Be sure to check the alerts on Metalink for Tru64 (Product Lifecycle, Alerts). There are OS level patches requried for nonclustered systems. See Note 132391.1. Jay Hostetter Oracle DBA D. E

Issues with Oracle on a Compaq Tru64 5.1 Cluster

, and a Storage Area Network for the disks. We are not running OPS and we are not using raw devices. Thank you, Jay Hostetter -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

<    1   2