Another idea would be, that i create a second instance at the database server just for this testing stuff. So when RMAN works together with the productive instance i also can backup all the tablespace. But how can RMAN identifies that?
i've found that link:
The first part "Improved Integration with Data Guard": is this possible a database that is not running in data guard mode? I think, when i want to use two instances, then i have to tell RMAN, that he has to backup only the productive instance and that should be configured about the db_unique_name parameter, right?
Thanks a lot for answers!
You can exclude some tablespaces from the database as below
CONFIGURE EXCLUDE FOR TABLESPACE example;
Then you can use normal backup script.
Hope that help,
I've just to ask again to understand it right:
In RMAN - Console i just exclude the tablespaces that should not be backed up with:
CONFIGURE EXCLUDE FOR TABLESPACE Tbs1, tbs2, tbs5;
And then RMAN knows, when he is doing a backup of the database, he will exclude that tablespaces that i've told him? Thats awesome! And easier to handle!
EDIT: I've tested this on my Oracle Test server and it works! Thanks a lot for the answers!
You also need to know how to handle the excluded Tablespaces and datafile when you attempt a RESTORE DATABASE.
You could set the datafiles OFFLINE after restoring the controlfile.
Hemant K Chitale