Thursday, March 28, 2013

Deleting Guaranteed Flashback restoepoints when v$restore_point view showing error

If you delete the flashback logs unexpectedly with out dropping Guaranteed Flashback Restore Points in Database, you will get following Error while select restore points from v$restore_point view.

SQL> select * from v$restore_point;
select * from v$restore_point
              *
ERROR at line 1:
ORA-38701: Flashback database log 142 seq 326 thread 1:
"C:\APP\ORACLE\FLASH_RECOVERY_AREA\ECPIX\FLASHBACK\O1_MF_8O59SSWM_.FLB"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Solution:

If we don't know restore points names, we can get the Restore points through RMAN Commands as mentioned below.

RMAN> list restore point all;
SCN              RSP Time  Type       Time      Name
---------------- --------- ---------- --------- ----
34541743                   GUARANTEED 28-MAR-13 BEFORE_CHANGES

Connect to sql prompt and drop the restore points.

SQL>drop restore point BEFORE_CHANGES;
SQL>select * from v$restore_point;


Note: After recieving this error if you turn off the flashback of the database, after that you can't turn on the flashback. To turn on the Flashback of database we have to drop the old restore points using above steps.



 

Thursday, March 21, 2013

ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option

Hi All,

To day I have faced the problem with  ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option errors while opening the database which is created newly.
There may be 3 possibilites to get above errors. I have solved my problem by using 3 rd option.

1) giving wrong or old ORACLE_HOME or PATH variables while opening newly upgraded DAtabase.
Solution:
set or export ORACLE_HOME= <newly upgraded ORACLE_HOME>
set or export PATH=<newly upgraded PATH variables>

2) After upgraing the ORACLE_HOME, if you missed to run catupgrd.sql script, we will get above errors while starting the datbase.

Solution:

sqlplus / as sysdba
sql>startup upgrade
sql>@<ORACLE_HOME>/rdbms/admin/catupgrd.sql
sql>@<ORACLE_HOME>/rdbms/admin/utlrp.sql
sql>shut immediate
sql>startup

3) After creation of new database if we missed to execute catalog.sql,catproc.sql or  executed with errors also we will get above errors.

Solution:

sqlplus / as sysdba
sql>startup upgrade
sql>@<ORACLE_HOME>/rdbms/admin/catalog.sql
sql>@<ORACLE_HOME>/rdbms/admin/catproc.sql
sql>shut immediate
sql>startup