What happens to the file name when you restore a datafile into RAC ?
I create a new tablespace and datafile.
I then make a backup of the tablespace/datafile
I shutdown the database and remove the datafile physically
Now I startup the database and restore the datafile
Now, I recover the datafile
Now, I check the datafile name
The alert log also shows me the restored (new) file name
The trailing portion of the file name changed from "t1.303.1041178221" to "t1.303.1041179951".
(The "t1" is actually the Tablespace Name).
So, we can see that ASM actually renames the file --- it is an Oracle Managed File. Every time, you place (i.e. restore) a datafile into ASM, the file name is changed. However, the controlfile and data dictionary are also updated correctly.
I create a new tablespace and datafile.
I then make a backup of the tablespace/datafile
I shutdown the database and remove the datafile physically
Now I startup the database and restore the datafile
Now, I recover the datafile
Now, I check the datafile name
The alert log also shows me the restored (new) file name
The trailing portion of the file name changed from "t1.303.1041178221" to "t1.303.1041179951".
(The "t1" is actually the Tablespace Name).
So, we can see that ASM actually renames the file --- it is an Oracle Managed File. Every time, you place (i.e. restore) a datafile into ASM, the file name is changed. However, the controlfile and data dictionary are also updated correctly.
No comments:
Post a Comment