Hi!
Expired backups are unusable since they were not found accessible during
last crosscheck or were set to expired state manually. This means that these
backups can't and won't be used for restore operation.
Obsolete backups can be deleted since there are enough redundant backups
according to
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
Ruth,
thanks, I am back. I took the redundancy policy to 4 now and deleted
today's backupset and try to recover from the yesterday backupset which
is a valid status in the rman report. I still got error. Rman still
looking for today's backupset sequence. If I do the crosscheck and
delete the
Sorry, I tried set until time, it works. Now I think we can move rman to
production since we tested all kinds of restore.
Thanks and have nice day!
Joan
Joan Hsieh wrote:
Ruth,
thanks, I am back. I took the redundancy policy to 4 now and deleted
today's backupset and try to recover from
Joan - Glad to hear your success. In the meanwhile I replied to your earlier
message.
Just to clarify, when you used a time-based recovery, setting a time earlier
than the most recent backup, RMAN ignored the most recent backup and
restored from an earlier backup? Wouldn't that have the
Joan - I have not used the redundancy policy, but my understanding is this
just involves how many backup copies to retain. It does not relate to
recovery as I read the manual.
Do you have Robert Freeman's book Oracle9i RMAN Backup Recovery?
Are you attempting an incomplete recovery or a
If you don't set the redundancey policy to a recovery window of N days, than
the record of the backup will be kept indefinitely. You should be able to
restore the backups from tape and restore from a previous backup. You may
need to do a set until time if there was corruption or another problem.
Tanel,
Yes, rman keep asking the newer backupset which is start *450.rman. I don't
know the command change backuupset unavailable command. I will give it a try.
I know there is very rare situration that we need restore from an older
backupset, but need to prepare it in case we do need it. I
I have never attempted what you are doing, so I must confess some ignorance.
But, looking at your error message, it appears that rman knows what file it
needs and is unable to get it. One must assume there is no file named
/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman
available on the hard
Hi!
As Stephen pointed out, rman searches for a file named
/rmanbackup/ADVDBA_F_20031231:15:03:39_1.450.rman, but can't find it. Is
this file a newer backupset which rman is automatically trying to use?
If you want to skip this file, you could use change backupset unavailable
command for
I was actually talking from database recovery point of view (that you can do
point in time recovery prior to current controlfile time if you use using
backup controlfile option when recovering.
For restoring a de-registered backupset, I see two options (there might be
more, more convenient ones):
Thanks Tanel. I will test it out.
Happy new year!
Joan
Tanel Poder wrote:
I was actually talking from database recovery point of view (that you can do
point in time recovery prior to current controlfile time if you use using
backup controlfile option when recovering.
For restoring a
After I did some testing, it is impossble to restore and recover a
deleted obsolete backupset. So I took off the delete obsolete command.
Retention policy to redundancy still keep it to 1. I did couple backups
and run list backup of database and report obsolete command.
Although report obsolet
I think you can do CONFIGURE CONTROLFILE AUTOBACKUP ON,
which enables RMAN to automatically backup controlfile to
a default location. Then you can restore the controlfile
before you restore other database files.
-Original Message-
Sent: Tuesday, December 30, 2003 3:34 PM
To: Multiple
Joan - Which Oracle version?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 30, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L
Hi Listers,
I have a question about rman restore. Right now, I configured RETENTION
POLICY TO
Dennis,
9.2.0.4
Joan
Quoting DENNIS WILLIAMS [EMAIL PROTECTED]:
Joan - Which Oracle version?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 30, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L
Hi Listers,
I
Well Roger, Suppose I still have the current control file and want to use days
old full backupset (obsolete already) to restore and recover the database to
the point of time. How it related to recover the autobackup controlfile? I did
configure controlfile autobackup on though.
Thanks,
Joan
You can do point in time recovery using current controlfile as well. You
just say recover database until cancal using backup controlfile then, that
way Oracle ignores SCN information inside controlfile and trusts only
datafile headers.
You have to open resetlogs after that. One issue I see with
Note that when you configure controlfile autobackup on, then a backup
controlfile will be saved to default location (dbs or database dir under
$ORACLE_HOME) after most physical database structure changes such is adding
a datafile, taking tablespace offline/online etc. This is the behaviour of
Tanel,
Do you mean if I am using current controlfile to recover database, It doesn't
matter the backupset is obsolete or not in the rman catalog repository
database, is that sounds right? So, I just have to restore the old backupset
from tape to disk and issue recover database command? At
Title: RMAN - the time has come
Raj,
It
really is a quick learn. The best way is to get some scripts (great
examples in the rdbms/demo directory) and try them on a test database.
Once you get something running, the rest is simple. If you need some
samples, let me know. It's really basic
Title: RMAN - the time has come
In addition to the Freeman book, I would also
suggest the RMAN Pocket Reference from O'Reilly. It predates the RF book and
certainly comes handy for learning - I learned from there.
HTH.
Arup Nanda
- Original Message -
From:
Jamadagni,
Title: RMAN - the time has come
Try Robert Freeman's
book. I have only heard good things about it.
Ruth
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni,
RajendraSent: Monday, December 22, 2003 10:35 AMTo:
Multiple recipients of
We have talked about a 10g version of the book, which I'm sure will happen
at some point in time :-)
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/22/2003 2:39 PM
Try Robert Freeman's book. I have only heard good things about it.
Ruth
I would say it is like chess.
Learning how the pieces move is easy.
Learning to put it altogether and use and manage it
is not quite as simple. There are a lot of nuances
to RMAN, and I don't pretend to have a handle on it.
Yet.
Jared
On Mon, 2003-12-22 at 08:04, Mercadante, Thomas F wrote:
Ian,
I think retention policy is new in 9i.
I purge my repository of backups that are older than 90 days (because our
tape systems rotates and reuses tapes after that time) using the change
backuppiece 330783 delete; command. I run a sql script againts the rman
repository looking for pieces
Thomas,
You are right it's new in 9i
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Sent: Thursday, December 18, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Ian,
I think retention policy is new in 9i.
I purge my repository of backups that are older
Did you connect to the target database first? I know this is a simple thing
but sometimes we forget.
Regards,
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
MacGregor, Ian A.
Sent: Wednesday, December 17, 2003 5:04 PM
To: Multiple
Thanks, for the example script. I had already reached the conclusion that change
backuppiece ... was needed, but
hadn't yet figured how to query for the proper pieces.
Ian MacGregor
Stanford linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 18,
I have ftp'd the backup pieces into the identical backup location as the orignal
server so I have all the stuff available... Im just wondering if I have to do
something to tell it that I am on a different server...
I've restored the controlfile mannually before but on the same server. I backup
DENNIS...Thanks for your feedback. Here it is.. (NSF problem??)
1. I am not using Tape only disk backups..
2. I ftp'd the backup pieces to new machine
3. I created a link to duplicate the backup location on the original machine
and other locations as pfiles...edited the init file for new
Brian - I think that is the problem -- you can't tell RMAN you are on a
different server. The part I'm not getting a clear picture on is your
control file. For this specific recovery, how is it getting a control file?
Did you move one over from production, or are you waiting for RMAN to cough
it
Brian - My sys admin pleads amnesia on the NFS problem. My recollection was
that it was misconfigured or had a default configuration that expected only
a couple of connections and RMAN actually opens MANY file connections. My
specific symptoms is that RMAN would create the first few data files and
Dennis and all,
I have no problem getting the controlfile... I just comment out the SET commands to
change the directories of the dbfs...and I replicate the control according to the init
file specifications.. So This operation actually extract the controlfile out of the
backup piece so I
why not use the RMAN duplicate database process. that sounds like what you
are trying to do. Have you ever let the script run to completion? Maybe its
slow for another reason. I have used duplicate database on Solaris many
times with great success.
Josh
-Original Message-
Sent: Monday,
I did this exercise a few months ago and created some rough
but detailed docs that you may find helpful.
http://www.cybcon.com/~jkstill/Alternate_Client_Restore_With_Veritas_NetBackup_and_Oracle_RMAN.doc
Jared
On Fri, 2003-12-05 at 14:14, Spears, Brian wrote:
Goal: To restore the database
Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
1. You say you connected to your
How did you expect the restore to work w/o first restoring the
controlfile? or am i missing something here?
joe
Spears, Brian wrote:
*Goal:* To restore the database from RMAN backup on a different
server by means of moving the backup pieces and logs over to the new
machine and use Rman to
Title: Message
By default RMAN restores the backup to the
machine from where it is backedup. If you need to restore the backup on to
alternate client, your netbackup admin has to setup the access. You have not mentioned
whether you are using Netbackup or legato or something else. Once the
Title: Message
I am sorry, I thought you are restoring
from Tape. In either case, you connect to target and catalog database on the
new server and see if you can access the backups that were backed up on the
original server.
-- Janardhana
-Original Message-
From: Spears,
Title: Message
May be you try the following:
If you get errors restoring controlfile, You
may ftp the controlfiles manually to the new server and startup mount the
database first. Then, Try your restore database.
-- Janardhana
-Original Message-
From: Spears, Brian
Janardhana - That's a good point.
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
I suppose just how much redundancy makes you sleep well is up to you. But,
one additional bit of info to keep in mind is that the backup info also gets
stored in the control files, and rman can use those too if no catalog
database is available. Making a copy of a control file after the backup
I do not think you need 2 Rman catalogs.
Build a small database just for Rman. After the daily backup finished bring
it down and do os level backup of all the environment for this small backup.
You can then easily restore it in case of disk problems.
Remember: A backup is good only when you can
i must have misread the docs. i thought it was either catalog or control file. didnt
know you could do both
thanks.
From: [EMAIL PROTECTED]
Date: 2003/12/04 Thu AM 11:04:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RMAN questions
I suppose just how
backup of all the environment for this small backup.
It should have been: for this small database.
Sorry about the mistake.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 6:44 PM
I do not think you
Hi Ramon,
I guess you are on 8i :
your setsize and fileperset specs should be
inside the backup command not outside i.e.
something like this :
backup
fileperset 2
setsize 2000
database
Randy
First, you may want to investigate your company's attitude toward
recovering their proprietary data on your personal machine.
I can give you some ideas on your task, but my experience is on 1)Unix,
and 2) Oracle 8i.
I would recommend you purchase Robert Freeman's book Oracle9i RMAN
More food for thought:
There is a good chance that the hardware platform is different. I
think that RMAN is not a valid way of changing to a new platform and you
would need to export/import. I'm certain the experts on the list will
correct me if I'm wrong.
Thanks
Stephen
[EMAIL PROTECTED]
Good catch Stephen. My understanding is that you
-Original Message-
Sent: Monday, November 24, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
More food for thought:
There is a good chance that the hardware platform is different. I
think that RMAN is not a valid way of changing
My apologies, I bumped the send button.
Stephen - my understanding is that you are correct, the platforms have to be
the same at the binary level - i.e.., both Solaris, both Windows, etc.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, November 24,
Wait till 10g.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 24, 2003 11:29 PM
My apologies, I bumped the send button.
Stephen - my understanding is that you are correct, the platforms have to
be
the same at the binary
Sami,
RMAN connects as SYSDBA. The password may actually be different.
The good one is that works
SQLconnect sys/[EMAIL PROTECTED] as SYSDBA
HTH
Vadim
-Original Message-
Sent: Tuesday, November 04, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
string
Hi list,
I have
Sami - You may also need to create an orapw file in order to connect as
SYSDBA remotely.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, November 04, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
str
Sami,
RMAN connects as SYSDBA. The
IF you set your ORACLE_SID to the target database as the Oracle user, all
you have to do is say RMAN connect target and it will automatically
connect. If you are working from the command line you connect
user_with_sysdba_privs/[EMAIL PROTECTED] and you will be connected. If
does not recognize
Tamizh,
You are probably running out of space in the file-system you
were located within when you invoked RMAN. It would be
better to specify a full path-name in the FORMAT= clause
(i.e. specify directory as well as filename), to make sure
that the file-system where you are creating the
Have you ever considered purchasing Robert Freeman's RMAN book?
If memory serves me right, it does describe MAXPIECESIZE option
to configure and allocate channel commands.
On 10/30/2003 10:04:32 AM, [EMAIL PROTECTED] wrote:
Hi List,
How to fix this error without changing something in OS
Tamizh,
To set the limit on the size of the output file use
set limit channel d1 kbytes=30; for a 3 gig file .
Ron
[EMAIL PROTECTED] 10/30/03 10:04AM
Hi List,
How to fix this error without changing something in OS level? Is tehre
any command to set max block size in RMAn before we do
It looks like you need to SET LIMIT ... for the channel allocation, if
8i, to less than 2GB. In 9i this can be set with MAXSETSIZE (not sure if
SET LIMIT is still supported in 9i).
Note that you cannot back up a file larger than the SET LIMIT size, so
based on your ulimit command I assume
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
Michal,
Are you using partitioning, and if so, are there
tablespaces you can set to read only?
If so, then you only need to back up the read only
tablespaces often enough that your backup software
retention time doesn't cause the RO TBS's to all be
aged out.
This could eliminate a lot of backup
Michael,
I hope you have the tables partitioned on some date
column. You can make some of the older partitions read only and back them up
only once.
Another solution is to exchange the partitions with
a table to convert your old partitions to tables, transporting them to a tape
and keep
Title: Re: RMAN Incremental
Michael,
Another good treatment of the use of partitioning in DW to reduce backups is a paper by Jeff Maresh posted online at http://www.EvDBT.com/papers.htm, entitled Managing the Data Lifecycle.
-Tim
on 10/24/03 4:34 PM, Michael Kline at [EMAIL PROTECTED] wrote
I consider a 20242 error as an acceptable one, here is why:
If i ask rman to backup archivelogs that are more than 2days old and
there are none, thats not an error. That is when i see it the most, now
most companies will force a log switch after a set amount of time during
the day so in DR,
Title: Message
Can
you figure out what to name the pipe in advance? Is there a way to reliably
determine what file name RMAN will create?
-Original Message-From: laura pena
[mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30,
2003 8:45 AMTo: Multiple recipients of list
I can use mknod and create a named pipe a head of time.
I do this when I use the exp or imp utilites (just wondering if I can do same with RMAN):
==
export EXP_DIR="/oracle/export"export PIPE_DIR="/oracle/export"export
I dont
think you can compress rman files while backups are running. RMAN doesnt support
external compression while backups are running 'cause RMAN has to validate
backups. You can compress all the files once your backup is completed. I tried
that in the past but didnt work. Infect thereare
/dev/vx/rdsk/dbdg13/Rcatctrl.ctl
Does this directory exist, does Oracle have priv's on it? Does the file
already exist, and of so who owns it and what are the privs?
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/25/2003 12:39 PM
Hi List,
Does anyone come
Hi Robert,
The directory does not exist. I am just trying to
register the database(RMANregister database).
My question is...
from where did it pick up the name of
the control file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl.
Also i tried the same operation(register database) for
different database which
Make sure that your oracle service is stopped and started correctly. If you
can't mount the database, it may be that your oracle service has started
incorrectly and is holding locks on the files that your instance needs in
order for it to mount.
Then check the alert log for more information.
Denham
Whether you need to back up the control file depends on whether you can
recover the database without it. On Oracle8i, I gave up trying to extract
the controlfile from the RMAN backup, and simply back the controlfile up
after the backup completes. Others on this list have reported they
It's so much easier to include an sql alter database backup controlfile
to filename;
in the rman script.
Backup the Database first.
Then backup the archive logs.
Then backup the controlfile.
Hemant
At 06:54 AM 18-09-03 -0800, you wrote:
Denham
Whether you need to back up the control file
I always backup the controlfile as a separate statement AFTER the back
is done so hopefully the backup i just completed is in there :)
joe
Denham Eva wrote:
Hello
Wondering about this. If backing up the database with RMAN in NOCATALOG
mode.
When would be the best time to do backup of the
Hi!
Denham
Whether you need to back up the control file depends on whether you can
recover the database without it. On Oracle8i, I gave up trying to extract
the controlfile from the RMAN backup, and simply back the controlfile up
after the backup completes. Others on this list have
me too. learned this from testing Rman back in 8.1.6. plus, you need this
control file to recover from to get as late (most recent) timestamp as
possible for recovery purposes.
-Original Message-
Sent: Thursday, September 18, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
I
No, controlfile is irrelevant as long as you got your physical structure
somewhere (eg. controlfile trace) and all your redologs intact. You just
recover using backup controlfile then (which means whatever controlfile
you got, ignore it's checkpoint progress and other SCN information). That
way
All,
I also backup the control file as the last step within the backup and use
the PL/SQL procedure within the documentation to restore the control file
manually if needed - I think 9i has this in RMAN now.
I found this was necessary if you wanted to get the last change from your
backup and
It looks like you don't have your ORACLE_SID specified correctly since, if I
read this correctly, the database you are trying to restore is on dick c:.
Set you ORACLE_SID which will be the target and try again.
HTH,
Ruth
p.s I do not have any databases on Windows so I am not sure how to set the
Ruth,
Set you ORACLE_SID which will be the target and try again.
c: set ORACLE_SID=AUX92
AUX92 is the name of my auxiliary instance on Host A ( target host ).
c: rman target [EMAIL PROTECTED] catalog [EMAIL PROTECTED] auxiliary sys
trace=c:\tspitr.log
where PE92 is the target on same Host A
There is no MSSQL utility that is directly
equivalent to RMAN. You use Enterprise Manager or Query Analyzer to manage
backups.
Gudmundur
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, September 16, 2003 9:39
You can actually use Database Maintenance Plans, to mimic RMAN to a certain
extent. Database Maintenance Plans is basically a wizard that generates a
load of MSDB jobs that get run by the SQL*Agent. This does have some
limitations though. It has no support for differential backups, doesn't
support
This
beast does not exist. You can use the Database Maintenance Plans in EM to
manage your backups. I have found these to be flaky and prefer writing my
own custom backup plans in scripts and schedule these as jobs. >From my
experience on SQL Server I recommend doing a native SQL Server
Prem - I haven't found anything significant online. Perhaps someone else
(Bwill point to a resource. If you want to learn RMAN, my recommendation is to
(Bget a couple of books. The advantage of a book is you end up with a
(Bcomprehensive 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.
--
Brian
I think that is about the performance we get. Maybe faster than what we
get.
One idea would be to
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
copy some big files using file system commands like cp and see what the
ok... I just hanging on here...don't let me fall...
what ..what?
Brian :)
-Original Message-
Sent: Thursday, August 21, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L
Brian
I think that is about the performance we get. Maybe faster than what we
get.
One idea would be to
Brian
Sorry, the mail system mangled my message. It's all there, just part is
below the signature. Here it is again:
I think that is about the performance we get. Maybe faster than what we get.
One idea would be to copy some big files using file system commands like
cp and see what the
:52 AMTo:
'[EMAIL PROTECTED]'Cc: David WagonerSubject: RE: RMAN
Script Question
David,
Change the
following line in ur script :
backup database plus archivelog delete
input
to
backupincremental level = 0plus
archivelog delete input
Hth,
Samir
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
Dennis,
I have been admiring you from far. Thank you so much to reply to my email.
The renamed data file has been tested and there is no corruption of any
kind. The nightly physical and logical backups were successful completed
with no error. However, I got an ora-19502 error when I
yes dennis.
this is what i am planning to do.
can you please mention the glitches and the parameters that have to be changed.
or some pointers from your implementaion which could be very useful.
thanks a lot
saiDENNIS WILLIAMS [EMAIL PROTECTED] wrote:
SaiAre you planning to do a RMAN backup
Anne
What version of Oracle is this?
Okay, you renamed a production database file 10 days ago. Since then,
has Oracle been able to use this file? Can you export the table that is
stored on this file without error? Have you examined your RMAN backup log to
ensure this file is specifically
Title: RMAN Script Question
David,
Change the
following line in ur script :
backup database plus archivelog delete
input
to
backupincremental level = 0plus
archivelog delete input
Hth,
Samir
Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 -
1 - 100 of 814 matches
Mail list logo
