RMAN question: couldn't execute cmd: no such file or directory

Hi all, I am trying to execute scheduled job via OEM console and the job fails with the following error couldn't execute "cmd": no such file or directory What might be the reason? rgds gbWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger

quick rman question

Hi does a command change backuppiece ... delete delete the info about a backup piece from a rman catalog only or does it also delete the backup piece itself from the tape? thanks gene __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design

Re: quick rman question

Gurevich, RMAN change backupset XXX delete; this deletes the backupset from disk.i have tried it. Hope change backuppiece XXX delete; also does the same on tape. Jp. 12-09-2003 06:34:27, Gene Gurevich [EMAIL PROTECTED] wrote: Hi does a command change backuppiece ... delete delete the info

RE: RMAN question.... (figured out if anywone is interested)....w

Title: RE: RMAN question (figured out if anywone is interested)with another question appended. :) Apparently the command: backup database format '/oracle_backup/ASTU/%U' (current controlfile); ..places the controlfile in $ORACLE_HOME/dbs, but: backup database format

RE: RMAN question.... (figured out if anywone is interested)....w

Chris - Congratulations on finding your problem. I have the RMAN log file emailed to me for each backup. This means more to look through. What you describe doesn't sound hard though. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent:

RE: RMAN question....

Title: RE: RMAN question Dennis, I wasn't actually restoring the control file. Only 'validating' that RMAN could do it. I also backup the control file several other ways and would likely never ask RMAN to perform that function. The only reason I issued 'restore controlfile validate

RE: RMAN question....

Chris - Thanks. Sorry for the tirade, bad day, reading too fast, thinking too slow. I checked my systems and I see the snapcf_SID.f files, one for each database being backed up. I do not see the other files you mention. I notice the mystery file names have a format quite close to your backup

RMAN question....

Title: RMAN question List, When I got into work this morning I noticed u01 was nearly full on out production OLTP machine. I found the files and the looked to be RMAN files. They were all in '$ORACLE_HOME/dbs/.' My first thought was that they were the snapshot controlfiles

RE: RMAN question....

Chris - Do you have any more details on the files you deleted that you felt were snapshot control files? How large? I may be incredibly stupid, but for the life of me I can't figure out why you would ask RMAN to restore your controlfile from backup. Was it corrupt? I would assume bad things

Basic RMAN question

Hi All, I am starting to play with rman in a test environment, however I seem to be hitting a really basic problem starting rman. I have oracle 9.2.0.1.0 installed on Redhat AS 2.1 When i issue the command: rman target='backup_admin/backup as [EMAIL PROTECTED]' nocatalog log=test.log rman:

RE: Basic RMAN question

Hi I don't think you need to have 'as sysdba' in your connect string. (But it's been a while) Jack -Original Message- Sent: woensdag 26 februari 2003 14:29 To: Multiple recipients of list ORACLE-L Hi All, I am starting to play with rman in a test environment, however I seem to be

RE: Basic RMAN question

This is odd. If you goto $ORACLE_HOME/bin and run ./rman nocatalog, does it work? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/26/2003 7:28 AM Hi All, I am starting to play with rman in a test environment, however I seem to be hitting a really basic problem

Re[2]: Basic RMAN question

Subject: Basic RMAN question FRI Hi All, FRI I am starting to play with rman in a test environment, however I seem FRI to be hitting a really basic problem starting rman. FRI I have oracle 9.2.0.1.0 installed on Redhat AS 2.1 FRI When i issue the command: rman target='backup_admin/backup

Re: Basic RMAN question

Ceri, I know the problem, on RH, do a which rman, you're probably hitting the binary that does Reverse MANpage. do a $ORACLE_HOME/bin/rman instead and all should be well. joe Hi All, I am starting to play with rman in a test environment, however I seem to be hitting a really basic

Re: Basic RMAN question

The connect string looks invalid. Please try: rman target='backup_admin/[EMAIL PROTECTED] as sysdba' nocatalog log="test.log" Have Fun :) Ceri Townsend wrote: Hi All, I am starting to play with rman in a test environment, however I seem to be hitting a really basic problem starting rman.

RE: Basic RMAN question

-Original Message- rman target='backup_admin/backup as [EMAIL PROTECTED]' nocatalog log=test.log rman: can't open target=backup_manager/backup as [EMAIL PROTECTED] Get rid of the as sysdba. rman will automatically connect however it needs to connect. Be sure you have granted

RE: Basic RMAN question

Don't need the as sysdba bit RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/26/2003 9:54 AM The connect string looks invalid. Please try: rman target='backup_admin/[EMAIL PROTECTED] as sysdba' nocatalog log=test.log Have Fun :) Ceri Townsend wrote: Hi

RE: Re[2]: Basic RMAN question

, does it FRI work? FRI RF FRI -Original Message- FRI From: Ceri Townsend FRI To: Multiple recipients of list ORACLE-L FRI Sent: 2/26/2003 7:28 AM FRI Subject: Basic RMAN question FRI Hi All, FRI I am starting to play with rman in a test environment, however I seem FRI to be hitting

Re: Basic RMAN question

Try RMAN and at rman prompt RMAN connect backup_admin/[EMAIL PROTECTED] Does that work ? Check for LD_LIBRARY_PATH, ORACLE_HOME environments and which RMAN Executable your session is using. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: Basic RMAN question

It may be a simple permissions error, such as the environment not being declared. From the prompt, type in lsnrctl, and from that promt, type status. If you can see your listener, all is well with permissions. I have tried your way to do it, and my output is fine: Recovery Manager: Release

RMAN question

Title: RMAN question Hi! How do I make RMAN delete all obsolete backups? We are using a recovery catalog. Example: RMAN report obsolete; RMAN-03022: compiling command: report Report of obsolete backups and copies Type Key Completion Time Filename/Handle

RE: RMAN question

Helmut, This thread came up a couple of days ago The answers were to use the commands change datafilecopy delete or change backuppiece delete Also have a look at the script $ORACLE_HOME/rdbms/demo/rman1.sh to automate the process from the output of report obsolete HTH John -Original

RMAN question

Title: RMAN question Hi! How do I make RMAN delete all obsolete backups? We are using a recovery catalog. Example: RMAN report obsolete; RMAN-03022: compiling command: report Report of obsolete backups and copies Type Key Completion Time Filename/Handle

stupid RMAN question

Ok i've been thru all of the 817 docs multiple times, searched metalstink, read the chapters in backup/recovery 101 multiple times. Where in the heck is the "spool" command for rman? Can i only spool stuff(and its an either to a file or to the screen, not both?) using the log parameter when

RE: stupid RMAN question

Joe are you on UNIX? you could pipe the stdout to a program called tee -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: stupid RMAN question Ok i've been thru all of the 817

RE: stupid RMAN question

Joe - quoting from Oracle RMAN Pocket Reference, p. 107 SPOOL (Oracle 9i only) Causes output generated from RMAN to be written to a log file. Syntax SPOOL LOG { OFF | TO filename } [APPEND][;] As for 817, you might try not logging the output, and run the script from a ksh (Unix)

Re: stupid RMAN question

You are correct - only the log command is available in 8i, spool is available in rman in 9i. -Joe --- JOE TESTA [EMAIL PROTECTED] wrote: Ok i've been thru all of the 817 docs multiple times, searched metalstink, read the chapters in backup/recovery 101 multiple times. Where in the heck is

Re: stupid RMAN question

(IMHO) There ain't none...dontcha just love it! Once you've entered the dark side (ie the rman prompt) there is no turning back... hth Connor --- JOE TESTA [EMAIL PROTECTED] wrote: Ok i've been thru all of the 817 docs multiple times, searched metalstink, read the chapters in

RE: stupid RMAN question

If you're on Unix, you can use the UnixSCRIPT command to write the terminal output to a file. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 10:14 AMTo: Multiple recipients of list ORACLE-LSubject: stupid RMAN question Ok i've

RE: stupid RMAN question

, Michael J. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2002 03:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: stupid RMAN question If you're on Unix, you can use the Unix SCRIPT command to write

RE: stupid RMAN question

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RMAN Question

Hi ALL Is there any way with RMAN to overwrite the backup files if they already exist. Example generating backup files with the same names each time. Thans Kamel B. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL

Re: RMAN Question

No, you can't do that. I just run a OS job everyday which removes the old backups to make room. HTH, Ruthg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 30, 2002 5:28 AM Hi ALL Is there any way with RMAN to overwrite the

rman question(allocating channels)

I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal), then does it make sense to allocate multiple channels? Are multiple channels related to CPUs or to destinations? thanks, joe

Re: rman question(allocating channels)

- From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 28, 2002 8:38 AM Subject: rman question(allocating channels) I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal

Re: rman question(allocating channels)

Rman channels are like processes, and you can have multiple channels writing to one disk and reading from one disk in a restore, If your server has the horsepower, then multiple channels will increase the speed of backups and restores, HTH, Ruth - Original Message - To: Multiple

RE: rman question(allocating channels)

it makes sense. Best thing is to try it out and compare timings. Ade -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: 28 August 2002 13:38To: Multiple recipients of list ORACLE-LSubject: rman question(allocating channels) I've tried to find this in the docs to no avail

RE: rman question(allocating channels)

. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 28, 2002 8:38 AMTo: Multiple recipients of list ORACLE-LSubject: rman question(allocating channels) I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup

RE: rman question(allocating channels)

Joe - 1) Why do you feel writing RMAN backup to one disk is not ideal? Is it the one disk, or disk vs. tape? 2) I would watch the I/O while it is running to see how close you are coming to maxing out your I/O subsystem. 3) I suspect, but haven't investigated, that RMAN defaults are

Re: RMAN QUestion

[EMAIL PROTECTED] sx.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RMAN QUestion

Re: RMAN QUestion

I'll bite I don't have a clue about RMAN and you say it is a trick question. I think control files from time a and time b are the same and should work. At 08:47 AM 6/21/2002 -0800, you wrote: Sorry, posted using wrong subject header, DUH! Use the following Exhibit to answer this question

RMAN QUestion

Sorry, posted using wrong subject header, DUH! Use the following Exhibit to answer this question (note: This is not a hacked OCP question. This question came about out of the experience of one of our junior DBA's that I had to come in and figure out...Several Sr. DBA's that I know have

RE: RMAN Question

THANK YOU IT'S TRUE, I WAS USING A 8.0 ORACLE DOCS REGARDS K.Benlatreche -Message d'origine- De : GL2Z/ INF DBA BENLATRECHE [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 29 mai 2002 15:24 À : Multiple recipients of list ORACLE-L Objet : RMAN Question Hi ALL, I want to use RMAN

RMAN Question

Hi ALL, I want to use RMAN (Oracle 8.1.7 under NT). Following Oracle docs (Server Backup and Recovery Guide), at one step (2) there is a reference to a script '@?/rdbms/admin/catrman', to create the recovery catalog, but I didn't find it ! Is there any missing on my Oracle installation ?

RE: RMAN Question

Kamel - I believe you may be looking at old instructions. I think that Oracle 8 used the catrman.sql script to create the recovery catalog schema, but in 8i you use the RMAN command: create catalog I'm not sure because I never used RMAN with Oracle 8, perhaps someone more knowledgeable

Re: RMAN Question

Dennis is correct. If you are on 8i you won't need the catrman.sql script. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 1:24 PM Kamel - I believe you may be looking at old instructions. I think that Oracle 8 used

Yet another rman question

Another (and hopefully final) Rman question for the community... If you decided NOT to use Rman and you opted for either another product, can you share with me why you decided not to use Rman. Was it the complexity, lack of documentation, or a really good software salesman? Robert G

rman views one other rman question - long, sorry

Hello everyone, I'm digging through rman again. Wish I had more time to do this ongoing. I've looked at the v$views in the past, but didn't dig into them too deeply. Now that my backup strategy is backup to disk - wait for media manager to take files to tape, I'll need to be able to

RE: rman views one other rman question - long, sorry

Lisa - Note 98342.1 might provide you some information. An excerpt: RMAN DATA DICTIONARY VIEWS used to query the control file - If you are not using a recovery catalog, RMAN information is stored in the target database's control file .

RE: A RMAN question

Hi Dennis, Thanks for replying. I guess I have not been able to make my question clear. You see, I need to backup only the cloned database on server B and NOT the database on server A. My scenario is as follows : The main db on server A is a partitioned data warehouse system and we r

RE: A RMAN question

on the last incremental backup. How can you restore? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: SARKAR, Samir [SMTP:[EMAIL PROTECTED]] Sent: Thu, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: A RMAN question Hi

RE: A RMAN question

: SARKAR, Samir [SMTP:[EMAIL PROTECTED]] Sent: Thu, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: A RMAN question Hi Dennis, Thanks for replying. I guess I have not been able to make my question clear. You see, I need to backup only the cloned database

RE: A RMAN question

a standby database. Jay -Original Message- From: SARKAR, Samir [SMTP:[EMAIL PROTECTED]] Sent: Thu, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: A RMAN question Hi Dennis, Thanks for replying. I guess I have not been able to make my

A RMAN question

Hi All, Though I have been using RMAN for quite a while now, I would like to ask for a clarification here. We have a production database with partitioning options on server A. We copy over the files (including the control files) of the prod database each night to a server B. We will then be

RE: A RMAN question

Samir - We have found that each Oracle database has an internal ID. This ID doesn't change when you clone it as you describe. RMAN uses this ID, and will become confused if it sees two databases that are identical. One way around this is to run two RMAN catalogs. I have not considered it an

RE: RMAN Question

You can tell RMAN to delete the archive files. We tell RMAN to keep the last 12 hours on disk. run { allocate channel ch1 type disk format '/bkup1/oracle/%d/full_s%s_p%p_%t'; allocate channel ch2 type disk format '/bkup5/oracle/%d/full_s%s_p%p_%t'; set limit channel ch1 kbytes=100; #

Re: RMAN Question

The following command will backup you archivelogs and then delete them if the backup is successful. (archivelog all delete input); HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 21, 2002 4:58 PM Ashoke If I

RE: RMAN Question

Thanks to all of you, who provided your input on this issue. I will test it and I will get in touch with you if I have any problem. Ashoke -Original Message- Sent: Friday, February 22, 2002 8:38 AM To: Multiple recipients of list ORACLE-L The following command will backup you

RE: RMAN Question

Ashoke If I understand you correctly, you are using RMAN to backup to disk, rather than to a media manager. You are asking whether you can archive these in RMAN, plus leave them on disk so they are readily available for recovery. I have used this configuration, and I have found

RMAN question

Hi if I take an incremental level 0 backups with RMAN .How do I determine by the list command if all these backups listed are of the same backup set or not. I took a incremental level 0 backup with filesperset 2. which is the column I should look at to uniquely identify a backup set. shown below

Re: RMAN question

Use LV-- level --- Sona [EMAIL PROTECTED] wrote: Hi if I take an incremental level 0 backups with RMAN .How do I determine by the list command if all these backups listed are of the same backup set or not. I took a incremental level 0 backup with filesperset 2. which is the column I

RMAN question

Hi if I take an incremental level 0 backups with RMAN .How do I determine by the list command if all these backups listed are of the same backup set or not. I took a incremental level 0 backup with filesperset 2. which is the column I should look at to uniquely identify a backup set. shown

rman question

Title: rman question OK, this may be dumb. I was under the impression that if you use rman to back up your database, you MUST use rman to restore and recover. Is this not true? Is it possible to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any

RE: rman question

Lisa, You must use RMAN for restore as the format of the backup pieces can be understood only by RMAN. Since RMAN is an Oracle - internal process, it reads the database a *DB* block (or multiples thereof) at a time, rather than the OS read an *OS* block at at time which could result in

RE: rman question

Title: rman question If You use RMAN to backup, you MUST use RMAN to restore. Once it is restored to the regular files, you may use Svrmgrl to recover if this is comfortable to you. But, recovery thru RMAN is easy, just one/two additional commands.Svrmgrl is not avaialble from Oracle 9

RE: rman question

Title: rman question Hi, Your initial statement is correct. If you use rman to backup, you must use it to restore/recover. All the rman backup sets are understandable only by rman. Cheers Sujatha -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 27

Re: rman question

Yes, That is, you can do both, let RMAN do it for you or apply the logs after restoring them. anjan "Koivu, Lisa" wrote: OK, this may be dumb. I was under the impression that if you use rman to back up your database, you MUST use rman to restore and recover. Is this not true? Is it possible

Re: rman question

You should backup all of the archivelogs if you are going to delete them and maybe even if you are not. The redo logs contain data which is already in the database when the backup is made so you don't need to back them up. In my scripts I always to an 'archive log current' and backup all of

Re: rman question

ORACLE-L Subject: rman question Hi Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold

Re: rman question

I forgot about the second part. The answer is yes but I have never done it successfully. Check the documentation. Sorry I don't know more about this, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 5:35 PM Hi Dear

Re: rman question

You can so a cold backup with rman, the database will be in mount state to do it. Just to a shutdown, startup mount and run a full of level 0 backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 5:35 PM Hi

Re: rman question

Ruth, Cold bacpup should backup online redo files. Level 0 did'nt include online redo files. If I do alter system archivelog current, should I backup archive files as well? We are in archive mode. Joan Ruth Gramolini wrote: You can so a cold backup with rman, the database will be in mount

Re: rman question

joan.hsieh@tTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ufts.educc: Sent by: Subject: Re: rman question

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

rman question

Hi Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore

RE: rman question

Title: RE: rman question You may try duplicate database with the dbname the same as test database using RMAN. You may need to use the tag command while backing up sothat you can specify the tag while restoring, but, if more than one backupset available with the same tag (it is in most

RMAN Question?

Hi I had these problems with the RMAN 8.0.5 that the backupsets were created with status 'DELETED' in the recovery catalog. I want to clear the control file records and the recreate the recovery catalog. Is there a way to clear the backup information from control file without recreating it. Any

RE: RMAN Question

Are the tables you are loading in direct mode in the same tablespace as your other tables ? If this is the case, then you will not be able to perform a complete recovery on the tablespace affecting the other logged tables. Whenever I have a mix like you have, some logged and some not, I keep the

RMAN Question

DBAs, I have two of my tables and index in nologging mode as I am loading data using SQL*Loader direct path mode. I have scheduled RMAN hot backup everday. When I issue REPORT UNRECOVERABLE, I am getting both the Data and Index datafiles are unrecoverable. I know that I wont be able to recover