daniesh

Forum Replies Created

Viewing 2 posts - 16 through 17 (of 17 total)
  • Author
    Posts
  • in reply to: clone database using Hot backup #2036
    daniesh
    Participant

    Hi Amit,

    please find the error below.

    ORA-01194: file 1 needs more recovery to be consistent

    ORA-01110: data file 1: ‘C:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF’

    Thanks.

    in reply to: clone database using Hot backup #2035
    daniesh
    Participant

    Hi Amit,

    Thanks for the input.

    I am using hot backup.

    The steps which i am following is

    1. alter system switch logfile;(2-3 times)

    2.Taking the database in backup mode

    3.copy all the datafiles from source to target server.

    4.alter system switch logfile;(2-3 times)

    5.alter database backup controlfile to trace;

    to generate a trace of the control file

    go to the udump location and copy the last trace file

    make chages and generate the control file script

    for e.g

    copy the contents of trace file from create controifile reuse….. character set

    and made some changes like inplace of reuse i write set as i am my database name is different from the source one.

    save the file as create.sql

    on target server:

    set the sid of target db.

    then conect to database using sqlplus

    create the dir udump, bdump and cdump.

    copy the pfile from the source database to the target database and made changes accordingly like dbname , path of controlfile as i am using different location for control file.

    startup the database in nomount stage

    run the script which i generated in step 5.

    on sql prompt i got the result as file created.

    now when i try to open the database using reset log option

    alter database open resetlogs;

    now i am getting an error that system01.dbf needs recovery.

    when i execute the conmmand

    recover database using backup controlfile until cancel;

    again i am getting an error.

    the error is

    ORA-01110

    i didnt remember the error exactly.

    I have one doubt if i will not copy the online redo log then how it will get generated.

    Please help me on this.

    Thanks

    Daniesh

Viewing 2 posts - 16 through 17 (of 17 total)