Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2010
    Posts
    18

    Unanswered: DB Restore question

    Hi everyone,
    I'm a developer working with an Oracle DB. Our DBA left, and we had a scheduled task setup on windows to do backups of the DB under his account.

    Since he left, the task has been failing (we didn't realize until now, a month later). We're trying to recover some missing data from a table... since our most recent *.DMP files are a month old, is there any other way to get data that was there 24 hours ago? I know there is something like flash backup, but the window for that is small. Any other options? Or are we up the creek?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    do as below so we can know complete Oracle version & OS name.

    Post via COPY & PASTE complete results of
    SELECT * from v$version;
    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
    Jun 2010
    Posts
    18
    Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
    PL/SQL Release 10.2.0.5.0 - Production
    "CORE 10.2.0.5.0 Production"
    TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
    NLSRTL Version 10.2.0.5.0 - Production

    Windows server 2008 R2...

    Thank you!

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by ducati321 View Post
    Hi everyone,
    I'm a developer working with an Oracle DB. Our DBA left, and we had a scheduled task setup on windows to do backups of the DB under his account.

    Since he left, the task has been failing (we didn't realize until now, a month later). We're trying to recover some missing data from a table... since our most recent *.DMP files are a month old, is there any other way to get data that was there 24 hours ago? I know there is something like flash backup, but the window for that is small. Any other options? Or are we up the creek?
    Unless your database is in archive log mode and you still have the archive logs from yesterday, you can recover the data using the logminer utility.

    Othewise, i'm sad to say you are "up the creek".
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Jun 2010
    Posts
    18
    Quote Originally Posted by LKBrwn_DBA View Post
    Unless your database is in archive log mode and you still have the archive logs from yesterday, you can recover the data using the logminer utility.

    Othewise, i'm sad to say you are "up the creek".
    So, how does one find out of they're in archive log mode?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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.

  7. #7
    Join Date
    Jun 2010
    Posts
    18
    thanks, I see it says how to startup the DB in archive mode - how do I determine if it is already running in that mode?

  8. #8
    Join Date
    Feb 2004
    Location
    Chennai
    Posts
    53
    select log_mode from v$database;
    -Mathan
    For a quick pocket reference of oracle refer http://pocketoracle.blogspot.com/

  9. #9
    Join Date
    Jun 2010
    Posts
    18
    Quote Originally Posted by getmathan View Post
    select log_mode from v$database;
    thank you!

Posting Permissions

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