Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

[suse-oracle] RMAN - Recovery Question

Arno Seidel

2007-04-25

Replies:

Hi there,

i hope someone out there can help me out of the problem:
Following situation:
Oracle Backups with rman
and these settings:
RMAN without recovery catalog
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';

from monday till friday with following command:
backup as compressed backupset incremental level = 1 database plus
archivelog delete input tag ='INCREMENTAL-$DATE';
on saturday i ran this command:
backup as compressed backupset incremental level = 0 database noexclude
plus archivelog delete input tag ='Full-$DATE';

my problem now is, that when i try to restore and recover the wohle
database (after a complete loss of controllfiles / datafiles /
archived_logs)
what i have is the full backup from saturday and the incremental ones
till today
i would issue following commands:
rman target / nocatalog
SET DBID 2356179800
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 1;}

shutdown immediate;
startup mount;
restore database;

till now every thing is ok ... but if i do the "final" step
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


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

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.