Archive log RMAN doubt

Printable View

03-24-2003, 11:30 AM
Rohit

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.
03-24-2003, 03:28 PM
padmam

Solution

Hi,

There is a Solution for your Problem in the Metalink....
Please read the same...If still you have problem please log your concern.....

Even though you have are not mentioned "Like" command in Lower case as mentioned in the Metalink case...Try that way and Let Us know.

=============================================

PURPOSE
-------

The purpose of this article is to resolve RMAN-20242 when trying to backup archived log files.

SCOPE & APPLICATION
-------------------

RMAN 'archivelog like' method is very useful when trying to backup archived log
on oracle parallel server and oracle parallel failsafe where archived logs exist
on all nodes local disks.

Resolving RMAN-20242: specification does not match any archivelog in the recovery catalog
-----------------------------------------------------------------------------------------

Trying to run the following RMAN script result with RMAN-20242.

RMAN> run {
2> allocate channel c1 type disk;
3> backup
4> archivelog like 'E:\oracle\oradata\prod\archive%';
5> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=17 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: specificati
on does not match any archivelog in the recovery catalog

To resolve the above error, query v$archived_log to find out the archived log
details and note the format of the name column.

SQL> select * from v$archived_log;

RECID STAMP
---------- ----------
NAME
--------------------------------------------------------------------------------
THREAD# SEQUENCE# RESETLOGS_CHANGE# RESETLOGS FIRST_CHANGE# FIRST_TIM
---------- ---------- ----------------- --------- ------------- ---------
NEXT_CHANGE# NEXT_TIME BLOCKS BLOCK_SIZE CREA REGI STA ARC DEL COMPLETIO
------------ --------- ---------- ---------- ---- ---- --- --- --- ---------
1 419970034
E:\ORACLE\ORADATA\PROD\ARCHIVE\PRODT001S01524.ARC
1 1524 1 21-JAN-01 599954 25-JAN-01
600067 25-JAN-01 103 512 FGRD FGRD NO YES YES 25-JAN-01

Notice the name is in upper case - 'E:\ORACLE\ORADATA\PROD\ARCHIVE\PRODT001S01524.ARC'. Modify
the script and run again.

RMAN> run {
2> allocate channel c1 type disk;
3> backup
4> archivelog like 'E:\ORACLE\ORADATA\PROD\ARCHIVE\PROD%'
5> delete input;
6> release channel c1;
7> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=17 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08009: channel c1: starting archivelog backupset
RMAN-08502: set_count=36 set_stamp=420311754 creation_time=29-JAN-01
RMAN-08014: channel c1: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=1538 recid=15 stamp=420196579
RMAN-08504: input archivelog thread=1 sequence=1539 recid=16 stamp=420239024
RMAN-08504: input archivelog thread=1 sequence=1540 recid=17 stamp=420310708
RMAN-08504: input archivelog thread=1 sequence=1541 recid=18 stamp=420310800
RMAN-08504: input archivelog thread=1 sequence=1542 recid=19 stamp=420310879
RMAN-08013: channel c1: piece 1 created
RMAN-08503: piece handle=E:\ORACLE\ORA817\DATABASE\14CGQSMA_1_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:02
RMAN-08071: channel c1: deleting archivelog(s)
RMAN-08514: archivelog filename=E:\ORACLE\ORADATA\PROD\ARCHIVE\PRODT001S01538.AR
C recid=15 stamp=420196579
RMAN-08514: archivelog filename=E:\ORACLE\ORADATA\PROD\ARCHIVE\PRODT001S01539.AR
C recid=16 stamp=420239024
RMAN-08514: archivelog filename=E:\ORACLE\ORADATA\PROD\ARCHIVE\PRODT001S01540.AR
C recid=17 stamp=420310708
RMAN-08514: archivelog filename=E:\ORACLE\ORADATA\PROD\ARCHIVE\PRODT001S01541.AR
C recid=18 stamp=420310800
RMAN-08514: archivelog filename=E:\ORACLE\ORADATA\PROD\ARCHIVE\PRODT001S01542.AR
C recid=19 stamp=420310879
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1

RMAN>

==============================
Cheers

Padmam
03-24-2003, 03:30 PM
julian

Re: Archive log RMAN doubt

Quote:

Originally posted by Rohit
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.

Run first:

change archivelog all crosscheck;
03-25-2003, 03:35 AM
Rohit

Thansk You so much Julian , but that command also displays the same error.

RMAN> run
2> {
3> allocate channel c1 type disk;
4> change archivelog all crosscheck;
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=14 devtype=DISK

RMAN-03022: compiling command: change
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: change
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archivelog in the recovery catalog

RMAN>

Can you pls Advice
Thanks
03-25-2003, 06:02 AM
ggnanaraj

Re: Archive log RMAN doubt

Quote:

Originally posted by Rohit

RMAN> run
2> {
3> allocate channel c1 type disk;
4> backup archivelog all;
5> release channel c1;
6> }

Replace the above with the following ...

Code:

RMAN> run 2> { 3> allocate channel c1 type disk; 4> backup (archivelog all); 5> release channel c1; 6> }

or better still try the following code (with trivial modifications for your specific situation)

Code:

RMAN> run { 2> allocate channel d1 type disk; 3> backup 4> format '/backups/log_t%t_s%s_p%p' 5> (archivelog all); 6> release channel d1; 7> }

BTW, what is the version of oracle that you are running?

HTH.
03-25-2003, 10:44 AM
julian

Quote:

Originally posted by Rohit
Thansk You so much Julian , but that command also displays the same error.

RMAN> run
2> {
3> allocate channel c1 type disk;
4> change archivelog all crosscheck;
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=14 devtype=DISK

RMAN-03022: compiling command: change
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: change
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archivelog in the recovery catalog

RMAN>

Can you pls Advice
Thanks

The command change archivelog all crosscheck; gives you the same error right? Which version of Oracle is it?
03-25-2003, 12:54 PM
Rohit

we are using oracle 8.1.6 on windows 2000
03-25-2003, 12:57 PM
adewri

8.1.6 for both catalog as well as the database ??
03-25-2003, 02:16 PM
marist89

Assuming everything is setup correctly, I used to get this error when there was nothing to backup in the log_archive_dest. I solved this problem by forcing a log switch before I started my archivelog backup.
03-26-2003, 05:08 AM
Rohit

Yea Both Catalog and Target are 8.1.6 and there are archive logs currently in the destination which were created after the registartion of the database with the catalog.

Thanks
03-26-2003, 05:13 AM
Rohit

I would like to add one more inforamtion which i said at the start of this post , Together with the Archive Log problem there is another problem ( threadid=34900) the List command does not display any output

For Example

RMAN>

RMAN> run
2> {
3> allocate channel c1 type disk;
4> copy datafile 5 to 'D:\testtools.dbf';
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: copy
RMAN-03023: executing command: copy
RMAN-08000: channel c1: copied datafile 5
RMAN-08501: output filename=D:\TESTTOOLS.DBF recid=3 stamp=360959478
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1

RMAN> list copy of datafile 'D:\ORACLE\ORADATA\PRAVITHA\TOOLS01.DBF';

RMAN-03022: compiling command: list

RMAN>

Like this no output is Displayed when i use List command except

RMAN> list incarnation
2> ;

RMAN-03022: compiling command: list

List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
267 268 PRAVITHA 161374775 NO 1 20-JAN-03
267 488 PRAVITHA 161374775 YES 242010 24-MAR-99

RMAN>

Are there any settings to be done . Could anyone Help
Thanks
03-29-2003, 10:30 AM
Rohit

Pls could anyone guide me on this. I am not able to view the list command as well as i am not able to backup archive logs. but backup work fine

Thanks and i would appreciate any help
03-30-2003, 08:23 AM
julian

Quote:

Originally posted by Rohit
Pls could anyone guide me on this. I am not able to view the list command as well as i am not able to backup archive logs. but backup work fine

Thanks and i would appreciate any help

Hi,

Run first:

CHANGE ARCHIVELOG ALL VALIDATE;

then

RMAN> run
{
allocate channel c1 type disk format 'D:\...\al_%d_%s_%p';;
backup archivelog all;
release channel c1;
};
03-31-2003, 04:10 AM
Rohit

Thanks Julian . I tried it but it still gives me the same error. I checked the archive log destination . and also i switched a few redologs manually , but still the same error repeats.

RMAN> run
2> {
3> allocate channel c1 type disk;
4> CHANGE ARCHIVELOG ALL VALIDATE;
5> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=11 devtype=DISK

RMAN-03022: compiling command: change
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: change
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specificati
on does not match any archivelog in the recovery catalog

RMAN> LIST INCARNATION;

RMAN-03022: compiling command: list

List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
33 34 PRAVITHA 161374775 YES 262621 30-MAR-99

RMAN>

SQL> select name from v$archived_log;

NAME
--------------------------------------------------------------------------------

D:\TESA\ARC00001.001
D:\TESA\ARC00002.001
D:\TESA\ARC00003.001
D:\TESA\ARC00004.001
D:\TESA\ARC00005.001

20 rows selected.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\tesa
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL>
SQL>
SQL>

Pls do advice. I tried changing the system dates still no effect.

Thanks
03-31-2003, 06:48 AM
julian

Please, run first:

RMAN> sql 'alter system archive log current';

RMAN> change archivelog all validate;

Now backup:

RMAN> run
{
allocate channel c1 type disk;
backup archivelog like 'D:\TEST\ARC%';
release channel c1;
};
03-31-2003, 11:27 AM
Rohit

Thanks for your reply but
Sorry to frustrate you julian , i still get the same error after doing that also. i cannot give the change archivelog all validate it gives me the error

RMAN-20242: specification does not match any archivelog in the recovery catalog

When i backup either backupset or image copy it works fine and creates teh backupset and images copies perfectly but when i loginto sqlplus to catalog user and try querying rc_datafile_copy or rc_backup views ite tells me no rows are selected. i think this information is not being updated in the catalog ? Why??? i dont understand. thats why when i give the list command it does not display any output and does not show error either.

I tried to unregister the database then register it again then resync the catalog many times but the error still remains .
Pls do give me your suggestion on what could be wrong and what could be done?
Thanks
04-01-2003, 04:12 AM
julian

It's OK, I am really interested in your problem:

1. Confirm with ARCHIVE LOG LIST; that the database is in archive log mode.

2. "RMAN-20242: specification does not match any archive log in the recovery"

occurs on a target database where there are no backups or copies of archivelogs in the Recovery Manager (RMAN) catalog database. So do you have any? Generate some! This is a bug fixed in 9i. This error usually occurs when you have no archive logs, i.e. the archive destination is empty.

3. Check carefully Doc ID: 403802.999