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

From: paul <nomail_at_nomail.com>
Date: Tue, 14 Aug 2007 16:52:47 +0200
Message-ID: <C18A75549EB5DA11A92900805F0DA7FA02BA2684@dun-com-news02.nord.usinor.com>

"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. Received on Tue Aug 14 2007 - 09:52:47 CDT

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