INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Restored database with RMAN in the state which I supposed will be different.

Restored database with RMAN in the state which I supposed will be different.

Restored database with RMAN in the state which I supposed will be different.

(OP)
Hello.
I'm occasional oracle user and not have lot of recent experience.
Excuse if my question might be simple,

It's about backup point done by RMAN.

1. Let's assume:
that I have oracle (rac) database.
that I have it in noarchivemode.

2. I do.
$rman target /
RMAN> backup database

3. I see the backup (created files during rman backup) in backup directory.
Now. For test purpose I drop created simple table yet before backup was done.

4. I want to come back to the time before the table was droped.

5. So I do:
shutdown instance on both nodes and start them in mount state.
$rman target /
RMAN> restore database

6. After successfull operation
I do
$SQL> alter database open.
But it says to me that one media needs recovery (and it exits from opening).

7. So what I execute is
$SQL> recover;
8. Afer that it starts completely.
And when I check content I do not see the droped table but all others.

My question is:
Why it is like this?
I'm afraid I don't deeply understand what happens here.
Why the change after backup is mainaned although restore was done with backup from before the operation?
Does not the backup contains also control file and redolog but that only before the changes?
I'm a little bit confused.

Thanks for hints.
M.







RE: Restored database with RMAN in the state which I supposed will be different.

As a general rule, online backups are not usable if your database is not in archivelog mode. The online backups of the datafiles will finish at slightly different times, so you will always need to do some forward recovery to get all of your datafiles in synch. But forward recovery most often needs archive log files, which you don't have because your database isn't in archivelog mode.

There's a good chance that you can forward recover in your simple test scenario, because your redo logs may still contain all of the transactions needed for forward recovery. But don't rely on this! Oracle can and will overwrite redo log files when it needs to. Some day you'll restore an online backup and the transactions needed for forward recovery will be gone. Then you're stuck with a database that can't be recovered.

The lesson here is to always run your database in archivelog mode, if you want to do online backups. If you're not archiving your redo log files, you will need to shut down your database and take cold backups.

RE: Restored database with RMAN in the state which I supposed will be different.

(OP)
Thank you very much karluk for your response.!
So my question is then (I just assume I'm asking but for something obvious just to ensure).
If I enable right now mode to archive log.
Wait until archive logs are created then make rman online backup.

Now assume disaster or just deletion of some tables which were important.
I'll restore that RMAN backup till the time (with proper command until time) - right?
M.

RE: Restored database with RMAN in the state which I supposed will be different.

That's right. If you encounter a problem with your database which requires going back to before the problem happened, you would restore from an online backup and then perform an incomplete forward recovery, ending the recovery before the problem started. There are a number of ways to tell Oracle when to stop the recovery. Check the manuals for the proper syntax.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close