ora-27037
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ora-27037

  1. #1
    Join Date
    Oct 2007
    Posts
    4

    ora-27037

    hi all
    i trying to apply archive on cold database in 10g.
    scenario is this:
    i'm firing scp command on linux and copying all the archives from the hot database to cold one but after copying it whenever im
    firing command on cold
    like
    Code:
    recover database using backup controlfile
    it show an error which is mentioned earlier
    "Every morning I check Forbes 40 richest Indians
    list , if i'm not there I go to work."

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    post the full output from the screen, not little bits which you have put in

  3. #3
    Join Date
    Oct 2007
    Posts
    4
    recover database using backup controlfile;
    ORA-00279: change 3389516449866 generated at 10/19/2007 22:11:04 needed for
    thread 1
    ORA-00289: suggestion :
    /soft/oracle/oracle/product/10.2.0/pay10g/flash_recovery_area/PAY10G/archivelog/
    2007_10_25/o1_mf_1_2776_%u_.arc
    ORA-00280: change 3389516449866 for thread 1 is in sequence #2776


    Specify log: {=suggested | filename | AUTO | CANCEL}
    auto
    ORA-00308: cannot open archived log
    '/soft/oracle/oracle/product/10.2.0/pay10g/flash_recovery_area/PAY10G/archivelog
    /2007_10_25/o1_mf_1_2776_%u_.arc'
    ORA-27037: unable to obtain file status
    Linux Error: 2: No such file or directory
    Additional information: 3


    ORA-00308: cannot open archived log
    '/soft/oracle/oracle/product/10.2.0/pay10g/flash_recovery_area/PAY10G/archivelog
    /2007_10_25/o1_mf_1_2776_%u_.arc'
    ORA-27037: unable to obtain file status
    Linux Error: 2: No such file or directory
    Additional information: 3
    "Every morning I check Forbes 40 richest Indians
    list , if i'm not there I go to work."

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    are you perhaps trying to apply archivelogs of database "A" which is in archivelog mode on database "B" which is in nonarchivelog mode?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Oct 2007
    Posts
    4
    database B is just the cold database and im trying to apply the archives of A to B.
    "Every morning I check Forbes 40 richest Indians
    list , if i'm not there I go to work."

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well the files dont exist and what is a 'cold' database as far as you know it

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