Re: rman point and time failing

it seems that something wrong with the missing redo log files. in my opinion, before doing the backup, I always issue something like switching log file. In RMAN, i also isssue a command to backup all redo log files.

in your case, you should list all the backup redo log files in RMAN. and then find a sequence number, then restore to this sequence only. If the RMAN backup not included the newly created redo log file, then your new table will be lost.

David

aanon_1_at_hotmail.com (anon) wrote in message news:<783a1476.0112180748.2aa625b_at_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 - 22:37:03 CST