rman point and time failing

From: anon <aanon_1_at_hotmail.com>
Date: 18 Dec 2001 07:48:05 -0800
Message-ID: <783a1476.0112180748.2aa625b@posting.google.com>

I've been testing Rman and it's features and have run into a issue that for some reason I cannot get around.

Here's the scenario:

1. I have a recovery catalog
2. At 14:45 I issued the following level 0 incremental backup via

create script tst_inc_0
{

allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;

backup incremental level 0
format '/u09/backups/rman/tst01/%d_%U.inc_level_0' database ;

release channel c1;
release channel c2;
release channel c3;

}

3) At 14:47 I created a table added some rows 4) At 14:50 I created a level 2 via

create script tst_inc_2
{

allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;

backup incremental level 2
format '/u09/backups/rman/tst01/%d_%U.inc_level_2' database ;

release channel c1;
release channel c2;
release channel c3;

}

5) I then shutdown the instance to be recovered and deleted ALL files for the instance

6) I the issued

run {

allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;

restore controlfile;
restore database;
sql "alter database mount";
recover database;
sql "alter database open resetlogs";
}

7) Things seem to work fine until I get

RMAN-08024: channel c1: restore complete

RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery

RMAN-03022: compiling command: recover(4)
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

---

RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03002: failure during compilation of command

RMAN-03013: command type: recover(4)
RMAN-06054: media recovery requesting unknown log: thread 1 scn 1294128030

8) I try and open the database and get

SVRMGR> connect internal
Connected.
SVRMGR> alter database open resetlogs

     2> /
alter database open resetlogs
*
ORA-01152: file 2 was not restored from a sufficiently old backup ORA-01110: data file 2: '/u01/oradata/tst01/tools01.dbf'

Am I doing something wrong here?? Is the backup missing a thread/log?  Any help would be greatly appreciated.

BTW - how do you get around the ORA-01152: ORA-01110: ?

TIA, JB Received on Tue Dec 18 2001 - 09:48:05 CST