Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rman 9.2.0.6 (RMAN-06026: some targets not found - aborting restore)

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

From: Jerome Vitalis <vitalismanN0SP4M_at_gmail.com.invalid>
Date: Tue, 14 Aug 2007 15:35:48 +0200
Message-ID: <46c1afae$0$8449$79c14f64@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. Received on Tue Aug 14 2007 - 08:35:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US