Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
DENNIS WILLIAMS
Sent: Tuesday, October 28, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: rman backup
AK
When you have RMAN back up archived logs, IIRC, in a recovery RMAN first
restores those
AK - Unless you specify otherwise, RMAN will automatically apply archive
logs to bring the database up to the time of failure (your recover database
statement). This is why it is good to run disaster recovery tests on a
regular basis, to ensure everything is ready, and you can try different
You can restore database and open it to the mount phase using RMAN.
Then you can get into sqlplus and type something like:
alter system set log_archive_dest_1=/directory/where/log/archives/reside
set autorecovery on
recover database auto until cancel
On 10/28/2003 12:44:24 PM, AK wrote:
We
Thanks Dennis for Reply,
My confusion is , does RMAN sees only those archived logs which are backup
using rman or it can use current archived log as well stored in original
format at other disk ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
As long as you have
the database in archivelog mode and have a level 0 backup as your starting point
then you can recover. Make sure that your level 0 includes the
controlfiles.
HTH,
Ruth
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of AKSent:
AK
When you have RMAN back up archived logs, IIRC, in a recovery RMAN first
restores those archived logs to the location that Oracle will expect them to
be, and I believe that is done as part of the RESTORE DATABASE command. In
my situation, I found no advantage from having RMAN store the
Prem - I haven't found anything significant online. Perhaps someone else
will point to a resource. If you want to learn RMAN, my recommendation is to
get a couple of books. The advantage of a book is you end up with a
comprehensive resource for reference. Myself, I need to go back and
Look at the Backup and Recovery Doc's. And there are sample scripts in
OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a
great resource!
HTH,
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Prem Khanna J
Sent: Thursday,
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter
devoted to case studies and RMAN.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/4/2003 11:44 AM
Look at the Backup and Recovery Doc's. And there are sample scripts in
Besides you may refer to Backup Recovery by Rama Velpuri (8/8i). A bit
old but nevertheless good. All said and done, create a clone database
and keep crashing it in all ways you can think of, and try to recover it.
That should give you the confidence , letting you know how oracle handles
the
Thanx Dennis,Robert,and Ruth.
I'm going thro' Roberts's book now.
as Robert said, it has a dedicated chapter for that.
...and i'm trying all the scenarios one by one .
but just thought, i could some more inputs from you Gurus.
thanx a lot guys.
I will continue with the book.
Regards,
Jp.
--
Good point Tom
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/7/2003 1:29 PM
Ronald,
It looks like just the archivelog was not going into the correct
directory, right? But then you did *not* include a format clause for
the archivelog.
Looking at the
Syntax error:
backup database format =
'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;
add the = after the format and it should run. RMAN is trying to help you
by ignoring this error and proceeding to backup the database to the default
location.
RF
-Original
: Multiple recipients of list
ORACLE-LSubject: RE: RMAN Backup piece being placed in wrong
directory
Ronald,
It
looks like just the archivelog was not going into the correct directory,
right? But then you did *not* include a format clause for the
archivelog.
Looking at the docs
Title: Message
Ronald,
It
looks like just the archivelog was not going into the correct directory,
right? But then you did *not* include a format clause for the
archivelog.
Looking at the docs, it looks like you should change the
following:
backup
database
Babu - We allocated multiple channels on an RMAN disk backup and the backup
time was reduced. I would suggest you try to figure out where your
bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several
features to keep the tape streaming, you may want to look at these. If your
Dennis,
Thanks for your reply. Iam taking tape backup with 3 channels as we have
multiple tape drives. I don't know where the bottleneck is. In the RMAN
output I see it is using all the three channels simultaneously with 10
datafiles per channel. But Iam not getting the throuput. It is taking the
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RMAN backup with MULTIPLE CHANNELS ..
Dennis,
Thanks for your reply. Iam taking tape backup with 3 channels as we have
multiple tape drives. I don't know where the bottleneck is. In the RMAN
output I see it is using all
:
Subject:RE: RMAN backup with MULTIPLE CHANNELS ..
Dennis,
Thanks for your reply. Iam taking tape backup with 3 channels as we have
multiple tape drives. I don't know where the bottleneck is. In the RMAN
output I see it is using all the three channels simultaneously with 10
datafiles per
Look for something like channels-per-tapedrive on the backup server configuration. You
have to be above this figure to use multiple tape drives.
[EMAIL PROTECTED] 02/21/03 07:47a.m.
Dennis,
Thanks for your reply. Iam taking tape backup with 3 channels as we have
multiple tape drives. I don't
also check Maximum Jobs per client.
you will find this setting in the Netbackup preferences window (Netbackup Java
console).
-Mandar
-Original Message-
From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 8:44 AM
To: Multiple recipients of list
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RMAN backup with MULTIPLE CHANNELS ..
Jared,
Please let me know what info you need. I would collect it from my
Netbackup
administrator and let you know.
Thanks,
-- Babu
-Original
Mandar,
Thanks for your reply. Iam in the process of checking with my Netbackup
Administrator about the parameter: Max_jobs_per_client. After seeing your
E-Mail, I too looked into the online manual and it seems the value should be
= Number of streams X No.Of Classes. In my case No.Of classes
Title: RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SPEED?
Brian,
If time is of the essence and you have EMC BCV's, look at Time Finder. I believe that's EMC's piece of software that allows you to sync and split a third mirror. That will be much faster for recovery than
Hi,
I have used 12 channels to backup 700GB database and writing to FOUR TAPES at the same
time. I used to backed up in 4 1/2 hours. On EMC disk, restore was done in 8 hours.
allocate channel c1 type 'SBT_TAPE';
allocate channel c2 type 'SBT_TAPE';
I stand corrected.
thanks Robert.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 16, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L
RMAN does no compression on any blocks with data. The only compression that
occurs that blocks above the
Also, RMAN can do incremental backups, copying only the blocks that changed since last
backup. More about all this in Oracle Manuals and in Robert's book.
- Kirti
-Original Message-
Sent: Thursday, January 16, 2003 10:04 PM
To: Multiple recipients of list ORACLE-L
Maria -
No.
Because Rman is not placing the tablespaces in a HOT BACKUP mode. Rman is
simply reading the blocks, compressing them, and writing them to tape.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 16, 2003 12:35 PM
To: Multiple recipients of
Rman uses the same construct to get the right data in a hot backup as
sqlplus, the SCN of the database. It reduces excess redo because you don't
have to put the datafile in backup mode with a begin backup and take it out
with and end backup.
HTH,
Ruth
- Original Message -
To: Multiple
RMAN does no compression on any blocks with data. The only compression that
occurs that blocks above the HWM are not included. No compression of data
occurs, and in fact empty blocks can and are backed up by RMAN.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts
Title: RE: RMAN backup - basic Qs
what happens when a 'snapshot too old' situation occurs??...how can RMAN produce a valid backup in that case?
many i'm missing something.
-Original Message-
From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 1:54 PM
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RMAN backup - basic Qs
what happens when a 'snapshot too old' situation occurs??...how can RMAN
produce a valid backup in that case?
many i'm missing something.
-Original Message-
Sent: Thursday, January 16, 2003
To better answer the original question, my understanding of this difference
is as under:
Why do you put the tablespace in backup mode during normal hot backups
without RMAN? This is to avoid backing up split blocks. Say, you have a
database with a block size of 16K. And that a block is in the
does this make RMAN hot backups faster or slower than when backing up file in
backup mode?
[EMAIL PROTECTED] wrote:
To better answer the original question, my understanding of this difference
is as under:
Why do you put the tablespace in backup mode during normal hot backups
without RMAN?
Maria - Definitely faster. Often hot backups can generate additional redo.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 16, 2003 9:24 PM
To: Multiple recipients of list ORACLE-L
does this make RMAN hot backups faster or
Subject: Re: RMAN backup
How about switching to incremental (from "full") backups?
Even if all youdo are level-0 backups?My understanding of the
difference between a "full" and a "level-0" backup(besides the obvious
impact on any subsequent level-n incre
Joe - Which type of RMAN backup are you doing? If you are doing RMAN
datafile backups, then the size of your datafiles matter. If you are using
the RMAN backup command, you are creating RMAN backup pieces. RMAN backup
pieces contain parts of several data files, and you can't control that. You
can
How about switching to incremental (from full) backups? Even if all you
do are level-0 backups?
My understanding of the difference between a full and a level-0 backup
(besides the obvious impact on any subsequent level-n incremental backups)
is that level-0 backups only back up database blocks
Tim, i'd be glad to hear someone else verify your statement as my
understanding is the the only difference between full and level 0 is
that full cannot be used as part of an incremental strategy, other than
that they both back up the ever used blocks.
Anyone else care to jump in on this one?
Joe Tim,
It is accurate to state the both full and level 0 have the same impact
on the database, and both backup all used blocks. It is also accurate
that a full backup cannot be used as a piece of an incremental strategy.
Although there may be rare instances (no pun intended :-) ) when you
Use map network drive on your target machine and define the drive as a
directory on your recovery machine.
I mean: map drive K on the target machine as f:\backup on the recovery
machine.
Then backup to drive K.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list
Well since you haven't gotten a reply from anyone else yet, I'll take a
crack at it, but I don't use Oracle on Windows so I may be totally off
base.
I'm assuming that your f drive is a mapped drive to your catalog db
server. I don't recall the details, but I believe that just because you
have
Hi
My problem went away when I did a startup mount of the database.
I have Rman user in TEST2 just for testing purposes (same username password
on target catalog is easier with ctrl C ctrl V)
One more question if I may.
Do you or anybody else have an example of a very complex rman
Jack,
What is the status of your target database?
Try having it in startup mount status rather than startup open.
The other thing you should do is to backup your control file (using Rman)
with every database backup. I do this as my last step with every backup so
that the latest changes
What version of the database are you using? My info here is based on 8.1.7.
I connect to my databases as internal to do the backups. I fire up RMAN with either
one of these commands:
rman target / catalog rman/rman@test1 (SID must be set correctly)
rman target internal/pwd@test2 catalog
This error occurs when you are trying recovery on an open database.the
database should be in MOUNT mode for recovery.
Sona
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 4:25 AM
Hi All,
I'm in the process of
Thanks - that worked.
Chris
Mercadante, Thomas F wrote:
Chris,
here is one way - use the SETSIZE command
7 backup
8incremental level 0
9setsize 222
it will figure out how many database files to fit into the 2 gig limit above
and create multiple pieces.
Chris,
here is one way - use the SETSIZE command
7 backup
8incremental level 0
9setsize 222
it will figure out how many database files
Rman backs up only used blocks, so the size difference
Johnson
--- Raj Gopalan [EMAIL PROTECTED]
wrote:
DBAs
I have taken hot backup using RMAN. The total Size
of the Database is
5200MB(By Sum(byes) in Dba_data_files). Where us the
backup file size put
together is 4600MB.
Where am I
Hi,
It's all O.K., blocks that never been used aren't backuped by rman.
oli
[EMAIL PROTECTED] wrote
DBAs
I have taken hot backup using RMAN. The total Size of the Database is
5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put
together is 4600MB.
Where am I missing
I believe that RMAN only backs up blocks that have been allocated to an oracle object
- index, segment, table, etc. If the block is in a datafile but not in use by an
oracle object (that is, the block is free), then RMAN doesn't backup those blocks.
Steve
[EMAIL PROTECTED] 04/30/01 12:25PM
Don,
You don't state whether or not you're getting the archived
redo logs at each Level 0 and 1 backup as well as the 3
archive-logs-only backups. If not, you probably should.
Also, if recovery speed will be important, those incremental
backups should be cumulative, not differential. However,
Hi, In one of our production site, I implemented RMAN backup and recovery scripts. I
did the following way.
Take a full backup using RMAN, the following things will be backed up
datafiles,Archive logs files, controlfile. I didn't use the catalog database. I used
the database's controlfile
53 matches
Mail list logo