 | | | RMAN - Recovery Question | RMAN - Recovery Question 2007-04-25 - By Arno Seidel
Back
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 (See http://MAN-06025.ora-code.com): 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
|
|
|