Thanx Govind.
as Robert said, it has a dedicated chapter for that.
...and i'm trying all the scenarios one by one with his book beside.
but just thought, i could some more inputs from the LIST.
I will continue with the book now.
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www
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.
--
the internals etc. Go thru Recovery principles, Case Studies by Rama
Velpuri. (Add RF's book too). Try doing the same with Standby too.
HTH
GovindanK
> My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter
> devoted to case studies and RMAN.
>
> RF
>
>
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
OH/rdbms/demo/
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 K
ts of list ORACLE-L
(B
(B
(BHi all,
(B
(BIs there any doc./URL which lists out RMAN backup and recovery scenarios ?
(Bdid not find one in metalink.
(B
(BThanks & Regards,
(BJp.
(B
(B
(B
(B--
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B--
(BAuthor: Prem
Hi all,
Is there any doc./URL which lists out RMAN backup and recovery scenarios ?
did not find one in metalink.
Thanks & Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
: Multiple recipients of list ORACLE-L
> Subject: RE: Backup and Recovery
>
> Sony
>I'm not Ruth, but perhaps I can provide some helpful information.
>Export is a logical backup. It is useful for recovering from some types
> of failures, but not for others. For examp
Oracle
backups including RMAN.
RMAN is included with your Oracle installation. It is free with Oracle.
The best book for RMAN is Oracle9i RMAN Backup & Recovery by Robert Freeman
and Matthew Hart.
Also visit with your user managers and learn what their backup and
recovery requirements are. How
e in oracle, or if it is a script, would you share it to me ?I use
oracle 9i on windows 2000 server.TIA,Sony>
-Original Message-> From: Ruth Gramolini
[SMTP:[EMAIL PROTECTED]]> Sent: Monday,
February 10, 2003 9:29 PM> To: Multiple recipients of
list ORACLE-L> Su
consultant with experience
in backup and recovery procedures to help this client. If the client is
paying you under the assumption that you are an Oracle backup and recovery
expert, you may be misleading them. Honesty builds long-term relationships.
Be sure the client has archive logging turned on
> -Original Message-
> From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 10, 2003 9:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Backup and Recovery
>
> Export is not the best way to do backup. Have a look at rman, it comes
&g
Santosh - You might consider locating an Oracle consultant with experience
in backup and recovery procedures to help this client. If the client is
paying you under the assumption that you are an Oracle backup and recovery
expert, you may be misleading them. Honesty builds long-term relationships
Export is not the best way to do backup. Have a look at
rman, it comes with the rdbms. Ruth
- Original Message -
From:
Santosh
Varma
To: Multiple recipients of list ORACLE-L
Sent: Monday, February 10, 2003 6:43
AM
Subject: Backup and Recovery
Hello
Oracle 8.1.7.
The client wants to have the backup and recovery procedure. As of now,
they
are using EXPORT utility.
Could any one of you tell me any other utility which the client will be
able
to use for Backup of their data ?
Thanks and Regards,
Santosh Varma
--
Please see the official
Hello
list,
I
am implementing a software in Oracle 8.1.7.
The client wants to
have the backup and recovery procedure. As of now, they are using EXPORT
utility.
Could any one of you
tell me any other utility which the client will be able to use for Backup of
their data ?
Thanks
Title: RE: backup and recovery exam results
Guys,
I recently as a consultant had to take it on the chin when I couldn't get a sys. admin. to do his diagnostics or believe it was actually a hardware failure and after (of course) unsuccessfully restoring/recovering and then fi
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Oracle9i RMAN Backup and Recovery
Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample chapter available and TOC for you all
to look at if you l
cc:
Subject: Oracle9i RMAN Backup and Recovery
Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample chapter available and TOC for you all
to look at if you like. Here is the URL:
http://shop.osborne.com/cgi-bin/osborne/0072226625.htm
2002 9:59 AM
To: Multiple recipients of list ORACLE-L
Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample chapter available and TOC for you all
to look at if you like. Here is the URL:
http://shop.osborne.com/cgi-bin/osborne/0072226625.html
Congratulations, Robert!!
Looking forward to receiving my copy...
- Kirti
-Original Message-
Sent: Thursday, October 10, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L
Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample
Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample chapter available and TOC for you all
to look at if you like. Here is the URL:
http://shop.osborne.com/cgi-bin/osborne/0072226625.html
Enjoy!
Robert
Robert G. Freeman - Oracle OCP
Oracle
0 PM
>
>
> > I was wondering if anyone would be interested in me posting one chapter
> from
> > Oracle9i RMAN Backup and Recovery
> > by Mathew Hart and Myself. I don't want to just force it on you all, or
> make
> > it seem like a marketing ploy. So, if there
> &g
iginal Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, September 26, 2002 4:30 PM
>
>
> > I was wondering if anyone would be interested in me posting one chapter
> from
> > Oracle9i RMAN Backup and Recovery
> &g
ACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 4:30 PM
> I was wondering if anyone would be interested in me posting one chapter
from
> Oracle9i RMAN Backup and Recovery
> by Mathew Hart and Myself. I don't want to just force it on you all, or
make
> it seem l
ng one chapter
from
> Oracle9i RMAN Backup and Recovery
> by Mathew Hart and Myself. I don't want to just force it on you all, or
make
> it seem like a marketing ploy. So, if there
> are enough folks interested in me doing so, I will, and if you object let
me
> know and I will n
be interested in me posting one chapter
> from Oracle9i RMAN Backup and Recovery
> by Mathew Hart and Myself. I don't want to just force it on you all, or
> make it seem like a marketing ploy. So, if there
> are enough folks interested in me doing so, I will, and if you object le
yea i'm interested by all means.
joe
Freeman, Robert wrote:
>I was wondering if anyone would be interested in me posting one chapter from
>Oracle9i RMAN Backup and Recovery
>by Mathew Hart and Myself. I don't want to just force it on you all, or make
>it seem like a
yea i'm interested by all means.
joe
Freeman, Robert wrote:
>I was wondering if anyone would be interested in me posting one chapter from
>Oracle9i RMAN Backup and Recovery
>by Mathew Hart and Myself. I don't want to just force it on you all, or make
>it seem like a
One more vote for it
-Original Message-
Robert
Sent: Thursday, September 26, 2002 10:31 PM
To: Multiple recipients of list ORACLE-L
Hand
I was wondering if anyone would be interested in me posting one chapter from
Oracle9i RMAN Backup and Recovery
by Mathew Hart and Myself. I don&#
Sure, do post it
Aleem
-Original Message-
Sent: Friday, September 27, 2002 1:31 AM
To: Multiple recipients of list ORACLE-L
Subject:Should I post a preview of Oracle9i RMAN Backup and Recovery
Hand
I was wondering if anyone would be interested in me posting one chapter
chapter from
Oracle9i RMAN Backup and Recovery
by Mathew Hart and Myself. I don't want to just force it on you all, or make
it seem like a marketing ploy. So, if there
are enough folks interested in me doing so, I will, and if you object let me
know and I will not (as long as the list owner
doesn&#
f
Oracle9i RMAN Backup and Recovery
Sent by: Hand
[EMAIL PROTECTED]
interested in me posting one chapter from
Oracle9i RMAN Backup and Recovery
by Mathew Hart and Myself. I don't want to just force it on you all, or make
it seem like a marketing ploy. So, if there
are enough folks interested in me doing so, I will, and if you object let me
know and I will not (as lo
I was wondering if anyone would be interested in me posting one chapter from
Oracle9i RMAN Backup and Recovery
by Mathew Hart and Myself. I don't want to just force it on you all, or make
it seem like a marketing ploy. So, if there
are enough folks interested in me doing so, I will, and i
Yup
(more or less). I highly encourage you to get Backup and Recovery Handbook
from Oracle Press. Its kick-ass.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Randy KirkpatrickSent:
Sunday, February 03, 2002 8:05 PMTo: Multiple recipients
Hum, he says nope and I say yup. Yet I believe we are giving
the same answer. So I will explain mine more fully.
One of the advantages of a database running in archive log mode
is the ability to restore just one data file.
-Original Message-
Thapliyal
Sent: Sunday, February 03, 2002 11
short answer: no gotchas, it will work for you
longer answer: yes, because that's the way recovery is designed to
work. In the header of every datafile is an SCN. If that SCN matches
the one n the controlfile, the datafile is presumed to be up-to-date
and no recovery is done on it.
--- Randy Ki
Hi,
Just recover the datafile is possible. AFAIK only changes in archives that
are for that datafile will be applied.
As for gotchas. Don't try it on your production database if it's your first
time.
Recover datafile '/path/filename'
Jack
"Randy Kirkpatrick" <[EMAIL PROTECTED]>@fatcity.c
nope .. this should just work fine:)
--- Randy Kirkpatrick <[EMAIL PROTECTED]> wrote:
> Listmembers,
>
> Are there any "gotchas" with restoring just one
> datafile from a hot backup
> and applying the archive logs? Will applying the
> archive logs only affect
> the restored datafile? For instance
Listmembers,
Are there any "gotchas" with restoring just one
datafile from a hot backup and applying the archive logs? Will applying the
archive logs only affect the restored datafile? For instance, if I have a hot
backup from Monday and all the archive logs to the current date and a disk
Personally speaking I think that it is one of the best books available on
Backup and Recovery.the case studies at the end of the boom r pure gems.
I have the Oracle 8 edition and the concepts r very clearly explained esp.
Media Recovery the concepts of which r still not very clear to many
Personally speaking I think that it is one of the best books available on
Backup and Recovery.the case studies at the end of the boom r pure gems.
I have the Oracle 8 edition and the concepts r very clearly explained esp.
Media Recovery the concepts of which r still not very clear to many
ick on
> 'http://www.needhim.org'
>
> ** The opinions and statements above are entirely my own and not
> those of my employer or clients **
>
>
> > -----Original Message-
> > From: Sam Bootsma [mailto:[EMAIL PROTECTED]]
> > Sent: Thurs
gt; From: Sam Bootsma [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 20, 2001 10:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: FW: Rama Velpuri's 9i Backup and Recovery Book Available?
>
>
> > I am thinking of buying Rama Velpuri's book, 'Oracle 8
mployer or clients **
> -Original Message-
> From: Sam Bootsma [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 20, 2001 10:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: FW: Rama Velpuri's 9i Backup and Recovery Book Available?
>
>
> > I
: Multiple recipients of list ORACLE-L
> I am thinking of buying Rama Velpuri's book, 'Oracle 8i Backup and
> Recovery'. Can anybody tell me if this is still considered to be one of
> the best Oracle Backup and Recovery books available? Before buying the 8i
> version of
10 PM
To: Multiple recipients of list ORACLE-L
Subject:FW: Rama Velpuri's 9i Backup and Recovery Book
Available?
> I am thinking of buying Rama Velpuri's book, 'Oracle 8i Backup and
> Recovery'. Can anybody tell me if this i
> I am thinking of buying Rama Velpuri's book, 'Oracle 8i Backup and
> Recovery'. Can anybody tell me if this is still considered to be one of
> the best Oracle Backup and Recovery books available? Before buying the 8i
> version of this book, can anybody tell me if t
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 c
icker
Sent: Tuesday, March 20, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L
We are in the midst of starting to use RMAN for our Backup
and Recovery. The backups I have put into place are Once a
week a Level 0 full backup, three times a week Level 1
incremental and three times archive logs
We are in the midst of starting to use RMAN for our Backup and Recovery. The backups I
have put into place are Once a week a Level 0 full backup, three times a week Level 1
incremental and three times archive logs only.
Can anyone suggest some different recovery scenarios to test? Or if I
Build a new database.. recover over there.. from backups+arch logs until
table was dropped
..
export there, import to the original database..
-bruce
"Sanjay Kumar" <[EMAIL PROTECTED]>@fatcity.com on 02/01/2001 11:16:10 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
on how to do this but I do know it is
possible.
Lisa
-Original Message-From: Sanjay Kumar
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 01, 2001
12:16 PMTo: Multiple recipients of list ORACLE-LSubject:
Backup and Recovery Question
Hi,
I have a situation like thi
LE-L
Sent: Thursday, February 01, 2001 8:16
PM
Subject: Backup and Recovery
Question
Hi,
I have a situation like this.
I found a user dropping a table today at 9 AM but
I came to know about that only at 2 PM the same day. I have a backup which was
taken the
Look in the documentation for a point_in_time tablespace recover. You have
to recover the tablespace into another database and then export the table
which was dropped and import it into the database from which it was dropped.
HTH,
Ruth
it is more important to be human than to be important
-
Hi,
I have a situation like this.
I found a user dropping a table today at 9 AM but I
came to know about that only at 2 PM the same day. I have a backup which was
taken the previous day at 4 PM. My database runs in Archivelog
mode.
I want to restore the table. If I put the
database in
57 matches
Mail list logo
