Re: what if recovery catalog is lost?
Ruth, Do you know if it's possible to make backup of recovery catalog using export/import? Regards, Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 6:08 PM I have put my recovery catalog database in archivelog mode. I do a cold backup of the database and the archivelogs each Friday. This way I won't lose it. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 4:58 AM Hi, That strange, but this has never come to my mind before. Ideally, the recovery catalog should be on other than production server (and it always was for me). And recovery catalog's database should be copied as well. Perhaps, using production database for recovery catalog. What if recovery catalog and production database crash at the same time and there is no way to recovery database with recovery catalog? I need the functionality of RMAN with recovery catalog, but I don't have separate server :( so I'm going to place it on the same server, but different database. I'm going to backup both databases symbiothically using each other as recovery catalog. If something goes wrong and server crashes with both databases, I will have backup copies but no catalog. Recovery scenarios: --1. I could create empty recovery catalog and collect all information again with CATALOG comand, but this works only when target database is open. Right? --2. Another possibility is to use RESYNC CATALOG FROM BACKUP CONTROL FILE should work fine, doesn't it? The only problem is that last structural changes are not available. --3. I'm not sure about third scenario - recovery target database without recovery catalog with backups taken while recovere catalog existed. I'm going to test this cases before set it up in production and I'd like to know about you experience in that area. Thanks in advance. Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: what if recovery catalog is lost?
Yes, it is very possible. That would work as well as a cold backup. I just wanted the archivelogs too. Regards, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 3:18 AM Ruth, Do you know if it's possible to make backup of recovery catalog using export/import? Regards, Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 6:08 PM I have put my recovery catalog database in archivelog mode. I do a cold backup of the database and the archivelogs each Friday. This way I won't lose it. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 4:58 AM Hi, That strange, but this has never come to my mind before. Ideally, the recovery catalog should be on other than production server (and it always was for me). And recovery catalog's database should be copied as well. Perhaps, using production database for recovery catalog. What if recovery catalog and production database crash at the same time and there is no way to recovery database with recovery catalog? I need the functionality of RMAN with recovery catalog, but I don't have separate server :( so I'm going to place it on the same server, but different database. I'm going to backup both databases symbiothically using each other as recovery catalog. If something goes wrong and server crashes with both databases, I will have backup copies but no catalog. Recovery scenarios: --1. I could create empty recovery catalog and collect all information again with CATALOG comand, but this works only when target database is open. Right? --2. Another possibility is to use RESYNC CATALOG FROM BACKUP CONTROL FILE should work fine, doesn't it? The only problem is that last structural changes are not available. --3. I'm not sure about third scenario - recovery target database without recovery catalog with backups taken while recovere catalog existed. I'm going to test this cases before set it up in production and I'd like to know about you experience in that area. Thanks in advance. Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: what if recovery catalog is lost?
Alexandre - Often RMAN is used only once or twice a day, so it easy to export it. The other advantage of the export is in case of a disaster recovery onto a loaner machine, it is easier to get your RMAN catalog back running. You can copy the export over to the target system so that gets written to the backup tape, along with the backups, so for disaster recovery you only need a single tape. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 29, 2002 2:18 AM To: Multiple recipients of list ORACLE-L Ruth, Do you know if it's possible to make backup of recovery catalog using export/import? Regards, Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 6:08 PM I have put my recovery catalog database in archivelog mode. I do a cold backup of the database and the archivelogs each Friday. This way I won't lose it. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 4:58 AM Hi, That strange, but this has never come to my mind before. Ideally, the recovery catalog should be on other than production server (and it always was for me). And recovery catalog's database should be copied as well. Perhaps, using production database for recovery catalog. What if recovery catalog and production database crash at the same time and there is no way to recovery database with recovery catalog? I need the functionality of RMAN with recovery catalog, but I don't have separate server :( so I'm going to place it on the same server, but different database. I'm going to backup both databases symbiothically using each other as recovery catalog. If something goes wrong and server crashes with both databases, I will have backup copies but no catalog. Recovery scenarios: --1. I could create empty recovery catalog and collect all information again with CATALOG comand, but this works only when target database is open. Right? --2. Another possibility is to use RESYNC CATALOG FROM BACKUP CONTROL FILE should work fine, doesn't it? The only problem is that last structural changes are not available. --3. I'm not sure about third scenario - recovery target database without recovery catalog with backups taken while recovere catalog existed. I'm going to test this cases before set it up in production and I'd like to know about you experience in that area. Thanks in advance. Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
RMAN: what if recovery catalog is lost?
Hi, That strange, but this has never come to my mind before. Ideally, the recovery catalog should be on other than production server (and it always was for me). And recovery catalog's database should be copied as well. Perhaps, using production database for recovery catalog. What if recovery catalog and production database crash at the same time and there is no way to recovery database with recovery catalog? I need the functionality of RMAN with recovery catalog, but I don't have separate server :( so I'm going to place it on the same server, but different database. I'm going to backup both databases symbiothically using each other as recovery catalog. If something goes wrong and server crashes with both databases, I will have backup copies but no catalog. Recovery scenarios: --1. I could create empty recovery catalog and collect all information again with CATALOG comand, but this works only when target database is open. Right? --2. Another possibility is to use RESYNC CATALOG FROM BACKUP CONTROL FILE should work fine, doesn't it? The only problem is that last structural changes are not available. --3. I'm not sure about third scenario - recovery target database without recovery catalog with backups taken while recovere catalog existed. I'm going to test this cases before set it up in production and I'd like to know about you experience in that area. Thanks in advance. Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: what if recovery catalog is lost?
I have put my recovery catalog database in archivelog mode. I do a cold backup of the database and the archivelogs each Friday. This way I won't lose it. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 4:58 AM Hi, That strange, but this has never come to my mind before. Ideally, the recovery catalog should be on other than production server (and it always was for me). And recovery catalog's database should be copied as well. Perhaps, using production database for recovery catalog. What if recovery catalog and production database crash at the same time and there is no way to recovery database with recovery catalog? I need the functionality of RMAN with recovery catalog, but I don't have separate server :( so I'm going to place it on the same server, but different database. I'm going to backup both databases symbiothically using each other as recovery catalog. If something goes wrong and server crashes with both databases, I will have backup copies but no catalog. Recovery scenarios: --1. I could create empty recovery catalog and collect all information again with CATALOG comand, but this works only when target database is open. Right? --2. Another possibility is to use RESYNC CATALOG FROM BACKUP CONTROL FILE should work fine, doesn't it? The only problem is that last structural changes are not available. --3. I'm not sure about third scenario - recovery target database without recovery catalog with backups taken while recovere catalog existed. I'm going to test this cases before set it up in production and I'd like to know about you experience in that area. Thanks in advance. Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).