|Unnamed data file with standby_file_management=manual|
|Written by Martin|
|Friday, 16 May 2008 16:56|
Tried to solve the following problem the other day on my standby database:
File #7 added to control file as 'UNNAMED00007' because
I had done this before, but - couldn't remember how to do it. The same problem can occur when you are recovering your database and a data file has been added to it which was not part of your backup set.
So, here is the solution! I came close to it while looking up the Oracle SQL reference:
On the standby, use "ALTER DATABASE CREATE DATAFILE" as shown in this example:
"Unnamed data file" in this conectxt is not the fully qualified file name, only UNNAMED00007.
Done! Enable recovery again:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE [USING CURRENT LOGFILE]
If your database is on ASM, then please use the following syntax instead in step 2:
SQL> alter database create datafile 'unnamed datafile' as '+TargetDiskGroupName' size xM;
It's important to specify the size, or the command will fail. An example should clarify this:
SQL> ALTER DATABASE CREATE DATAFILE
|Last Updated on Thursday, 23 December 2010 12:08|