By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,180 Members | 1,012 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,180 IT Pros & Developers. It's quick & easy.

RMAN resynchonize question

P: n/a
Hi, folks!

I am new to RMAN and now trying to configure it. There is one issue
concerning me.
Let's say I backup the target database every 6:PM and the database
generates about 100 archived logs every day.
So what happens if the database crashs at 5PM? I have the backup at
6PM of the last day only and no backup of archive logs generated
between that time.
Have anynone experienced that any what is your solution?

Thank a bunch.
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You should keep 2 copies of your archive logs, on separate disks.
On separate servers if possible.

Look at LOG_ARCHIVE_DEST_n syntax

I keep one copy on a mirrorred disk locally, and one copy on another machine
which is in a different city.

But should your database "crash", as you say, most of the times your archive
logs will still be available. You`ll have lost one datafile, or any part of
the database but not your archive logs (as long as they are kept on their
own disk or storage device), so you can recover.
If you loose your archive logs in both locations (if you save them onto 2
locations that is) you still have the database. Just hurry to take a good
backup of it.

Loosing everything can only happen if the server bursts into flames (or
something of the like), in which case you need more than your archive logs
to recover, you need a complete disaster plan.

Regards,

Syltrem

"Tho Nguyen" <th*****@yahoo.com> a écrit dans le message de
news:d1**************************@posting.google.c om...
Hi, folks!

I am new to RMAN and now trying to configure it. There is one issue
concerning me.
Let's say I backup the target database every 6:PM and the database
generates about 100 archived logs every day.
So what happens if the database crashs at 5PM? I have the backup at
6PM of the last day only and no backup of archive logs generated
between that time.
Have anynone experienced that any what is your solution?

Thank a bunch.

Jul 19 '05 #2

P: n/a
th*****@yahoo.com (Tho Nguyen) wrote in message news:<d1**************************@posting.google. com>...
Hi, folks!

I am new to RMAN and now trying to configure it. There is one issue
concerning me.
Let's say I backup the target database every 6:PM and the database
generates about 100 archived logs every day.
So what happens if the database crashs at 5PM? I have the backup at
6PM of the last day only and no backup of archive logs generated
between that time.
Have anynone experienced that any what is your solution?

Thank a bunch.


backup the archivelogs every hour or as you like.

regards

s.kapitza
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.