Doubt in RMAN configuration

[igor.rmarinho]

Environment information:
* Oracle version: 10g
* Operating system: Win Server 2003

I am changing the RMAN settings

and changed the following settings:



up to all OK The Full backup goes to the RMAN folder and the ControlFile goes to the ControlFile folder. .. but as mute to the archivelogs go to the folder => 'e:\backup\Archives'?

[diegoleite]

Igor,

formats in your Archive backup script.
Ex:

Select all

backup archivelog all format 'e:\backup\archivelog\....'

[igor.rmarinho]

I thought I had to set up him by Rman.

Another doubt ....

I am doing two backup routines

first

0]]
Second

Select all

 
RUN { 
  ALLOCATE CHANNEL c1 DEVICE TYPE DISK; 
  
	 
  backup incremental level 1 as compressed backupset database  
  TAG 'BKP_INC_LVL_1' 
    FORMAT 'e:\backup\Rman\%d_%I_INC_LEVEL1_%s_%p_%u.rman'; 
     
  RELEASE CHANNEL c1; 
   
} 
 

The first is a full backup and the second an incremental backup.

My doubt is ....
I need to recover my full backup, since the table I need to recover is not in the incremental and then raise incremental backup ... There's another table that only has in it ...
But how do I choose which backup file will I use?

Thanks.

[diegolenhardt]

You have to catalog the files that you want to use in the restore ...

Select all

CATALOG BACKUPPIECE 

later

Select all

restore & recover until...

[igor.rmarinho]

Vlw !!
I just needed this

[igor.rmarinho]

I think I celebrated before the time hehe

I used

Select all

CATALOG BACKUPPIECE 'E:\Backup\RMAN\BKP_DB1_721400974_173.RMAN';

and I sent the restore database;
But he has not changed ... He continues to get the last backup I made that is the incremental level1

I forgot something?
[url=http://img813.imageshack.us/i/errocatalogpiece.jpg/]

[diegolenhardt]

From a list backup, then you will show all the points you return to "time", then you see where you want, and give a restore using the Until SCN clause and poem the SCN number obtained by the list backup

[igor.rmarinho]

Now he took the right backup thanks.

[igor.rmarinho]

I have not yet been able to restore the table of the full backup and the incremental lvl 1

I tried to make it another way tb did not give, someone could tell me the step by step of this process

What I tried was:
Use restore until SCN do full
I give recover database until time the time he was done
then restore until SCN do incremental and recover database until time The time of select resetlogs_time from v$database;
later alter database open resetlogs;


Thanks.