sorry for the mess, it may because my firefox format issue, let me reinput ... > *Note:130724.1 > **Note:29430.1* > > Make sure the database is mounted. > In all cases you need the name of the missing datafile. Because the > controlfile is up-to-date you can retrieve this information with the > following query: > select name from v$datafile where file#=2; > => /u02/oradata/target/users_target01.dbf > > 1. The missing datafile is the only datafile that needs recovery. > In this case you do not have to restore anything. > Archivelogs are restored automatically by RMAN as they are needed for the > recover command. > > run { > allocate channel d1 type disk; > sql "alter database create datafile > ''/u02/oradata/target/users_target01.dbf'' " ; > recover database; > sql "alter database open"; > release channel d1; > } > > > } > > > On Wed, Nov 5, 2008 at 10:04 PM, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx > > wrote: > >> >> Mark, >> >> But if you indeed have all the redo to apply, lacking the datafile is not >> "game over" regardless of what the usually infallible TK said at OOW. >> >> What was it that TK said as being "game over" ? >> >> You are right. It is not game over. >> >> Hemant >> >> At 01:54 AM Wednesday, Mark W. Farnham wrote: >> >>> If, as you wrote, you are merely recovering, there should be no problem. >>> >>> However, if you have lost your datafiles and you are actually restoring >>> and then recovering, and in particular if you lost the new datafile, you'll >>> need to recreate it and make sure it is where it is expected to be. Look up >>> the exact procedure, command, and syntax in your exact release level to >>> create an empty datafile. For example in 11gR1 look at alter database >>> create_datafile_clause. >>> >>> Take home lesson: If you add a data file, the simplest way to avoid >>> future trouble is to immediately back up the tablespace it is part of and >>> also back up the controlfile both through RMAN and to trace. (Or if you're >>> not using RMAN, in binary to a file system file and to trace.) But if you >>> indeed have all the redo to apply, lacking the datafile is not "game over" >>> regardless of what the usually infallible TK said at OOW. >>> >>> Regards, >>> >>> mwf >>> >>> >> >> Hemant K Chitale >> http://hemantoracledba.blogspot.com >> >> "A 'No' uttered from the deepest conviction is better than a 'Yes' merely >> uttered to please, or worse, to avoid trouble." >> Mohandas Gandhi Quotes : >> http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html >> >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> > > > -- > > ("'-''-/").___..--''"'-._ > '7_ 7 ) '_. ( ).'-.__.') > (_Y_.) ._ ) '._ '. ''-..-' > _.'--'_..-_/ /--'_.' ,' > (il),-'' (li),' ((!.-' > > Best regards, > Yours sincerely House > baojiejie@xxxxxxxxx > > > -- ("'-''-/").___..--''"'-._ '7_ 7 ) '_. ( ).'-.__.') (_Y_.) ._ ) '._ '. ''-..-' _.'--'_..-_/ /--'_.' ,' (il),-'' (li),' ((!.-' Best regards, Yours sincerely House baojiejie@xxxxxxxxx