While I start my database with my initialization parameter it fails with oracle error
Solution :-
su oracle
run environment variable
sqlplus / as sysdba
run environment variable
sqlplus / as sysdba
SQL>create pfile from spfile;
Then remove or comment below line in pfile
db_recovery_file_dest
Save and exit
su oracle
run environment variable
sqlplus / as sysdba
run environment variable
sqlplus / as sysdba
SQL>startup mount;
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes
it should became the mount stage then open the DB as follows
SQL>alter database open;
Database altered.
0 comments:
Post a Comment