Refreshing Development database - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Refreshing Development database

  1. #11
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Since it is a standby database only, you need not worry as long as you primary is intact. If nothing works you can always rebuild the standby from primary.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  2. #12
    Join Date
    Jan 2001
    Posts
    138
    I coped over all the datafiles to the Development database. Created a control file script and when I executed the script to create the control file, it fails.

    In the alert.log, all I see is the following:

    ORA-1503 signalled during: CREATE CONTROLFILE set DATABASE "DEV" RESETLO..

    There is no other accompanying message.

    Has anyone seen this? I am stumped as to what to do next.

  3. #13
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    It's been a while since I've done this kind of thing, what with the ability to clone using RMAN these days, but you might want to check the following in the create controlfile script if your cloning from a cold backup:

    1)'CREATE CONTROLFILE REUSE DATABASE "prod" RESETLOGS' becomes 'CREATE CONTROLFILE REUSE set DATABASE "dev" RESETLOGS'

    2) All paths in the controlfile are correct for the copied database e.g. /u02/oradata/prod/system01.dbf is where the copied file resides and has that name. If the dev box has the same filesystems as the standby box then this should not be a problem

    3)The CREATE CONTROLFILE command will be preceded by a series of comments and a STARTUP NOMOUNT command. These need to be stripped out of the file. In addition, after the create controlfile command, there will be a number of comments and the commands RECOVER DATABASE and ALTER DATABASE OPEN, which should also be stripped out, leaving just the create controlfile command itself.

    4) The init.ora for the copied database needs to be correct. Check the db_name is set to DEV or whatever. Check controlfiles parameter etc.

    When you're happy then you can startup nomount the database using the pfile parameter to ensure your using the init.ora file you made the changes to e.g.

    startup nomount pfile=/u01/app/oracle/admin/dev/initdev.ora

    Now run your amended create controlfile script and then

    'alter database open resetlogs'

    Hope this helps, and good luck.

    Austin

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