473,378 Members | 1,156 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

RMAN resynchonize question

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
2 2477
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: sunilwarrier | last post by:
I found a few documents on this topic, but didn't resolve my issue. I am trying to restore an RMAN backup to a different host (with a differnet instance name) from where the backup was taken. ...
1
by: steve | last post by:
Hi, I am using the java database manager on oracle 9i linux , to monitor and modify my oracle 9i system. there is a wizard that allows the setting up of an rman job. I had setup a backup...
1
by: RYAN | last post by:
Hi All, I am new to Oracle and I have some question that I hope that someone out there can help me. I have heard the Oracle Rman can do replication of Archives logs. In this way, one can...
0
by: TX-DBA | last post by:
#####Background 1) CRONJOB runs 2 RMAN shell scripts at 3AM backup_begin.sh- export and rman backups report_begin.sh- list rman reports My report_begin.sh script, which was messed up, was...
2
by: Alex | last post by:
Hi all Is possible with RMAN recover only one table of my db? Where can i find some infromation about this? If is not possible , where can i find products to make this? Is possible to restore...
0
by: gohel | last post by:
I have cofigured rman on linux with oracle 9i (catdb) as revecory catalog db and target db is on win XP with oracle 9i in archive log mode , Now problm is I want backup of target DB (targdb)...
0
by: gunsbong | last post by:
hello again everybody.. i just copied the backup file from production to another server with the same config with the production...when i restore the copied backup file this message appears......
2
by: Tho Nguyen | last post by:
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...
9
by: mdfaraz | last post by:
SIR AS IAM USING ORACLE 10G RELEASE 2 IN RED HAT LINUX AS4, AS I CREATED ONE DATABASE NAMED AS <BSNL>..AND THE DEFAULT DATABASE IS ORCL. I ALREADY SET BSNL IN TNSNAMES.ORA AND ALSO IN LISTENER.ORA....
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.