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).
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: 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--
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
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).
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') and in the
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: 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).
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
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
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
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
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
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 newname for
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).
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).
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
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 -
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).
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).
Re: RMAN: SVR4 Error: 27: File too large
Have you ever considered purchasing Robert Freeman's RMAN book? If memory serves me right, it does describe MAXPIECESIZE option to configure and allocate channel commands. On 10/30/2003 10:04:32 AM, [EMAIL PROTECTED] wrote: 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: RMAN: SVR4 Error: 27: File too large
Tamizh, To set the limit on the size of the output file use set limit channel d1 kbytes=30; for a 3 gig file . Ron [EMAIL PROTECTED] 10/30/03 10:04AM 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). -- 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: RMAN: SVR4 Error: 27: File too large
It looks like you need to SET LIMIT ... for the channel allocation, if 8i, to less than 2GB. In 9i this can be set with MAXSETSIZE (not sure if SET LIMIT is still supported in 9i). Note that you cannot back up a file larger than the SET LIMIT size, so based on your ulimit command I assume that you don't have any datafiles larger the 2GB as well. Andy Rivenes [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: rman backup
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).
Re: rman backup
You can restore database and open it to the mount phase using RMAN. Then you can get into sqlplus and type something like: alter system set log_archive_dest_1=/directory/where/log/archives/reside set autorecovery on recover database auto until cancel On 10/28/2003 12:44:24 PM, AK wrote: 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 Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: rman backup
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).
RE: rman backup
As long as you have the database in archivelog mode and have a level 0 backup as your starting point then you can recover. Make sure that your level 0 includes the controlfiles. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AKSent: Tuesday, October 28, 2003 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: rman backup 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
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 (like subscribing).
Re: RMAN Incremental
Michal, Are you using partitioning, and if so, are there tablespaces you can set to read only? If so, then you only need to back up the read only tablespaces often enough that your backup software retention time doesn't cause the RO TBS's to all be aged out. This could eliminate a lot of backup time/tape. Jared On Fri, 2003-10-24 at 16:34, Michael Kline wrote: I'm working at a Data Warehouse and they are looking for backup possibilities... This is almost a TB, a baby, and it may be that RMAN with incremental could be a good solution. If say for instance there is a single tablespace of some 100 gig and they add 200,000,000 records to one of the tables and we do an incremental backup. Is the whole tablespace slated for backup? Also if this tablespace was lost, and we recover.. What happens during that process? Does RMAN basically have to filter through two complete copies of that tablespace or just once and then get changed blocks? What solutions have some doing this found to be best practice? Thanks. Michael Kline, Principal Consultant Business To Business Solutions, LLC Richmond, VA 804-744-1545 -- 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: RMAN Incremental
Michael, I hope you have the tables partitioned on some date column. You can make some of the older partitions read only and back them up only once. Another solution is to exchange the partitions with a table to convert your old partitions to tables, transporting them to a tape and keep it on the tape. If the database crashed, you will plug these TSs back to the DB and exchange the partitions with the tables created earlier. I presented a session at Oracle World this year describing a case study of a datawarehouse where I have described the backup and recovery approach. You can download it from OTN or from my website (www.proligence.com/downloads.html). Be sure to download both the paper and the presentation. HTH. Arup Nanda - Original Message - From: Michael Kline To: Multiple recipients of list ORACLE-L Sent: Friday, October 24, 2003 7:34 PM Subject: RMAN Incremental I'm working at a Data Warehouse and they are looking for backup possibilities... This is almost a TB, a baby,and it may be that RMAN with incremental could be a good solution. If say for instance there is a single tablespace of some 100 gig and they add 200,000,000 records to one of the tables and we do an incremental backup. Is the whole tablespace slated for backup? Also if this tablespace was lost, and we recover.. What happens during that process? Does RMAN basically have to filter through two completecopies of that tablespace or just once and then get changed blocks? What solutions have some doing this found to be "best practice"? Thanks. Michael Kline, Principal ConsultantBusiness To Business Solutions, LLCRichmond, VA804-744-1545
Re: RMAN Incremental
Title: Re: RMAN Incremental Michael, Another good treatment of the use of partitioning in DW to reduce backups is a paper by Jeff Maresh posted online at http://www.EvDBT.com/papers.htm, entitled Managing the Data Lifecycle. -Tim on 10/24/03 4:34 PM, Michael Kline at [EMAIL PROTECTED] wrote: I'm working at a Data Warehouse and they are looking for backup possibilities... This is almost a TB, a baby, and it may be that RMAN with incremental could be a good solution. If say for instance there is a single tablespace of some 100 gig and they add 200,000,000 records to one of the tables and we do an incremental backup. Is the whole tablespace slated for backup? Also if this tablespace was lost, and we recover.. What happens during that process? Does RMAN basically have to filter through two complete copies of that tablespace or just once and then get changed blocks? What solutions have some doing this found to be best practice? Thanks. Michael Kline, Principal Consultant Business To Business Solutions, LLC Richmond, VA 804-744-1545
Re: RMAN problem: RMAN-20242
I consider a 20242 error as an acceptable one, here is why: If i ask rman to backup archivelogs that are more than 2days old and there are none, thats not an error. That is when i see it the most, now most companies will force a log switch after a set amount of time during the day so in DR, you dont lose days worth of redo that might still be hanging in a redo log if it gets lost. joe Daiminger, Helmut wrote: Hi there! We are having problems with an Oracle backup. The compiling of the backup command fails with the error message: RMAN-20242: specification does not match any archivelog in the recovery catalog But RMAN is only supposed to backup any archived logs that are there and then insert them in the catalog... Did anybody experience anything similar? This is 8.1.7 on HP-UX with Legato Networker Thanks, Helmut -- 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: RMAN - Compressing using named piped
Title: Message Can you figure out what to name the pipe in advance? Is there a way to reliably determine what file name RMAN will create? -Original Message-From: laura pena [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 8:45 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Compressing using named piped I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space. Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? If someone has done this before, can you let me know how ? My rman backups are 71g compresed they are 12g. Thanks ahead of time. -Lizz Do you Yahoo!?The New Yahoo! Shopping - with improved product search
RE: RMAN - Compressing using named piped
I can use mknod and create a named pipe a head of time. I do this when I use the exp or imp utilites (just wondering if I can do same with RMAN): == export EXP_DIR="/oracle/export"export PIPE_DIR="/oracle/export"export PIPE_FILE="$PIPE_DIR/imp_pipe"mydump="DBAFULL_090403.DMP.gz" i=1for db in voicelog authcode_cp authcode_user crd_user crd_cp vlsuperdo echo $i rm -f ${PIPE_FILE}.$i mknod ${PIPE_FILE}.$i p echo `date` echo "Running gzip" nohup cat $EXP_DIR/$mydump | /usr/bin/gunzip -c ${PIPE_FILE}.$i echo `date` echo "Running imp" imp system/$1 FROMUSER=$db TOUSER=$db file=${PIPE_FILE}.$i log=$db.imp.log buffer=1024000 rows=y indexes=n constraints=n feedback=1000 RESUMABLE=Y grants=n commit=y ignore=y echo `date` echo "Done with imp for $i" i=`expr $i + 1`doneecho "Import for Users complete" = "Orr, Steve" [EMAIL PROTECTED] wrote: Can you figure out what to name the pipe in advance? Is there a way to reliably determine what file name RMAN will create? -Original Message-From: laura pena [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 8:45 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Compressing using named piped I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space. Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? If someone has done this before, can you let me know how ? My rman backups are 71g compresed they are 12g. Thanks ahead of time. -Lizz Do you Yahoo!?The New Yahoo! Shopping - with improved product search Do you Yahoo!? The New Yahoo! Shopping - with improved product search
RE: RMAN - Compressing using named piped
I dont think you can compress rman files while backups are running. RMAN doesnt support external compression while backups are running 'cause RMAN has to validate backups. You can compress all the files once your backup is completed. I tried that in the past but didnt work. Infect thereare sometechnical forums onmetalink about that. I have a script which I used to validate backups and gzip files after backups are completed. If you are interested I can send you offline, script is not very good but worked fine. -Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 7:45 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Compressing using named piped I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space. Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? If someone has done this before, can you let me know how ? My rman backups are 71g compresed they are 12g. Thanks ahead of time. -Lizz Do you Yahoo!?The New Yahoo! Shopping - with improved product searchDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: RMAN error while registering the target database
/dev/vx/rdsk/dbdg13/Rcatctrl.ctl Does this directory exist, does Oracle have priv's on it? Does the file already exist, and of so who owns it and what are the privs? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/25/2003 12:39 PM Hi List, Does anyone come across this issue? What should i do to resolve this? Any help would be really appreciated. TIA RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-01580: error creating control backup file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl ORA-27040: skgfrcre: create error, unable to create file SVR4 Error: 2: No such file or directory RMAN-10031: ORA-1580 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN error while registering the target database
Hi Robert, The directory does not exist. I am just trying to register the database(RMANregister database). My question is... from where did it pick up the name of the control file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl. Also i tried the same operation(register database) for different database which is running on the same box and it works fine. Thanks Sami --- Freeman Robert - IL [EMAIL PROTECTED] wrote: /dev/vx/rdsk/dbdg13/Rcatctrl.ctl Does this directory exist, does Oracle have priv's on it? Does the file already exist, and of so who owns it and what are the privs? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/25/2003 12:39 PM Hi List, Does anyone come across this issue? What should i do to resolve this? Any help would be really appreciated. TIA RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-01580: error creating control backup file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl ORA-27040: skgfrcre: create error, unable to create file SVR4 Error: 2: No such file or directory RMAN-10031: ORA-1580 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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 Problem
Make sure that your oracle service is stopped and started correctly. If you can't mount the database, it may be that your oracle service has started incorrectly and is holding locks on the files that your instance needs in order for it to mount. Then check the alert log for more information. -Original Message- Sent: Tuesday, September 23, 2003 2:50 PM To: Multiple recipients of list ORACLE-L I am trying to learn RMAN using the Oracle Backup Recovery 101 book. I keep running into the error below. ORA-01102 cannot mount database in EXCLUSIVE mode This is on an NT server. I can't see that the database is already up. Never had this problem before. Any ideas? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: RMAN in NOCATALOG mode?
Denham Whether you need to back up the control file depends on whether you can recover the database without it. On Oracle8i, I gave up trying to extract the controlfile from the RMAN backup, and simply back the controlfile up after the backup completes. Others on this list have reported they were able to extract the controlfile from the RMAN backup. I believe that on Oracle9i this is much improved. The important thing is that you validate your backup regularly because an untested backup can't be trusted. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 9:40 AM To: Multiple recipients of list ORACLE-L Hello Wondering about this. If backing up the database with RMAN in NOCATALOG mode. When would be the best time to do backup of the controlfile? Before backup / after backup /before and after backup. Does this aid your recovery from a crash? What advantage would it have? Many Thanks Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva 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 in NOCATALOG mode?
It's so much easier to include an sql alter database backup controlfile to filename; in the rman script. Backup the Database first. Then backup the archive logs. Then backup the controlfile. Hemant At 06:54 AM 18-09-03 -0800, you wrote: Denham Whether you need to back up the control file depends on whether you can recover the database without it. On Oracle8i, I gave up trying to extract the controlfile from the RMAN backup, and simply back the controlfile up after the backup completes. Others on this list have reported they were able to extract the controlfile from the RMAN backup. I believe that on Oracle9i this is much improved. The important thing is that you validate your backup regularly because an untested backup can't be trusted. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 9:40 AM To: Multiple recipients of list ORACLE-L Hello Wondering about this. If backing up the database with RMAN in NOCATALOG mode. When would be the best time to do backup of the controlfile? Before backup / after backup /before and after backup. Does this aid your recovery from a crash? What advantage would it have? Many Thanks Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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 in NOCATALOG mode?
I always backup the controlfile as a separate statement AFTER the back is done so hopefully the backup i just completed is in there :) joe Denham Eva wrote: Hello Wondering about this. If backing up the database with RMAN in NOCATALOG mode. When would be the best time to do backup of the controlfile? Before backup / after backup /before and after backup. Does this aid your recovery from a crash? What advantage would it have? Many Thanks Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- 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: RMAN in NOCATALOG mode?
Hi! Denham Whether you need to back up the control file depends on whether you can recover the database without it. On Oracle8i, I gave up trying to extract the controlfile from the RMAN backup, and simply back the controlfile up after the backup completes. Others on this list have reported they were able to extract the controlfile from the RMAN backup. I believe that on Oracle9i this is much improved. The important thing is that you validate your backup regularly because an untested backup can't be trusted. In 9i RMAN you can configure controlfile autobackup on - that way RMAN always backs up controlfile as well during any backup. You just have to note that if you configure controlfile autobackup on, then this is remembered in controlfile and during several physical database operations like adding datafile, creating/dropping tablespace, taking tablespace/datafile online a controlfile backup is also created (default location $ORACLE_HOME/dbs or database). If you don't take it into account you could have hundreds of old controlfiles lying around if your environment involves a lot of physical structure changes (transportable tablespaces, read only/read write tablespaces etc). Tanel. -- 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 in NOCATALOG mode?
me too. learned this from testing Rman back in 8.1.6. plus, you need this control file to recover from to get as late (most recent) timestamp as possible for recovery purposes. -Original Message- Sent: Thursday, September 18, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I always backup the controlfile as a separate statement AFTER the back is done so hopefully the backup i just completed is in there :) joe Denham Eva wrote: Hello Wondering about this. If backing up the database with RMAN in NOCATALOG mode. When would be the best time to do backup of the controlfile? Before backup / after backup /before and after backup. Does this aid your recovery from a crash? What advantage would it have? Many Thanks Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- 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). -- 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 in NOCATALOG mode?
No, controlfile is irrelevant as long as you got your physical structure somewhere (eg. controlfile trace) and all your redologs intact. You just recover using backup controlfile then (which means whatever controlfile you got, ignore it's checkpoint progress and other SCN information). That way you can recover to any point in time, providing that you recover all online datafiles to consistent SCN (you can't open a database recovered until SCN 1000 when one file has checkpoint SCN 1200 for example) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 8:39 PM me too. learned this from testing Rman back in 8.1.6. plus, you need this control file to recover from to get as late (most recent) timestamp as possible for recovery purposes. -Original Message- Sent: Thursday, September 18, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I always backup the controlfile as a separate statement AFTER the back is done so hopefully the backup i just completed is in there :) joe Denham Eva wrote: Hello Wondering about this. If backing up the database with RMAN in NOCATALOG mode. When would be the best time to do backup of the controlfile? Before backup / after backup /before and after backup. Does this aid your recovery from a crash? What advantage would it have? Many Thanks Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- 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). -- 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: 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 in NOCATALOG mode?
All, I also backup the control file as the last step within the backup and use the PL/SQL procedure within the documentation to restore the control file manually if needed - I think 9i has this in RMAN now. I found this was necessary if you wanted to get the last change from your backup and the recovery catalog was not available for some reason. Also meant that I didn't have the extra work of restoring our recovery catalog during Disaster Recovery. What is everyone's opinion on using the recovery catalog? I still have one configured because it records a lot more history (which I needed at one point), but is it really necessary? Cheers, Craig. At 09:39 AM 18/09/2003 -0800, Mercadante, Thomas F wrote: me too. learned this from testing Rman back in 8.1.6. plus, you need this control file to recover from to get as late (most recent) timestamp as possible for recovery purposes. -Original Message- Sent: Thursday, September 18, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I always backup the controlfile as a separate statement AFTER the back is done so hopefully the backup i just completed is in there :) joe Denham Eva wrote: Hello Wondering about this. If backing up the database with RMAN in NOCATALOG mode. When would be the best time to do backup of the controlfile? Before backup / after backup /before and after backup. Does this aid your recovery from a crash? What advantage would it have? Many Thanks Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- 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). -- 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: Craig Munday 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 - can someone help ?
It looks like you don't have your ORACLE_SID specified correctly since, if I read this correctly, the database you are trying to restore is on dick c:. Set you ORACLE_SID which will be the target and try again. HTH, Ruth p.s I do not have any databases on Windows so I am not sure how to set the SID. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Tuesday, September 16, 2003 10:35 PM To: Multiple recipients of list ORACLE-L Subject: RMAN error - can someone help ? Hi, My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ). My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ). My target destination for backup files is R:\ which resides on Host C (WinNT).This drive R:\ is common to both Host A and B. Things work fine accessing R:\ from both Host A and B. I tried a TSPITR following the doc. 180436.1. It is for 8i. Question #1: is it applicable for 9i also ? If YES, when i say (on Host A,the target), run { ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK; ALLOCATE CHANNEL c1 TYPE DISK; recover tablespace users until time TO_DATE('MAR-05-2002 11:27:00', 'MON-DD- HH:MI:SS'); } i get the error below: channel a1: starting datafile backupset restore channel a1: specifying datafile(s) to restore from backup set restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF released channel: a1 released channel: c1 RMAN-00571: == RMAN-00569: === ERROR MESSAGE STACK FOLLOWS = RMAN-00571: == RMAN-03002: failure of recover command at 09/16/2003 17:48:32 RMAN-03015: error occurred in stored script Memory Script ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF ORA-27040: skgfrcre: create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) Path not found. Question #2: db_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92); log_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata \aux92); why does RMAN try to restore SYSTEM01.DBF to D:\ORACLE\ORA92\DATABASE\ ? i have not mentioned this path anywhere in my recovery action. Question #3: though it is not restore path,why does RMAN's Memory script append ;\ in the path i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF this is where it fails. can someone explain me where the problem is ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: RE: RMAN error - can someone help ?
Ruth, Set you ORACLE_SID which will be the target and try again. c: set ORACLE_SID=AUX92 AUX92 is the name of my auxiliary instance on Host A ( target host ). c: rman target [EMAIL PROTECTED] catalog [EMAIL PROTECTED] auxiliary sys trace=c:\tspitr.log where PE92 is the target on same Host A and LAT92 is my recovery catalog on a diff. host. This is what metalink doc. 180436.1 says: rman target sys/[EMAIL PROTECTED] catalog rman/[EMAIL PROTECTED] auxiliary / trace=d:\tspitr.log It looks like you don't have your ORACLE_SID specified correctly since, if I read this correctly, the database you are trying to restore is on dick c:. my target database is in d:\oracle\ but even then where did this path come from ?? ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF those ;\ in the path look strange and wonder oracle appends that ?? any clues Ruth.just stuck up here and not able to proceed further. i tried it repeatedly. Thanx once again. Jp. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Tuesday, September 16, 2003 10:35 PM To: Multiple recipients of list ORACLE-L Subject: RMAN error - can someone help ? Hi, My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ). My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ). My target destination for backup files is R:\ which resides on Host C (WinNT).This drive R:\ is common to both Host A and B. Things work fine accessing R:\ from both Host A and B. I tried a TSPITR following the doc. 180436.1. It is for 8i. Question #1: is it applicable for 9i also ? If YES, when i say (on Host A,the target), run { ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK; ALLOCATE CHANNEL c1 TYPE DISK; recover tablespace users until time TO_DATE('MAR-05-2002 11:27:00', 'MON-DD- HH:MI:SS'); } i get the error below: channel a1: starting datafile backupset restore channel a1: specifying datafile(s) to restore from backup set restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF released channel: a1 released channel: c1 RMAN-00571: == RMAN-00569: === ERROR MESSAGE STACK FOLLOWS = RMAN-00571: == RMAN-03002: failure of recover command at 09/16/2003 17:48:32 RMAN-03015: error occurred in stored script Memory Script ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF ORA-27040: skgfrcre: create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) Path not found. Question #2: db_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92); log_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata \aux92); why does RMAN try to restore SYSTEM01.DBF to D:\ORACLE\ORA92\DATABASE\ ? i have not mentioned this path anywhere in my recovery action. Question #3: though it is not restore path,why does RMAN's Memory script append ;\ in the path i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF this is where it fails. can someone explain me where the problem is ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rman equivalent for MS-SQL server
There is no MSSQL utility that is directly equivalent to RMAN. You use Enterprise Manager or Query Analyzer to manage backups. Gudmundur - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 16, 2003 9:39 AM Subject: Rman equivalent for MS-SQL server Hi good people- Does anyone out there know of the equivalent of oracles RMAN in MS SQL server environs. Im investigating the possibility of having my SQL server dump the backups direct to a third party tape library VERITAS to be specific. Your input on this thread will be highly appreciated. CSW Simon.
RE: Rman equivalent for MS-SQL server
You can actually use Database Maintenance Plans, to mimic RMAN to a certain extent. Database Maintenance Plans is basically a wizard that generates a load of MSDB jobs that get run by the SQL*Agent. This does have some limitations though. It has no support for differential backups, doesn't support appended backups to an already existing device, you can't duplex back up files, and a number of the backup options aren't available. This is described in some detail in SQLServer for Oracle DBAs an e-book that I would highly recommend to all primarily Oracle DBAs that have to do a certain amount of SQLServer work too. http://www.chriskempster.com/ HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Gudmundur Josepsson Sent: 16 September 2003 11:19 To: Multiple recipients of list ORACLE-L There is no MSSQL utility that is directly equivalent to RMAN. You use Enterprise Manager or Query Analyzer to manage backups. Gudmundur - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 16, 2003 9:39 AM Hi good people- Does anyone out there know of the equivalent of oracles RMAN in MS SQL server environs. Im investigating the possibility of having my SQL server dump the backups direct to a third party tape library VERITAS to be specific. Your input on this thread will be highly appreciated. CSW Simon. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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 equivalent for MS-SQL server
This beast does not exist. You can use the Database Maintenance Plans in EM to manage your backups. I have found these to be flaky and prefer writing my own custom backup plans in scripts and schedule these as jobs. >From my experience on SQL Server I recommend doing a native SQL Server backup to disk, then have the third party backup software pickup those files to tape. Just my $.02 Dave -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 16, 2003 4:39 AMTo: Multiple recipients of list ORACLE-LSubject: Rman equivalent for MS-SQL server Hi good people- Does anyone out there know of the equivalent of oracles RMAN in MS SQL server environs. Im investigating the possibility of having my SQL server dump the backups direct to a third party tape library VERITAS to be specific. Your input on this thread will be highly appreciated. CSW Simon.
RE: RMAN backup and recovery scenarios
Prem - I haven't found anything significant online. Perhaps someone else (Bwill point to a resource. If you want to learn RMAN, my recommendation is to (Bget a couple of books. The advantage of a book is you end up with a (Bcomprehensive resource for reference. Myself, I need to go back and refresh (Bmyself now and then. (B - Oracle9i RMAN Backup Recovery by Robert Freeman (B - I found Oracle 101 Backup Recovery (Smith and Haisley) helpful to get (Bstarted. About half of it is RMAN. It has very simple tutorials that you can (Bfollow step-by-step to understand the basic RMAN concepts. But Robert's book (Bwasn't published when I was trying to set up RMAN. (B (BDennis Williams (BDBA, 80%OCP, 100% DBA (BLifetouch, Inc. (B[EMAIL PROTECTED] (B (B (B-Original Message- (BSent: Thursday, September 04, 2003 1:44 AM (BTo: Multiple recipients of list ORACLE-L (B (B (BHi all, (B (BIs there any doc./URL which lists out RMAN backup and recovery scenarios ? (Bdid not find one in metalink. (B (BThanks Regards, (BJp. (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing). (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: DENNIS WILLIAMS (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
RE: RMAN backup and recovery scenarios
Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 backup and recovery scenarios
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: 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 backup and recovery scenarios
Besides you may refer to Backup Recovery by Rama Velpuri (8/8i). A bit old but nevertheless good. All said and done, create a clone database and keep crashing it in all ways you can think of, and try to recover it. That should give you the confidence , letting you know how oracle handles the internals etc. Go thru Recovery principles, Case Studies by Rama Velpuri. (Add RF's book too). Try doing the same with Standby too. HTH GovindanK My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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 backup and recovery scenarios
Thanx Dennis,Robert,and Ruth. I'm going thro' Roberts's book now. as Robert said, it has a dedicated chapter for that. ...and i'm trying all the scenarios one by one . but just thought, i could some more inputs from you Gurus. thanx a lot guys. I will continue with the book. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rman disk performance
Brian I think that is about the performance we get. Maybe faster than what we get. One idea would be to Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] copy some big files using file system commands like cp and see what the performance is. My guess is that would be your theoretical upper limit. -Original Message- Sent: Thursday, August 21, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Anybady have values of how many GIGS per HOUR they can Backup and RESTORE the database using RMAN backup to disk. What kind of machine, Memory, storage? 1) I am using cheap network attached disk 2) I am getting about 40 Gigs an hour for Backup 3) I am getting about 34 Gigs an hour for Restore 4) 350 Meg of SGA on an Hp9000 Anybody find a good way to improve performance other than increasing channels? Cheers, Thanks for any help Brian Spears Sr. DBA [EMAIL PROTECTED] DC4 (614)577-2677 DC3 (614)415-1398 Limitedbrands TECHNOLOGY SERVICES -Original Message- Sent: Thursday, August 21, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Thanks Julio, But that didnt work either.. Maybe I need to reinstall both Linux and 9i. Thanks Anjan -Original Message- QuijadaReina, Julio C Sent: Wednesday, August 20, 2003 7:54 PM To: Multiple recipients of list ORACLE-L Anjan, Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm try setting the following on the user's .profile or on your user's shell startup file: LD_LIBRARY_PATH = $ORACLE_HOME/lib LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib Maybe oracle is looking for 64 bit library files! Julio -Original Message- Sent: Wednesday, August 20, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Gurus, Would appreciate any help that I can get on this... I have 9.2.0.1 on redhat 9 ... However I cannot seen to start the agent on the server... agentctl start just bails out.. no messages... This what I see in the dbsnmp.nohup /db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared libraries: libvppdc.so: cannot open shared object file: No such file or directory Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127 Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003 libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit file.. Thanks in advance... Anjan -- 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 disk performance
ok... I just hanging on here...don't let me fall... what ..what? Brian :) -Original Message- Sent: Thursday, August 21, 2003 3:40 PM To: Multiple recipients of list ORACLE-L Brian I think that is about the performance we get. Maybe faster than what we get. One idea would be to Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] copy some big files using file system commands like cp and see what the performance is. My guess is that would be your theoretical upper limit. -Original Message- Sent: Thursday, August 21, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Anybady have values of how many GIGS per HOUR they can Backup and RESTORE the database using RMAN backup to disk. What kind of machine, Memory, storage? 1) I am using cheap network attached disk 2) I am getting about 40 Gigs an hour for Backup 3) I am getting about 34 Gigs an hour for Restore 4) 350 Meg of SGA on an Hp9000 Anybody find a good way to improve performance other than increasing channels? Cheers, Thanks for any help Brian Spears Sr. DBA [EMAIL PROTECTED] DC4 (614)577-2677 DC3 (614)415-1398 Limitedbrands TECHNOLOGY SERVICES -Original Message- Sent: Thursday, August 21, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Thanks Julio, But that didnt work either.. Maybe I need to reinstall both Linux and 9i. Thanks Anjan -Original Message- QuijadaReina, Julio C Sent: Wednesday, August 20, 2003 7:54 PM To: Multiple recipients of list ORACLE-L Anjan, Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm try setting the following on the user's .profile or on your user's shell startup file: LD_LIBRARY_PATH = $ORACLE_HOME/lib LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib Maybe oracle is looking for 64 bit library files! Julio -Original Message- Sent: Wednesday, August 20, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Gurus, Would appreciate any help that I can get on this... I have 9.2.0.1 on redhat 9 ... However I cannot seen to start the agent on the server... agentctl start just bails out.. no messages... This what I see in the dbsnmp.nohup /db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared libraries: libvppdc.so: cannot open shared object file: No such file or directory Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127 Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003 libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit file.. Thanks in advance... Anjan -- 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: 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).
RE: Rman disk performance
Brian Sorry, the mail system mangled my message. It's all there, just part is below the signature. Here it is again: I think that is about the performance we get. Maybe faster than what we get. One idea would be to copy some big files using file system commands like cp and see what the performance is. My guess is that would be your theoretical upper limit. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 21, 2003 5:10 PM To: Multiple recipients of list ORACLE-L ok... I just hanging on here...don't let me fall... what ..what? Brian :) -Original Message- Sent: Thursday, August 21, 2003 3:40 PM To: Multiple recipients of list ORACLE-L Brian I think that is about the performance we get. Maybe faster than what we get. One idea would be to Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] copy some big files using file system commands like cp and see what the performance is. My guess is that would be your theoretical upper limit. -Original Message- Sent: Thursday, August 21, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Anybady have values of how many GIGS per HOUR they can Backup and RESTORE the database using RMAN backup to disk. What kind of machine, Memory, storage? 1) I am using cheap network attached disk 2) I am getting about 40 Gigs an hour for Backup 3) I am getting about 34 Gigs an hour for Restore 4) 350 Meg of SGA on an Hp9000 Anybody find a good way to improve performance other than increasing channels? Cheers, Thanks for any help Brian Spears Sr. DBA [EMAIL PROTECTED] DC4 (614)577-2677 DC3 (614)415-1398 Limitedbrands TECHNOLOGY SERVICES -Original Message- Sent: Thursday, August 21, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Thanks Julio, But that didnt work either.. Maybe I need to reinstall both Linux and 9i. Thanks Anjan -Original Message- QuijadaReina, Julio C Sent: Wednesday, August 20, 2003 7:54 PM To: Multiple recipients of list ORACLE-L Anjan, Kind of strange there is no lib32 dir under your $ORACLE_HOME. Hummm try setting the following on the user's .profile or on your user's shell startup file: LD_LIBRARY_PATH = $ORACLE_HOME/lib LD_LIBRARY_PATH_64 = $ORACLE_HOME/lib Maybe oracle is looking for 64 bit library files! Julio -Original Message- Sent: Wednesday, August 20, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Gurus, Would appreciate any help that I can get on this... I have 9.2.0.1 on redhat 9 ... However I cannot seen to start the agent on the server... agentctl start just bails out.. no messages... This what I see in the dbsnmp.nohup /db/app/oracle/product/9.2.0/bin/dbsnmp: error while loading shared libraries: libvppdc.so: cannot open shared object file: No such file or directory Agent exited at Wed Aug 20 12:33:26 CDT 2003 with return value 127 Agent thrashing. Exiting dbsnmpwd at Wed Aug 20 12:33:26 CDT 2003 libvppdc.so file exists in the location ORACLE_HOME/lib and it is a 32 bit file.. Thanks in advance... Anjan -- 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: 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). -- 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
RE: RMAN Script Question
Title: RMAN Script Question Thanks Samir, but I already tried that one too and it didn't work either. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions-Original Message-From: SARKAR, Samir [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 06, 2003 9:52 AMTo: '[EMAIL PROTECTED]'Cc: David WagonerSubject: RE: RMAN Script Question David, Change the following line in ur script : backup database plus archivelog delete input to backupincremental level = 0plus archivelog delete input Hth, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: 06 August 2003 15:09To: Multiple recipients of list ORACLE-LSubject: RMAN Script Question I believe I have an RMAN script syntax error. The following script works fine: resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 0 skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; } However, when I change the backup command to include archive logs and remove them after backup, I get an exit status of 1 in NetBackup and some RMAN errors. Here is the revised script: resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup database plus archivelog delete input skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; } Here is the RMAN error: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found "(": expecting one of: "channel, comma, delete, diskratio, filesperset, format, force, include, keep, maxsetsize, noexclude, nokeep, not, parms, pool, ;, skip, setsize, tag" RMAN-01007: at line 8 column 36 file: /usr/openv/netbackup/oracle_db/hot_database_backup_level0.rcv Anyone see the error? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions
RE: RMAN Backup piece being placed in wrong directory
Good point Tom RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/7/2003 1:29 PM Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs, it looks like you should change the following: backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; to backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format 'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak' Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Robert? Dennis? Anyone? -Original Message- Sent: Thursday, August 07, 2003 9:24 AM To: Multiple recipients of list ORACLE-L OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{ set archivelog destination to 'D:\backup\oracle\Hotbackup'; set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak'; backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; } Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=4 recid=2 stamp=500738572 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting archive log backupset channel ORA_DISK_2: specifying archive log(s) in backup set input archive log thread=1 sequence=5 recid=1 stamp=500738568 input archive log thread=1 sequence=6 recid=3 stamp=500738573 input archive log thread=1 sequence=7 recid=4 stamp=500738574 input archive log thread=1 sequence=8 recid=5 stamp=500815654 input archive log thread=1 sequence=9 recid=6 stamp=500824391 input archive log thread=1 sequence=10 recid=7 stamp=501340112 channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting archive log backupset channel ORA_DISK_3: specifying archive log(s) in backup set input archive log thread=1 sequence=11 recid=8 stamp=501343673 input archive log thread=1 sequence=12 recid=9 stamp=501343804 input archive log thread=1 sequence=13 recid=10 stamp=501347437 input archive log thread=1 sequence=14 recid=11 stamp=501347562 input archive log thread=1 sequence=15 recid=12 stamp=501407160 input archive log thread=1 sequence=16 recid=13 stamp=501407288 channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_3: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=17 recid=14 stamp=501407709 input archive log thread=1 sequence=18 recid=15 stamp=501407832 input archive log thread=1 sequence=19 recid=16 stamp=501407991 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:20 Finished backup at 07-AUG-03 Starting backup at 07-AUG-03 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBF input datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBF input datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBF input datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBF channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting full datafile backupset channel ORA_DISK_2: specifying datafile(s) in backupset input datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBF input datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBF input datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBF input datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBF channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting full datafile backupset
RE: RMAN recovery
Dennis, I have been admiring you from far. Thank you so much to reply to my email. The renamed data file has been tested and there is no corruption of any kind. The nightly physical and logical backups were successful completed with no error. However, I got an ora-19502 error when I tried to use these backups to restore/duplicate the database from a remote node. It might be asynch io problem. I am trying to set the 'fileperset to 1'. Do you have any other ideas? Thanks again, Anne -Original Message- Sent: Thursday, August 07, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Anne What version of Oracle is this? Okay, you renamed a production database file 10 days ago. Since then, has Oracle been able to use this file? Can you export the table that is stored on this file without error? Have you examined your RMAN backup log to ensure this file is specifically listed as being backed up? Is it possible that the error you are receiving has nothing to do with the production database, but is entirely due to your backup or test database? In other words, maybe the test system has a bad drive? Another possibility, awhile back on this list several people reported that they had datafiles with errors, but RMAN did not detect these errors when it was backing them up. That is why I suggest exporting the table. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 07, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Dear List, I have renamed a datafile in a production database ten days ago. I have no error to back up this database but I cannot duplicate/recover this database since. I am getting ora-19502 write error on this file. Please advise. Many thanks, -- 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: Anne Yu 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 implementation
yes dennis. this is what i am planning to do. can you please mention the glitches and the parameters that have to be changed. or some pointers from your implementaion which could be very useful. thanks a lot saiDENNIS WILLIAMS [EMAIL PROTECTED] wrote: SaiAre you planning to do a RMAN backup to disk and the disk is Netapp? Weran into a couple of hitches. If you are able to mount a tablespace on theNetapp device, you should be past the first thing we ran into. The otherissue had to do with the fact that RMAN opens many connections to disk, sowhen we tried to recover the backup, RMAN would recover some files, thenquit. Changing a Netapp configuration parameter fixed that problem.Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Sunday, August 10, 2003 2:39 PMTo: Multiple recipients of list ORACLE-Lhican someone give me pointers on pros and cons of implementing rman withnetapp filers.any pointers,white papers,case study,implementation doc will be veryhelpful.thankssai-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: RMAN recovery
Anne What version of Oracle is this? Okay, you renamed a production database file 10 days ago. Since then, has Oracle been able to use this file? Can you export the table that is stored on this file without error? Have you examined your RMAN backup log to ensure this file is specifically listed as being backed up? Is it possible that the error you are receiving has nothing to do with the production database, but is entirely due to your backup or test database? In other words, maybe the test system has a bad drive? Another possibility, awhile back on this list several people reported that they had datafiles with errors, but RMAN did not detect these errors when it was backing them up. That is why I suggest exporting the table. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 07, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Dear List, I have renamed a datafile in a production database ten days ago. I have no error to back up this database but I cannot duplicate/recover this database since. I am getting ora-19502 write error on this file. Please advise. Many thanks, -- 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 Script Question
Title: RMAN Script Question David, Change the following line in ur script : backup database plus archivelog delete input to backupincremental level = 0plus archivelog delete input Hth, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: 06 August 2003 15:09To: Multiple recipients of list ORACLE-LSubject: RMAN Script Question I believe I have an RMAN script syntax error. The following script works fine: resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 0 skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; } However, when I change the backup command to include archive logs and remove them after backup, I get an exit status of 1 in NetBackup and some RMAN errors. Here is the revised script: resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup database plus archivelog delete input skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak' (database); backup tag='control_file_backup' format 'control_%s_%t.ctl' (current controlfile) ; release channel t1; } Here is the RMAN error: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found "(": expecting one of: "channel, comma, delete, diskratio, filesperset, format, force, include, keep, maxsetsize, noexclude, nokeep, not, parms, pool, ;, skip, setsize, tag" RMAN-01007: at line 8 column 36 file: /usr/openv/netbackup/oracle_db/hot_database_backup_level0.rcv Anyone see the error? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions