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 software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich 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: 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 about a backup piece from a rman catalog only or does it also delete the backup piece itself from the tape? thanks gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: 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 '/oracle_backup/ASTU/%U' include current controlfile; ..places the contrlofile in the specified directory along with all other backup pieces. Thanks for all input. Chris And now for the next step... .anyone have a script handy to query the catalog directly and validate all backups ran successfully and send the info of success/failure in an email? .Thanks! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 01, 2003 8:29 AM To: Multiple recipients of list ORACLE-L Subject: 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 format. I also notice the dates on the mystery files are today's date, so something must have written to them. Did the size change as well? Is there any possibility that another backup script is running? Maybe a cron job from another userid. Have you verified that your RMAN backup files are getting created in the expected location? You could also check the catalog for additional backups. And just to be sure, you might connect to the target database alone and check for backups. A record of recent backups are stored in the controlfile even if you are using a catalog. Glad you are enjoying Lawson's book. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 7:24 AM To: Multiple recipients of list ORACLE-L 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' was because it would help me figure out what those mystery files are for. I just checked the directory and there are 3 more files with similar names corresponding to the 3 databases we back up on that machine. I need to talk to the other DBA and find out if he has been manually deleting them because I haven't noticed this and we have been using RMAN for over a month now. In addition, I don't believe these are the snapshot control files as there are 3 other files in $ORACLE_HOME/dbs named: -rw-r- 1 oracle dba 41213952 Apr 1 00:35 snapcf_ASTU.f -rw-r- 1 oracle dba 14376960 Apr 1 00:08 snapcf_PRD1.f -rw-r- 1 oracle dba 16281600 Apr 1 00:36 snapcf_PRD2.f The files in question are: -rw-r- 1 oracle dba 16290816 Apr 1 00:36 26eje5g8_1_1 -rw-r- 1 oracle dba 14394368 Apr 1 00:08 28eje3r5_1_1 -rw-r- 1 oracle dba 41231360 Apr 1 00:35 2seje5e5_1_1 They seem to have corresponding file sizes. I just don't see what statement in my simple little scripts would cause the files to be written there. Again here is the backup script I use: #!/bin/sh export ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_SID=ASTU export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/ rm /oracle_backup/$ORACLE_SID/* $ORACLE_HOME/bin/rman EOF set dbid=1337318309 connect target connect catalog rman_cat/[EMAIL PROTECTED] run{ allocate channel d1 type disk; backup database format '/oracle_backup/ASTU/%U' (current controlfile); } sql alter system switch logfile; sql alter system archive log all; sql alter database backup controlfile to trace; sql alter database backup controlfile to ''/oracle_backup/ASTU/astu_ctl''; exit; EOF # Thanks for the input Dennis!! Ps. I read your review of The Art and Science of Oracle Performance Tuning on amazon and decided to give it a try myself. I'm about 60 pages into it. It is easily the best read of any Oracle text I have come across. I definitely agree it belongs on everyone's bookshelf!!! [Chris Stephens] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: 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: Wednesday, April 02, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Apparently the command: backup database format '/oracle_backup/ASTU/%U' (current controlfile); ..places the controlfile in $ORACLE_HOME/dbs, but: backup database format '/oracle_backup/ASTU/%U' include current controlfile; ..places the contrlofile in the specified directory along with all other backup pieces. Thanks for all input. Chris And now for the next step... .anyone have a script handy to query the catalog directly and validate all backups ran successfully and send the info of success/failure in an email? .Thanks! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, April 01, 2003 8:29 AM To: Multiple recipients of list ORACLE-L 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 format. I also notice the dates on the mystery files are today's date, so something must have written to them. Did the size change as well? Is there any possibility that another backup script is running? Maybe a cron job from another userid. Have you verified that your RMAN backup files are getting created in the expected location? You could also check the catalog for additional backups. And just to be sure, you might connect to the target database alone and check for backups. A record of recent backups are stored in the controlfile even if you are using a catalog. Glad you are enjoying Lawson's book. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 7:24 AM To: Multiple recipients of list ORACLE-L 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' was because it would help me figure out what those mystery files are for. I just checked the directory and there are 3 more files with similar names corresponding to the 3 databases we back up on that machine. I need to talk to the other DBA and find out if he has been manually deleting them because I haven't noticed this and we have been using RMAN for over a month now. In addition, I don't believe these are the snapshot control files as there are 3 other files in $ORACLE_HOME/dbs named: -rw-r- 1 oracle dba41213952 Apr 1 00:35 snapcf_ASTU.f -rw-r- 1 oracle dba14376960 Apr 1 00:08 snapcf_PRD1.f -rw-r- 1 oracle dba16281600 Apr 1 00:36 snapcf_PRD2.f The files in question are: -rw-r- 1 oracle dba16290816 Apr 1 00:36 26eje5g8_1_1 -rw-r- 1 oracle dba14394368 Apr 1 00:08 28eje3r5_1_1 -rw-r- 1 oracle dba41231360 Apr 1 00:35 2seje5e5_1_1 They seem to have corresponding file sizes. I just don't see what statement in my simple little scripts would cause the files to be written there. Again here is the backup script I use: #!/bin/sh export ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_SID=ASTU export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/ rm /oracle_backup/$ORACLE_SID/* $ORACLE_HOME/bin/rman EOF set dbid=1337318309 connect target connect catalog rman_cat/[EMAIL PROTECTED] run{ allocate channel d1 type disk; backup database format '/oracle_backup/ASTU/%U' (current controlfile); } sql alter system switch logfile; sql alter system archive log all; sql alter database backup controlfile to trace; sql alter database backup controlfile to ''/oracle_backup/ASTU/astu_ctl''; exit; EOF # Thanks for the input Dennis!! Ps. I read your review of The Art and Science of Oracle Performance Tuning on amazon and decided to give it a try myself. I'm about 60 pages into it. It is easily the best read of any Oracle text I have come across. I definitely agree it belongs on everyone's bookshelf!!! [Chris Stephens] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing
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' was because it would help me figure out what those mystery files are for. I just checked the directory and there are 3 more files with similar names corresponding to the 3 databases we back up on that machine. I need to talk to the other DBA and find out if he has been manually deleting them because I haven't noticed this and we have been using RMAN for over a month now. In addition, I don't believe these are the snapshot control files as there are 3 other files in $ORACLE_HOME/dbs named: -rw-r- 1 oracle dba 41213952 Apr 1 00:35 snapcf_ASTU.f -rw-r- 1 oracle dba 14376960 Apr 1 00:08 snapcf_PRD1.f -rw-r- 1 oracle dba 16281600 Apr 1 00:36 snapcf_PRD2.f The files in question are: -rw-r- 1 oracle dba 16290816 Apr 1 00:36 26eje5g8_1_1 -rw-r- 1 oracle dba 14394368 Apr 1 00:08 28eje3r5_1_1 -rw-r- 1 oracle dba 41231360 Apr 1 00:35 2seje5e5_1_1 They seem to have corresponding file sizes. I just don't see what statement in my simple little scripts would cause the files to be written there. Again here is the backup script I use: #!/bin/sh export ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_SID=ASTU export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/ rm /oracle_backup/$ORACLE_SID/* $ORACLE_HOME/bin/rman EOF set dbid=1337318309 connect target connect catalog rman_cat/[EMAIL PROTECTED] run{ allocate channel d1 type disk; backup database format '/oracle_backup/ASTU/%U' (current controlfile); } sql alter system switch logfile; sql alter system archive log all; sql alter database backup controlfile to trace; sql alter database backup controlfile to ''/oracle_backup/ASTU/astu_ctl''; exit; EOF # Thanks for the input Dennis!! Ps. I read your review of The Art and Science of Oracle Performance Tuning on amazon and decided to give it a try myself. I'm about 60 pages into it. It is easily the best read of any Oracle text I have come across. I definitely agree it belongs on everyone's bookshelf!!! [Chris Stephens]
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 format. I also notice the dates on the mystery files are today's date, so something must have written to them. Did the size change as well? Is there any possibility that another backup script is running? Maybe a cron job from another userid. Have you verified that your RMAN backup files are getting created in the expected location? You could also check the catalog for additional backups. And just to be sure, you might connect to the target database alone and check for backups. A record of recent backups are stored in the controlfile even if you are using a catalog. Glad you are enjoying Lawson's book. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 7:24 AM To: Multiple recipients of list ORACLE-L 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' was because it would help me figure out what those mystery files are for. I just checked the directory and there are 3 more files with similar names corresponding to the 3 databases we back up on that machine. I need to talk to the other DBA and find out if he has been manually deleting them because I haven't noticed this and we have been using RMAN for over a month now. In addition, I don't believe these are the snapshot control files as there are 3 other files in $ORACLE_HOME/dbs named: -rw-r- 1 oracle dba41213952 Apr 1 00:35 snapcf_ASTU.f -rw-r- 1 oracle dba14376960 Apr 1 00:08 snapcf_PRD1.f -rw-r- 1 oracle dba16281600 Apr 1 00:36 snapcf_PRD2.f The files in question are: -rw-r- 1 oracle dba16290816 Apr 1 00:36 26eje5g8_1_1 -rw-r- 1 oracle dba14394368 Apr 1 00:08 28eje3r5_1_1 -rw-r- 1 oracle dba41231360 Apr 1 00:35 2seje5e5_1_1 They seem to have corresponding file sizes. I just don't see what statement in my simple little scripts would cause the files to be written there. Again here is the backup script I use: #!/bin/sh export ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_SID=ASTU export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/ rm /oracle_backup/$ORACLE_SID/* $ORACLE_HOME/bin/rman EOF set dbid=1337318309 connect target connect catalog rman_cat/[EMAIL PROTECTED] run{ allocate channel d1 type disk; backup database format '/oracle_backup/ASTU/%U' (current controlfile); } sql alter system switch logfile; sql alter system archive log all; sql alter database backup controlfile to trace; sql alter database backup controlfile to ''/oracle_backup/ASTU/astu_ctl''; exit; EOF # Thanks for the input Dennis!! Ps. I read your review of The Art and Science of Oracle Performance Tuning on amazon and decided to give it a try myself. I'm about 60 pages into it. It is easily the best read of any Oracle text I have come across. I definitely agree it belongs on everyone's bookshelf!!! [Chris Stephens] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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).
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. but aren't those automatically deleted? I double checked the RMAN scripts I use to make sure nothing was explicitly written there. They weren't. So I deleted those files. I next ran the following on one of the databases: RMAN run { 2 allocate channel d1 type disk; 3 restore database validate; 4 } that returned successfully. (whew) then: RMAN run { 2 allocate channel d1 type disk; 3 restore controlfile validate; 4 } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=14 devtype=DISK RMAN-03022: compiling command: restore RMAN-03025: performing implicit partial resync of recovery catalog RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08518: channel d1: scanning controlfile copy /oracle_backup/ASTU/astu_ctl RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: d1 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: restore RMAN-03006: non-retryable error occurred during execution of command: IRESTORE RMAN-07004: unhandled exception during command execution on channel d1 RMAN-10035: exception raised in RPC: ORA-00600: internal error code, arguments:] ORA-19600: input file is datafile copy 0 () RMAN-10031: ORA-600 occurred during call to DBMS_BACKUP_RESTORE.SCANDATAFILECOPY RMAN exit YIKES!! anybody have an idea why this would happen?? Here is the backup script that is used each night (it's the same for all 3 databases minus the changes is ORACLE_SID and sub-directories): #!/bin/sh export ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_SID=ASTU export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/ rm /oracle_backup/$ORACLE_SID/* $ORACLE_HOME/bin/rman EOF set dbid=1337318309 connect target connect catalog rman_cat/[EMAIL PROTECTED] run{ allocate channel d1 type disk; backup database format '/oracle_backup/ASTU/%U' (current controlfile); } sql alter system switch logfile; sql alter system archive log all; sql alter database backup controlfile to trace; sql alter database backup controlfile to ''/oracle_backup/ASTU/astu_ctl''; exit; EOF # any and all help will be GREATLY appreciated. I won't be sleeping well until I know the backup process is truly ok. Thanks Chris
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 could happen if you did that. I could see backing it up just to be safe. Was this a test database? Anyway I'm always willing to learn. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 31, 2003 3:54 PM To: Multiple recipients of list O d RACLE-L 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. but aren't those automatically deleted? I double checked the RMAN scripts I use to make sure nothing was explicitly written there. They weren't. So I deleted those files. I next ran the following on one of the databases: RMAN run { 2 allocate channel d1 type disk; 3 restore database validate; 4 } that returned successfully. (whew) then: RMAN run { 2 allocate channel d1 type disk; 3 restore controlfile validate; 4 } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=14 devtype=DISK RMAN-03022: compiling command: restore RMAN-03025: performing implicit partial resync of recovery catalog RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08518: channel d1: scanning controlfile copy /oracle_backup/ASTU/astu_ctl RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: d1 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: restore RMAN-03006: non-retryable error occurred during execution of command: IRESTORE RMAN-07004: unhandled exception during command execution on channel d1 RMAN-10035: exception raised in RPC: ORA-00600: internal error code, arguments:] ORA-19600: input file is datafile copy 0 () RMAN-10031: ORA-600 occurred during call to DBMS_BACKUP_RESTORE.SCANDATAFILECOPY RMAN exit YIKES!! anybody have an idea why this would happen?? Here is the backup script that is used each night (it's the same for all 3 databases minus the changes is ORACLE_SID and sub-directories): #!/bin/sh export ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_SID=ASTU export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/ rm /oracle_backup/$ORACLE_SID/* $ORACLE_HOME/bin/rman EOF set dbid=1337318309 connect target connect catalog rman_cat/[EMAIL PROTECTED] run{ allocate channel d1 type disk; backup database format '/oracle_backup/ASTU/%U' (current controlfile); } sql alter system switch logfile; sql alter system archive log all; sql alter database backup controlfile to trace; sql alter database backup controlfile to ''/oracle_backup/ASTU/astu_ctl''; exit; EOF # any and all help will be GREATLY appreciated. I won't be sleeping well until I know the backup process is truly ok. Thanks Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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).
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: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri -- Ceri Townsend Database Admin mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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: 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 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: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri -- Ceri Townsend Database Admin mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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: Jack van Zanen 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: 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 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: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri -- Ceri Townsend Database Admin mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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: Freeman Robert - IL 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[2]: Basic RMAN question
Hi Freeman, Wednesday, February 26, 2003, 2:39:20 PM, you wrote: FRI This is odd. If you goto $ORACLE_HOME/bin and run ./rman nocatalog, 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 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 as [EMAIL PROTECTED]' nocatalog FRI log=test.log FRI rman: can't open target=backup_manager/backup as [EMAIL PROTECTED] FRI So i tested the connect string i had used as shown below: FRI Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog FRI SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 FRI Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba FRI Connected. FRI So I thought id start simple: rman nocatalog FRI rman: can't open nocatalog rman FRI this just hangs FRI So what have i missed? FRI Thanks I cant believe it was that simple..I've been tearing my hair out over this! There was another rman excutable that it was picking up first in /usr/bin/X11. Thanks Ceri -- CeriDatabase Administrator mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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: 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 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: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri -- Ceri Townsend Database Admin mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S 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).
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. 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: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri
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 sysdba to whoever you are connecting as. I always use sys or system instead of messing with yet another userid. I've not played with the single quotes; but that could be part of the problem. In general, it is not good practice to put user/password on a command line. Sometimes the program will hide its command line from the ps command, and sometimes not. I think rman does not. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Maybe need to export ORACLE_SID=YADAYADA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: 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 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: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Re[2]: Basic RMAN question
Glad to help! Robert Author Oracle9i RMAN Backup and Recovery -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/26/2003 8:49 AM Hi Freeman, Wednesday, February 26, 2003, 2:39:20 PM, you wrote: FRI This is odd. If you goto $ORACLE_HOME/bin and run ./rman nocatalog, 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 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 as [EMAIL PROTECTED]' nocatalog FRI log=test.log FRI rman: can't open target=backup_manager/backup as [EMAIL PROTECTED] FRI So i tested the connect string i had used as shown below: FRI Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog FRI SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 FRI Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba FRI Connected. FRI So I thought id start simple: rman nocatalog FRI rman: can't open nocatalog rman FRI this just hangs FRI So what have i missed? FRI Thanks I cant believe it was that simple..I've been tearing my hair out over this! There was another rman excutable that it was picking up first in /usr/bin/X11. Thanks Ceri -- CeriDatabase Administrator mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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: Freeman Robert - IL 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: 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: Wednesday, February 26, 2003 05: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 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: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri -- Ceri Townsend Database Admin mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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: Nikunj Gupta 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: 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 8.1.7.0.0 - Production RMAN-06005: connected to target database: TRINITY (DBID=88690634) RMAN-06009: using target database controlfile instead of recovery catalog -Original Message- Sent: Thursday, February 27, 2003 6:54 AM To: Multiple recipients of list ORACLE-L 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: Wednesday, February 26, 2003 05: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 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: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri -- Ceri Townsend Database Admin mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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: Nikunj Gupta 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: Clinton Naude 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).
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 -- -- Backup Set 523573 29012003-16:19:33 Backup Piece 523575 29012003-16:19:33 03ee44q5_1_1 Backup Set 525544 31012003-03:47:24 Backup Piece 525546 31012003-03:47:24 06ee80te_1_1 Backup Set 525545 31012003-08:04:25 Backup Piece 525547 31012003-08:04:25 07ee8d2m_1_1 Backup Set 526282 01022003-03:34:14 Backup Piece 526284 01022003-03:34:14 0aeealdg_1_1 Backup Set 526283 01022003-07:55:02 Backup Piece 526285 01022003-07:55:02 0beeb0m0_1_1 Backup Set 527884 04022003-03:52:28 Backup Piece 527886 04022003-03:52:28 0eeeiiig_1_1 Backup Set 527885 04022003-08:12:52 Backup Piece 527887 04022003-08:12:52 0feeius4_1_1 Backup Set 528851 05022003-03:51:41 Backup Piece 528853 05022003-03:51:41 0ieel6sk_1_1 Backup Set 528852 05022003-08:13:00 Backup Piece 528854 05022003-08:13:00 0jeelj6h_1_1 Backup Set 529486 06022003-03:43:12 Backup Piece 529488 06022003-03:43:12 0meenrds_1_1 Backup Set 529487 06022003-08:00:57 Backup Piece 529489 06022003-08:00:57 0neeo72i_1_1 Now I want to delete those obsolete backups... RMAN delete obsolete; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found obsolete: expecting one of: expired, script RMAN-01007: at line 1 column 9 file: standard input What would be the correct syntax? This is 8.1.7 on solaris. Thanks, Helmut
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 Message- Sent: 07 February 2003 11:39 To: Multiple recipients of list ORACLE-L 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 KeyCompletion TimeFilename/Handle -- -- Backup Set 523573 29012003-16:19:33 Backup Piece 523575 29012003-16:19:33 03ee44q5_1_1 Backup Set 525544 31012003-03:47:24 Backup Piece 525546 31012003-03:47:24 06ee80te_1_1 Backup Set 525545 31012003-08:04:25 Backup Piece 525547 31012003-08:04:25 07ee8d2m_1_1 Backup Set 526282 01022003-03:34:14 Backup Piece 526284 01022003-03:34:14 0aeealdg_1_1 Backup Set 526283 01022003-07:55:02 Backup Piece 526285 01022003-07:55:02 0beeb0m0_1_1 Backup Set 527884 04022003-03:52:28 Backup Piece 527886 04022003-03:52:28 0eeeiiig_1_1 Backup Set 527885 04022003-08:12:52 Backup Piece 527887 04022003-08:12:52 0feeius4_1_1 Backup Set 528851 05022003-03:51:41 Backup Piece 528853 05022003-03:51:41 0ieel6sk_1_1 Backup Set 528852 05022003-08:13:00 Backup Piece 528854 05022003-08:13:00 0jeelj6h_1_1 Backup Set 529486 06022003-03:43:12 Backup Piece 529488 06022003-03:43:12 0meenrds_1_1 Backup Set 529487 06022003-08:00:57 Backup Piece 529489 06022003-08:00:57 0neeo72i_1_1 Now I want to delete those obsolete backups... RMAN delete obsolete; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found obsolete: expecting one of: expired, script RMAN-01007: at line 1 column 9 file: standard input What would be the correct syntax? This is 8.1.7 on solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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).
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 -- -- Backup Set 523573 29012003-16:19:33 Backup Piece 523575 29012003-16:19:33 03ee44q5_1_1 Backup Set 525544 31012003-03:47:24 Backup Piece 525546 31012003-03:47:24 06ee80te_1_1 Backup Set 525545 31012003-08:04:25 Backup Piece 525547 31012003-08:04:25 07ee8d2m_1_1 Backup Set 526282 01022003-03:34:14 Backup Piece 526284 01022003-03:34:14 0aeealdg_1_1 Backup Set 526283 01022003-07:55:02 Backup Piece 526285 01022003-07:55:02 0beeb0m0_1_1 Backup Set 527884 04022003-03:52:28 Backup Piece 527886 04022003-03:52:28 0eeeiiig_1_1 Backup Set 527885 04022003-08:12:52 Backup Piece 527887 04022003-08:12:52 0feeius4_1_1 Backup Set 528851 05022003-03:51:41 Backup Piece 528853 05022003-03:51:41 0ieel6sk_1_1 Backup Set 528852 05022003-08:13:00 Backup Piece 528854 05022003-08:13:00 0jeelj6h_1_1 Backup Set 529486 06022003-03:43:12 Backup Piece 529488 06022003-03:43:12 0meenrds_1_1 Backup Set 529487 06022003-08:00:57 Backup Piece 529489 06022003-08:00:57 0neeo72i_1_1 Now I want to delete those obsolete backups... RMAN delete obsolete; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found obsolete: expecting one of: expired, script RMAN-01007: at line 1 column 9 file: standard input What would be the correct syntax? This is 8.1.7 on solaris. Thanks, Helmut
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 starting rman. if I've started rman with out the log parm, there is no way to open a spool file? I'm currently stuck on 817 rman if that makes a difference. thanks, joe
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 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 starting rman. if I've started rman with out the log parm, there is no way to open a spool file? I'm currently stuck on 817 rman if that makes a difference. thanks, joe
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) script, and send the standard out from that script to a file. Just an idea. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 14, 2002 10:14 AM To: Multiple recipients of list ORACLE-L 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 starting rman. if I've started rman with out the log parm, there is no way to open a spool file? I'm currently stuck on 817 rman if that makes a difference. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: 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 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 starting rman. if I've started rman with out the log parm, there is no way to open a spool file? I'm currently stuck on 817 rman if that makes a difference. thanks, joe __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: 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 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 starting rman. if I've started rman with out the log parm, there is no way to open a spool file? I'm currently stuck on 817 rman if that makes a difference. thanks, joe = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: 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 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 starting rman. if I've started rman with out the log parm, there is no way to open a spool file? I'm currently stuck on 817 rman if that makes a difference. thanks, joe Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it.
RE: stupid RMAN question
Unix SCRIPT command? Never heard of it. Hmm. man script | col -b Thanks! Learn something every day on this job. Jared SCRIPT(1) System General Commands Manual SCRIPT(1) NAME script - make typescript of terminal session SYNOPSIS script [-a] [-f] [-q] [file] DESCRIPTION Script makes a typescript of everything printed on your terminal. It is useful for students who need a hardcopy record of an interactive session as proof of an assignment, as the typescript file can be printed out later with lpr(1). If the argument file is given, script saves all dialogue in file. If no file name is given, the typescript is saved in the file typescript. Options: -a Append the output to file or typescript, retaining the prior con tents. -f Flush output after each write. This is nice for telecooperation: One person does `mkfifo foo; script -f foo' and another can supervise real-time what is being done using `cat foo'. -q Be quiet. The script ends when the forked shell exits (a control-D to exit the Bourne shell (sh(1)), and exit, logout or control-d (if ignoreeof is not set) for the C-shell, csh(1)). Certain interactive commands, such as vi(1), create garbage in the type script file. Script works best with commands that do not manipulate the screen, the results are meant to emulate a hardcopy terminal. ENVIRONMENT The following environment variable is utilized by script: SHELL If the variable SHELL exists, the shell forked by script will be that shell. If SHELL is not set, the Bourne shell is assumed. (Most shells set this variable automatically). SEE ALSO csh(1) (for the history mechanism). HISTORY The script command appeared in 3.0BSD. BUGS Script places everything in the log file, including linefeeds and backspaces. This is not what the naive user expects. LinuxJuly 30, 2000 Linux Kurth, 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 the terminal output to a file. -Original Message- Sent: Monday, October 14, 2002 10:14 AM To: Multiple recipients of list ORACLE-L 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 starting rman. if I've started rman with out the log parm, there is no way to open a spool file? I'm currently stuck on 817 rman if that makes a difference. thanks, joe Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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 - 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 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 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: 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 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 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.com -- Author: Ruth Gramolini 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).
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)
Joe, I have the same situation. I my case I used 2 channels, and so around a 25-30% decrease in thebackup time for a 30gb database. Once I increased it to 3 channels the payback was minimal. It also became very cpu intensive, so I kept the setting at 2. - Original Message - 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), 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)
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 recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 8:38 AM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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 question(allocating channels)
Joe, We only write out to tapes, so one channel equals one tape drive, each extra channel goes and gets another drive. Not too sure about disks, I guess it depends on I/O bandwith. Two channels will be faster than one, if the disk can cope with the input from two channels then maybe 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. 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 -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
RE: rman question(allocating channels)
Yep its me answering a question for you for a change - I was able to bounce your questionoff of Dinis (our RMAN guru)and he said: ( Yeah I could have pretended that I knew the answer but I don't think you would have fallen for that!) Channels are streams. Basically when you have multiple channels (lets say 4 channel) you can write to take or disk with 4 streams at the same time, which means that you will be able to backup more datafiles concurrently. No channels are not related to CPU or destinations. Yes it makes sense that you allocate more channels because it will shorten you backup time but then again the more channels you use the more resources you will be using on the server that you are backing up the database. I hope this answers your question but if not please let me know. P.S. Each channel willcorrespond toa session in the database that is being backed up. -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 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)
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 set a little low so that it doesn't tend to interfere with normal production. If this is true, you might either try increasing the RATE parameter, or allocating a second channel. Of course, if your Oracle is being used during the backup, increasing the I/O for RMAN may interfere with the users. 4) One issue is the read side of the RMAN backup process. The bottleneck may be in reading data blocks, no just writing them. In the worst case you have a single-disk Oracle system so RMAN is reading and writing to/from the same drive. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 28, 2002 7:38 AM To: Multiple recipients of list ORACLE-L 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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 QUestion
Hi Can autobackup of control file be NOT enabled? If you do full database backup using RMAN you get the controlfile like it or not, isn't it? So i'd say a because with b you don't automatically get the controlfiles Jack Freeman, Robert Robert_Freeman@cTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sx.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RMAN QUestion [EMAIL PROTECTED] 21-06-2002 18:47 Please respond to ORACLE-L 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 gotten it wrong already... but we got some smart fokls here! :-) RMAN backup. Autobackup of control file is not enabled. Time a - Backup of database Time b - Archivelog Backups Time c - Drop tablespace Time d - Archivelog Backup To restore successfully, with RMAN (no manual fiddling) to time point b, you will first need to restore a control file. Which backup would you want to restore the control file from... (more than one answer may well be correct, I'm not telling). a. Control file from point a b. Control file from point b c. Control file from before point c d. Control file from after point c e. Control file from point d f. Recovery is not possible. I'll reveal the answer in the next 2 days...(and this *IS* a trick question, so think carefully). Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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). == 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
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 (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 gotten it wrong already... but we got some smart fokls here! :-) RMAN backup. Autobackup of control file is not enabled. Time a - Backup of database Time b - Archivelog Backups Time c - Drop tablespace Time d - Archivelog Backup To restore successfully, with RMAN (no manual fiddling) to time point b, you will first need to restore a control file. Which backup would you want to restore the control file from... (more than one answer may well be correct, I'm not telling). a. Control file from point a b. Control file from point b c. Control file from before point c d. Control file from after point c e. Control file from point d f. Recovery is not possible. I'll reveal the answer in the next 2 days...(and this *IS* a trick question, so think carefully). Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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 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 gotten it wrong already... but we got some smart fokls here! :-) RMAN backup. Autobackup of control file is not enabled. Time a - Backup of database Time b - Archivelog Backups Time c - Drop tablespace Time d - Archivelog Backup To restore successfully, with RMAN (no manual fiddling) to time point b, you will first need to restore a control file. Which backup would you want to restore the control file from... (more than one answer may well be correct, I'm not telling). a. Control file from point a b. Control file from point b c. Control file from before point c d. Control file from after point c e. Control file from point d f. Recovery is not possible. I'll reveal the answer in the next 2 days...(and this *IS* a trick question, so think carefully). Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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 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 (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 ? Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE 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: GL2Z/ INF DBA BENLATRECHE 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 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 ? Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE 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 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 will respond. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L 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 ? Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE 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: DENNIS WILLIAMS 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 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 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 will respond. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L 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 ? Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE 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: DENNIS WILLIAMS 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: Ruth Gramolini 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).
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. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author Oracle9i New Features, Mastering Oracle8i The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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 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 intelligently tell my SA what files I need should a restore become necessary. I don't have the luxury of a recovery catalog. However, it looks as if the v$ views in the target database will tell me what I need to know. Has anyone ever seen an erd or some documentation stating the relationship between these views? I know that the important ones (so far - v$backup_set, v$backup_datafile, v$backup_redolog, v$backup_piece) are related by set_stamp and set_count. I'd like to be able to create an erd for the dba that will be covering when I'm out on leave. Does v$log_history relate back in somehow? Another thing I'm looking at is deleting old backups. I've been messing with the CHANGE command but it only references backupset and backuppiece. Would I have to give this command for every archive log that I am ready to get rid of? Or is there a twist to this command that will get rid of the backup piece that contains the archive logs? Thanks in advance for any pointers, websites, etc. Lisa Koivu Oracle Database Dog Catcher Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa 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 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 . V$ARCHIVED_LOG This view displays archived log information from the controlfile including archive log names. An archive log record is inserted after the online redo log is successfully archived or cleared (name column is NULL if the log was cleared). If the log is archived twice, there will be two archived log records with the same THREAD#, SEQUENCE#, and FIRST_CHANGE#, but with a different name. An archive log record is also inserted when an archive log is restored from a backup set or a copy. COLUMN DESCRIPTION RECID Archived log record ID STAMP Archived log record stamp NAME Archived log file name THREAD#Redo thread number SEQUENCE# Redo log sequence number RESETLOGS_CHANGE# Resetlogs change# of database when written RESETLOGS_TIME Resetlogs time of database when written FIRST_CHANGE# First change# in the archived log FIRST_TIME Timestamp of the first change NEXT_CHANGE# First change in the next log NEXT_TIME Timestamp of the next change BLOCKS Size of the archived log in blocks BLOCK_SIZE Redo log block size COMPLETION_TIMETime when the archiving completed DELETEDYES/NO V$BACKUP_CORRUPTION This view displays information about corruptions in datafile backups from the controlfile. Note that corruptions are not tolerated in the controlfile and archived log backups. COLUMN DESCRIPTION RECID Backup corruption record ID STAMP Backup corruption record stamp SET_STAMP Backup set stamp SET_COUNT Backup set count PIECE# Backup piece number FILE# Datafile number BLOCK# First block of the corrupted range BLOCKS Number of contiguous blocks in corrupted range CORRUPTION_CHANGE# Change# where logical corruption was detected. MARKED_CORRUPT YES/NO. If YES the blocks were not marked corrupted in datafile, but were detected and marked while making backup V$COPY_CORRUPTION This view displays information about datafile copy corruptions from the controlfile. COLUMN DESCRIPTION RECID Copy corruption record ID STAMP Copy corruption record stamp COPY_RECID Datafile copy record ID COPY_STAMP Datafile copy record stamp FILE# Datafile number BLOCK# First block of the corrupted range BLOCKS Number of contiguous blocks in corrupted range CORRUPTION_CHANGE# Change# where logical corruption was detected. MARKED_CORRUPT YES/NO. If YES the blocks were not marked corrupted in datafile, but were detected and marked while making the datafile copy V$BACKUP_DATAFILE Useful for creating equal sized backup sets by determining the number of blocks in each datafile. Can also find the number of corrupt blocks for the datafile. COLUMN DESCRIPTION RECID Backup datafile record ID STAMP Backup datafile record stamp SET_STAMP Backup set stamp SET_COUNT Backup set count FILE# Datafile number. Set to 0 for controlfile CREATION_CHANGE# Creation change of the datafile CREATION_TIME Creation timestamp of the datafile RESETLOGS_CHANGE# Resetlogs change# of datafile when backed up RESETLOGS_TIME Resetlogs timestamp of datafile when backed up INCREMENTAL_LEVEL (0-4) incremental backup level INCREMENTAL_CHANGE# All blocks changed after incremental change# is included in this backup. CHECKPOINT_CHANGE# All changes up to checkpoint change# are included in this backup CHECKPOINT_TIMETimestamp of the checkpoint ABSOLUTE_FUZZY_CHANGE# Highest change# in this backup MARKED_CORRUPT Number of blocks marked corrupt MEDIA_CORRUPT Number of blocks media corrupt LOGICALLY_CORRUPT Number of blocks logically corrupt DATAFILE_BLOCKSSize of the datafile in blocks at backup time. BLOCKS Size of the backup datafile in blocks. BLOCK_SIZE Block size OLDEST_OFFLINE_RANGE The RECID of the oldest offline range record in this backup controlfile. COMPLETION_TIME The time completed. V$BACKUP_REDOLOG This view displays information about archived logs in backup sets from the
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 planning to copy over the data files and the control files every night to the cloned db on server B. Thereafter, we will b taking a RMAN backup of the cloned db on server B only. As I said, RMAN writes the backup info on the target database's control files when it takes the backup. I also said that we plan to take a full backup on Sundays and incremental backup on the other days. My confusion was : Say, RMAN takes a backup of the database on the cloned db on server B on a Monday. On MOnday night as per procedure, the control files and the database files from the main db on server A are copied over to server B. On Tuesday, will RMAN b happy taking the incremental backup again of the cloned db on server B even though it finds that the control files r different than the ones it wrote the backup info to the previous day ?? Or will it get confused and prompt for a FULL backup ?? Any ideas from anybody would b appreciated a lot. Regards, Samir 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 -Original Message- Sent: 20 March 2002 19:16 To: Multiple recipients of list ORACLE-L 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 advantage to use RMAN with the control file (non-catalog) option, so I haven't considered all the ramifications there. Have you looked at the RMAN DUPLICATE command to clone the database? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 20, 2002 10:14 AM To: Multiple recipients of list ORACLE-L 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 using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir 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 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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:
RE: A RMAN question
Hello Samir I do not work with RMAN but I THINK that you have a conceptual error in your logic. Since you do not have a catalog RMAN use the control files as catalog. When you want to restore RMAN will not find the data on the full backup in the control files. You will have only the data 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 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 planning to copy over the data files and the control files every night to the cloned db on server B. Thereafter, we will b taking a RMAN backup of the cloned db on server B only. As I said, RMAN writes the backup info on the target database's control files when it takes the backup. I also said that we plan to take a full backup on Sundays and incremental backup on the other days. My confusion was : Say, RMAN takes a backup of the database on the cloned db on server B on a Monday. On MOnday night as per procedure, the control files and the database files from the main db on server A are copied over to server B. On Tuesday, will RMAN b happy taking the incremental backup again of the cloned db on server B even though it finds that the control files r different than the ones it wrote the backup info to the previous day ?? Or will it get confused and prompt for a FULL backup ?? Any ideas from anybody would b appreciated a lot. Regards, Samir 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 -Original Message- Sent: 20 March 2002 19:16 To: Multiple recipients of list ORACLE-L 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 advantage to use RMAN with the control file (non-catalog) option, so I haven't considered all the ramifications there. Have you looked at the RMAN DUPLICATE command to clone the database? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 20, 2002 10:14 AM To: Multiple recipients of list ORACLE-L 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 using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir 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 __ _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600
RE: A RMAN question
Hi Yechiel, Of course I do use a RMAN catalog on server B to backup the cloned database. The scenario I described was because I am wondering whether RMAN will be happy taking a second incremental backup the next day after the controlfiles of the target database were overwritten overnight. Please read my earlier mail keeping in mind that a RMAN catalog database is being used. I would b thankful for any advice on this. Regards, Samir 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 -Original Message- Sent: 21 March 2002 13:38 To: Multiple recipients of list ORACLE-L Hello Samir I do not work with RMAN but I THINK that you have a conceptual error in your logic. Since you do not have a catalog RMAN use the control files as catalog. When you want to restore RMAN will not find the data on the full backup in the control files. You will have only the data 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 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 planning to copy over the data files and the control files every night to the cloned db on server B. Thereafter, we will b taking a RMAN backup of the cloned db on server B only. As I said, RMAN writes the backup info on the target database's control files when it takes the backup. I also said that we plan to take a full backup on Sundays and incremental backup on the other days. My confusion was : Say, RMAN takes a backup of the database on the cloned db on server B on a Monday. On MOnday night as per procedure, the control files and the database files from the main db on server A are copied over to server B. On Tuesday, will RMAN b happy taking the incremental backup again of the cloned db on server B even though it finds that the control files r different than the ones it wrote the backup info to the previous day ?? Or will it get confused and prompt for a FULL backup ?? Any ideas from anybody would b appreciated a lot. Regards, Samir 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 -Original Message- Sent: 20 March 2002 19:16 To: Multiple recipients of list ORACLE-L 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 advantage to use RMAN with the control file (non-catalog) option, so I haven't considered all the ramifications there. Have you looked at the RMAN DUPLICATE command to clone the database? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 20, 2002 10:14 AM To: Multiple recipients of list ORACLE-L 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 using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir 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
RE: A RMAN question
Thanks Jay.actually our clients want it that way that the cloned DB is backed up instead of the production DB. I think u r right about RMAN getting confused when it reads the controlfiles the next day for taking an incremental backup since they will have been replaced overnight. But I am using a recovery catalog database, so I dont understand why won't RMAN just go and take an incremental backup of only the changed blocks anyway instead of bothering about whats there in the control files of the target database. Does this also mean that in case I have to recreate the controlfile of the target database, I can never do an incremental backup during the first go ?? Regards, Samir 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 -Original Message- Sent: 21 March 2002 14:58 To: Multiple recipients of list ORACLE-L I think RMAN will have problems with the incremental backup. When it looks at the control files for the cloned db, they will have no record of a previous backup. What you are doing is a bit unusual in that the database on server A (which would be considered production) should be backed up. And if you are backing up the database on server A, why bother to backup the datbase on Server B? Especially if you are refreshing it each night. It sounds like you should really be setting up 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 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 planning to copy over the data files and the control files every night to the cloned db on server B. Thereafter, we will b taking a RMAN backup of the cloned db on server B only. As I said, RMAN writes the backup info on the target database's control files when it takes the backup. I also said that we plan to take a full backup on Sundays and incremental backup on the other days. My confusion was : Say, RMAN takes a backup of the database on the cloned db on server B on a Monday. On MOnday night as per procedure, the control files and the database files from the main db on server A are copied over to server B. On Tuesday, will RMAN b happy taking the incremental backup again of the cloned db on server B even though it finds that the control files r different than the ones it wrote the backup info to the previous day ?? Or will it get confused and prompt for a FULL backup ?? Any ideas from anybody would b appreciated a lot. Regards, Samir 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 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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
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 using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir 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 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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: 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 advantage to use RMAN with the control file (non-catalog) option, so I haven't considered all the ramifications there. Have you looked at the RMAN DUPLICATE command to clone the database? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 20, 2002 10:14 AM To: Multiple recipients of list ORACLE-L 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 using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir 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 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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: DENNIS WILLIAMS 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 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; # Limit sets to 1 Gb. set limit channel ch2 kbytes=100; # filesperset is used to avoid O R A-04030 backup full database filesperset=4 tag='daily_full_backup'; allocate channel ch3 type disk format '/bkup5/oracle/%d/arc_s%s_p%p_%t'; allocate channel ch4 type disk format '/bkup1/oracle/%d/arc_s%s_p%p_%t'; set limit channel ch3 kbytes=100; set limit channel ch4 kbytes=100; backup filesperset=20 (archivelog from time 'sysdate-12/24' channel ch3 ) (archivelog until time 'sysdate-12/24' delete input channel ch4 ); } The reason that we use RMAN to backup our archive logs is so that we have a complete backup on our tapes. We backup to disk, which is then backed up to tape. If I want to restore my database from 3 weeks ago, I know that the tape from that day contains all of the files I need to restore my database for that day. This is especially important if I am restoring a hot backup or I am restoring to a specific point in time (i.e. a point in time that is different from the backup time). On a separate but related note, I previously posted a script which used SET UNTIL TIME and TO_DATE. e.g.: #set until time to_date(0125200207,mmddhh24miss); I obtained this from a note on MetaLink. It turns out that this doesn't work, due to a bug (1887009). I found it mentioned on a forum under Doc ID: 180832.995. It is supposedly fixed in 9.0.2. The workaround is to use NLS_DATE_FORMAT. Be sure to set NLS_LANG 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 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 that RMAN leaves the archive logs on disk after it has backed them up. Also, I believe but have not tested this, that in case of a recovery, RMAN first looks to the original unarchived disk location for the archive logs and if it can't find them there, it will retrieve them from its backup location (disk file or tape if you are using a media manager), and put them where they should be, then continue the recovery. After thinking about this, I decided that using RMAN to backup the archive logs wasn't buying me anything. Just making my setup more complicated. If I was backing up to a media manager, then having RMAN back up the archive logs would be great because it would be moving them to tape. As it is, RMAN isn't compressing them before moving them to disk. My regular nightly tape backup will give me a safety copy on tape. If I feel I need a disk copy, I will just compress the files to another location and end up with something significantly smaller. If I have overlooked something in my logic, please point that out to me because I am just beginning to learn RMAN and am frequently interrupted by other DBA duties, so learning is going very slowly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 21, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Greetings, We are at Oracle 8.1.7 on Sun Solaris 7. Can we backup all the archive logs at any point of time but not deleting all these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) in the disk so that we don't need to restore the archive logs from rman backup in case of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: DENNIS WILLIAMS 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: 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 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 that RMAN leaves the archive logs on disk after it has backed them up. Also, I believe but have not tested this, that in case of a recovery, RMAN first looks to the original unarchived disk location for the archive logs and if it can't find them there, it will retrieve them from its backup location (disk file or tape if you are using a media manager), and put them where they should be, then continue the recovery. After thinking about this, I decided that using RMAN to backup the archive logs wasn't buying me anything. Just making my setup more complicated. If I was backing up to a media manager, then having RMAN back up the archive logs would be great because it would be moving them to tape. As it is, RMAN isn't compressing them before moving them to disk. My regular nightly tape backup will give me a safety copy on tape. If I feel I need a disk copy, I will just compress the files to another location and end up with something significantly smaller. If I have overlooked something in my logic, please point that out to me because I am just beginning to learn RMAN and am frequently interrupted by other DBA duties, so learning is going very slowly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 21, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Greetings, We are at Oracle 8.1.7 on Sun Solaris 7. Can we backup all the archive logs at any point of time but not deleting all these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) in the disk so that we don't need to restore the archive logs from rman backup in case of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: DENNIS WILLIAMS 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: Ruth Gramolini 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 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 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 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 that RMAN leaves the archive logs on disk after it has backed them up. Also, I believe but have not tested this, that in case of a recovery, RMAN first looks to the original unarchived disk location for the archive logs and if it can't find them there, it will retrieve them from its backup location (disk file or tape if you are using a media manager), and put them where they should be, then continue the recovery. After thinking about this, I decided that using RMAN to backup the archive logs wasn't buying me anything. Just making my setup more complicated. If I was backing up to a media manager, then having RMAN back up the archive logs would be great because it would be moving them to tape. As it is, RMAN isn't compressing them before moving them to disk. My regular nightly tape backup will give me a safety copy on tape. If I feel I need a disk copy, I will just compress the files to another location and end up with something significantly smaller. If I have overlooked something in my logic, please point that out to me because I am just beginning to learn RMAN and am frequently interrupted by other DBA duties, so learning is going very slowly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 21, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Greetings, We are at Oracle 8.1.7 on Sun Solaris 7. Can we backup all the archive logs at any point of time but not deleting all these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) in the disk so that we don't need to restore the archive logs from rman backup in case of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: DENNIS WILLIAMS 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: Ruth Gramolini 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: Mandal, Ashoke 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
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 that RMAN leaves the archive logs on disk after it has backed them up. Also, I believe but have not tested this, that in case of a recovery, RMAN first looks to the original unarchived disk location for the archive logs and if it can't find them there, it will retrieve them from its backup location (disk file or tape if you are using a media manager), and put them where they should be, then continue the recovery. After thinking about this, I decided that using RMAN to backup the archive logs wasn't buying me anything. Just making my setup more complicated. If I was backing up to a media manager, then having RMAN back up the archive logs would be great because it would be moving them to tape. As it is, RMAN isn't compressing them before moving them to disk. My regular nightly tape backup will give me a safety copy on tape. If I feel I need a disk copy, I will just compress the files to another location and end up with something significantly smaller. If I have overlooked something in my logic, please point that out to me because I am just beginning to learn RMAN and am frequently interrupted by other DBA duties, so learning is going very slowly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 21, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Greetings, We are at Oracle 8.1.7 on Sun Solaris 7. Can we backup all the archive logs at any point of time but not deleting all these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) in the disk so that we don't need to restore the archive logs from rman backup in case of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: DENNIS WILLIAMS 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 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 is the output of the RMANlist backup set of database; List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 378 16 452962659 0 452962651 20 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 379 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/rman/df_BKUPTEST_20_452962651_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 Full 142896 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 384 17 452970568 0 452970560 21 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 385 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_21_452970560_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 Full 142925 04-FEB-02 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0 Full 142925 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 389 18 452971072 0 452971064 23 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 392 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_23_452971064_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 Full 162954 04-FEB-02 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0 Full 162954 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 390 19 452971100 0 452971080 24 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 393 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_24_452971080_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 1/ora/data01/bkuptest/dbfiles/system.1.dbf 0 Full 162955 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 391 20 452971112 0 452971105 25 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 394 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_25_452971105_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 Full 162956 04-FEB-02 TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona 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
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 should look at to uniquely identify a backup set. shown below is the output of the RMANlist backup set of database; List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 378 16 452962659 0 452962651 20 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 379 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/rman/df_BKUPTEST_20_452962651_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 Full 142896 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 384 17 452970568 0 452970560 21 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 385 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_21_452970560_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 Full 142925 04-FEB-02 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0 Full 142925 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 389 18 452971072 0 452971064 23 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 392 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_23_452971064_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 Full 162954 04-FEB-02 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0 Full 162954 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 390 19 452971100 0 452971080 24 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 393 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_24_452971080_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 1/ora/data01/bkuptest/dbfiles/system.1.dbf 0 Full 162955 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 391 20 452971112 0 452971105 25 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 394 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_25_452971105_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 Full 162956 04-FEB-02 TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona 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
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 is the output of the RMANlist backup set of database; List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 378 16 452962659 0 452962651 20 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 379 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/rman/df_BKUPTEST_20_452962651_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- - - --- 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 Full 142896 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 384 17 452970568 0 452970560 21 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 385 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_21_452970560_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- - - --- 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 Full 142925 04-FEB-02 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0 Full 142925 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 389 18 452971072 0 452971064 23 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 392 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_23_452971064_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- - - --- 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 Full 162954 04-FEB-02 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0 Full 162954 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 390 19 452971100 0 452971080 24 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 393 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_24_452971080_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- - - --- 1/ora/data01/bkuptest/dbfiles/system.1.dbf 0 Full 162955 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 391 20 452971112 0 452971105 25 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- - --- 394 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_25_452971105_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- - - --- 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 Full 162956 04-FEB-02 TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona 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
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 comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
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 fractured reads (which in turn necessitates full block redo logging during Hot backup mode). This also means that RMAN can recognize empty blocks and thus skip backup of these blocks - resulting in a small backup set in the beginning that grows with database usage and activity... Lots of interesting stuff / concepts can be found in the Recovery Manager user's guide and reference - a must read if you are planning to user RMAN. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, November 26, 2001 1:05 PM To: Multiple recipients of list ORACLE-L 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 comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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 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 onwards! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, November 26, 2001 1:05 PMTo: Multiple recipients of list ORACLE-LSubject: 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 comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
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 November 2001 8:05 AMTo: Multiple recipients of list ORACLE-LSubject: 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 comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
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 to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A version:2.1 email;internet:[EMAIL PROTECTED] title:Infrastructure Specialist fn:Anjan Thakuria end:vcard
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 my archive logs and delete them. We don't have enough room to keep them. This way the archive logs that I might need to restore and recovery from a particular backup are with that backup when I put it on tape. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 3:46 PM 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 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 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 a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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: Ruth Gramolini 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: Joan Hsieh 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: Ruth Gramolini 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 question
Janardhana, Thanks, another question is that on same production machine we have FM online production instance and reporting instance. We refresh reporting database everynight. (shutdown production, cp datafiles..) Can I use rman to restore all datafiles and redo files to reporting database and recreate control file to rename the reporting database? How rman deal with redo files if we use cold backup? (you know, I can do OS image copy for those files) Is that a tag name can include all the datafiles, control files and redo files image copies)? Joan Janardhana Babu wrote: 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 cases), it would restore the latest backupset with that tag. I haven't found anyother way to restore the old backup. Iam anxious to know if there is anyother possible solution from the list. -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 2:36 PM To: Multiple recipients of list 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 backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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: Joan Hsieh 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 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 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 a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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: Ruth Gramolini 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 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 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 a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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: Ruth Gramolini 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 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 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 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 a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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: Ruth Gramolini 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: Joan Hsieh 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 question
Joan, I don't know about about cold backups but I have done this successfully with hot backups. What you can do is restore your hot backups ( could be old ones ) and do a point in time database recovery using rman 'duplicate database' command. It 's fairly straightforward. Dennis Meng Database Administrator Focal Communications 847-954-8328 Joan Hsieh joan.hsieh@tTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ufts.educc: Sent by: Subject: Re: rman question root@fatcity. com 07/13/01 09:10 AM Please respond to ORACLE-L Janardhana, Thanks, another question is that on same production machine we have FM online production instance and reporting instance. We refresh reporting database everynight. (shutdown production, cp datafiles..) Can I use rman to restore all datafiles and redo files to reporting database and recreate control file to rename the reporting database? How rman deal with redo files if we use cold backup? (you know, I can do OS image copy for those files) Is that a tag name can include all the datafiles, control files and redo files image copies)? Joan Janardhana Babu wrote: 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 cases), it would restore the latest backupset with that tag. I haven't found anyother way to restore the old backup. Iam anxious to know if there is anyother possible solution from the list. -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 2:36 PM To: Multiple recipients of list 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 backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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: Joan Hsieh 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
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 [EMAIL PROTECTED] 07/13/01 03:46PM 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 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 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 a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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: Ruth Gramolini 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: Joan Hsieh 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: 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 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 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 a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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 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 cases), it would restore the latest backupset with that tag. I haven't found anyother way to restore the old backup. Iam anxious to know if there is anyother possible solution from the list. -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 2:36 PM To: Multiple recipients of list 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 backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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 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 suggestions are appreciated... Ghenadie Z. 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).
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 tables/indexes seperate. I hope this helps -Original Message- Sent: 10 May 2001 18:16 To: Multiple recipients of list ORACLE-L 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 the tables in nologging mode. What I would like to know is about the recovery possibility of other tables in logging mode. Will there be any problem during recovery as these datafiles are in unrecoverable status? TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: holders 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 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 the tables in nologging mode. What I would like to know is about the recovery possibility of other tables in logging mode. Will there be any problem during recovery as these datafiles are in unrecoverable status? TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).