Page 1 of 2 12 LastLast
Results 1 to 15 of 18

Thread: Offline Backup

  1. #1
    Join Date
    May 2004
    Posts
    12

    Unanswered: Offline Backup

    Hi,

    I tried to find an easy way to make good backup of my Oracle 9i running on my windows 2000 server, I have never been able to restore a good backup. So before the real thing happens, can someone tell me what I'm doing wrong.

    In the meanwhile I use Oracle template creation to copy my DB over another newly intalled PC.

    On the server to backup :

    1) log as /
    2) shutdown normal
    3) Make a copy of the datafiles, resetlog and redologs
    4) Make a copy of my admin/pfile/init.ora

    On the server to restore
    1) Install a new database with the same SID without DATA
    2) Log in as /
    3) Shutdown normal
    4) Copy over all my datafiles and logs in their right directory
    5) recreate fully my admin folder with all sub folders
    6) Copy in the admin/pfiles the init.ora
    7) Startup

    I get the following error:

    ORA-03113: end-of-file on communication channel


    Thanks for helping out

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Are you 100% certain that you new system is completely & correctly configured to run Oracle as specified by
    http://download-west.oracle.com/docs...493_01/toc.htm
    I suspect that you are being aflicted by an "environmental" issue;
    which is more than likely an error of ommission;
    as opposed to an error of commission.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2004
    Posts
    12
    Actually, it is the same machine!

    Same OS, Same Service pack..

    I'm completly confuse.. Is my procedure right?

    Martin

  4. #4
    Join Date
    May 2004
    Posts
    12
    oh! By the way

    Using template, all my users have expired password now... any solution for this also would be appreciate

    Martin

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I'm completly confuse.. Is my procedure right?
    Obviously it is not right, because if it were right the DB would be online. QED!
    >Using template, all my users have expired password now
    Undo what you did to expire the passwords.
    Good luck in restoring the DB from backups.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Feb 2004
    Location
    Hong Kong
    Posts
    15

    Abnormal

    You are acting abnormally. If you are just copying whle thing to your new data. It will not syncronize at all. Therefore, it is giving error. Instead, you can use import/export command to do it.


    Quote Originally Posted by Rockyboa
    Hi,

    I tried to find an easy way to make good backup of my Oracle 9i running on my windows 2000 server, I have never been able to restore a good backup. So before the real thing happens, can someone tell me what I'm doing wrong.

    In the meanwhile I use Oracle template creation to copy my DB over another newly intalled PC.

    On the server to backup :

    1) log as /
    2) shutdown normal
    3) Make a copy of the datafiles, resetlog and redologs
    4) Make a copy of my admin/pfile/init.ora

    On the server to restore
    1) Install a new database with the same SID without DATA
    2) Log in as /
    3) Shutdown normal
    4) Copy over all my datafiles and logs in their right directory
    5) recreate fully my admin folder with all sub folders
    6) Copy in the admin/pfiles the init.ora
    7) Startup

    I get the following error:

    ORA-03113: end-of-file on communication channel


    Thanks for helping out

  7. #7
    Join Date
    May 2004
    Posts
    12
    Okay,

    If for the moment the only thing that really matters is the fact that one user as an expired password and I'm no longer able to connect to my 2M$ business system that was developped by a no longer existing firm using hard coded password.

    If I delete that USER from the data directetory, can I EXP and IMP back again with is old password, profile, grants, priviliges and role...

    Martin

  8. #8
    Join Date
    May 2004
    Posts
    12
    I did run EXP / IMP as follow :

    Old system:

    EXP system/password file=Z:\expdat.dmp compress=y full=y consistent=y

    IMP system/password file=Z:\expdat.dmp full=y commit=y buffer=64000 destroy=y

    But I get so many error... I don't trust this (even if at the end a message tells me that the import was succeful with warning)

    Thanks

    Martin

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    1) Before you make a bigger mess than already exists, take a cold backup of everything.
    2) Hire somebody who actually knows what they are doing to try to recover the DB.
    What did you do that prevents you from opening the original DB?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  10. #10
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You can use the import, but it expects that all the tablespaces already exist and they have enough space to store the imported objects. If you precreate the tablespaces, and answer 'Y' to ignore create errors, your full database export from your first machine will import into your new database with no problems. I speak from experence, I have done this Many, Many times.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  11. #11
    Join Date
    May 2004
    Posts
    12
    anacedent, Thanks for helping out... I think I can pretty much handle this and I'm very close to suceed in this project.

    I have a disk that has bad cluster that the compagnie who we hired for installing it didnt know anything about RAID or backup

    My active directory is down and my vm system also. But I still can oben my original DB.

    beilstwh
    I already have a full clone of my original DB installed on my new server, I use template for this and it works perfectly. The only thing now is that I'm missing one account password. Yes when you use template to clone a database all account are lock and their password expired.

    We don't have this password since it is hardcoded in the application.

    So if you have a solution to import a single user in my database with all his information related.. Please tell..

    I tried an export with the owner set to the user I want to export but it seems to export much more than the account info.

  12. #12
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    have you tried to go into a priviledged agount and issue the unlock command (see below)

    alter user scott account unlock;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  13. #13
    Join Date
    May 2004
    Posts
    12
    Yes I did, actually it unlocks the user but still, his password as expired...

    Do you know any way to use template creation without defaulting the lock and expired password policy.

    Martin

  14. #14
    Join Date
    Jul 2003
    Posts
    2,296
    go to host of the database.
    at commandline:
    sqlplus /nolog
    connect / as sysdba
    alter user username account unlock;
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  15. #15
    Join Date
    May 2004
    Posts
    12
    The Duck,

    At the host database the account are unlock and password are not expired. I guess that, for security reason, Oracle locks ans expired password (excepted sys and system) during restoration all of those accounts.

    Martin

Posting Permissions

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