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