Title: RE: RMAN question (figured out if anywone is interested)with another question appended. :)
Apparently the command:
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
..places the controlfile in $ORACLE_HOME/dbs, but:
backup database format
Chris - Congratulations on finding your problem. I have the RMAN log file
emailed to me for each backup. This means more to look through. What you
describe doesn't sound hard though.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent:
Title: RE: RMAN question
Dennis,
I wasn't actually restoring the control file. Only 'validating' that RMAN could do it. I also backup the control file several other ways and would likely never ask RMAN to perform that function. The only reason I issued 'restore controlfile validate
Chris - Thanks. Sorry for the tirade, bad day, reading too fast, thinking
too slow. I checked my systems and I see the snapcf_SID.f files, one for
each database being backed up. I do not see the other files you mention. I
notice the mystery file names have a format quite close to your backup
Chris - Do you have any more details on the files you deleted that you felt
were snapshot control files? How large?
I may be incredibly stupid, but for the life of me I can't figure out why
you would ask RMAN to restore your controlfile from backup. Was it corrupt?
I would assume bad things
Helmut,
This thread came up a couple of days ago
The answers were to use the commands
change datafilecopy delete or change backuppiece delete
Also have a look at the script $ORACLE_HOME/rdbms/demo/rman1.sh to automate
the process from the output of report obsolete
HTH
John
-Original
No, you can't do that. I just run a OS job everyday which removes the old
backups to make room.
HTH,
Ruthg
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 30, 2002 5:28 AM
Hi ALL
Is there any way with RMAN to overwrite the
Joe,
I have the same situation.
I my case I used 2 channels, and
so around a 25-30% decrease in
thebackup time for a 30gb database.
Once I increased it to 3
channels
the payback was minimal. It also
became very cpu intensive,
so I kept the setting at 2.
- Original Message -
Rman channels are like processes, and you can have multiple channels writing
to one disk and reading from one disk in a restore, If your server has the
horsepower, then multiple channels will increase the speed of backups and
restores,
HTH,
Ruth
- Original Message -
To: Multiple
Joe,
We only write out to tapes, so one channel
equals one tape drive, each extra channel goes and gets another drive. Not too
sure about disks, I guess it depends on I/O bandwith. Two channels will be
faster than one, if the disk can cope with the input from two channels then
maybe it
Yep its me answering a question for you for
a change - I was able to bounce your questionoff of Dinis (our RMAN
guru)and he said: ( Yeah I could have pretended that I knew
the answer but I don't think you would have fallen for that!)
Channels are streams. Basically when you
have multiple
Joe -
1) Why do you feel writing RMAN backup to one disk is not ideal? Is it
the one disk, or disk vs. tape?
2) I would watch the I/O while it is running to see how close you are
coming to maxing out your I/O subsystem.
3) I suspect, but haven't investigated, that RMAN defaults are
Hi
Can autobackup of control file be NOT enabled?
If you do full database backup using RMAN you get the controlfile like it
or not, isn't it?
So i'd say a because with b you don't automatically get the controlfiles
Jack
I'll bite
I don't have a clue about RMAN and you say it is a trick question.
I think control files from time a and time b are the same and should work.
At 08:47 AM 6/21/2002 -0800, you wrote:
Sorry, posted using wrong subject header, DUH!
Use the following Exhibit to answer this question
THANK YOU
IT'S TRUE, I WAS USING A 8.0 ORACLE DOCS
REGARDS
K.Benlatreche
-Message d'origine-
De : GL2Z/ INF DBA BENLATRECHE [mailto:[EMAIL PROTECTED]]
Envoyé : mercredi 29 mai 2002 15:24
À : Multiple recipients of list ORACLE-L
Objet : RMAN Question
Hi ALL,
I want to use RMAN
Kamel - I believe you may be looking at old instructions. I think that
Oracle 8 used the catrman.sql script to create the recovery catalog schema,
but in 8i you use the RMAN command:
create catalog
I'm not sure because I never used RMAN with Oracle 8, perhaps someone more
knowledgeable
Dennis is correct. If you are on 8i you won't need the catrman.sql script.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 1:24 PM
Kamel - I believe you may be looking at old instructions. I think that
Oracle 8 used
You can tell RMAN to delete the archive files. We tell RMAN to keep the last 12 hours
on disk.
run
{
allocate channel ch1 type disk format '/bkup1/oracle/%d/full_s%s_p%p_%t';
allocate channel ch2 type disk format '/bkup5/oracle/%d/full_s%s_p%p_%t';
set limit channel ch1 kbytes=100; #
The following command will backup you archivelogs and then delete them if
the backup is successful.
(archivelog all
delete input);
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, February 21, 2002 4:58 PM
Ashoke
If I
Thanks to all of you, who provided your input on this issue. I will test it
and I will get in touch with you if I have any problem.
Ashoke
-Original Message-
Sent: Friday, February 22, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L
The following command will backup you
Ashoke
If I understand you correctly, you are using RMAN to backup to disk,
rather than to a media manager. You are asking whether you can archive these
in RMAN, plus leave them on disk so they are readily available for recovery.
I have used this configuration, and I have found
Use LV-- level
--- Sona [EMAIL PROTECTED] wrote:
Hi
if I take an incremental level 0 backups with RMAN
.How do I determine by
the list command if all these backups listed are of
the same backup set or
not.
I took a incremental level 0 backup with filesperset
2.
which is the column I
Lisa,
You must use RMAN for restore as the format of the backup pieces can be
understood only by RMAN. Since RMAN is an Oracle - internal process, it
reads the database a *DB* block (or multiples thereof) at a time, rather
than the OS read an *OS* block at at time which could result in
Title: rman question
If You
use RMAN to backup, you MUST use RMAN to restore. Once it is restored to the
regular files, you may use Svrmgrl to recover if this is comfortable to you.
But, recovery thru RMAN is easy, just one/two additional commands.Svrmgrl
is not avaialble from Oracle 9
Title: rman question
Hi,
Your
initial statement is correct. If you use rman to backup, you must use it to
restore/recover. All the rman backup sets are understandable only by
rman.
Cheers
Sujatha
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, 27
Yes,
That is, you can do both, let RMAN do it for you or apply the logs after
restoring them.
anjan
"Koivu, Lisa" wrote:
OK, this may be dumb. I was under the impression
that if you use rman to back up your database, you MUST use rman to restore
and recover.
Is this not true? Is it possible
You should backup all of the archivelogs if you are going to delete them and
maybe even if you are not. The redo logs contain data which is already in
the database when the backup is made so you don't need to back them up.
In my scripts I always to an 'archive log current' and backup all of
Janardhana,
Thanks, another question is that on same production machine we have FM
online production instance and reporting instance. We refresh reporting
database everynight. (shutdown production, cp datafiles..) Can I use
rman to restore all datafiles and redo files to reporting database and
I forgot about the second part. The answer is yes but I have never done it
successfully. Check the documentation.
Sorry I don't know more about this,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 12, 2001 5:35 PM
Hi Dear
You can so a cold backup with rman, the database will be in mount state to
do it. Just to a shutdown, startup mount and run a full of level 0 backup.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 12, 2001 5:35 PM
Hi
Ruth,
Cold bacpup should backup online redo files. Level 0 did'nt include
online redo files. If I do alter system archivelog current, should I
backup archive files as well? We are in archive mode.
Joan
Ruth Gramolini wrote:
You can so a cold backup with rman, the database will be in mount
joan.hsieh@tTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
ufts.educc:
Sent by: Subject: Re: rman question
Joan,
RMAN does not backup online redo files. If you take a cold backup, then restore it,
you need to issue an 'open database resetlogs'. These documents on MetaLink may be
helpful: Note: 61801.1 and Note: 106432.1.
Jay Hostetter
Oracle DBA
D. E. Communications
Ephrata, PA USA
Title: RE: rman question
You may try duplicate database with the dbname the same as test database using RMAN.
You may need to use the tag command while backing up sothat you can specify the tag while restoring, but, if more than one backupset available with the same tag (it is in most
Are the tables you are loading in direct mode in the same tablespace as your
other tables ?
If this is the case, then you will not be able to perform a complete
recovery on the tablespace
affecting the other logged tables. Whenever I have a mix like you have, some
logged and some not,
I keep the
35 matches
Mail list logo