exceed limit of datafile numbers - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: exceed limit of datafile numbers

  1. #21
    Join Date
    Sep 2000
    Posts
    31

    Unhappy

    Hi guys,
    I looked at my test instance's alert log and believe that i did make a mess on my test instance. Please look at my today test's alert message and please suggest what i should do:

    Fri Jan 26 08:36:13 2001
    Shutting down instance (immediate)
    License high water mark = 1
    Fri Jan 26 08:36:13 2001
    alter database close normal
    Fri Jan 26 08:36:13 2001
    SMON: disabling tx recovery
    SMON: disabling cache recovery
    Fri Jan 26 08:36:14 2001
    Thread 1 closed at log sequence 999
    Current log# 3 seq# 999 mem# 0: /usr2/oracle/arc/dblogrtp3.dbf
    Fri Jan 26 08:36:14 2001
    Completed: alter database close normal
    Fri Jan 26 08:36:14 2001
    alter database dismount
    Completed: alter database dismount
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    LICENSE_MAX_USERS = 0
    Starting up ORACLE RDBMS Version: 7.1.4.1.0.
    System parameters with non-default values:
    processes = 200
    shared_pool_size = 6000000
    control_files = $ORACLE_HOME/dbs/c1arc.ctl, /usr2/oracle/arc/c2arc.ctl, /usr3/oracle/arc/c3arc.ctl
    db_block_buffers = 1200
    log_archive_start = TRUE
    log_buffer = 163840
    log_checkpoint_interval = 10000
    db_files = 20
    rollback_segments = rb_1, rb_2, rb_3, rb_4, rb_5, rb_6, rb_7, rb_8
    sequence_cache_entries = 100
    sequence_cache_hash_buckets= 89
    remote_login_passwordfile= NONE
    mts_service = arc
    mts_servers = 0
    mts_max_servers = 0
    mts_max_dispatchers = 0
    audit_trail = NONE
    sort_area_retained_size = 65536
    db_name = arc
    open_cursors = 200
    ifile = $ORACLE_HOME/dbs/cfarc.ora
    background_dump_dest = $ORACLE_HOME/rdbms/log
    user_dump_dest = $ORACLE_HOME/rdbms/log
    max_dump_file_size = 10240
    core_dump_dest = $ORACLE_HOME/dbs
    PMON started
    DBWR started
    ARCH started
    LGWR started
    RECO started
    Fri Jan 26 08:47:04 2001
    alter database mount exclusive
    Fri Jan 26 08:47:04 2001
    Completed: alter database mount exclusive
    Fri Jan 26 08:47:04 2001
    alter database open
    Fri Jan 26 08:47:05 2001
    Thread 1 opened at log sequence 999
    Current log# 3 seq# 999 mem# 0: /usr2/oracle/arc/dblogrtp3.dbf
    Fri Jan 26 08:47:06 2001
    SMON: enabling cache recovery
    SMON: enabling tx recovery
    Fri Jan 26 08:47:06 2001
    Completed: alter database open
    Fri Jan 26 08:50:33 2001
    alter database backup controlfile to trace noresetlogs
    Completed: alter database backup controlfile to trace noreset...
    Fri Jan 26 08:53:40 2001
    Shutting down instance (immediate)
    License high water mark = 1
    Fri Jan 26 08:53:40 2001
    alter database close normal
    Fri Jan 26 08:53:40 2001
    SMON: disabling tx recovery
    SMON: disabling cache recovery
    Fri Jan 26 08:53:42 2001
    Thread 1 closed at log sequence 999
    Current log# 3 seq# 999 mem# 0: /usr2/oracle/arc/dblogrtp3.dbf
    Fri Jan 26 08:53:42 2001
    Completed: alter database close normal
    Fri Jan 26 08:53:42 2001
    alter database dismount
    Completed: alter database dismount
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    LICENSE_MAX_USERS = 0
    Starting up ORACLE RDBMS Version: 7.1.4.1.0.
    System parameters with non-default values:
    (info is deleted by jn1971)
    PMON started
    DBWR started
    ARCH started
    LGWR started
    RECO started
    Fri Jan 26 08:54:49 2001
    CREATE CONTROLFILE REUSE DATABASE "ARC" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 50
    MAXINSTANCES 1
    MAXLOGHISTORY 100
    LOGFILE
    GROUP 1 '/usr2/oracle/arc/dblogrtp1.dbf' SIZE 2M,
    GROUP 2 '/usr2/oracle/arc/dblogrtp2.dbf' SIZE 2M,
    GROUP 3 '/usr2/oracle/arc/dblogrtp3.dbf' SIZE 2M,
    GROUP 4 '/usr2/oracle/arc/dblogrtp4.dbf' SIZE 2M
    DATAFILE
    '/usr3/oracle/arc/dborartp.dbf' SIZE 30M,
    '/usr2/oracle/arc/rtprb01.dbf' SIZE 200M,
    '/usr3/oracle/arc/rtpdat01.dbf' SIZE 150M,
    '/usr2/oracle/arc/rtptemp01.dbf' SIZE 30M,
    '/usr3/oracle/arc/rtpidx01.dbf' SIZE 30M,
    '/usr2/oracle/arc/rtptool01.dbf' SIZE 10M,
    '/usr3/oracle/arc/prestdata1.dbf' SIZE 90M,
    '/usr2/oracle/arc/rtpuser01.dbf' SIZE 50M,
    '/usr2/oracle/arc/rtptempu01.dbf' SIZE 50M,
    '/usr3/oracle/arc/prestdata2.dbf' SIZE 90M,
    '/usr3/oracle/arc/rtpdat02.dbf' SIZE 50M,
    '/usr3/oracle/arc/rtpdat04.dbf' SIZE 100M,
    '/usr3/oracle/arc/rtpidx02.dbf' SIZE 30M,
    '/usr3/oracle/arc/rtpidx03.dbf' SIZE 60M,
    '/usr3/oracle/arc/rtpidx04.dbf' SIZE 30M,
    '/usr3/oracle/arc/rtpidx05.dbf' SIZE 100M,
    '/usr3/oracle/arc/rtpidx06.dbf' SIZE 100M,
    '/usr2/oracle/arc/rtptemp02.dbf' SIZE 50M,
    '/usr3/oracle/arc/rtpdat03.dbf' SIZE 100M,
    '/usr2/oracle/arc/rtptempu02.dbf' SIZE 50M
    Fri Jan 26 08:54:50 2001
    ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ARC" NORESETLOG...
    Fri Jan 26 08:54:50 2001
    ALTER DATABASE OPEN
    ORA-1507 signalled during: ALTER DATABASE OPEN...
    Fri Jan 26 09:01:58 2001
    Starting ORACLE instance (normal)
    Fri Jan 26 09:01:58 2001
    CREATE CONTROLFILE REUSE DATABASE "ARC" NORESETLOGS NOARCHIVELOG
    ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ARC" NORESETLOG...
    (detial is deleted by jn1971)
    Fri Jan 26 09:01:58 2001
    alter database recover DATABASE
    ORA-1507 signalled during: alter database recover DATABASE...
    Fri Jan 26 09:01:58 2001
    alter database recover cancel
    ORA-1507 signalled during: alter database recover cancel...
    Fri Jan 26 09:01:58 2001
    ALTER DATABASE OPEN
    ORA-1507 signalled during: ALTER DATABASE OPEN...

    ARC is sid of my test instance. Please help.

    Thanks,
    jn1971 :(

  2. #22
    Join Date
    Dec 2000
    Posts
    46
    Check your alert log! see what it says. We can proceed from there.

  3. #23
    Join Date
    Dec 2000
    Posts
    46
    This is what you have to do:


    . Shutdown your instance
    . Make sure that there is no background processing running for this instance
    (run ps -ef | grep -i oracle, kill if required or do a shutdown abort)
    . Its good idea to move the existing redologs to a new location
    sometimes you might need it for recovery purposes.
    . move or rename your control files (you can also use the reuse clause)
    . Verify that your create control file is something like this :

    STARTUP NOMOUNT
    CREATE CONTROLFILE REUSE DATABASE "PM1" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 30
    MAXINSTANCES 1
    MAXLOGHISTORY 226
    LOGFILE
    GROUP 1 '/oradata/pm1/vg01_01/redo_01.log' SIZE 126M,
    GROUP 2 '/oradata/pm1/vg01_01/redo_02.log' SIZE 126M,
    GROUP 3 '/oradata/pm1/vg01_01/redo_03.log' SIZE 126M
    DATAFILE
    '/oradata/pm1/vg01_01/system_01.dbf',
    '/oradata/pm1/vg01_01/rbs1_01.dbf',
    '/oradata/pm1/vg01_01/rbs2_01.dbf',
    '/oradata/pm1/vg01_01/users_01.dbf',
    '/oradata/pm1/vg01_01/tools_01.dbf',
    '/oradata/pm1/vg01_01/pm1_med01.dbf'
    ;

    I am assuming you have a script that does the above eg :makecontrol.sql
    . you may have to use resetlogs (its been a while since I did this)
    . make sure your sid is set accordingly (. oraenv)
    . start a server mamager session :
    . svrmgrl
    . connect internal
    . @makecontrol.sql
    . you can now try an alter database open command to see if the database will come up
    . if it says it needs recovery, do the recovery (recover database or
    recover database until cancel).
    . you should not have any problems bringing your database back up!.

  4. #24
    Join Date
    Sep 2000
    Posts
    31

    Talking Its fixed

    Hi guys And Gram2000,
    My instance is fine know and i did recreate the controlfiles successfully. The prolem was that I typed

    setenv oracle_sid test
    not
    setenv ORACLE_SID test

    Unix does take serious about case sensitivity.

    I could shut down the instance and follow your suggestions to create controlfiles.

    THANKS VERY MUCH ALL OF YOU OUT THERE FOR HELPING ME.

    THANKS,
    jn1971

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width