Multiple backup-restore using cold backup
Hello,
I'm a beginner with RMAN backup-restore utility, and have a question about something I have done and seems working, but does not seem very clean.
Here is the situation:
I have a test database (11.1.0.7.0), which is not archived, and a developer is making data transformation on it regularly.
So my job here is to take a cold backup and restore it whenever it fails.
I have made a full backup in mount mode including controlfile:
RMAN> run{
allocate channel ch1 device type disk ;
backup database noexclude include current controlfile
format '/oracle/backup/DB_TMP_%t_%s_%p';
}2> 3> 4> 5>
allocated channel: ch1