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

Thread: 9i coldbackup done, how to restore db with output without RMAN

  1. 03-18-2007, 02:00 PM #1
    dbareflex
    dbareflex is offline Junior Member
    Join Date
    Mar 2007
    Location
    mt view
    Posts
    7

    Question 9i coldbackup done, how to restore db with output without RMAN

    I have to do a restore test to a 9i database. It was done in cold backup. I have all the files. But I have to prove the restore works. I know I probablly can just open the database. But I am fuzzy about how to show a log that I restore the database. Also , the database has NO archive logs at all. I am new to oracle. But have dba experience in many other database. Can any kind Oracle DBA friends help me to clarify this concept? Thanks.
    Reply With Quote Reply With Quote
  2. 03-18-2007, 02:53 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    cold backup with no archives? just put the files in the same place as they were originally and start it up
    Reply With Quote Reply With Quote
  3. 03-18-2007, 03:08 PM #3
    patel_dil
    patel_dil is offline Senior Member
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Jhcheng, Restore from cold backups do not need any archive log files but know that you will be setting back the status of database to a point where cold backup was taken. For real upto date database restore(which is true for almost all production database), read about hot backups and RMAN concepts and practise them.
    -- Dilip
    Reply With Quote Reply With Quote
  4. 03-18-2007, 06:01 PM #4
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    I hope when you say "cold backup" you mean an O/S backup done while the database was down.
    If this is the case both davey23uk and patel_dil comments apply.
    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.
    Reply With Quote Reply With Quote
  5. 03-18-2007, 06:51 PM #5
    dbareflex
    dbareflex is offline Junior Member
    Join Date
    Mar 2007
    Location
    mt view
    Posts
    7

    I understand but...

    I know I can simply open the database. I guess this is not a good test case just to prove our back up was good. Again, I have done rman before but this is "too" simple and made me wonder why it was asked me to do it.
    Reply With Quote Reply With Quote
  6. 03-18-2007, 06:55 PM #6
    dbareflex
    dbareflex is offline Junior Member
    Join Date
    Mar 2007
    Location
    mt view
    Posts
    7
    Well, since the database has been shutdown a month ago, we are trying to test restore from Nov. I have the cold backup from Nov. When trying to do conn...I got this:


    SQL> conn / as sysdba
    ERROR:
    ORA-12560: TNSrotocol adapter error


    I should be able to open the db but it is not able to...can anyone tell me why?
    Reply With Quote Reply With Quote
  7. 03-18-2007, 07:17 PM #7
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    guess you are on windows

    your database service probably isnt started
    Reply With Quote Reply With Quote
  8. 03-18-2007, 08:22 PM #8
    dbareflex
    dbareflex is offline Junior Member
    Join Date
    Mar 2007
    Location
    mt view
    Posts
    7

    thanks. this is resolved

    this is a server about to retire....so someone disabled the services. I was able to open and captured the alert log for documentation. This is so simple and yet I thought I was missing something....ugg. Thanks everyone.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width