DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Cloning

  1. #1
    Join Date
    Dec 2000
    Posts
    75
    We are running on Oracle 8i on HP. The source database has 4 datafiles that have the same names after someone had made changes to it. Then I am trying to clone this database to a new one by making sure these files are in separate directories. I then used a script to clone the new database as follows:

    STARTUP NOMOUNT
    CREATE CONTROLFILE SET DATABASE "PSDEV8" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 8
    MAXLOGMEMBERS 4
    MAXDATAFILES 1021
    MAXINSTANCES 1
    MAXLOGHISTORY 680
    LOGFILE
    GROUP 1 (
    '/u06/oradata/PSDEV8/log01.dbf',
    '/u06/oradata/PSDEV8/log01_b.dbf'
    ) SIZE 70M,
    GROUP 2 '/u06/oradata/PSDEV8/log02.dbf' SIZE 70M,
    GROUP 3 '/u06/oradata/PSDEV8/log03.dbf' SIZE 70M
    DATAFILE
    '/u06/oradata/PSDEV8/amapp.dbf',
    '/u06/oradata/PSDEV8/bdapp.dbf',
    '/u06/oradata/PSDEV8/bnapp.dbf',
    ..
    ..
    CHARACTER SET WE8ISO8859P15
    ;
    # Recovery is required if any of the datafiles are restored backups,
    # or if the last shutdown was not normal or immediate.
    #RECOVER DATABASE
    # Database can now be opened normally.
    ALTER DATABASE OPEN RESETLOGS;
    # No tempfile entries found to add.

    --------------------------------------------------------------


    I got the following error messages after alter database open resetlogs;
    ORACLE instance started.
    Total System Global Area 209243156 bytes
    Fixed Size 76820 bytes
    Variable Size 126189568 bytes
    Database Buffers 81920000 bytes
    Redo Buffers 1056768 bytes
    Statement processed.
    ALTER DATABASE OPEN RESETLOGS
    *
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: '/u06/oradata/PSDEV8/system01.dbf'
    SVRMGR> select name from v$datafile;
    NAME
    ---------------------------------------------------------------------------

    I looked like Oracle got confused because of duplicated filenames or last shutdown wasn't clean?? Is there a quick way of fixing this?
    goodhealth

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You're getting this error because you don't have a consistent set of datafiles. I am guessing that the database was not shutdown in NORMAL or IMMEDIATE mode.
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Posts
    20

    Talking

    i feel that the last shutdown may not be a clean shutdown. What you can do is

    1. Issue Revover database command first and then Alter database open resetlogs.

    ...thomas
    Thomas

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