AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
You will have to add the statement “SWITCH DATAFILE ALL” after the restore statement & before the recovery statement.ĥ. If you do not know all the datafile numbers, once the controlfile is restored, you can open a sqlplus session to find out the datafile information with a query like: SELECT FILE#, NAME FROM V$DATAFILE I had a problem because I attempted to put the full path of the files including directories & sub directories like with flat files. You do not have to tell the ASM the full path. For each file number in the database, a line has to let the restore where that file number is to moving to in the new ASM diskgroup.įor the destination, you only need to select the name of the diskgroup. I wanted the database restore to write my files to a another ASM diskgroup that was named ‘NEW’. Started the database nomount using the pfile.ĭepending on your situation, you may or may not need to perform the steps above. Started RMAN & connected to the target.Ģ. Sounds simple but I was tripped up on the syntax.īefore I started the restore, I did the following:ġ. Recently, I wanted to restore my Oracle database on a different server in a different ASM diskgroup.
0 Comments
Read More
Leave a Reply. |