| RMAN Duplicate & ORA-01152 [message #315329] |
Mon, 21 April 2008 02:27  |
milhouse23
Messages: 5
Registered: April 2008
|
Junior Member |
|
|
Hello.
Ok, I have kind of a weired problem and are really starting to loose it about it.
I tried to pull up a test environment from our production database. I wanted to use RMAN duplicate. So this is what I did:
1.) I made a full (incremental level 0) backup from my production database and copied it to the test server. My command for this in rman:
rman << EOF
connect target /;
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32;
setlimit channel d2 kbytes 2097150 maxopenfiles 32;
backup incremental level 0 database
plus archivelogs format '/u02/rman10g/backup/INC0_PROD_%s_%p_%t'
tag = 'WHOLE_INC0';
release channel d1;
release channel d2;
}
EOF
Next step is I copied the init.ora file of my instance to the test server and modified it, including db_file_name_rename and log_file_name_rename (I have not the same database name nor the same file structure). I created the directory structure.
Then I run my duplicate as follows on the test server. I figured out the sequence# from the last baackup archive from v$backup_redolog:
rman << EOF
connect target sys/passwd@prod
connect auxiliary /;
run
{
set until sequence XXX;
allocate auxiliary channel d1 type disk;
duplicate target database to 'TEST' nofilenamecheck;
}
Everythin runs fine. The restore completes, but after the recovery when rman tries to open the database with the resetlogs option I get an ORA-01152:
File system01.dbf was not restored from a sufficiently old backup.
I really have no clue, what is wrong with my concept...
Thanks a lot for your help.
Best,
milhouse
|
|
|
|
|
|
| Re: RMAN Duplicate & ORA-01152 [message #315332 is a reply to message #315330] |
Mon, 21 April 2008 02:40  |
milhouse23
Messages: 5
Registered: April 2008
|
Junior Member |
|
|
Well, this is the Oracle answer, which I already know. But I really don't get how this is possible. I make a duplicate from a freshly made incremental level0 backup? How can my restored datafile #1 be not consistent after the recovery?
Thanks,
Milhouse
|
|
|
|
| Re: RMAN Duplicate & ORA-01152 [message #315333 is a reply to message #315332] |
Mon, 21 April 2008 03:00 |
milhouse23
Messages: 5
Registered: April 2008
|
Junior Member |
|
|
To be more precise, here the complete ERROR:
channel d1: restore complete
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u00/oracle/oradata/TEST/system01.dbf'
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/21/2008 09:54:36
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 11159 scn 386442526 found to restore
|
|
|
|
|
|
| Re: RMAN Duplicate & ORA-01152 [message #315346 is a reply to message #315339] |
Mon, 21 April 2008 04:08 |
milhouse23
Messages: 5
Registered: April 2008
|
Junior Member |
|
|
Hello.
Actually that happend to me on 9i (9.2.0.4) and on 10gR2 with different production databases.
For the mentioned example I did not use a catalog, but just the controlfile. I do see the archive logs when I do a
RMAN> list copy of archivelog all;
Particulary, I find the error message disturbing, because it sounds like I am trying to restore/recover my database to a point-in-time before my last backup was taken, doesn't it?
Just to make things clear. I used v$backup_redolog directly after the backup to get the sequence# of the last backed-up archive log. When I do an duplicate with the 'until sequence' clause, it should not need any of the online redos but only the archives that ARE included in my backup-set. Or am I just completely wrong?
Thanks,
milhouse
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
