| Soumya |
Posted: Mar 07, 2006 07:02:24 AM |
Total Post: 65
Joined: Mar, 2006
|
| There is a question about RMAN. What is the situation if a datafile is added when online backup with RMAN is going on. Will it be backed up or do not get backed up? If not backed up how will you recover the same with that backup set? |
|
|
Gitesh |
| Posted: Mar 19, 2008 12:24:15 AM | |
|
Total Post: 482
Joined: May, 2005
|
NO. RMAN doesn't take backup of added datafile. When you are going to perform recover that time you should create datafile with using alter database command as follows.
run {
allocate channel d1 type disk;
sql "alter database create datafile
''/u02/oradata/target/users_target01.dbf'' " ;
#j�W e4V:E U�R"Q`S0 recover database;
sql "alter database open";
release channel d1;
}
|
|
|
|
|
positive |
| Posted: Jun 28, 2008 02:45:18 PM | |
|
Total Post: 613
Joined: Jun, 2008
|
If you are performing a backupset backup it is not possible.In case of image copies it is possible.
|
|
|
|
|
positive |
| Posted: Jun 16, 2009 01:59:41 PM | |
|
Total Post: 613
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |