In the process of refreshing a 9i Dev database I had to change the file locations of a few datafiles and the logfiles. Though the usage of DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT would have made the job simpler but i just did not feel like using them. So, the controlfile was re-created, recovery was invoked and thats when the issues started showing up one by one - detailed below.
*SQL> startup nomount ORACLE instance started. Total System Global Area 395387088 bytes Fixed Size 454864 bytes Variable Size 285212672 bytes Database Buffers 109051904 bytes Redo Buffers 667648 bytes SQL> @C:\Oracle\admin\devel\scripts\crea_ctrl_20_oct_2010.sql Control file created.* *___________________________________________________________________* * more such articles on oracleandunix.blogspot.com ______________________________________ Get 3 GBs of online storage where you can dump all your files which can appear both Public / Private to others and you can access them anywhere online. Even uploading the files is easier, does not take much time - you can upload files whilst you are working online on something else. Follow the link pasted below. https://www.dropbox.com/referrals/NTQ5NDA0Mjk* -- You received this message because you are subscribed to the Google Groups "GTA DBA" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/gtadba?hl=en.
