Ronny Egner schrieb:
> Arno Seidel schrieb:
>> Maxim Tkachenko schrieb:
>>>
>>>> recover database;
>>>> rman stops after some time and says:
>>>> RMAN-06025: no backup of log thread 1 seq found to restore
>>>> several times ... these requested log sequences are older than 3
>>>> weeks and i don?t have them any more.
>>>> Why does Rman want this old logs???
>>>> And how can i recover the database without these old logs?
>>>>
>>>> any help would be great.
>>>>
>>>> regards from germany
>>>>
>>>> Arno Seidel
>>>>
>>>>
>>> use "restore archivelog time " or "restore archivelog sequence XXXX".
>>> Number of sequence may give from backup.log or  use "list backup"
>>> on rman.
>>>
>>>
>> list backup only shows the highest missing archived_log sequwnce and
>> these backupsets are marked as
>> expired (they are over 3 weeks old and happend before 3 full backups
>> of the database).
>>
>> There must be a way to tell rman to skip these verry old archived_logs.
>> crosscheck backup
>> and delete expired backup does not change the behavior of the recover
>> command ...
>
> I??m sorry but this behavior is completely anormal. I??ve never
> seen that before.
> Could you show the complete script please and the complete output?
>
>


This is the script for the backup. from monday til friday it runs
(rman.sh day) and on saturday
it runs (rman.sh week)

#!/bin/bash

DATE=`date '+%Y-%m-%d'`
export ORACLE_HOME=/opt/oracle/product/R2
export NLS_LANG=German_Germany.utf8
RMAN_BIN="/opt/oracle/product/R2/bin/rman"

DBUSR="XXXX"
DBPWD="XXXXXX"
DBSID="LNCL"

function DAY {
$RMAN_BIN TARGET $DBUSR/$DBPWD@(protected)
backup as compressed backupset incremental level = 1 database plus
archivelog delete input tag ='INCREMENTAL-$DATE';
EOF
}

function WEEK {
$RMAN_BIN TARGET $DBUSR/$DBPWD@(protected)
backup as compressed backupset incremental level = 0 database noexclude
plus archivelog delete input tag ='Full-$DATE';
EOF
}

function CONFIGURE {
#mkdir /opt/rmanbackup
#chown oracle:oinstall /opt/rmanbackup
$RMAN_BIN TARGET $DBUSR/$DBPWD@(protected)
configure channel device type disk format
'/opt/rmanbackup/rman_%t_%s_%p.dbf';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/opt/rmanbackup/%F';
EOF
}

function CLEAN {
$RMAN_BIN TARGET $DBUSR/$DBPWD@(protected)
report obsolete;
delete noprompt obsolete;
EOF
}

function MOVE {
      mount /opt/EXT_rmanbackup
      mv /opt/rmanbackup/* /opt/EXT_rmanbackup/
      umount /opt/EXT_rmanbackup
      }

case "$1" in
      day)
           DAY
           MOVE
      ;;

      week)
           WEEK
           MOVE
      ;;
      configure)
           CONFIGURE
      ;;
      *)
           echo "USAGE $0 week / day"
      ;;
esac

To recover i did following steps:
1. setup a new server (SLES 9)
2. installed the same Oracle Release 10g R2
3. copied the rman backupfiles to the same desitination on the new host
4. startet rman target / nocatalog
and issued following commands:

SET DBID 2353143907
STARTUP FORCE NOMOUNT PFILE='/opt/oracle/product/R2/dbs/initLNCL.ora';
run {
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/opt/rmanbackup/%F';
restore controlfile from autobackup maxdays 2;
}
shutdown immediate;
startup mount;
restore database;

every thing runs fine, and this is the output:


executing command: SET CONTROLFILE AUTOBACKUP FORMAT

Starting restore at 26-APR-07
using channel ORA_DISK_1

channel ORA_DISK_1: looking for autobackup on day: 20070426
channel ORA_DISK_1: looking for autobackup on day: 20070425
channel ORA_DISK_1: autobackup found:
/opt/rmanbackup/c-2353143907-20070425-00
channel ORA_DISK_1: control file restore from autobackup complete
output filename=/opt/oracle/oradata/LNCL/control01.ctl
output filename=/opt/oracle/oradata/LNCL/control02.ctl
output filename=/opt/oracle/oradata/LNCL/control03.ctl
Finished restore at 26-APR-07
RMAN> SPOOL LOG TO '/tmp/backup.log'
RMAN> restore database;
RMAN>recover database;
RMAN>list backup;

and look at attached backup.log

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting