Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2008
    Posts
    38

    Unanswered: rollforward issue

    Hi
    Assume I have two identical databases.They both have same datafiles,controlfiles, structure is exactly same, except data..
    The name of the first db is "AA" which is in archivelogmode (production database)
    The name of the second db is "BB" which is in noarchivelogmode.


    If I restore from "BB" db`s backup, can I apply archivelogs of "AA"? so that both have the same data..

    Cheers

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    OraFAQ Forum: Backup & Recovery => rollforward issue

    What part of NO do you not understand?
    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
    Feb 2008
    Posts
    38
    Regarding the recovery process
    After the restore operation;
    If the scn number of redlogs and datafile headers and control files are not same, db cannot be opened
    and archivelogs are added to make scn equal.

    Is that correct?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is that correct?
    In addition to other reasons.
    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.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Dbid

    Glossary

    DBID

    An internal, uniquely generated number that differentiates databases. Oracle creates this number automatically when you create the database.
    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 2008
    Posts
    38
    Assume the SCN in datafile header is 200.
    and SCN in redologs are 400.

    so recovery is needed.

    Here is the question:
    if I recreate the controlfile,what will its SCN?
    I think it will be different than both datafiles and redologs.

    so how do u recover?

    controlfile has diffrent SCN, datafiles have diffrent SCN, and so redologs

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >if I recreate the controlfile,what will its SCN?
    How do you do that?
    Why do you do that?

    Your answer is just a few clicks beyond the URL below.
    Search and Download Oracle Database, Application Server, and Collaboration Suite Documentation
    Let us know when you have found your answer.
    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.

  8. #8
    Join Date
    Feb 2008
    Posts
    38
    Let me try to explain again

    if I restore BB from ALL of AA's backup, then AA becomes BB . . . .

    Therefore, BB has same SCN of last AA backup. and so that I can apply AA`s archivelogs.


    Little bit complicated to explain, but I hope you get me.

Posting Permissions

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