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

Thread: OPS backup

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    146

    OPS backup

    Hi All,

    I have an Oracle 8i OPS on AIX 4.3.2. I also have 2 intances running
    against the DB. My question is, if I shutdown intance1 and perform a cold backup while instance2 is actively performing DMLs, how can I apply changes (archive logs of instance2) to intance1 during recovery?
    I have coppied instance1 and the DB to a test server and started it up.

    Thanks in advance friends,

  2. #2
    Join Date
    Feb 2001
    Location
    Adelaide, Australia
    Posts
    159
    Rommel,

    You cannot take a 'cold' backup if an instance is writing to the database files.
    You must stop both instances to do this.

    Secondly, all 'changes' are made in the database files eventually anyway, and are logged in thread-specific archive logs. Why do you need to 'recover' instance 1? Just restart it and away you go.

    Brgds,

    Andy

  3. #3
    Join Date
    Jan 2002
    Posts
    146
    Thanks Friend, I'm quite puzzled.
    So, If I have a hot backup on instance1 and supposing my database crashed, Do you mean I will just restore instance1 and apply its archive logs and no need to bother on instance2?

  4. #4
    Join Date
    Jan 2002
    Posts
    146
    Hi Friends,

    Sorry for being redundant (dumb) , but I still can't make a right db recovery.

    If I'm going to have an online backup, which files should I backup first, or what is the right sequence? My understanding are the ff:
    1. datafiles (with alter tablespace begin/end backup)
    2. control files (backup to file)
    3. redo logs files (online?)
    4. archived logs

    I always get an error of unsync time stamp between files esp
    system.dbf

    Am i right? Why is that the docs says not to include the redo logs files? Online redo logs refers to the current physical redo logs, right? How can I start a database without the physical redo logs? Do
    I have to create a new one?

    Thanks a lot.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by rommel
    Hi Friends,

    Sorry for being redundant (dumb) , but I still can't make a right db recovery.

    If I'm going to have an online backup, which files should I backup first, or what is the right sequence? My understanding are the ff:
    1. datafiles (with alter tablespace begin/end backup)
    2. control files (backup to file)
    3. redo logs files (online?)
    4. archived logs

    I always get an error of unsync time stamp between files esp
    system.dbf

    Am i right? Why is that the docs says not to include the redo logs files? Online redo logs refers to the current physical redo logs, right? How can I start a database without the physical redo logs? Do
    I have to create a new one?

    Thanks a lot.
    How about learning some RMAN, right?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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