Re: Rman 9.2.0.6 (RMAN-06026: some targets not found

From: Jerome Vitalis <vitalismanN0SP4M_at_gmail.com>
Date: Wed, 15 Aug 2007 13:27:42 +0200
Message-ID: <46c2e326$0$1378$79c14f64@nan-newsreader-07.noos.net>

paul wrote:
> "Jerome Vitalis" <vitalismanN0SP4M_at_gmail.com.invalid> a écrit dans le
> message de news: 46c1afae$0$8449$79c14f64_at_nan-newsreader-05.noos.net...

>> paul wrote:
>>> Hello,
>>> I have a question concerning rman on oracle 9.2.0.6
>>> I've made a backup of archivelog with this command
>>>
>>> backup  format 'f:\test_archivelog_d1008_h0955.bck' (archivelog all

> delete

>>> input) ;
>>>
>>> it worked ok
>>>
>>> now i want to extract archive log files contained in the file
>>> 'f:\test_archivelog_d1008_h0955.bck' but i don't konw how to do it

> because

>>> RMan says :
>>> "RMAN-06026: some targets not found - aborting restore."
>>>
>>> How can i do it  ?
>>>
>>>
>>> I entered the following commands :
>>>
>>> rman nocatalog
>>> RMAN>connect target .../...
>>> RMAN>list backupset ;
>>>
>>> BS Key  Size
>>> ------- ----------
>>> 14      228M
>>>
>>>   List of Archived Logs in backup set 14
>>>   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
>>>   ---- ------- ---------- --------- ---------- ---------
>>>   1    18      8134863    07-AUG-07 8480171    08-AUG-07
>>>   1    19      8480171    08-AUG-07 8821850    10-AUG-07
>>>   1    20      8821850    10-AUG-07 8926186    10-AUG-07
>>>   1    21      8926186    10-AUG-07 8926189    10-AUG-07
>>>
>>>   Backup Set Copy #1 of backup set 14
>>>   Device Type Elapsed Time Completion Time Tag
>>>   ----------- ------------ --------------- ---
>>>   DISK        00:00:12     10-AUG-07       TAG20070810T095621
>>>
>>>     List of Backup Pieces for backup set 14 Copy #1
>>>     BP Key  Pc# Status      Piece Name
>>>     ------- --- ----------- ----------
>>>     14      1   AVAILABLE   F:\TEST_ARCHIVELOG_D1008_H0955.BCK
>>>
>>> RMAN> restore archivelog all ;
>>>
>>> Starting restore at 14-AUG-07
>>>
>>> using channel ORA_DISK_1
>>> RMAN-00571: ===========================================================
>>> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>>> RMAN-00571: ===========================================================
>>> RMAN-03002: failure of restore command at 08/14/2007 11:55:10
>>> RMAN-06026: some targets not found - aborting restore
>>> RMAN-06025: no backup of log thread 1 seq 3 scn 9660177 found to restore
>>> RMAN-06025: no backup of log thread 1 seq 2 scn 9291312 found to restore
>>> RMAN-06025: no backup of log thread 1 seq 1 scn 8926992 found to restore
>>>
>> When you specify "backup archivelog all", RMAN backs up all archivelogs
>> on disks.
>> When you specify "restore archivelog all", RMAN tries to restore all
>> archivelogs that are known in its repository (the control file in your
>> case). So here it is trying to restore archived logs that you hadn't
>> backed up.
>>
>> You'll have to replace "all" with an option that will only try to
>> restore the logs you backed up. See options from, high, like, low, scn,
>> sequence, time, until in the doco.

>
>
> ok i tried this way
> RMAN > restore archivelog from SCN 8134863
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of restore command at 08/14/2007 11:55:10
> RMAN-06026: some targets not found - aborting restore
> RMAN-06025: no backup of log thread 1 seq 3 scn 9660177 found to restore
> RMAN-06025: no backup of log thread 1 seq 2 scn 9291312 found to restore
> RMAN-06025: no backup of log thread 1 seq 1 scn 8926992 found to restore
>
>
> But it's the same error, one thing i discovered is that the database was
> opened with resetlogs after the backup of archived logs so i think it messed
> up rman
> because i issued a new backup of archived logs and can extract them with the
> above command.
>
> I think i need to restart with an old control file but the backup of control
> file was made before the backup of archived logs so i'm stuck.
>
>

Yes it seems you're in a situation where a catalog is needed (that's why after a resetlogs you can't rely on previous backups anymore.)

But I guess you may still have a workaround here: create a CATALOG, connect to it and to your database with rman. After registering your database, the control file repository will be copied to the catalog. Then issue a "reset database to incarnation xxx;" (the previous incarnation) and you might be able to restore those old archived logs.

However I'm not 100% sure the backup entries for the old incarnation will be copied this way... Give it a try. Received on Wed Aug 15 2007 - 06:27:42 CDT

Re: Rman 9.2.0.6 (RMAN-06026: some targets not found - aborting restore)