DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: COPY THE INSTANCE FROM LINUX TO SUN - URGENT

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    it is 8.1.7 / ARCHIVE LOG MODE

    I need to copy one instance from LINUX machine to Sun- Solaris , now the thing is the unix file struture is different in both the machines

    like - sun has u1/u2/u3/u4/u5

    linux is having usr1/usr2/usr3/usr4/usr5

    so what i am going to do is ---

    Now the instance is in linux machine

    1 Get a copy of the control file by giving command backup
    control file to trace.
    2 issue a log switch in my linux machine.
    3 shut downn the database gracefully.
    4 take a cold backup of all the files ( datafiles , control
    files , archived redo logs )
    5 copy all the files in the SUN machine.
    6 edit the control file for changing the path /file location
    7 start the database in nomount phase
    8 run the create control file script that i have just edited.
    9 open the database with RESETLOGS OPTION.

    is there any thing i missed out.
    i am thinking of doing this in evening, so advise is needed.

    --pravin


    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cannot do that, the binaries are not compatible

  3. #3
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    even if i ftp it in a binary mode . wont it help .

    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Create a new database on the Sun workstation using the same database name and tablespace/datafile names. Create your schema owner. Do an export on the original database, and import into the new database.

    Export parfile
    userid=system/password@dbname
    full=y
    inctype=complete
    file=name_of_dump_file
    log=name_of_log_file

    Import parfile
    userid=system/password@dbname
    full=y
    commit=y
    file=name_of_export_dump_file
    log=name_of_import_log_file

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by pravin
    even if i ftp it in a binary mode . wont it help .

    nop, it´s like I take command.com and run it on unix

  6. #6
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    thanks pando and stecal for ur comments.

    But tell me if i had to do from linux to linux and the instance name is same , but the location of the files is different path , what the steps i wrote is correct or not ?

    please let me know so that i can keep this steps handy whenver i need it .

    pravin
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  7. #7
    Join Date
    Jan 2001
    Posts
    191
    RECOVER DATABASE USING BACKUP CONTROLFILE until cancel ;
    ALTER DATABASE OPEN RESETLOGS;
    if you changed you database name, then,
    alter database rename global_name to .

  8. #8
    Join Date
    Jan 2001
    Posts
    191
    alter database rename global_name to .

  9. #9
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    xyz2000 ur answer is not clear to me see my situation is that i have the database name same , and it has to be kept same. so i will have to open with
    ALTER DATABASE OPEN RESETLOGS;

    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  10. #10
    Join Date
    Jan 2001
    Posts
    191
    Yes. after recover the database with backup controlfile until cancel, then you can open database with resetlog. There is no need to rename database if you database name and domain name are not changed.

    The syntax for rename database is:

    alter database
    rename global_name
    to .

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