473,465 Members | 4,818 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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 2485
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

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.