RMAN: nocatalog; remove backed up archived redos
Ramon, Thanks for the reply. I guess I've tried the delete part as well. Here's another attempt at it: - List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- -- 70 70 442774915 0 442774914 70 10-OCT-01 List of Backup Pieces Key Pc# Cp# Status Completion TimePiece Name --- --- --- --- -- 70 1 1 AVAILABLE 10-OCT-01 /data3/rman_bk/HOTP_70_1_442774914 List of Archived Logs Included Thrd Seq Low SCNNext SCN Low TimeNext Time --- -- -- --- --- 1805 165149 165150 08-OCT-01 08-OCT-01 RMAN allocate channel for delete type disk; RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: delete RMAN-08500: channel delete: sid=15 devtype=DISK RMAN change datafilecopy 2 '/data3/rman_bk/HOTP_70_1_442774914' delete; RMAN-03022: compiling command: change RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: change RMAN-06003: ORACLE error from target database: RMAN-20230: datafile copy not found in the recovery catalog RMAN-06015: error while looking up datafilecopy name: /data3/rman_bk/HOTP_70_1_442774914 --- Not found in recovery catalog! I'm not using a catalog. And the file is an archived redo log, not a datafile. All you rman experts, what do we do now? Ta, Leng. = Date: Wed, 24 Oct 2001 09:48:08 -0500 Subject: RE: RMAN: nocatalog; remove backed up archived redos Leng, If you dont use a catalog with rman you wouldn't be able to store scripts to make automated backups and restore. Also that means that all the information about your backups will be stored in the control file of the target database, if you loose your controlfiles will loose all the information of your backups, so they will be useless. Allocate channel for delete type disk; change datafilecopy 'yourfile' delete; release channel; This would work for you Luck (Suerte) Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Leng Kaing Enviado el: Tuesday, 23 October, 2001 6:10 PM Para: Multiple recipients of list ORACLE-L Asunto: RMAN: nocatalog; remove backed up archived redos Hello everyone, Env: 8i and 8.0 I've been digging around the rman manuals and metalink but can't seem to find anything decent on this so thought I'd try this forum... Firstly, what functionality do you loose when you don't use a catalog? 2ndly, how does one delete old backups? I'm backing up to disk. All is fine with the backup. But now I need to delete the backups from disk, and remove the information about the backup from the controlfile. Tried doing this but failed: -- RMAN allocate channel for delete type disk; RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: delete_05 RMAN-08500: channel delete_05: sid=15 devtype=DISK RMAN change backuppiece 70 delete; RMAN-03022: compiling command: change RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: change RMAN-06091: no channel allocated for maintenance (of an appropriate type) --- What's wrong here? I've allocated a channel and RMAN acknowledges that it's for delete. But can't do it. Help!! Thanks, Leng. = Leng Kaing - [EMAIL PROTECTED] Ph: +61-3-417-371-348 AUSOUG-VIC : http://www.ausoug.org/vic/ http://briefcase.yahoo.com.au - Yahoo! Briefcase - Manage your files online. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Leng=20Kaing?= 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
RMAN: nocatalog; remove backed up archived redos
Hello everyone, Env: 8i and 8.0 I've been digging around the rman manuals and metalink but can't seem to find anything decent on this so thought I'd try this forum... Firstly, what functionality do you loose when you don't use a catalog? 2ndly, how does one delete old backups? I'm backing up to disk. All is fine with the backup. But now I need to delete the backups from disk, and remove the information about the backup from the controlfile. Tried doing this but failed: -- RMAN allocate channel for delete type disk; RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: delete_05 RMAN-08500: channel delete_05: sid=15 devtype=DISK RMAN change backuppiece 70 delete; RMAN-03022: compiling command: change RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: change RMAN-06091: no channel allocated for maintenance (of an appropriate type) --- What's wrong here? I've allocated a channel and RMAN acknowledges that it's for delete. But can't do it. Help!! Thanks, Leng. = Leng Kaing - [EMAIL PROTECTED] Ph: +61-3-417-371-348 AUSOUG-VIC : http://www.ausoug.org/vic/ http://briefcase.yahoo.com.au - Yahoo! Briefcase - Manage your files online. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Leng=20Kaing?= 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).
URGENT: Hot Standby Graceful failover and failback
Good morning everyone, HELP! HELP!!! It's very early in the morning and I'm still struggling with the Oracle Hot Standby - 8.0.5 and 8I. ARGH! Ok, I got the failover going. I can activate the standby database and use it as a normal database. But when I try to turn it into a standby database again and then reactivate it again, it errors out on me. Oracle Support just tells me that I'm not supposed to use it this way. HUH? I'm not trying to put it back in standby mode so I can recover from the original primary database! I want to put it back in standby mode to similulate a total primary site loss. And always have a standby database to activate. Ok, I may be rambling on a bit here. Very tired. So here's what I've done so far: 1. create a hot standby from a primary database 2. activate the hot standby 3. shutdown the new primary and made a backup of the new primary database 4. restart the new primary, created a table and create a standby controlfile 5. shutdown the new primary 6. restore from backup created in step 3, and replaced the current control files with the standby controlfiles created from stop 4 7. mounted the database in standby mode again 8. tried to activate the new standby database but it failed with ORA-1152 and ORA-1110 complaining that the system.dbf is not restored from a sufficiently old backup. Argh! How do we have a continuous failover and failback scenario? Any help would be greatly appreciated. I've just discovered Lawrence To's article on Graceful Switch Over and Switch back as well. The following from page 11 scares me: "Graceful switchover and switchback are not possible when the production database's online redo logs are not accessible. A graceful switchover and switch back is NOT possible whenever a production database or standby database executes one of the following: - alter database open resetlogs or - alter database activate standby database (which does an implicit resetlogs operation)" HUH??? There are certainly times when we have to do a resetlogs. One of the problems our Unix boxes have at the moment is a redo log corruption so there are not choices but to resetlogs. So what does this all mean? That if we resetlogs we can't ever have continuous failover and failback? ARGH!! What am I dealing with here! I need a holiday from this crazy scenario! Ok, please let me know if you've had any success with what I'm describing here. Am I aiming for the impossible? Surely not! Thanks, Leng. = Leng Kaing - [EMAIL PROTECTED] AUSOUG-VIC : http://www.ausoug.org/vic/ _ http://movies.yahoo.com.au - Yahoo! Movies - Now showing: Dude Where's My Car, The Wedding Planner, Traffic.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Leng=20Kaing?= 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: parallel server; ops setup
Hi, I'm in digest mode, so here's reply to those OPS questions... I don't think you can set up OPS without a hardware cluster. In fact, if you don't turn on the Lock manager at the os level the Oracle installer won't even show OPS as an installation option! As for other other question re. converting a single instance db to ops... well, you'd be interested to know that to create an ops db I actually create a single instance db first, then do the following: 1. add new threads, ie. a thread per instance 2. shutdown 1st instance 3. create new init.ora for new instances 4. ensure that parallel_server=true. note this is 8i 5. startup all instances All of the above of course assumes that you have set up the hardware and installed ops as someone else has pointed out. HTH, Leng. [EMAIL PROTECTED] -- From: Muhammed Adnan Ansari Date: Tue, 27 Mar 2001 00:33:21 -0800 (PST) Subject: Parallel Server Do any body worked with Parallel server without a Hardware cluster...i mean just an evaluation of parallel server ...if yes then how??/ Adnan = Leng Kaing - [EMAIL PROTECTED] AUSOUG-VIC : http://www.ausoug.org/vic/ __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Leng=20Kaing?= 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).
