Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
SQL> startup
ORACLE instance started.

Total System Global Area 3841982464 bytes
Fixed Size                  2025392 bytes
Variable Size             788531280 bytes
Database Buffers         3036676096 bytes
Redo Buffers               14749696 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

.profile file is:

# User specific environment and startup programs    PATH=/usr/bin:/usr/sbin:/usr/X11R6/bin:/usr/openwin/bin:/u01/app/oracle/oracle/product/10.2.0/db_1/bin:$PATH

export PATH
unset USERNAME
# Oracle 10g
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_OWNER=oracle; export ORACLE_OWNER
#ORACLE_SID=test; export ORACLE_SID
ORACLE_SID=orcl; export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
CLASSSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib; export CLASSPATH

LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
umask 022

The create control file statement used to create second instance is :

CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/u01/app/oracle/oradata/orcl/redo01.log'  SIZE 50M,
  GROUP 2 '/u01/app/oracle/oradata/orcl/redo02.log'  SIZE 50M,
  GROUP 3 '/u01/app/oracle/oradata/orcl/redo03.log'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/orcl/system01.dbf',
  '/u01/app/oracle/oradata/orcl/undotbs01.dbf',
  '/u01/app/oracle/oradata/orcl/sysaux01.dbf',
  '/u01/app/oracle/oradata/orcl/users01.dbf',
  '/u01/app/oracle/oradata/orcl/example01.dbf',
  '/u01/app/oracle/oradata/orcl/nfl.dbf',
  '/u01/app/oracle/oradata/orcl/finance.dbf',
  '/u01/app/oracle/oradata/orcl/labppt.dbf',
  '/u01/app/oracle/oradata/orcl/timeoffice.dbf',
  '/u01/app/oracle/oradata/orcl/project.dbf',
  '/u01/app/oracle/oradata/orcl/production.dbf',
  '/u01/app/oracle/oradata/orcl/pf.dbf',
  '/u01/app/oracle/oradata/orcl/personnel.dbf',
  '/u01/app/oracle/oradata/orcl/ndtppt.dbf',
  '/u01/app/oracle/oradata/orcl/hospital.dbf',
  '/u01/app/oracle/oradata/orcl/payroll.dbf',
  '/u01/app/oracle/oradata/orcl/market.dbf'
CHARACTER SET WE8ISO8859P1
;
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/orcl/temp01.dbf'
     SIZE 20971520  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;

Kindly Help

share|improve this question
1  
What do you mean by "second instance"? What did you find out when searching for that error, what did you try to fix it, and why didn't it work? –  Mat Jun 25 at 7:12
    
Are you trying to create a second database running independently from an already existing database, or are you trying to create a cluster database that is serviced by two instances (all using the same files)? –  ik_zelf Jun 25 at 7:47
    
I am trying to create a cluster database that is serviced by two instances (all using the same files) –  user3773749 Jun 25 at 9:04
    
I followed the steps given on this link to create a second instance: onlineappsdba.blogspot.in/2007/10/… –  user3773749 Jun 25 at 9:11
    
The error that I got while starting up the database was:SQL> startup ORACLE instance started. Total System Global Area 3841982464 bytes Fixed Size 2025392 bytes Variable Size 788531280 bytes Database Buffers 3036676096 bytes Redo Buffers 14749696 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open –  user3773749 Jun 25 at 9:12
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.