On Sunday, I was just sit to setup Oracle at Disaster Recovery Site. I was having exported file that I had to import at another site. When I took control on another side Database Machine, I found that Enterprise Manager is working. Database was not in archive log mode. So, the challenges were to setup Enterprise Manager and making database in archive log mode. Another challenge was that the location set for archive at the time of installation was different from the actual. First I tried to make database in archive mode and got success. I changed the archive log destination. But by mistake I missed one letter in path. So When I started database after shut down, I got an error that "Unable to start database because of not translation of Archive log destination". So, I started database using Pfile (Startup pfile=). Thereafter I created again SPFILE using pfile. But here again I did mistake. I used double quote ("") instead of single quote (''). Due to this it was giving an error that "Identifier is too long". Here I got success and I started database using spfile.
After creating the spfile
SQL>Shut Immediate
SQL>Startup
SQL>Alter Database Archivelog;
SQL>Alter Database Open;
At this stage I was having exported data from database that was having character set WE8ISO8859P1 but the database where it was ported was in UTF character set mode. It was giving error for some columns "Value larger actual size : x , column size : y".
After creating the spfile
SQL>Shut Immediate
SQL>Startup
SQL>Alter Database Archivelog;
SQL>Alter Database Open;
At this stage I was having exported data from database that was having character set WE8ISO8859P1 but the database where it was ported was in UTF character set mode. It was giving error for some columns "Value larger actual size : x , column size : y".
Comments
Post a Comment