Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Remove all the Control files

SQL> shutdown immediate

oracle> cd /u02/app/oracle/crms

oracle> ls

oracle> rm control01.ctl

oracle> cd /u01/app/oracle/fast_recovery_area/crms

oracle> ls

oracle> rm control02.ctl

oracle> export ORACLE_SID=crms

oracle> sqlplus / as sysdba

SQL> startup nomount

SQL> @cont.sql

SQL> alter database open;

                ORA-01589: must use RESETLOGS or NORESETLOGS options for database open.

SQL> alter database open resetlogs;

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter