Oracle Error From Recovery Catalog Database Rman-20242
Contents |
log RMAN doubt If this is your first visit, be sure to check out the FAQ by rman-20242: specification does not match any archived log in the repository clicking the link above. You may have to register before
Rman-20242 Restore Archivelog
you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 17 Thread: Archive log RMAN doubt Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-24-2003,10:30 AM #1 Rohit View Profile View Forum Posts Member Join Date Aug 2002 Posts 176 Archive log RMAN doubt I have posted a previous doubt on Listing similarly when i try to backup the archive logs it tells me RMAN> run 2> { 3> allocate channel c1 type disk; 4> backup archivelog all; 5> release channel c1; 6> } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: c1 RMAN-08500: channel c1: sid=16 devtype=DISK RMAN-03022: compiling command: backup RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: c1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archivelog in the recovery catalog RMAN> There are archivelog files in the Destination. Can anyone Advice pls. Success Consists of Getting Up Just One More Time Than You've Fallen Down Be Blessed Reply With Quote 03-24-2003,02:28 PM #2 padmam View Profile View Forum Posts Join Date Mar 2000 Location Chennai.Tamilnadu.India. Post
Polls :: Message Navigator E-mail to friend RMAN-20242: specification does not match any archive log in the recovery catalog [message #334726] Thu, 17 July 2008 15:13 kumar.joy Messages: 69Registered: August 2007 Location: morrisville Member experts, archive backup was failing for following error. i checked the v$archived_log and i did not find any archive logs over there. what could be the reason. please find error stack. can any one help me where i was wrong. run { 12> allocate channel dev1 type 'SBT_TAPE'; 13> allocate channel http://www.dbasupport.com/forums/showthread.php?34901-Archive-log-RMAN-doubt dev2 type 'SBT_TAPE'; 14> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; 15> backup 16> format 'ctl_%d_%t_%s_%p' 17> tag 'archiveset_ctl' 18> current controlfile ; 19> backup 20> filesperset=30 21> setsize=6000000 22> format='arch_%d_%t_%s_%p' 23> archivelog like 23> '/opt/mis/oracle/admin/BCXSINT/arch/BCXSINT%' delete input; 24> } 25> allocated channel: dev1 channel dev1: sid=1051 devtype=SBT_TAPE channel dev1: VERITAS NetBackup for Oracle - Release 5.1 (2006040521) allocated channel: dev2 http://www.orafaq.com/forum/t/122059/ channel dev2: sid=2166 devtype=SBT_TAPE channel dev2: VERITAS NetBackup for Oracle - Release 5.1 (2006040521) sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT Starting backup at 17-JUL-08 channel dev1: starting full datafile backupset channel dev1: specifying datafile(s) in backupset including current control file in backupset channel dev1: starting piece 1 at 17-JUL-08 channel dev1: finished piece 1 at 17-JUL-08 piece handle=ctl_PLAZATRL_660270225_3_1 tag=ARCHIVESET_CTL comment=API Version 2.0,MMS Version 5.0.0.0 channel dev1: backup set complete, elapsed time: 00:00:46 Finished backup at 17-JUL-08 Starting backup at 17-JUL-08 released channel: dev1 released channel: dev2 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 07/17/2008 00:24:31 RMAN-20242: specification does not match any archive log in the recovery catalog Recovery Manager complete. 07/17/08 00:24:31: Job failed: notification sent [Mod-edit: Reformatted post] [Updated on: Thu, 17 July 2008 18:57] by ModeratorReport message to a moderator Re: RMAN-20242: specification does not match any archive log in the recovery catalog [message #334761 is a reply to message #334726] Thu, 17 July 2008 18:52 ebrian Messages: 2794Registered: Apri
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=12116 Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus https://docs.oracle.com/cd/A87860_01/doc/server.817/a76990/troubler.htm Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | oracle error Best last month | Question Most of my databases are on version 12.1 11.2 11.1 10.2 10.1 or lower Answer and see the results DBA Top 10 1 M. Cadot 35800 2 F. Diaz 34000 3 J. Schnackenberg 16400 4 B. Vroman 15450 5 A. Kavsek 15250 6 P. Wisse 14250 7 T. Boles 13500 8 M. Hidayathullah ... 10900 9 A. oracle error from Hudspith 9200 10 A. Khan 4100 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47788Total active users2117Act. users last 24h9Act. users last hour1Registered user hits last week756Registered user hits last month6432 Go up crosscheck backup Next thread: ORA-12801 ORA-01157 ORA-01110 - During index rebuild Prev thread: ORA-08106 during index rebuild Message Score Author Date This is the base which is running in no archive lo...... Gnana Sekar Apr 18, 2005, 14:55 if you have delete archive log files, you can try ...... lei liu Apr 19, 2005, 03:52 My database is in no archive log...... Gnana Sekar Apr 19, 2005, 17:35 hi i didn't get you. if your database is in no ...... ayinampudi gopalarao Apr 20, 2005, 07:02 Follow up by mail Click here Subject: crosscheck backup Author: Gnana Sekar, India Date: Apr 18, 2005, 14:55, 4206 days ago Os info: AIX 5L Oracle info: Oracle 8.1.7 Error info: RMAN> crosscheck backup; RMAN-03022: compiling command: XCHECK RMAN-03026: error recovery releasing channel resources RMAN-0057
includes the following topics: Interpreting Message Output Testing the Media Management API Monitoring RMAN Jobs Terminating an RMAN Session Troubleshooting Scenarios Interpreting Message Output Recovery Manager provides detailed error messages that can aid in troubleshooting problems. Also, the Oracle database server and third-party media vendors generate useful debugging output of their own. This section addresses the following topics: Identifying Types of Message Output Identifying Error Codes Interpreting RMAN Error Stacks Interpreting Debugging Output Identifying Types of Message Output Output that is useful for troubleshooting failed RMAN jobs is located in several different places, as explained in the following table: Type of Output Produced By Location Description RMAN messages RMAN Direct this output to: Standard output (typically the terminal) A log file specified by the log option on the command line A log file created by re-directing standard output using operators at the command line Describes actions relevant to the RMAN job as well as error messages generated by RMAN, the server, and the media vendor. RMAN trace file RMAN's debug command The file specified using the trace parameter at the command line. Contains exhaustive output on the creation and execution of PL/SQL program units. alert.log Oracle database server The directory specified in the USER_DUMP_DEST initialization parameter. Contains a chronological log of errors, init.ora settings, and administration operations. Records values for overwritten control file records (see "Monitoring the Overwriting of Control File Records"). Oracle trace file Oracle database server The directory specified in the USER_DUMP_DEST initialization parameter. Contains detailed output generated by Oracle server processes. This file is created when an ORA-600 or ORA-3113 error message occurs. sbtio.log Third-party media management software The directory specified in the USER_DUMP_DEST initialization parameter. Contains information on the functioning of the media management device. Media manager log file Third-party media management software The filenames for any media manager logs other than sbtio.log are determined by the