We planned to upgrade DB to 11.2.0.4
In test DB, we took back up and deleted few old datas which was not used. At the time of restore we created some directories manually and moved the files like datafiles etc.
Initially i changed the paths directly in both pfile and spfile in VI editor mode.
When i tried to open a Db, i got the Ora error 01110 and Ora 01157 and not able to startup.
As per the info from google, i opened in mount state and gave following command.
sql> alter database datafile '/home1/datafiles/users01_new.dbf' offline drop;
then, i tried to open and got below.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16038: log 2 sequence# 31383 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/oradata/VIJBLMSD/redo02.log'
After which, i have increased the db_recovery_file_dest_size,
SQL> alter system set db_recovery_file_dest_size=12G;
System altered.
SQL> alter database open;
Database altered.
Now DB is opened, but when i give v$datafile,
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oradata/VIJBLMSD/system01.dbf
/oradata/VIJBLMSD/undotbs01.dbf
/oradata/VIJBLMSD/sysaux01.dbf
/home1/datafiles/users01_new.dbf
/oradata/VIJBLMSD/users_02.dbf
/oradata/VIJBLMSD/users_03.dbf
/oradata/VIJBLMSD/users_04.dbf
users01_new.dbf showing the old path.. How system is reading this old path and how to change it correctly.
I don know whether i followed the correct steps, Please advise on this.?
Regards,
Sanjay G