Re: rman expired vs obsolete
Hi! Expired backups are unusable since they were not found accessible during last crosscheck or were set to expired state manually. This means that these backups can't and won't be used for restore operation. Obsolete backups can be deleted since there are enough redundant backups according to current backup retention policy. If an obsolete backup is not manually deleted yet, it can be used for restore, unlike expired backups. Backup retention policy can be changed using rman's configure command. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:59 PM Hi, I'm getting a little confused between expired backups and obsolete backups. As I understand it, expired means the backups are no longer on disk. Obsolete means the backup is too old(?). Since I have a data ware house, I only have room on disk for 1 backup. Prior to running my weekly backup, do I issue a Delete Expired or Delete Obsolete, to remove last weeks backup that is currently on disk. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy 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: Tanel Poder 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 expired vs obsolete
Hi, I'm getting a little confused between expired backups and obsolete backups. As I understand it, expired means the backups are no longer on disk. Obsolete means the backup is too old(?). Since I have a data ware house, I only have room on disk for 1 backup. Prior to running my weekly backup, do I issue a Delete Expired or Delete Obsolete, to remove last weeks backup that is currently on disk. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy 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 backup
Sorry to respond to such an old thread (man I'm way behind), but what if the expected location of the archived logs isn't large enough? For example, let's say we have a 10G archive directory, and we dump 5-10G of logs per day. I have to go to a backup made a week ago. That's 35-70G worth of logs if I need to roll forward. Does RMAN try and cram 'em all in at once, or will it roll through them? That sure would be a nice feature. ;-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Tuesday, October 28, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: rman backup AK When you have RMAN back up archived logs, IIRC, in a recovery RMAN first restores those archived logs to the location that Oracle will expect them to be, and I believe that is done as part of the RESTORE DATABASE command. In my situation, I found no advantage from having RMAN store the archive logs, so I have no experience there, just what I've read in the manual. Only RMAN can perform the RESTORE DATABASE command, but once you complete that command, you can complete the recovery using svrmgrl. From everything I've seen, RMAN just issues the RECOVER DATABASE command to svrmgrl or SQL*Plus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Thanks Dennis for Reply, My confusion is , does RMAN sees only those archived logs which are backup using rman or it can use current archived log as well stored in original format at other disk ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 10:49 AM AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK 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: 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
Re: RAC on Win2K using RMAN to Create Standby
jwiegand wrote: Good Day. Has anyone succeeded in this and care to share? I've tried sharing out the directory containing the Oracle backup, tried setting the Oracle services to run under a Windows domain user, but continue to get failures. Hello, Oracle on Windows don't support network drives. You may copy backup file from one server to other manualny, and then create standby database from backup. regards, Marcin Przpiórowski Senior Oracle DBA www.oracledba.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Marcin_Przepi=F3rowski?= 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: RAC on Win2K using RMAN to Create Standby
True, but you can use a UNC address \\machine_name\shared_dir to copy a backup file remotely. But you need to make sure that the user who fires off the copy command has write access on the shared destination directory. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Sent: Thursday, January 15, 2004 4:34 AM To: Multiple recipients of list ORACLE-L jwiegand wrote: Good Day. Has anyone succeeded in this and care to share? I've tried sharing out the directory containing the Oracle backup, tried setting the Oracle services to run under a Windows domain user, but continue to get failures. Hello, Oracle on Windows don't support network drives. You may copy backup file from one server to other manualny, and then create standby database from backup. regards, Marcin Przpiórowski Senior Oracle DBA www.oracledba.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Marcin_Przepi=F3rowski?= 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: QuijadaReina, Julio C 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).
RAC on Win2K using RMAN to Create Standby
Good Day. Has anyone succeeded in this and care to share? I've tried sharing out the directory containing the Oracle backup, tried setting the Oracle services to run under a Windows domain user, but continue to get failures. Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: jwiegand 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 restore question
Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset? thanks! Joan Ruth Gramolini wrote: If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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 restore question
Sorry, I tried set until time, it works. Now I think we can move rman to production since we tested all kinds of restore. Thanks and have nice day! Joan Joan Hsieh wrote: Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset? thanks! Joan Ruth Gramolini wrote: If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: Joan Hsieh 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 restore question
Joan - Glad to hear your success. In the meanwhile I replied to your earlier message. Just to clarify, when you used a time-based recovery, setting a time earlier than the most recent backup, RMAN ignored the most recent backup and restored from an earlier backup? Wouldn't that have the disadvantage that you're stuck with a database that doesn't have all the recent transactions applied? Just asking, you're probably suffering from recovery fatigue now. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 9:39 AM To: Multiple recipients of list ORACLE-L Sorry, I tried set until time, it works. Now I think we can move rman to production since we tested all kinds of restore. Thanks and have nice day! Joan Joan Hsieh wrote: Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset? thanks! Joan Ruth Gramolini wrote: If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: Joan Hsieh 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
RE: rman restore question
Joan - I have not used the redundancy policy, but my understanding is this just involves how many backup copies to retain. It does not relate to recovery as I read the manual. Do you have Robert Freeman's book Oracle9i RMAN Backup Recovery? Are you attempting an incomplete recovery or a complete recovery? Any recovery to a time prior to the current time is defined as an incomplete recovery. If I am recalling your goal, you are trying to recover but not use the latest backup sets. I always back up using an RMAN catalog, but have always tested recovery just using the control file. On Oracle8i I found it easier to separately issue a SQL command to back up the control file after an RMAN backup, then I ensure that control file ends up on the backup tape. This means that I can take the backup tape, restore the control file, then issue RMAN commands that will restore the database. That control file only knows about the RMAN backup that was last performed. So I could restore the data files from any backup. Now, as you know, recovery in RMAN is basically a shell over the Oracle recovery mechanism. You can restore using RMAN, then recover the database using Oracle server manager (now SQL*Plus) commands. So it should be possible to restore the database using RMAN as I described it (but not restore), then replace the old control file with a more recent control file, then recover the database (Oracle will apply archive log files) until the current time is reached. Obviously by starting with an older restore, more archive logs must be applied. Take a look at this idea and see if it would meet your requirements. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:24 AM To: Multiple recipients of list ORACLE-L Ruth, thanks, I am back. I took the redundancy policy to 4 now and deleted today's backupset and try to recover from the yesterday backupset which is a valid status in the rman report. I still got error. Rman still looking for today's backupset sequence. If I do the crosscheck and delete the expired today's backup. I can recover sucessfully. Is there any possible way not using delete expired command, just recover from day old backupset? thanks! Joan Ruth Gramolini wrote: If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858
RAC with RMAN
Is anybody Running Rac on Unix that is also implemented RMAN on it as well? What type of setup or special considerations did you run into if any? I am considering my options with RAC and whether to expect any bumps with RMAN and/or extra considerations. Feedback is greatly appreciated. Brian S. LimitedBrands -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Spears, Brian 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 options (was: Deleting database)
Title: Re: Deleting database Yechiel, I am letting RMAN do that for me. I have several scripts that help me accomplish this. The first one does a full exportof production. This logical backup is just in case that I need to recreate my production database from scratch. The second one (using RMAN) resyncs and backs up production plus archivelogs and right after that it also backs up my recovery catalog database. The third one (which I only run once a week), shuts down test, starts it with nomount option and then dups production into test. This way I have a new test database with fresh data. I realize that test will contain data 'a week old' from that of production. But that is not critical to my environment. As you pointed out, schemas and tablespaces as well as datafile names in test are the same as in production. Oracles' site suggests to use 'REDUNDANCY TO' a value greater than 1. I see that some other people use the 'RETENTION WINDOW TO. I notice that the REDUNDANCY TO parameter does not show up after Ive set RETENTION WINDOW TO. There is also the option to 'AUTOBACKUP CONTROLFILE'. The question I have is: What option(s) or (combination of them for that matter) do I need to useto be able to do apoint-in-time recovery? Wouldntit beenough to just backup plus archivelogs? As always, grateful for your input! Julio -Original Message- From: [EMAIL PROTECTED]on behalf ofYechiel Adar Sent: Sun 1/4/2004 5:34 AM To: Multiple recipients of list ORACLE-L Cc: Subject: Re: Deleting database I think that if you use exactly the same file names and db structure in both of your database, you can simply ( if it is possible) bring down the production database and copy the files to the test database. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 3:39 PM Carel-Jan, Thanks for your insight in the difference between export/import and copying databases. Two factors had me initially thinking of doing export/import: 1) The tables in production are not big and 2) tables are not subject to heavy changes. As it was pointed out before and although I am not in favor of analyzing stats in a regular basis, the need for analyzing statistics will be determined by the circumstances of one's environment. My test database is more like a test to my logical backups and to have an instance for me to study the tables of this application. Thanks Branimir, Ron, and Vaidya too for your ideas. Now I have a broader view of the various ways to delete a database. Regards, Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Carel-Jan Engel Sent: Tuesday, December 30, 2003 3:39 PM To: Multiple recipients of list ORACLE-L As far as I can understand your question you are copying your production environment to test. So, test should be a copy, and not an export/import logical represantation of prod. Otherwise your tables/indexes will be reorganized every time you create the new test database. This means re-analyzing statistics (see another HOT topic today), and ending up with a non-represntative version of your production database, at least from the SQL-tuning/optimizing point of view. So, I would suggest to take rman, or the old-fashioned well working alter tablespace begein/end backup scenario, and clone your production database. This will give you the physical copy. I've done this many times on unix flavours, never on M$ OS's I like to keep it that way ;-). I guess you might find some nice articles about this on metalink, searching with the keywords clone database. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 12:14 30-12-03 -0800, you wrote: That's right - you would have to drop all schema owners. In my opinion it is simpler and easier task to automate dropping of all owners followed by one full import compared to task of automating database deletions followed by database creations then doing full import in very last step. DOS environment offers weak (better word is miserable) error handling, so unless you resort to non M$ scripting languages to do this task for you I believe you'd be better off to stick with simpler of two approaches. Another reason to try avoiding tearing/re-creating databases lies in the fact that when you create new database on WinXYZ platform, newly created data files are always fragmented at file level (which may not be overly fact important for your test database but it is an ugly site to look at nevertheless). Branimir Branimir, Correct me if I am wrong, but if I used your approach of dropping schema owner then if I have 25 schemas on my test db, I would have to drop ALL of them? I would think
RE: rman restore question
If you don't set the redundancey policy to a recovery window of N days, than the record of the backup will be kept indefinitely. You should be able to restore the backups from tape and restore from a previous backup. You may need to do a set until time if there was corruption or another problem. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joan Hsieh Sent: Tuesday, December 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Subject: rman restore question Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: 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).
Re: rman restore question
Tanel, Yes, rman keep asking the newer backupset which is start *450.rman. I don't know the command change backuupset unavailable command. I will give it a try. I know there is very rare situration that we need restore from an older backupset, but need to prepare it in case we do need it. I will go sqlserver training for next 3 days. I will post after I get back and tested it out. Thanks, joan Quoting Tanel Poder [EMAIL PROTECTED]: Hi! As Stephen pointed out, rman searches for a file named /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman, but can't find it. Is this file a newer backupset which rman is automatically trying to use? If you want to skip this file, you could use change backupset unavailable command for temporarily disabling this newer backupset. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 10:49 PM After I did some testing, it is impossble to restore and recover a deleted obsolete backupset. So I took off the delete obsolete command. Retention policy to redundancy still keep it to 1. I did couple backups and run list backup of database and report obsolete command. Although report obsolet show the backupset but they also shown in list backup of database report and status is valid. Now I have to rephase my question, is it possible to recover from an old backups? I tried restore full, it keep give me the error and asking the newest backupset which I intend move to somewhere else. RMAN-03002: failure of restore command at 12/31/2003 15:36:27 ORA-19505: failed to identify file /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Joan Joan Hsieh wrote: Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: Joan Hsieh 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: Tanel Poder 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: Joan Hsieh 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
RE: rman restore question
I have never attempted what you are doing, so I must confess some ignorance. But, looking at your error message, it appears that rman knows what file it needs and is unable to get it. One must assume there is no file named /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman available on the hard drives. -Original Message- After I did some testing, it is impossble to restore and recover a deleted obsolete backupset. So I took off the delete obsolete command. Retention policy to redundancy still keep it to 1. I did couple backups and run list backup of database and report obsolete command. Although report obsolet show the backupset but they also shown in list backup of database report and status is valid. Now I have to rephase my question, is it possible to recover from an old backups? I tried restore full, it keep give me the error and asking the newest backupset which I intend move to somewhere else. RMAN-03002: failure of restore command at 12/31/2003 15:36:27 ORA-19505: failed to identify file /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory -- 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).
Re: rman restore question
Hi! As Stephen pointed out, rman searches for a file named /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman, but can't find it. Is this file a newer backupset which rman is automatically trying to use? If you want to skip this file, you could use change backupset unavailable command for temporarily disabling this newer backupset. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 10:49 PM After I did some testing, it is impossble to restore and recover a deleted obsolete backupset. So I took off the delete obsolete command. Retention policy to redundancy still keep it to 1. I did couple backups and run list backup of database and report obsolete command. Although report obsolet show the backupset but they also shown in list backup of database report and status is valid. Now I have to rephase my question, is it possible to recover from an old backups? I tried restore full, it keep give me the error and asking the newest backupset which I intend move to somewhere else. RMAN-03002: failure of restore command at 12/31/2003 15:36:27 ORA-19505: failed to identify file /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Joan Joan Hsieh wrote: Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: Joan Hsieh 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: Tanel Poder 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 restore question
I was actually talking from database recovery point of view (that you can do point in time recovery prior to current controlfile time if you use using backup controlfile option when recovering. For restoring a de-registered backupset, I see two options (there might be more, more convenient ones): 1) use a old controlfile from the time when the backupset was still registered in it (you can create another, temporary recovery catalog and use resync catalog from controlfilecopy '' and then can use restore command to read from your old backupset) See metalink note 132927.1 for that. 2) use dbms_backup_restore to manually extract your files from orphan backupsets (Note 60545.1) Tanel. - Original Message - To: [EMAIL PROTECTED]; Tanel Poder [EMAIL PROTECTED] Cc: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 3:55 AM Tanel, Do you mean if I am using current controlfile to recover database, It doesn't matter the backupset is obsolete or not in the rman catalog repository database, is that sounds right? So, I just have to restore the old backupset from tape to disk and issue recover database command? At beginning, I thought to recatalog the backupset, make it valid and then recover from it. However, I couldn't find this kind of operation in manual. So I am wondering how to recover it from an obsolete backupset? Thanks again, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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 restore question
Thanks Tanel. I will test it out. Happy new year! Joan Tanel Poder wrote: I was actually talking from database recovery point of view (that you can do point in time recovery prior to current controlfile time if you use using backup controlfile option when recovering. For restoring a de-registered backupset, I see two options (there might be more, more convenient ones): 1) use a old controlfile from the time when the backupset was still registered in it (you can create another, temporary recovery catalog and use resync catalog from controlfilecopy '' and then can use restore command to read from your old backupset) See metalink note 132927.1 for that. 2) use dbms_backup_restore to manually extract your files from orphan backupsets (Note 60545.1) Tanel. - Original Message - To: [EMAIL PROTECTED]; Tanel Poder [EMAIL PROTECTED] Cc: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 3:55 AM Tanel, Do you mean if I am using current controlfile to recover database, It doesn't matter the backupset is obsolete or not in the rman catalog repository database, is that sounds right? So, I just have to restore the old backupset from tape to disk and issue recover database command? At beginning, I thought to recatalog the backupset, make it valid and then recover from it. However, I couldn't find this kind of operation in manual. So I am wondering how to recover it from an obsolete backupset? Thanks again, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Joan Hsieh 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 restore question
After I did some testing, it is impossble to restore and recover a deleted obsolete backupset. So I took off the delete obsolete command. Retention policy to redundancy still keep it to 1. I did couple backups and run list backup of database and report obsolete command. Although report obsolet show the backupset but they also shown in list backup of database report and status is valid. Now I have to rephase my question, is it possible to recover from an old backups? I tried restore full, it keep give me the error and asking the newest backupset which I intend move to somewhere else. RMAN-03002: failure of restore command at 12/31/2003 15:36:27 ORA-19505: failed to identify file /rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Joan Joan Hsieh wrote: Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: Joan Hsieh 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 restore question
Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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 restore question
I think you can do CONFIGURE CONTROLFILE AUTOBACKUP ON, which enables RMAN to automatically backup controlfile to a default location. Then you can restore the controlfile before you restore other database files. -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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 restore question
Joan - Which Oracle version? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: 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 restore question
Dennis, 9.2.0.4 Joan Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Joan - Which Oracle version? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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 restore question
Well Roger, Suppose I still have the current control file and want to use days old full backupset (obsolete already) to restore and recover the database to the point of time. How it related to recover the autobackup controlfile? I did configure controlfile autobackup on though. Thanks, Joan Quoting Roger Xu [EMAIL PROTECTED]: I think you can do CONFIGURE CONTROLFILE AUTOBACKUP ON, which enables RMAN to automatically backup controlfile to a default location. Then you can restore the controlfile before you restore other database files. -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: Joan Hsieh 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 restore question
You can do point in time recovery using current controlfile as well. You just say recover database until cancal using backup controlfile then, that way Oracle ignores SCN information inside controlfile and trusts only datafile headers. You have to open resetlogs after that. One issue I see with this approach is that when you have added log/datafiles after your backup, then there'll be controlfile/data dictionary mismatch, but it's anyway solvable. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 1:29 AM Well Roger, Suppose I still have the current control file and want to use days old full backupset (obsolete already) to restore and recover the database to the point of time. How it related to recover the autobackup controlfile? I did configure controlfile autobackup on though. Thanks, Joan Quoting Roger Xu [EMAIL PROTECTED]: I think you can do CONFIGURE CONTROLFILE AUTOBACKUP ON, which enables RMAN to automatically backup controlfile to a default location. Then you can restore the controlfile before you restore other database files. -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: Joan Hsieh 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: Tanel Poder 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
Re: rman restore question
Note that when you configure controlfile autobackup on, then a backup controlfile will be saved to default location (dbs or database dir under $ORACLE_HOME) after most physical database structure changes such is adding a datafile, taking tablespace offline/online etc. This is the behaviour of 9.2.0.4 on W2k at least. It may generate a good bunch of backup controfiles to Oracle software directory without your knowing... Anyway, I have less than 23 hours to new year here, so I wish you happy ending of current year and happy new year! And you probably won't hear from me for next few days ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 11:54 PM I think you can do CONFIGURE CONTROLFILE AUTOBACKUP ON, which enables RMAN to automatically backup controlfile to a default location. Then you can restore the controlfile before you restore other database files. -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: Tanel Poder 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 restore question
Tanel, Do you mean if I am using current controlfile to recover database, It doesn't matter the backupset is obsolete or not in the rman catalog repository database, is that sounds right? So, I just have to restore the old backupset from tape to disk and issue recover database command? At beginning, I thought to recatalog the backupset, make it valid and then recover from it. However, I couldn't find this kind of operation in manual. So I am wondering how to recover it from an obsolete backupset? Thanks again, Joan Quoting Tanel Poder [EMAIL PROTECTED]: You can do point in time recovery using current controlfile as well. You just say recover database until cancal using backup controlfile then, that way Oracle ignores SCN information inside controlfile and trusts only datafile headers. You have to open resetlogs after that. One issue I see with this approach is that when you have added log/datafiles after your backup, then there'll be controlfile/data dictionary mismatch, but it's anyway solvable. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 1:29 AM Well Roger, Suppose I still have the current control file and want to use days old full backupset (obsolete already) to restore and recover the database to the point of time. How it related to recover the autobackup controlfile? I did configure controlfile autobackup on though. Thanks, Joan Quoting Roger Xu [EMAIL PROTECTED]: I think you can do CONFIGURE CONTROLFILE AUTOBACKUP ON, which enables RMAN to automatically backup controlfile to a default location. Then you can restore the controlfile before you restore other database files. -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: Joan Hsieh 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
RE: Duplicating with rman
Yeah. I noticed that too and wondered about it. The script that was posted was, in fact, the script that was run. Maybe same kind of line length limitation? -Original Message- From: Yong Huang [mailto:[EMAIL PROTECTED] Sent: Saturday, December 20, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Subject: Re: Duplicating with rman Hi, I'm not sure why your RMAN output says LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', Where's the ) reuse shown in your RMAN script? Are you sure the script you showed here was run? Yong Huang you wrote: RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE DEVL ... LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', ... RMAN-06136: ORACLE error from auxiliary database: ORA-02236: invalid file name RMAN-06097: text of failing SQL statement: CREATE CONTROLFILE REUSE SET ... LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', ... RMAN script is: run { allocate auxiliary channel d1 type disk; set until logseq 5115 thread 1; set newname for datafile 1 to '/u03/oradata/DEVL/system_01.dbf'; ... duplicate target database to DEVL nofilenamecheck logfile group 1 ('/z01/oradata/DEVL/redo_01a.dbf','/z02/oradata/DEVL/redo_01b. dbf') reuse, group 2 ('/z01/oradata/DEVL/redo_02a.dbf','/z02/oradata/DEVL/redo_02b. dbf') reuse, group 3 __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: [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 - the time has come
Title: RMAN - the time has come Okay, its time to bite the bullet ... time to learn RMAN. Outside of TFM (which I just started reading), are there any good books/articles on RMAN? I know there is one by RFreeman, and it is for 9i (Robert, will there be a 10g version?) Yeah, I am also google'ing, taeoma'ing and in general stfw'ing whenever time permits. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
RE: RMAN - the time has come
Title: RMAN - the time has come Raj, It really is a quick learn. The best way is to get some scripts (great examples in the rdbms/demo directory) and try them on a test database. Once you get something running, the rest is simple. If you need some samples, let me know. It's really basic stuff. Tom Mercadante Oracle Certified Professional -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, December 22, 2003 10:35 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - the time has come Okay, its time to bite the bullet ... time to learn RMAN. Outside of TFM (which I just started reading), are there any good books/articles on RMAN? I know there is one by RFreeman, and it is for 9i (Robert, will there be a 10g version?) Yeah, I am also google'ing, taeoma'ing and in general stfw'ing whenever time permits. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
Re: RMAN - the time has come
Title: RMAN - the time has come In addition to the Freeman book, I would also suggest the RMAN Pocket Reference from O'Reilly. It predates the RF book and certainly comes handy for learning - I learned from there. HTH. Arup Nanda - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, December 22, 2003 10:34 AM Subject: RMAN - the time has come Okay, its time to bite the bullet ... time to learn RMAN. Outside of TFM (which I just started reading), are there any good books/articles on RMAN? I know there is one by RFreeman, and it is for 9i (Robert, will there be a 10g version?) Yeah, I am also google'ing, taeoma'ing and in general stfw'ing whenever time permits. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
RE: RMAN - the time has come
Title: RMAN - the time has come Try Robert Freeman's book. I have only heard good things about it. Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, RajendraSent: Monday, December 22, 2003 10:35 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - the time has come Okay, its time to bite the bullet ... time to learn RMAN. Outside of TFM (which I just started reading), are there any good books/articles on RMAN? I know there is one by RFreeman, and it is for 9i (Robert, will there be a 10g version?) Yeah, I am also google'ing, taeoma'ing and in general stfw'ing whenever time permits. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
RE: RMAN - the time has come
We have talked about a 10g version of the book, which I'm sure will happen at some point in time :-) Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/22/2003 2:39 PM Try Robert Freeman's book. I have only heard good things about it. Ruth -Original Message- Jamadagni, Rajendra Sent: Monday, December 22, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Okay, its time to bite the bullet ... time to learn RMAN. Outside of TFM (which I just started reading), are there any good books/articles on RMAN? I know there is one by RFreeman, and it is for 9i (Robert, will there be a 10g version?) Yeah, I am also google'ing, taeoma'ing and in general stfw'ing whenever time permits. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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: RMAN - the time has come
I would say it is like chess. Learning how the pieces move is easy. Learning to put it altogether and use and manage it is not quite as simple. There are a lot of nuances to RMAN, and I don't pretend to have a handle on it. Yet. Jared On Mon, 2003-12-22 at 08:04, Mercadante, Thomas F wrote: Raj, It really is a quick learn. The best way is to get some scripts (great examples in the rdbms/demo directory) and try them on a test database. Once you get something running, the rest is simple. If you need some samples, let me know. It's really basic stuff. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 22, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Okay, its time to bite the bullet ... time to learn RMAN. Outside of TFM (which I just started reading), are there any good books/articles on RMAN? I know there is one by RFreeman, and it is for 9i (Robert, will there be a 10g version?) Yeah, I am also google'ing, taeoma'ing and in general stfw'ing whenever time permits. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Duplicating with rman
Hi, I'm not sure why your RMAN output says LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', Where's the ) reuse shown in your RMAN script? Are you sure the script you showed here was run? Yong Huang you wrote: RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE DEVL ... LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', ... RMAN-06136: ORACLE error from auxiliary database: ORA-02236: invalid file name RMAN-06097: text of failing SQL statement: CREATE CONTROLFILE REUSE SET ... LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', ... RMAN script is: run { allocate auxiliary channel d1 type disk; set until logseq 5115 thread 1; set newname for datafile 1 to '/u03/oradata/DEVL/system_01.dbf'; ... duplicate target database to DEVL nofilenamecheck logfile group 1 ('/z01/oradata/DEVL/redo_01a.dbf','/z02/oradata/DEVL/redo_01b.dbf') reuse, group 2 ('/z01/oradata/DEVL/redo_02a.dbf','/z02/oradata/DEVL/redo_02b.dbf') reuse, group 3 __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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).
Duplicating with rman
I was using RMAN to duplicate a database -- my first time (please be gentle). Copied an on-disk rman backup to target box. started clone instance nomount. rman nocatalog connect target abc/[EMAIL PROTECTED] connect auxiliary xyz/[EMAIL PROTECTED] @script (see below) Everything was going OK until Got error: RMAN-08523: restoring datafile 00016 to /u03/oradata/DEVL/ora_audit_idx_01.dbf RMAN-08023: channel d1: restored backup piece 1 RMAN-08511: piece handle=/u05/oracle/admin/HRP1/backup/dnf9b1m4_1_1_DATA tag=BACKUP_DB_FULL params=NULL RMAN-08024: channel d1: restore complete RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE DEVL RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 907 LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', GROUP 3 ( '/z01/oradata/DEVL/redo_03a.dbf', '/z02/oradata/DEVL/redo_03b.dbf', GROUP 4 ( '/z01/oradata/DEVL/redo_04a.dbf', '/z02/oradata/DEVL/redo_04b.dbf' DATAFILE '/u03/oradata/DEVL/system_01.dbf' CHARACTER SET US7ASCII 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: Duplicate Db RMAN-06136: ORACLE error from auxiliary database: ORA-02236: invalid file name RMAN-06097: text of failing SQL statement: CREATE CONTROLFILE REUSE SET DATABASE DEVL RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 907 LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', '/z02/oradata/DEVL/redo_02b.dbf', GROUP 3 ( '/z01/oradata/DEVL/redo_03a.dbf', '/z02/oradata/DEVL/redo_03b.dbf', GROUP 4 ( '/z01/oradata/DEVL/redo_04a.dbf', '/z02/oradata/DEVL/redo_04b.dbf' RMAN-06099: error occurred in source file: krmk.pc, line: 7544 RMAN **end-of-file** - - RMAN script is: run { allocate auxiliary channel d1 type disk; set until logseq 5115 thread 1; set newname for datafile 1 to '/u03/oradata/DEVL/system_01.dbf'; set newname for datafile 2 to '/u03/oradata/DEVL/rbs_01.dbf'; set newname for datafile 3 to '/u03/oradata/DEVL/users_01.dbf'; set newname for datafile 4 to '/u03/oradata/DEVL/tools_01.dbf'; set newname for datafile 5 to '/u03/oradata/DEVL/temp_01.dbf'; set newname for datafile 6 to '/u03/oradata/DEVL/css_temp_01.dbf'; set newname for datafile 7 to '/u03/oradata/DEVL/css_tools_01.dbf'; set newname for datafile 8 to '/u03/oradata/DEVL/css_tools_index_01.dbf'; set newname for datafile 9 to '/u03/oradata/DEVL/css_data_01.dbf'; set newname for datafile 10 to '/u03/oradata/DEVL/css_data_index_01.dbf'; set newname for datafile 11 to '/u03/oradata/DEVL/css_pay_01.dbf'; set newname for datafile 12 to '/u03/oradata/DEVL/css_pay_index_01.dbf'; set newname for datafile 13 to '/u03/oradata/DEVL/css_pay2_01.dbf'; set newname for datafile 14 to '/u03/oradata/DEVL/css_pay2_index_01.dbf'; set newname for datafile 15 to '/u03/oradata/DEVL/ora_audit_01.dbf'; set newname for datafile 16 to '/u03/oradata/DEVL/ora_audit_idx_01.dbf'; duplicate target database to DEVL nofilenamecheck logfile group 1 ('/z01/oradata/DEVL/redo_01a.dbf','/z02/oradata/DEVL/redo_01b.dbf') reuse, group 2 ('/z01/oradata/DEVL/redo_02a.dbf','/z02/oradata/DEVL/redo_02b.dbf') reuse, group 3 ('/z01/oradata/DEVL/redo_03a.dbf','/z02/oradata/DEVL/redo_03b.dbf') reuse, group 4 ('/z01/oradata/DEVL/redo_04a.dbf','/z02/oradata/DEVL/redo_04b.dbf') reuse; } - - The error ORA-02236: invalid file name would seem to indicate a syntax problem in the rman script. But I can't figure it out. Recreating the control file by hand then running: RMAN run { 2 allocate auxiliary channel d1 type disk; 3 set until logseq 5115 thread 1; 4 recover clone database; 5 } Worked OK. Any suggestions? -- 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
RE: RMAN Retention Policy
Ian, I think retention policy is new in 9i. I purge my repository of backups that are older than 90 days (because our tape systems rotates and reuses tapes after that time) using the change backuppiece 330783 delete; command. I run a sql script againts the rman repository looking for pieces that satisfy this requirement. The sql looks like this: select 'change backuppiece bp.bp_key delete;' from rc_backup_piece bp,rc_database db where db.name = upper('ORACLE_SID') and bp.db_id = db.dbid and bp.start_time sysdate-90 / This is in an 8i database. Hope this is what you were looking for. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, December 17, 2003 5:04 PM To: Multiple recipients of list ORACLE-L How is this set on 8.1.7 and 8.1.6 databases RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found identifier: expecting one of: compatible RMAN-01008: the bad identifier was: RETENTION RMAN-01007: at line 1 column 11 file: standard input I looked at commands such as crosscheck backup of database completed before 'SYSDATE-7'; delete expired backup of database completed before 'SYSDATE-7'; But crosscheck only expires backups which are in the catalog, but not available on the backup media. Do I have to use the change command and designate each backup piece? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Retention Policy
Thomas, You are right it's new in 9i Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Thursday, December 18, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Ian, I think retention policy is new in 9i. I purge my repository of backups that are older than 90 days (because our tape systems rotates and reuses tapes after that time) using the change backuppiece 330783 delete; command. I run a sql script againts the rman repository looking for pieces that satisfy this requirement. The sql looks like this: select 'change backuppiece bp.bp_key delete;' from rc_backup_piece bp,rc_database db where db.name = upper('ORACLE_SID') and bp.db_id = db.dbid and bp.start_time sysdate-90 / This is in an 8i database. Hope this is what you were looking for. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, December 17, 2003 5:04 PM To: Multiple recipients of list ORACLE-L How is this set on 8.1.7 and 8.1.6 databases RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found identifier: expecting one of: compatible RMAN-01008: the bad identifier was: RETENTION RMAN-01007: at line 1 column 11 file: standard input I looked at commands such as crosscheck backup of database completed before 'SYSDATE-7'; delete expired backup of database completed before 'SYSDATE-7'; But crosscheck only expires backups which are in the catalog, but not available on the backup media. Do I have to use the change command and designate each backup piece? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?Q?Ram=F3n_Estevez?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Retention Policy
Did you connect to the target database first? I know this is a simple thing but sometimes we forget. Regards, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MacGregor, Ian A. Sent: Wednesday, December 17, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Subject: RMAN Retention Policy How is this set on 8.1.7 and 8.1.6 databases RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found identifier: expecting one of: compatible RMAN-01008: the bad identifier was: RETENTION RMAN-01007: at line 1 column 11 file: standard input I looked at commands such as crosscheck backup of database completed before 'SYSDATE-7'; delete expired backup of database completed before 'SYSDATE-7'; But crosscheck only expires backups which are in the catalog, but not available on the backup media. Do I have to use the change command and designate each backup piece? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
RE: RMAN Retention Policy
Thanks, for the example script. I had already reached the conclusion that change backuppiece ... was needed, but hadn't yet figured how to query for the proper pieces. Ian MacGregor Stanford linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 5:07 AM To: '[EMAIL PROTECTED]' Cc: MacGregor, Ian A. Ian, I think retention policy is new in 9i. I purge my repository of backups that are older than 90 days (because our tape systems rotates and reuses tapes after that time) using the change backuppiece 330783 delete; command. I run a sql script againts the rman repository looking for pieces that satisfy this requirement. The sql looks like this: select 'change backuppiece bp.bp_key delete;' from rc_backup_piece bp,rc_database db where db.name = upper('ORACLE_SID') and bp.db_id = db.dbid and bp.start_time sysdate-90 / This is in an 8i database. Hope this is what you were looking for. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, December 17, 2003 5:04 PM To: Multiple recipients of list ORACLE-L How is this set on 8.1.7 and 8.1.6 databases RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found identifier: expecting one of: compatible RMAN-01008: the bad identifier was: RETENTION RMAN-01007: at line 1 column 11 file: standard input I looked at commands such as crosscheck backup of database completed before 'SYSDATE-7'; delete expired backup of database completed before 'SYSDATE-7'; But crosscheck only expires backups which are in the catalog, but not available on the backup media. Do I have to use the change command and designate each backup piece? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN Retention Policy
How is this set on 8.1.7 and 8.1.6 databases RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found identifier: expecting one of: compatible RMAN-01008: the bad identifier was: RETENTION RMAN-01007: at line 1 column 11 file: standard input I looked at commands such as crosscheck backup of database completed before 'SYSDATE-7'; delete expired backup of database completed before 'SYSDATE-7'; But crosscheck only expires backups which are in the catalog, but not available on the backup media. Do I have to use the change command and designate each backup piece? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Table recovery from RMAN backup
Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Table recovery from RMAN backup
Take a look at TSPITR (tablespace point in time recovery), I believe that's how it's performed as I've never tried it. Essentially RMAN creates a temporary database, recovers the objects in the tablespace targeted for recovery, and then you can recover the data in the object(s) in question. At 08:14 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). Andy Rivenes Lawrence Livermore National Laboratory Phone: 925-424-9834 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes 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: Table recovery from RMAN backup
Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do a flashback query. If not, you must recover the database to the specific time, you cannot recover just a single table. You should probably read the TSPITR recovery chapter in Rob Freeman's book. I have, a long time ago, but I've never done it. On 12/12/2003 11:14:33 AM, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Table recovery from RMAN backup
Metalink Note:223543.1 has good information on how to recover just a single table using a modified TSPITR. I performed this operation successful on a data warehouse. Josh -Original Message- Sent: Friday, December 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do a flashback query. If not, you must recover the database to the specific time, you cannot recover just a single table. You should probably read the TSPITR recovery chapter in Rob Freeman's book. I have, a long time ago, but I've never done it. On 12/12/2003 11:14:33 AM, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier 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: Table recovery from RMAN backup
Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami - Original Message - Date: Friday, December 12, 2003 11:34 am Take a look at TSPITR (tablespace point in time recovery), I believe that's how it's performed as I've never tried it. Essentially RMAN creates a temporary database, recovers the objects in the tablespace targeted for recovery, and then you can recover the data in the object(s) in question. At 08:14 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). Andy Rivenes Lawrence Livermore National Laboratory Phone: 925-424-9834 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes 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: 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: Table recovery from RMAN backup
Hi! I believe flashback query works only on existing tables, you can query deleted data from it for example, but you can't see dropped tables with it. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 12, 2003 6:59 PM Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do a flashback query. If not, you must recover the database to the specific time, you cannot recover just a single table. You should probably read the TSPITR recovery chapter in Rob Freeman's book. I have, a long time ago, but I've never done it. On 12/12/2003 11:14:33 AM, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Table recovery from RMAN backup
You can use export and flashback to recover a dropped table. The only time I needed it, it gave a warning on the export but still worked OK. Simon Anderson SciSys Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/12/2003 17:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Table recovery from RMAN backup Hi! I believe flashback query works only on existing tables, you can query deleted data from it for example, but you can't see dropped tables with it. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Table recovery from RMAN backup
The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes 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: Table recovery from RMAN backup
Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of writing should not be underestimated (misunderestimated?) either. If you're a beginner, looking to delve into RMAN, Robert Freeman's book is a must have. Also, Joe Testa used to have some very useful examples and scripts which I've fortgotten to mention so far. scripts. On 12/12/2003 01:34:25 PM, Andy Rivenes wrote: The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Table recovery from RMAN backup
Mladen I'll send you $10 payment fee via paypal :) joe Mladen Gogala wrote: Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of writing should not be underestimated (misunderestimated?) either. If you're a beginner, looking to delve into RMAN, Robert Freeman's book is a must have. Also, Joe Testa used to have some very useful examples and scripts which I've fortgotten to mention so far. scripts. On 12/12/2003 01:34:25 PM, Andy Rivenes wrote: The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Table recovery from RMAN backup
Sami, While you are purchasing the reading material also look at the 101 series as excellent references. Oracle Performance tuning 101, Oracle dba 101, Oracle backup and recovery 101.There are a lot of excellent references on the market and a lot of authors participate on this list. You can get answers to your questions here. I also recommend Robert Freeman's book on RMAN usage as well as the book Expert One-on-One by Thomas Kyte Ron [EMAIL PROTECTED] 12/12/2003 2:04:38 PM Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of writing should not be underestimated (misunderestimated?) either. If you're a beginner, looking to delve into RMAN, Robert Freeman's book is a must have. Also, Joe Testa used to have some very useful examples and scripts which I've fortgotten to mention so far. scripts. On 12/12/2003 01:34:25 PM, Andy Rivenes wrote: The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Table recovery from RMAN backup
My Question: I just tried to locate the web site for Joe's scripts, and I got an error or something. Wasssup? My Contribution (xmas season and all...): http://www.secunia.com/internet_explorer_address_bar_spoofing_test Is it too early to wish merry xmas to all? Thanks in advance. Regards, Mike Thomas --- Joe Testa [EMAIL PROTECTED] wrote: Mladen I'll send you $10 payment fee via paypal :) joe Mladen Gogala wrote: Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of writing should not be underestimated (misunderestimated?) either. If you're a beginner, looking to delve into RMAN, Robert Freeman's book is a must have. Also, Joe Testa used to have some very useful examples and scripts which I've fortgotten to mention so far. scripts. On 12/12/2003 01:34:25 PM, Andy Rivenes wrote: The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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 restore on another server
I have ftp'd the backup pieces into the identical backup location as the orignal server so I have all the stuff available... Im just wondering if I have to do something to tell it that I am on a different server... I've restored the controlfile mannually before but on the same server. I backup the controlfile and wrap in the backup piece with the normal backup. Brian -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 8:19 PM To: Multiple recipients of list ORACLE-L Janardhana - That's a good point. Brian - were you expecting RMAN to extract your controlfile from the RMAN backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in 8i. I couldn't get that to work myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 6:49 PM To: Multiple recipients of list ORACLE-L May be you try the following: If you get errors restoring controlfile, You may ftp the controlfiles manually to the new server and startup mount the database first. Then, Try your restore database. -- Janardhana -Original Message- Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname for datafile 21 to 77 '/u02/vssppln/aimstruct1_index01.dbf'; 78 79 set newname for datafile 22 to 80 '/u02/vssppln/aimwork01.dbf'; 81 82 set newname for datafile 23 to 83 '/u02/vssppln/mipsdata01.dbf'; 84 85 set newname for datafile 24 to 86 '/u02/vssppln/mipsindex01.dbf'; 87 88 set newname for datafile 25 to 89 '/u02/vssppln/mipsdata101.dbf'; 90 91 set newname for datafile 26 to 92 '/u02
RE: RMAN restore on another server
DENNIS...Thanks for your feedback. Here it is.. (NSF problem??) 1. I am not using Tape only disk backups.. 2. I ftp'd the backup pieces to new machine 3. I created a link to duplicate the backup location on the original machine and other locations as pfiles...edited the init file for new control locations etc. 4. The controlfile was wrapping in the backup piece same backup command 5. It is an NSF mount point. (Netapp) Is there a solution with the NFS issue? Brian Spears Database Services [EMAIL PROTECTED] Limitedbrands TECHNOLOGY SERVICES -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Brian - First, congratulations on performing what seems pretty close to a disaster recovery test. I don't know the specific answer to your problem, so I'll ask a couple of questions related to hard points I encountered, and maybe that will strike a cord. 1. You say you connected to your existing RMAN catalog? How does the catalog know to recover this new database and not the one it backed up? Maybe it is confused. I found it much simpler to recover from the controlfile even if I used the catalog to perform the backup. Also in a true disaster, you may not have your RMAN catalog unless you have another tape. If you can recover from the single tape with the RMAN backup, then your offsite tape could get you up and running. 2. Are the backup pieces in the same path as you backed them up? I don't think that is your problem because that usually gives a clear error. 3. Are you using NFS? I encountered a problem with NFS very similar to your symptoms. My sys admin assumed there would be only a connection or two over NFS, so left some stuff default. Come to find out RMAN opens a bunch of connections. Sorry, but that is all my brain can think up on Friday. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 4:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62
RE: RMAN restore on another server
Brian - I think that is the problem -- you can't tell RMAN you are on a different server. The part I'm not getting a clear picture on is your control file. For this specific recovery, how is it getting a control file? Did you move one over from production, or are you waiting for RMAN to cough it up from the backup pieces? On 8i this tends to be a problem. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 08, 2003 8:39 AM To: Multiple recipients of list ORACLE-L I have ftp'd the backup pieces into the identical backup location as the orignal server so I have all the stuff available... Im just wondering if I have to do something to tell it that I am on a different server... I've restored the controlfile mannually before but on the same server. I backup the controlfile and wrap in the backup piece with the normal backup. Brian -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 8:19 PM To: Multiple recipients of list ORACLE-L Janardhana - That's a good point. Brian - were you expecting RMAN to extract your controlfile from the RMAN backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in 8i. I couldn't get that to work myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 6:49 PM To: Multiple recipients of list ORACLE-L May be you try the following: If you get errors restoring controlfile, You may ftp the controlfiles manually to the new server and startup mount the database first. Then, Try your restore database. -- Janardhana -Original Message- Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln
RE: RMAN restore on another server
Brian - My sys admin pleads amnesia on the NFS problem. My recollection was that it was misconfigured or had a default configuration that expected only a couple of connections and RMAN actually opens MANY file connections. My specific symptoms is that RMAN would create the first few data files and then just stop. Oracle Support made me take NFS out of the mix and then everything worked. In your case, I am also concerned about the control file. I was unable to get 8i to create the control file from the backup although others on this list reported success with that. I would feel better if you said that you separately backed up the control file at the end of the RMAN backup, and manually moved that control file into place on the test system. At least you would eliminate that as the problem. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 08, 2003 8:49 AM To: Multiple recipients of list ORACLE-L DENNIS...Thanks for your feedback. Here it is.. (NSF problem??) 1. I am not using Tape only disk backups.. 2. I ftp'd the backup pieces to new machine 3. I created a link to duplicate the backup location on the original machine and other locations as pfiles...edited the init file for new control locations etc. 4. The controlfile was wrapping in the backup piece same backup command 5. It is an NSF mount point. (Netapp) Is there a solution with the NFS issue? Brian Spears Database Services [EMAIL PROTECTED] Limitedbrands TECHNOLOGY SERVICES -Original Message- DENNIS WILLIAMS Sent: Friday, December 05, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Brian - First, congratulations on performing what seems pretty close to a disaster recovery test. I don't know the specific answer to your problem, so I'll ask a couple of questions related to hard points I encountered, and maybe that will strike a cord. 1. You say you connected to your existing RMAN catalog? How does the catalog know to recover this new database and not the one it backed up? Maybe it is confused. I found it much simpler to recover from the controlfile even if I used the catalog to perform the backup. Also in a true disaster, you may not have your RMAN catalog unless you have another tape. If you can recover from the single tape with the RMAN backup, then your offsite tape could get you up and running. 2. Are the backup pieces in the same path as you backed them up? I don't think that is your problem because that usually gives a clear error. 3. Are you using NFS? I encountered a problem with NFS very similar to your symptoms. My sys admin assumed there would be only a connection or two over NFS, so left some stuff default. Come to find out RMAN opens a bunch of connections. Sorry, but that is all my brain can think up on Friday. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 4:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02
RE: RMAN restore on another server
Dennis and all, I have no problem getting the controlfile... I just comment out the SET commands to change the directories of the dbfs...and I replicate the control according to the init file specifications.. So This operation actually extract the controlfile out of the backup piece so I know the location and connections are working fine. But since the controlfile is backup and I am restoring it with the same RMan command I think I should have no problem.. I know other DBAs.. run this same script and restore the database on another server with no problem if the controlfile is restored before the database is restored and recovered. Here is the restore controlfile script and resulting log file == Controlfile restore Script == connect catalog rman81740/[EMAIL PROTECTED] connect target / run { allocate channel d1 type disk ; sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; set until time = '2003-12-02 05:50:00'; #restore controlfile to '/u02/vssppln/restored_cf.ctl'; replicate controlfile from '/u02/vssppln/restored_cf.ctl'; release channel d1; } == Successful Controlfile restore log == Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 run 7 8 { 9 10 allocate channel d1 type disk ; 11 12 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 13 set until time = '2003-12-02 05:50:00'; 14 15 16 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 17 18 replicate controlfile from '/u02/vssppln/restored_cf.ctl'; 19 20 release channel d1; 21 } 22 23 RMAN-06008: connected to recovery catalog database RMAN-06006: connected to target database: vssppln (not mounted) RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=12 devtype=DISK RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS RMAN-03023: executing command: sql RMAN-03022: compiling command: set RMAN-03022: compiling command: replicate RMAN-03023: executing command: replicate RMAN-08058: replicating controlfile RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: d1 Recovery Manager complete. = Here is the orignal entire script to restore controlfile and database but it just hangs on the set commands.. = == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname
RE: RMAN restore on another server
why not use the RMAN duplicate database process. that sounds like what you are trying to do. Have you ever let the script run to completion? Maybe its slow for another reason. I have used duplicate database on Solaris many times with great success. Josh -Original Message- Sent: Monday, December 08, 2003 8:20 AM To: Multiple recipients of list ORACLE-L Dennis and all, I have no problem getting the controlfile... I just comment out the SET commands to change the directories of the dbfs...and I replicate the control according to the init file specifications.. So This operation actually extract the controlfile out of the backup piece so I know the location and connections are working fine. But since the controlfile is backup and I am restoring it with the same RMan command I think I should have no problem.. I know other DBAs.. run this same script and restore the database on another server with no problem if the controlfile is restored before the database is restored and recovered. Here is the restore controlfile script and resulting log file == Controlfile restore Script == connect catalog rman81740/[EMAIL PROTECTED] connect target / run { allocate channel d1 type disk ; sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; set until time = '2003-12-02 05:50:00'; #restore controlfile to '/u02/vssppln/restored_cf.ctl'; replicate controlfile from '/u02/vssppln/restored_cf.ctl'; release channel d1; } == Successful Controlfile restore log == Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 run 7 8 { 9 10 allocate channel d1 type disk ; 11 12 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 13 set until time = '2003-12-02 05:50:00'; 14 15 16 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 17 18 replicate controlfile from '/u02/vssppln/restored_cf.ctl'; 19 20 release channel d1; 21 } 22 23 RMAN-06008: connected to recovery catalog database RMAN-06006: connected to target database: vssppln (not mounted) RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=12 devtype=DISK RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS RMAN-03023: executing command: sql RMAN-03022: compiling command: set RMAN-03022: compiling command: replicate RMAN-03023: executing command: replicate RMAN-08058: replicating controlfile RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl RMAN-03022: compiling command: release RMAN-03023: executing command: release RMAN-08031: released channel: d1 Recovery Manager complete. = Here is the orignal entire script to restore controlfile and database but it just hangs on the set commands.. = == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02
Re: RMAN restore on another server
I did this exercise a few months ago and created some rough but detailed docs that you may find helpful. http://www.cybcon.com/~jkstill/Alternate_Client_Restore_With_Veritas_NetBackup_and_Oracle_RMAN.doc Jared On Fri, 2003-12-05 at 14:14, Spears, Brian wrote: Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname for datafile 21 to 77 '/u02/vssppln/aimstruct1_index01.dbf'; 78 79 set newname for datafile 22 to 80 '/u02/vssppln/aimwork01.dbf'; 81 82 set newname for datafile 23 to 83 '/u02/vssppln/mipsdata01.dbf'; 84 85 set newname for datafile 24 to 86 '/u02/vssppln/mipsindex01.dbf'; 87 88 set newname for datafile 25 to 89 '/u02/vssppln/mipsdata101.dbf'; 90 91 set newname for datafile 26 to 92 '/u02/vssppln/mipsdata1_index01.dbf'; 93 94 set newname for datafile 27 to 95 '/u02/vssppln/mipsdata201.dbf'; 96 97 set newname for datafile 28 to 98 '/u02/vssppln/nipsdata2_index01.dbf'; 99 100 set newname for datafile 29 to 101 '/u02/vssppln/tools01.dbf'; 102 103 set newname for datafile 30 to 104 '/u02/vssppln/users01.dbf'; 105 106 set newname for datafile 31 to 107 '/u02/vssppln/AIMINDEX01.dbf'; 108 109 set newname for datafile 32 to 110 '/u02/vssppln/aimfact1_index05.dbf'; 111 112 set newname for datafile 33 to 113 '/u02/vssppln/aimfact2_index05.dbf'; 114 115 116 restore database; 117 118 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 119 120 mount database; 121 122 switch datafile all; 123 124 release channel disk_channel1; 125 } 126 127 RMAN-06008: connected to recovery catalog database RMAN-06006: connected to target
RMAN restore on another server
Title: Message Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i2) install the patch 4.03) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command andgets to the"RMAN-03022: compiling command: set " and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED]2 3 connect target /4 5 6 7 run8 9 {10 11 allocate channel disk_channel1 type disk ;12 13 sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';14 set until time = '2003-12-02 05:50:00';15 16 set newname for datafile 1 to17 '/u02/vssppln/system01.dbf';18 19 set newname for datafile 2 to20 '/u02/vssppln/rbs01.dbf';21 22 set newname for datafile 3 to23 '/u02/vssppln/rbs02.dbf';24 25 set newname for datafile 4 to26 '/u02/vssppln/AIMFACT01.dbf';27 28 set newname for datafile 5 to29 '/u02/vssppln/AIMFACT_INDEX01.dbf';30 31 set newname for datafile 6 to32 '/u02/vssppln/AIMFACT101.dbf';33 34 set newname for datafile 7 to35 '/u02/vssppln/AIMFACT102.dbf';36 37 set newname for datafile 8 to38 '/u02/vssppln/aimfact1_index01.dbf';39 40 set newname for datafile 9 to41 '/u02/vssppln/aimfact1_index02.dbf';42 43 set newname for datafile 10 to44 '/u02/vssppln/aimfact1_index03.dbf';45 46 set newname for datafile 11 to47 '/u02/vssppln/aimfact1_index04.dbf';48 49 set newname for datafile 12 to50 '/u02/vssppln/aimfact201.dbf';51 52 set newname for datafile 13 to53 '/u02/vssppln/aimfact202.dbf';54 55 set newname for datafile 14 to56 '/u02/vssppln/aimfact2_index01.dbf';57 58 set newname for datafile 15 to59 '/u02/vssppln/aimfact2_index02.dbf';60 61 set newname for datafile 16 to62 '/u02/vssppln/aimfact2_index03.dbf';63 64 set newname for datafile 17 to65 '/u02/vssppln/aimfact2_index04.dbf';66 67 set newname for datafile 18 to68 '/u02/vssppln/aimstruct01.dbf';69 70 set newname for datafile 19 to71 '/u02/vssppln/aimstruct_index01.dbf';72 73 set newname for datafile 20 to74 '/u02/vssppln/aimstruct101.dbf';75 76 set newname for datafile 21 to77 '/u02/vssppln/aimstruct1_index01.dbf';78 79 set newname for datafile 22 to80 '/u02/vssppln/aimwork01.dbf';81 82 set newname for datafile 23 to83 '/u02/vssppln/mipsdata01.dbf';84 85 set newname for datafile 24 to86 '/u02/vssppln/mipsindex01.dbf';87 88 set newname for datafile 25 to89 '/u02/vssppln/mipsdata101.dbf';90 91 set newname for datafile 26 to92 '/u02/vssppln/mipsdata1_index01.dbf';93 94 set newname for datafile 27 to95 '/u02/vssppln/mipsdata201.dbf';96 97 set newname for datafile 28 to98 '/u02/vssppln/nipsdata2_index01.dbf';99 100 set newname for datafile 29 to101 '/u02/vssppln/tools01.dbf';102 103 set newname for datafile 30 to104 '/u02/vssppln/users01.dbf';105 106 set newname for datafile 31 to107 '/u02/vssppln/AIMINDEX01.dbf';108 109 set newname for datafile 32 to110 '/u02/vssppln/aimfact1_index05.dbf';111 112 set newname for datafile 33 to113 '/u02/vssppln/aimfact2_index05.dbf';114 115 116 restore database;117 118 restore controlfile to '/u02/vssppln/restored_cf.ctl';119 120 mount database;121 122 switch datafile all;123 124 release channel disk_channel1;125 }126 127 RMAN-06008: connected to recovery catalog database RMAN-06006: connected to target database: vssppln (not mounted) RMAN-03022: compiling command: allocateRMAN-03023: executing command: allocateRMAN-08030: allocated channel: disk_channel1RMAN-08500: channel disk_channel1: sid=10 devtype=DISK RMAN-03022: compiling command: sqlRMAN-06162: sql statement: alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"RMAN-03023: executing command: sql RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-
RE: RMAN restore on another server
Brian - First, congratulations on performing what seems pretty close to a disaster recovery test. I don't know the specific answer to your problem, so I'll ask a couple of questions related to hard points I encountered, and maybe that will strike a cord. 1. You say you connected to your existing RMAN catalog? How does the catalog know to recover this new database and not the one it backed up? Maybe it is confused. I found it much simpler to recover from the controlfile even if I used the catalog to perform the backup. Also in a true disaster, you may not have your RMAN catalog unless you have another tape. If you can recover from the single tape with the RMAN backup, then your offsite tape could get you up and running. 2. Are the backup pieces in the same path as you backed them up? I don't think that is your problem because that usually gives a clear error. 3. Are you using NFS? I encountered a problem with NFS very similar to your symptoms. My sys admin assumed there would be only a connection or two over NFS, so left some stuff default. Come to find out RMAN opens a bunch of connections. Sorry, but that is all my brain can think up on Friday. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 4:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname for datafile 21 to 77 '/u02/vssppln/aimstruct1_index01.dbf'; 78 79 set newname for datafile 22 to 80 '/u02/vssppln/aimwork01.dbf'; 81 82 set newname for datafile 23 to 83 '/u02/vssppln/mipsdata01.dbf'; 84 85 set newname for datafile 24 to 86 '/u02/vssppln/mipsindex01.dbf'; 87 88 set newname for datafile 25 to 89
Re: RMAN restore on another server
How did you expect the restore to work w/o first restoring the controlfile? or am i missing something here? joe Spears, Brian wrote: *Goal:* To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. *Strategy:* To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. *Here is the command in operation* == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname for datafile 21 to 77 '/u02/vssppln/aimstruct1_index01.dbf'; 78 79 set newname for datafile 22 to 80 '/u02/vssppln/aimwork01.dbf'; 81 82 set newname for datafile 23 to 83 '/u02/vssppln/mipsdata01.dbf'; 84 85 set newname for datafile 24 to 86 '/u02/vssppln/mipsindex01.dbf'; 87 88 set newname for datafile 25 to 89 '/u02/vssppln/mipsdata101.dbf'; 90 91 set newname for datafile 26 to 92 '/u02/vssppln/mipsdata1_index01.dbf'; 93 94 set newname for datafile 27 to 95 '/u02/vssppln/mipsdata201.dbf'; 96 97 set newname for datafile 28 to 98 '/u02/vssppln/nipsdata2_index01.dbf'; 99 100 set newname for datafile 29 to 101 '/u02/vssppln/tools01.dbf'; 102 103 set newname for datafile 30 to 104 '/u02/vssppln/users01.dbf'; 105 106 set newname for datafile 31 to 107 '/u02/vssppln/AIMINDEX01.dbf'; 108 109 set newname for datafile 32 to 110 '/u02/vssppln/aimfact1_index05.dbf'; 111 112 set newname for datafile 33 to 113 '/u02/vssppln/aimfact2_index05.dbf'; 114 115 116 restore database; 117 118 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 119 120 mount database; 121 122 switch datafile all; 123 124 release channel disk_channel1; 125 } 126 127 RMAN-06008: connected to recovery catalog database RMAN-06006: connected to target database: vssppln (not mounted) RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: disk_channel1 RMAN-08500: channel disk_channel1: sid=10 devtype=DISK RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter session set
RE: RMAN restore on another server
Title: Message By default RMAN restores the backup to the machine from where it is backedup. If you need to restore the backup on to alternate client, your netbackup admin has to setup the access. You have not mentioned whether you are using Netbackup or legato or something else. Once the access is set up, you can test it by connecting to rman target / catalog rman/[EMAIL PROTECTED] on the new machine ,and issuing the command list backup at RMAN prompt on the new machine. If you see the backups, you can restore the backup. If you are using NETBACKUP, use the var NB_ORA_CLIENT, If not substitute with the corresponding variable. Startup nomount; Run { Allocate channel t1 type 'sbt_tape' parms="ENV=(NB_ORA_CLIENT=backedupclient; export NB_ORA_CLIENT); Restore controlfile; Alter database mount; Restore database; Alter database open; } -- Janardhana -Original Message- From: Spears, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RMAN restore on another server Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command andgets to theRMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname for datafile 21 to 77 '/u02/vssppln/aimstruct1_index01.dbf'; 78 79 set newname for datafile 22 to 80 '/u02/vssppln/aimwork01.dbf'; 81 82 set newname for datafile 23 to 83 '/u02/vssppln/mipsdata01.dbf'; 84 85 set newname for datafile 24 to 86 '/u02/vssppln/mipsindex01.dbf'; 87 88 set newname for datafile 25 to 89 '/u02/vssppln/mipsdata101.dbf'; 90 91 set newname for datafile 26 to 92 '/u02/vssppln/mipsdata1_index01.dbf'; 93 94 set newname for datafile 27 to 95 '/u02/vssppln/mipsdata201.dbf'; 96 97 set ne
RE: RMAN restore on another server
Title: Message I am sorry, I thought you are restoring from Tape. In either case, you connect to target and catalog database on the new server and see if you can access the backups that were backed up on the original server. -- Janardhana -Original Message- From: Spears, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RMAN restore on another server Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command andgets to theRMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname for datafile 21 to 77 '/u02/vssppln/aimstruct1_index01.dbf'; 78 79 set newname for datafile 22 to 80 '/u02/vssppln/aimwork01.dbf'; 81 82 set newname for datafile 23 to 83 '/u02/vssppln/mipsdata01.dbf'; 84 85 set newname for datafile 24 to 86 '/u02/vssppln/mipsindex01.dbf'; 87 88 set newname for datafile 25 to 89 '/u02/vssppln/mipsdata101.dbf'; 90 91 set newname for datafile 26 to 92 '/u02/vssppln/mipsdata1_index01.dbf'; 93 94 set newname for datafile 27 to 95 '/u02/vssppln/mipsdata201.dbf'; 96 97 set newname for datafile 28 to 98 '/u02/vssppln/nipsdata2_index01.dbf'; 99 100 set newname for datafile 29 to 101 '/u02/vssppln/tools01.dbf'; 102 103 set newname for datafile 30 to 104 '/u02/vssppln/users01.dbf'; 105 106 set newname for datafile 31 to 107 '/u02/vssppln/AIMINDEX01.dbf'; 108 109 set newname for datafile 32 to 110 '/u02/vssppln/aimfact1_index05.dbf'; 111 112 set newname for datafile 33 to 113 '/u02/vssppln/aimfact2_index05.dbf'; 114 115 116 restore database; 117 118 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 119 120 mount database; 121 122 switch datafile all; 123 124 release channel disk_channel1; 125
RE: RMAN restore on another server
Title: Message May be you try the following: If you get errors restoring controlfile, You may ftp the controlfiles manually to the new server and startup mount the database first. Then, Try your restore database. -- Janardhana -Original Message- From: Spears, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RMAN restore on another server Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command andgets to theRMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname for datafile 21 to 77 '/u02/vssppln/aimstruct1_index01.dbf'; 78 79 set newname for datafile 22 to 80 '/u02/vssppln/aimwork01.dbf'; 81 82 set newname for datafile 23 to 83 '/u02/vssppln/mipsdata01.dbf'; 84 85 set newname for datafile 24 to 86 '/u02/vssppln/mipsindex01.dbf'; 87 88 set newname for datafile 25 to 89 '/u02/vssppln/mipsdata101.dbf'; 90 91 set newname for datafile 26 to 92 '/u02/vssppln/mipsdata1_index01.dbf'; 93 94 set newname for datafile 27 to 95 '/u02/vssppln/mipsdata201.dbf'; 96 97 set newname for datafile 28 to 98 '/u02/vssppln/nipsdata2_index01.dbf'; 99 100 set newname for datafile 29 to 101 '/u02/vssppln/tools01.dbf'; 102 103 set newname for datafile 30 to 104 '/u02/vssppln/users01.dbf'; 105 106 set newname for datafile 31 to 107 '/u02/vssppln/AIMINDEX01.dbf'; 108 109 set newname for datafile 32 to 110 '/u02/vssppln/aimfact1_index05.dbf'; 111 112 set newname for datafile 33 to 113 '/u02/vssppln/aimfact2_index05.dbf'; 114 115 116 restore database; 117 118 restore controlfile to '/u02/vssppln/restored_cf.ctl'; 119 120 mount database; 121 122 switch datafile all; 123 124 release channel disk_channel1; 125 } 126 127
RE: RMAN restore on another server
Janardhana - That's a good point. Brian - were you expecting RMAN to extract your controlfile from the RMAN backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in 8i. I couldn't get that to work myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 6:49 PM To: Multiple recipients of list ORACLE-L May be you try the following: If you get errors restoring controlfile, You may ftp the controlfiles manually to the new server and startup mount the database first. Then, Try your restore database. -- Janardhana -Original Message- Sent: Friday, December 05, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Goal: To restore the database from RMAN backup on a different server by means of moving the backup pieces and logs over to the new machine and use Rman to unpack the database files. Strategy: To restore the database from the RMAN backup pieces into a new directory locations on the machine and extract the control file and startup the database. Some of the steps to setup the new machine. 1) Install oracle 8i 2) install the patch 4.0 3) copy .profile over 4) duplicated the Admin directories for the database to be restored 5) created a big mount /u02/vssppln/ point for all the datafiles and controlfiles and so on 6) Created a backup mount point to store the RMAN backup pieces and archivelogs 7) moved the backup pieces and archivelogs to the new machine 8) Setup and confirm connectivity to Rman catalog 9) No mount the database to be on the new machine 10) Launch the Rman command rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log Problem... I run this restore from Rman backup...but it gets to processing the command and gets to the RMAN-03022: compiling command: set and just hangs...adding another line every 1/2 hour or so... Anybody seen this or have ideas? I talked to one guy who did have this but couldn't remember the solution. This is the first time doing this so I might be missing something simple.. Here is the command in operation == rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log Recovery Manager: Release 8.1.7.4.0 - Production RMAN RMAN connect catalog rman81740/[EMAIL PROTECTED] mailto:rman81740/[EMAIL PROTECTED] 2 3 connect target / 4 5 6 7 run 8 9 { 10 11 allocate channel disk_channel1 type disk ; 12 13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS'; 14 set until time = '2003-12-02 05:50:00'; 15 16 set newname for datafile 1 to 17 '/u02/vssppln/system01.dbf'; 18 19 set newname for datafile 2 to 20 '/u02/vssppln/rbs01.dbf'; 21 22 set newname for datafile 3 to 23 '/u02/vssppln/rbs02.dbf'; 24 25 set newname for datafile 4 to 26 '/u02/vssppln/AIMFACT01.dbf'; 27 28 set newname for datafile 5 to 29 '/u02/vssppln/AIMFACT_INDEX01.dbf'; 30 31 set newname for datafile 6 to 32 '/u02/vssppln/AIMFACT101.dbf'; 33 34 set newname for datafile 7 to 35 '/u02/vssppln/AIMFACT102.dbf'; 36 37 set newname for datafile 8 to 38 '/u02/vssppln/aimfact1_index01.dbf'; 39 40 set newname for datafile 9 to 41 '/u02/vssppln/aimfact1_index02.dbf'; 42 43 set newname for datafile 10 to 44 '/u02/vssppln/aimfact1_index03.dbf'; 45 46 set newname for datafile 11 to 47 '/u02/vssppln/aimfact1_index04.dbf'; 48 49 set newname for datafile 12 to 50 '/u02/vssppln/aimfact201.dbf'; 51 52 set newname for datafile 13 to 53 '/u02/vssppln/aimfact202.dbf'; 54 55 set newname for datafile 14 to 56 '/u02/vssppln/aimfact2_index01.dbf'; 57 58 set newname for datafile 15 to 59 '/u02/vssppln/aimfact2_index02.dbf'; 60 61 set newname for datafile 16 to 62 '/u02/vssppln/aimfact2_index03.dbf'; 63 64 set newname for datafile 17 to 65 '/u02/vssppln/aimfact2_index04.dbf'; 66 67 set newname for datafile 18 to 68 '/u02/vssppln/aimstruct01.dbf'; 69 70 set newname for datafile 19 to 71 '/u02/vssppln/aimstruct_index01.dbf'; 72 73 set newname for datafile 20 to 74 '/u02/vssppln/aimstruct101.dbf'; 75 76 set newname for datafile 21 to 77 '/u02/vssppln/aimstruct1_index01.dbf'; 78 79 set newname for datafile 22 to 80 '/u02/vssppln/aimwork01.dbf'; 81 82 set newname for datafile 23 to 83 '/u02/vssppln/mipsdata01.dbf'; 84 85 set newname for datafile 24 to 86 '/u02/vssppln/mipsindex01.dbf'; 87 88 set newname for datafile 25 to 89 '/u02/vssppln/mipsdata101.dbf'; 90 91 set newname for datafile 26 to 92 '/u02/vssppln/mipsdata1_index01.dbf'; 93 94 set newname for datafile 27 to 95 '/u02/vssppln/mipsdata201.dbf'; 96 97 set newname for datafile 28 to 98 '/u02/vssppln/nipsdata2_index01.dbf'; 99 100 set newname for datafile 29 to 101 '/u02/vssppln/tools01.dbf'; 102 103 set newname for datafile 30 to 104 '/u02/vssppln/users01.dbf'; 105 106 set newname for datafile 31 to 107 '/u02/vssppln/AIMINDEX01.dbf'; 108 109 set newname for datafile 32 to 110 '/u02/vssppln/aimfact1_index05.dbf'; 111 112 set newname
RE: RMAN questions
I suppose just how much redundancy makes you sleep well is up to you. But, one additional bit of info to keep in mind is that the backup info also gets stored in the control files, and rman can use those too if no catalog database is available. Making a copy of a control file after the backup finishes, and saving that copy, can be a part of the rman backup. That way, if you lost all control files and your catalog database, rman can use your saved control file copy get back at least most, if not all, of your stuff. -Original Message- Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- 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 questions
We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i. I'm looking at using RMAN for our backup and recovery. We have many instances but essentially 2 types. 1. Production instances that have both OLAP and OLTP. These must be in archive log mode. 2. We have staging instances where we do data loads. We do not put these in archive log mode for obvious reasons. We do our backups of these with transportable tablespaces and running dbverify. We also have 2 locations. One is remote. Its not practical to store our backups from the remote location at our local location or vice versa. So we will need 2 seperate RMAN setups. I have seen that some people like to use two instances that have RMAN. Many people will just put the RMAN catalog in an existing instance. Is that really a good idea? The idea behind two instances is that they can back each other up. Is that really enough? You can lose both instances, then your backup sets are useless. We have a shared NAS, so each location uses the same set of storage. We do backup to tape as well. Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- 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).
Re: RMAN questions
I do not think you need 2 Rman catalogs. Build a small database just for Rman. After the daily backup finished bring it down and do os level backup of all the environment for this small backup. You can then easily restore it in case of disk problems. Remember: A backup is good only when you can restore from it. Test restores. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 4:44 PM We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i. I'm looking at using RMAN for our backup and recovery. We have many instances but essentially 2 types. 1. Production instances that have both OLAP and OLTP. These must be in archive log mode. 2. We have staging instances where we do data loads. We do not put these in archive log mode for obvious reasons. We do our backups of these with transportable tablespaces and running dbverify. We also have 2 locations. One is remote. Its not practical to store our backups from the remote location at our local location or vice versa. So we will need 2 seperate RMAN setups. I have seen that some people like to use two instances that have RMAN. Many people will just put the RMAN catalog in an existing instance. Is that really a good idea? The idea behind two instances is that they can back each other up. Is that really enough? You can lose both instances, then your backup sets are useless. We have a shared NAS, so each location uses the same set of storage. We do backup to tape as well. Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar 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: RMAN questions
i must have misread the docs. i thought it was either catalog or control file. didnt know you could do both thanks. From: [EMAIL PROTECTED] Date: 2003/12/04 Thu AM 11:04:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RMAN questions I suppose just how much redundancy makes you sleep well is up to you. But, one additional bit of info to keep in mind is that the backup info also gets stored in the control files, and rman can use those too if no catalog database is available. Making a copy of a control file after the backup finishes, and saving that copy, can be a part of the rman backup. That way, if you lost all control files and your catalog database, rman can use your saved control file copy get back at least most, if not all, of your stuff. -Original Message- Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- 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). -- 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).
Re: RMAN questions
backup of all the environment for this small backup. It should have been: for this small database. Sorry about the mistake. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 6:44 PM I do not think you need 2 Rman catalogs. Build a small database just for Rman. After the daily backup finished bring it down and do os level backup of all the environment for this small backup. You can then easily restore it in case of disk problems. Remember: A backup is good only when you can restore from it. Test restores. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 4:44 PM We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i. I'm looking at using RMAN for our backup and recovery. We have many instances but essentially 2 types. 1. Production instances that have both OLAP and OLTP. These must be in archive log mode. 2. We have staging instances where we do data loads. We do not put these in archive log mode for obvious reasons. We do our backups of these with transportable tablespaces and running dbverify. We also have 2 locations. One is remote. Its not practical to store our backups from the remote location at our local location or vice versa. So we will need 2 seperate RMAN setups. I have seen that some people like to use two instances that have RMAN. Many people will just put the RMAN catalog in an existing instance. Is that really a good idea? The idea behind two instances is that they can back each other up. Is that really enough? You can lose both instances, then your backup sets are useless. We have a shared NAS, so each location uses the same set of storage. We do backup to tape as well. Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: RMAN Script
Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed it and the same error. run { allocate channel c1 type disk format '/u08/backups/rman/BD_%d_%U'; allocate channel c2 type disk format '/u08/backups/rman/ARCH_%d_%U'; set limit channel c1 kbytes=200; set limit channel c2 kbytes=200; setsize=2000; filesperset=2; backup database include current controlfile tag 'Backup Full'; release channel c1; backup archivelog all tag 'Backup Archives'; release channel c2; } TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 winmail.dat
RMAN Script
Title: RMAN Script Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed it and the same error. run { allocate channel c1 type disk format '/u08/backups/rman/BD_%d_%U'; allocate channel c2 type disk format '/u08/backups/rman/ARCH_%d_%U'; set limit channel c1 kbytes=200; set limit channel c2 kbytes=200; setsize=2000; filesperset=2; backup database include current controlfile tag 'Backup Full'; release channel c1; backup archivelog all tag 'Backup Archives'; release channel c2; } TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
Re: RMAN Script
Hi Ramon, I guess you are on 8i : your setsize and fileperset specs should be inside the backup command not outside i.e. something like this : backup fileperset 2 setsize 2000 database
RMAN restore to different machine
I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy 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 restore to different machine
Randy First, you may want to investigate your company's attitude toward recovering their proprietary data on your personal machine. I can give you some ideas on your task, but my experience is on 1)Unix, and 2) Oracle 8i. I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup Recovery. Well worth the money. In Oracle8i I wasn't able to extract the control file from the RMAN backup, so I just backed that up separately. But I think Robert's book describes how to do that. I never worried about the init.ora file in Oracle8i, relying on the normal system backup to back that up. You could probably either copy the spfile from your production system (if you tell me you don't have access to that system, then you'll really concern me about what you are trying to do) or create a dummy init.ora to get the instance started. I don't know if you used the controlfile or catalog backup to create this RMAN backup. I use the catalog backup, but found it easier to recover using just the controlfile. The one sticky point is that RMAN will want its backup pieces in the same path that it backed them up. I haven't found any way of changing that. In Unix you can fool RMAN by creating a link. When you say that you couldn't get RMAN to look at the CD drive, that may be the problem you are encountering. If you are using Windows, perhaps you could find the drive letter used to create the backup and use that same drive letter on your personal machine. You can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy 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: 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 restore to different machine
More food for thought: There is a good chance that the hardware platform is different. I think that RMAN is not a valid way of changing to a new platform and you would need to export/import. I'm certain the experts on the list will correct me if I'm wrong. Thanks Stephen [EMAIL PROTECTED] 11/24/03 11:54AM Randy First, you may want to investigate your company's attitude toward recovering their proprietary data on your personal machine. I can give you some ideas on your task, but my experience is on 1)Unix, and 2) Oracle 8i. I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup Recovery. Well worth the money. In Oracle8i I wasn't able to extract the control file from the RMAN backup, so I just backed that up separately. But I think Robert's book describes how to do that. I never worried about the init.ora file in Oracle8i, relying on the normal system backup to back that up. You could probably either copy the spfile from your production system (if you tell me you don't have access to that system, then you'll really concern me about what you are trying to do) or create a dummy init.ora to get the instance started. I don't know if you used the controlfile or catalog backup to create this RMAN backup. I use the catalog backup, but found it easier to recover using just the controlfile. The one sticky point is that RMAN will want its backup pieces in the same path that it backed them up. I haven't found any way of changing that. In Unix you can fool RMAN by creating a link. When you say that you couldn't get RMAN to look at the CD drive, that may be the problem you are encountering. If you are using Windows, perhaps you could find the drive letter used to create the backup and use that same drive letter on your personal machine. You can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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 restore to different machine
Good catch Stephen. My understanding is that you -Original Message- Sent: Monday, November 24, 2003 3:05 PM To: Multiple recipients of list ORACLE-L More food for thought: There is a good chance that the hardware platform is different. I think that RMAN is not a valid way of changing to a new platform and you would need to export/import. I'm certain the experts on the list will correct me if I'm wrong. Thanks Stephen [EMAIL PROTECTED] 11/24/03 11:54AM Randy First, you may want to investigate your company's attitude toward recovering their proprietary data on your personal machine. I can give you some ideas on your task, but my experience is on 1)Unix, and 2) Oracle 8i. I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup Recovery. Well worth the money. In Oracle8i I wasn't able to extract the control file from the RMAN backup, so I just backed that up separately. But I think Robert's book describes how to do that. I never worried about the init.ora file in Oracle8i, relying on the normal system backup to back that up. You could probably either copy the spfile from your production system (if you tell me you don't have access to that system, then you'll really concern me about what you are trying to do) or create a dummy init.ora to get the instance started. I don't know if you used the controlfile or catalog backup to create this RMAN backup. I use the catalog backup, but found it easier to recover using just the controlfile. The one sticky point is that RMAN will want its backup pieces in the same path that it backed them up. I haven't found any way of changing that. In Unix you can fool RMAN by creating a link. When you say that you couldn't get RMAN to look at the CD drive, that may be the problem you are encountering. If you are using Windows, perhaps you could find the drive letter used to create the backup and use that same drive letter on your personal machine. You can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: 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
RE: RMAN restore to different machine
My apologies, I bumped the send button. Stephen - my understanding is that you are correct, the platforms have to be the same at the binary level - i.e.., both Solaris, both Windows, etc. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 3:20 PM To: '[EMAIL PROTECTED]' Good catch Stephen. My understanding is that you -Original Message- Sent: Monday, November 24, 2003 3:05 PM To: Multiple recipients of list ORACLE-L More food for thought: There is a good chance that the hardware platform is different. I think that RMAN is not a valid way of changing to a new platform and you would need to export/import. I'm certain the experts on the list will correct me if I'm wrong. Thanks Stephen [EMAIL PROTECTED] 11/24/03 11:54AM Randy First, you may want to investigate your company's attitude toward recovering their proprietary data on your personal machine. I can give you some ideas on your task, but my experience is on 1)Unix, and 2) Oracle 8i. I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup Recovery. Well worth the money. In Oracle8i I wasn't able to extract the control file from the RMAN backup, so I just backed that up separately. But I think Robert's book describes how to do that. I never worried about the init.ora file in Oracle8i, relying on the normal system backup to back that up. You could probably either copy the spfile from your production system (if you tell me you don't have access to that system, then you'll really concern me about what you are trying to do) or create a dummy init.ora to get the instance started. I don't know if you used the controlfile or catalog backup to create this RMAN backup. I use the catalog backup, but found it easier to recover using just the controlfile. The one sticky point is that RMAN will want its backup pieces in the same path that it backed them up. I haven't found any way of changing that. In Unix you can fool RMAN by creating a link. When you say that you couldn't get RMAN to look at the CD drive, that may be the problem you are encountering. If you are using Windows, perhaps you could find the drive letter used to create the backup and use that same drive letter on your personal machine. You can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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
Re: RMAN restore to different machine
Wait till 10g. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 24, 2003 11:29 PM My apologies, I bumped the send button. Stephen - my understanding is that you are correct, the platforms have to be the same at the binary level - i.e.., both Solaris, both Windows, etc. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 3:20 PM To: '[EMAIL PROTECTED]' Good catch Stephen. My understanding is that you -Original Message- Sent: Monday, November 24, 2003 3:05 PM To: Multiple recipients of list ORACLE-L More food for thought: There is a good chance that the hardware platform is different. I think that RMAN is not a valid way of changing to a new platform and you would need to export/import. I'm certain the experts on the list will correct me if I'm wrong. Thanks Stephen [EMAIL PROTECTED] 11/24/03 11:54AM Randy First, you may want to investigate your company's attitude toward recovering their proprietary data on your personal machine. I can give you some ideas on your task, but my experience is on 1)Unix, and 2) Oracle 8i. I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup Recovery. Well worth the money. In Oracle8i I wasn't able to extract the control file from the RMAN backup, so I just backed that up separately. But I think Robert's book describes how to do that. I never worried about the init.ora file in Oracle8i, relying on the normal system backup to back that up. You could probably either copy the spfile from your production system (if you tell me you don't have access to that system, then you'll really concern me about what you are trying to do) or create a dummy init.ora to get the instance started. I don't know if you used the controlfile or catalog backup to create this RMAN backup. I use the catalog backup, but found it easier to recover using just the controlfile. The one sticky point is that RMAN will want its backup pieces in the same path that it backed them up. I haven't found any way of changing that. In Unix you can fool RMAN by creating a link. When you say that you couldn't get RMAN to look at the CD drive, that may be the problem you are encountering. If you are using Windows, perhaps you could find the drive letter used to create the backup and use that same drive letter on your personal machine. You can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RMAN Script
Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed and the same error. run { allocate channel c1 type disk format '/u08/backups/rman/BD_%d_%U'; allocate channel c2 type disk format '/u08/backups/rman/ARCH_%d_%U'; set limit channel c1 kbytes=200; set limit channel c2 kbytes=200; setsize=2000; filesperset=2; backup database include current controlfile tag 'Backup Full'; release channel c1; backup archivelog all tag 'Backup Archives'; release channel c2; } TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 winmail.dat
Re: Point-In-Time recovery question, Non-RMAN solution
I think it is possible to enable DDL command logging in 9i, it can be used in logical standby. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 6:09 PM You guessed and hoped you were close enough. If you were wrong, you repeated the exercise until you found the point in time before the drop I'm not sure logminer will show you the drop table in any case. At least not explicitly as drop table is NOT a logged operation. You might see the effect of it on fet$ and uet$ in that extents would be released back to the tablespace but if you have locally managed tablespaces you'd have to search for the update to tab$ to find the time. --- [EMAIL PROTECTED] wrote: How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Point-In-Time recovery question, Non-RMAN solution .com 11/06/2003 10:09 AM Please respond to ORACLE-L Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Point-In-Time recovery question, Non-RMAN solution
Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Point-In-Time recovery question, Non-RMAN solution
Rick unless i'm missing something you need to restore ALL datafiles and then roll forward to the point in time, since all of the SCN have to match before you can get the db open. the timestamp format for step 5 is: RECOVER DATABASE UNTIL TIME '1998-11-23:12:47:30' hth, joe [EMAIL PROTECTED] wrote: Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Point-In-Time recovery question, Non-RMAN solution
Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: Point-In-Time recovery question, Non-RMAN solution
How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Point-In-Time recovery question, Non-RMAN solution .com 11/06/2003 10:09 AM Please respond to ORACLE-L Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: 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
RE: Point-In-Time recovery question, Non-RMAN solution
Rick, In a perfect world, we would be tracking major changes to the database (even updates) by time. In your case, you are stuck with taking a WAG, or more better, and educated WAG. You said that you think you dropped the table at about 1700. You can choose a point-in-time recovery to be 1630, to be safe. When you open the database, if the table is there, then you are done. If not, do it again. Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, November 06, 2003 10:44 AM To: Multiple recipients of list ORACLE-L How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Point-In-Time recovery question, Non-RMAN solution .com 11/06/2003 10:09 AM Please respond to ORACLE-L Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
RE: Point-In-Time recovery question, Non-RMAN solution
Rick - Being very conservative with the time you select ;-) Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 06, 2003 9:44 AM To: Multiple recipients of list ORACLE-L How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Point-In-Time recovery question, Non-RMAN solution .com 11/06/2003 10:09 AM Please respond to ORACLE-L Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: 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: 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: Point-In-Time recovery question, Non-RMAN solution
You guessed and hoped you were close enough. If you were wrong, you repeated the exercise until you found the point in time before the drop I'm not sure logminer will show you the drop table in any case. At least not explicitly as drop table is NOT a logged operation. You might see the effect of it on fet$ and uet$ in that extents would be released back to the tablespace but if you have locally managed tablespaces you'd have to search for the update to tab$ to find the time. --- [EMAIL PROTECTED] wrote: How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Point-In-Time recovery question, Non-RMAN solution .com 11/06/2003 10:09 AM Please respond to ORACLE-L Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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
RE: Point-In-Time recovery question, Non-RMAN solution
Rick You are getting some good replies on your problem. Since you say that you are recovering the table from two days ago, I'm assuming you are recovering to a test server. On the precision of the recovery time, a lot depends on just how much precision you need. As Scott says, you can use Logminer to get extremely close. But maybe if you dropped the table two days ago, just sometime earlier than the drop will be close enough. I also try to perform regular exports on all tables that aren't so large as to be unwieldly. Often when something comes up you can offer an export from a couple of days ago and that is good enough. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 06, 2003 7:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- 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: Point-In-Time recovery question, Non-RMAN solution
you kinda/sorta had to know when it happened and hope for the best. joe [EMAIL PROTECTED] wrote: How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Point-In-Time recovery question, Non-RMAN solution .com 11/06/2003 10:09 AM Please respond to ORACLE-L Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Point-In-Time recovery question, Non-RMAN solution
although it is logged in 9i. joe Rachel Carmichael wrote: You guessed and hoped you were close enough. If you were wrong, you repeated the exercise until you found the point in time before the drop I'm not sure logminer will show you the drop table in any case. At least not explicitly as drop table is NOT a logged operation. You might see the effect of it on fet$ and uet$ in that extents would be released back to the tablespace but if you have locally managed tablespaces you'd have to search for the update to tab$ to find the time. --- [EMAIL PROTECTED] wrote: How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Point-In-Time recovery question, Non-RMAN solution .com 11/06/2003 10:09 AM Please respond to ORACLE-L Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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
RMAN: connecting target DB with SYS account using connect string
Hi list, I have problem connecting to target DB using account SYS with connect string. But SQL*Plus works fine. For example, SQLconnect sys/[EMAIL PROTECTED] connected. but in RMAN (using same OS account and server) == RMAN connect target sys/[EMAIL PROTECTED] failed RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-04005: error from target database: ORA-01017: invalid username/password; logon denied Any help will be really appreciated. -Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan 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: connecting target DB with SYS account using connect str
Sami, RMAN connects as SYSDBA. The password may actually be different. The good one is that works SQLconnect sys/[EMAIL PROTECTED] as SYSDBA HTH Vadim -Original Message- Sent: Tuesday, November 04, 2003 10:15 AM To: Multiple recipients of list ORACLE-L string Hi list, I have problem connecting to target DB using account SYS with connect string. But SQL*Plus works fine. For example, SQLconnect sys/[EMAIL PROTECTED] connected. but in RMAN (using same OS account and server) == RMAN connect target sys/[EMAIL PROTECTED] failed RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-04005: error from target database: ORA-01017: invalid username/password; logon denied Any help will be really appreciated. -Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan 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: Gorbounov,Vadim 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: connecting target DB with SYS account using connect str
Sami - You may also need to create an orapw file in order to connect as SYSDBA remotely. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 04, 2003 9:59 AM To: Multiple recipients of list ORACLE-L str Sami, RMAN connects as SYSDBA. The password may actually be different. The good one is that works SQLconnect sys/[EMAIL PROTECTED] as SYSDBA HTH Vadim -Original Message- Sent: Tuesday, November 04, 2003 10:15 AM To: Multiple recipients of list ORACLE-L string Hi list, I have problem connecting to target DB using account SYS with connect string. But SQL*Plus works fine. For example, SQLconnect sys/[EMAIL PROTECTED] connected. but in RMAN (using same OS account and server) == RMAN connect target sys/[EMAIL PROTECTED] failed RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-04005: error from target database: ORA-01017: invalid username/password; logon denied Any help will be really appreciated. -Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan 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: Gorbounov,Vadim 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: 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: connecting target DB with SYS account using connect string
IF you set your ORACLE_SID to the target database as the Oracle user, all you have to do is say RMAN connect target and it will automatically connect. If you are working from the command line you connect user_with_sysdba_privs/[EMAIL PROTECTED] and you will be connected. If does not recognize the as sysdba. HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Saminathan Sent: Tuesday, November 04, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Subject: RMAN: connecting target DB with SYS account using connect string Hi list, I have problem connecting to target DB using account SYS with connect string. But SQL*Plus works fine. For example, SQLconnect sys/[EMAIL PROTECTED] connected. but in RMAN (using same OS account and server) == RMAN connect target sys/[EMAIL PROTECTED] failed RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-04005: error from target database: ORA-01017: invalid username/password; logon denied Any help will be really appreciated. -Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan 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: 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 Error
Hi List, I am getting the following RMAN error. Any help would be really appreciated. RMAN script:- == RMAN replace script ts_system_backup { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; sql 'alter system switch logfile'; resync catalog; backup tablespace system format='al_%d%t%p'; } OUTPUT RMAN-03022: compiling command: backup RMAN-03023: executing command: backup RMAN-08008: channel c1: starting full datafile backupset RMAN-08502: set_count=7 set_stamp=508754890 creation_time=30-OCT-03 RMAN-08010: channel c1: specifying datafile(s) in backupset RMAN-08522: input datafile fno=1 name=/dev/vx/rdsk/dbdg10/System.dbf RMAN-08011: including current controlfile in backupset RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: c1 RMAN-08031: released channel: c2 RMAN-08031: released channel: c3 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03015: error occurred in stored script ts_system_backup RMAN-03007: retryable error occurred during execution of command: backup RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19502: write error on file al_HSBC5087548901, blockno 2040833 (blocksize=512) ORA-27063: skgfospo: number of bytes read/written is incorrect Additional information: 52736 Additional information: 131072 RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE RMAN Recovery Manager complete. Thanks -tamizh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: RMAN Error
Tamizh, You are probably running out of space in the file-system you were located within when you invoked RMAN. It would be better to specify a full path-name in the FORMAT= clause (i.e. specify directory as well as filename), to make sure that the file-system where you are creating the backupsets is the one you intend. Hope this helps... -Tim Hi List, I am getting the following RMAN error. Any help would be really appreciated. RMAN script:- == RMAN replace script ts_system_backup { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; sql 'alter system switch logfile'; resync catalog; backup tablespace system format='al_%d%t%p'; } OUTPUT RMAN-03022: compiling command: backup RMAN-03023: executing command: backup RMAN-08008: channel c1: starting full datafile backupset RMAN-08502: set_count=7 set_stamp=508754890 creation_time=30-OCT-03 RMAN-08010: channel c1: specifying datafile(s) in backupset RMAN-08522: input datafile fno=1 name=/dev/vx/rdsk/dbdg10/System.dbf RMAN-08011: including current controlfile in backupset RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: c1 RMAN-08031: released channel: c2 RMAN-08031: released channel: c3 RMAN-00571: == = RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: == = RMAN-03015: error occurred in stored script ts_system_backup RMAN-03007: retryable error occurred during execution of command: backup RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19502: write error on file al_HSBC5087548901, blockno 2040833 (blocksize=512) ORA-27063: skgfospo: number of bytes read/written is incorrect Additional information: 52736 Additional information: 131072 RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE RMAN Recovery Manager complete. Thanks -tamizh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: SVR4 Error: 27: File too large
Hi List, How to fix this error without changing something in OS level? Is tehre any command to set max block size in RMAn before we do backup? Thanks in advance? RMAN-08031: released channel: c1 RMAN-08031: released channel: c2 RMAN-08031: released channel: c3 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-10035: exception raised in RPC: O RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE RMAN-03015: error occurred in stored script ts_noncrm_data_backup RMAN-03007: retryable error occurred during execution of command: backup RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19504: failed to create file /u03/backup/rman/al_HSBC5087585421 ORA-27044: unable to write the header block of file SVR4 Error: 27: File too large Additional information: 3 RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE RMAN $ ulimit -sa time(seconds)unlimited file(blocks) unlimited data(kbytes) 2097148 stack(kbytes)8192 coredump(blocks) 0 nofiles(descriptors) 64 vmemory(kbytes) unlimited -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).