RE: RMAN question.... (figured out if anywone is interested)....w
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 '/oracle_backup/ASTU/%U' include current controlfile;
..places the contrlofile in the specified directory along with all other backup pieces.
Thanks for all input.
Chris
And now for the next step...
.anyone have a script handy to query the catalog directly and validate all backups ran successfully and send the info of success/failure in an email?
.Thanks!
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 01, 2003 8:29 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RMAN question
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
format. I also notice the dates on the mystery files are today's date, so
something must have written to them. Did the size change as well? Is there
any possibility that another backup script is running? Maybe a cron job from
another userid. Have you verified that your RMAN backup files are getting
created in the expected location? You could also check the catalog for
additional backups. And just to be sure, you might connect to the target
database alone and check for backups. A record of recent backups are stored
in the controlfile even if you are using a catalog.
Glad you are enjoying Lawson's book.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 01, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L
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' was because it would help me figure out what
those mystery files are for. I just checked the directory and there are 3
more files with similar names corresponding to the 3 databases we back up on
that machine. I need to talk to the other DBA and find out if he has been
manually deleting them because I haven't noticed this and we have been using
RMAN for over a month now.
In addition, I don't believe these are the snapshot control files as there
are 3 other files in $ORACLE_HOME/dbs named:
-rw-r- 1 oracle dba 41213952 Apr 1 00:35 snapcf_ASTU.f
-rw-r- 1 oracle dba 14376960 Apr 1 00:08 snapcf_PRD1.f
-rw-r- 1 oracle dba 16281600 Apr 1 00:36 snapcf_PRD2.f
The files in question are:
-rw-r- 1 oracle dba 16290816 Apr 1 00:36 26eje5g8_1_1
-rw-r- 1 oracle dba 14394368 Apr 1 00:08 28eje3r5_1_1
-rw-r- 1 oracle dba 41231360 Apr 1 00:35 2seje5e5_1_1
They seem to have corresponding file sizes. I just don't see what statement
in my simple little scripts would cause the files to be written there.
Again here is the backup script I use:
#!/bin/sh
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=ASTU
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/
rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman EOF
set dbid=1337318309
connect target
connect catalog rman_cat/[EMAIL PROTECTED]
run{
allocate channel d1 type disk;
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
}
sql alter system switch logfile;
sql alter system archive log all;
sql alter database backup controlfile to trace;
sql alter database backup controlfile to
''/oracle_backup/ASTU/astu_ctl'';
exit;
EOF
#
Thanks for the input Dennis!!
Ps. I read your review of The Art and Science of Oracle Performance Tuning
on amazon and decided to give it a try myself. I'm about 60 pages into it.
It is easily the best read of any Oracle text I have come across. I
definitely agree it belongs on everyone's bookshelf!!!
[Chris Stephens]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RMAN question.... (figured out if anywone is interested)....w
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: Wednesday, April 02, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Apparently the command:
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
..places the controlfile in $ORACLE_HOME/dbs, but:
backup database format '/oracle_backup/ASTU/%U' include current controlfile;
..places the contrlofile in the specified directory along with all
other backup pieces.
Thanks for all input.
Chris
And now for the next step...
.anyone have a script handy to query the catalog directly and validate
all backups ran successfully and send the info of success/failure in an
email?
.Thanks!
-Original Message-
mailto:[EMAIL PROTECTED] ]
Sent: Tuesday, April 01, 2003 8:29 AM
To: Multiple recipients of list ORACLE-L
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
format. I also notice the dates on the mystery files are today's date, so
something must have written to them. Did the size change as well? Is there
any possibility that another backup script is running? Maybe a cron job from
another userid. Have you verified that your RMAN backup files are getting
created in the expected location? You could also check the catalog for
additional backups. And just to be sure, you might connect to the target
database alone and check for backups. A record of recent backups are stored
in the controlfile even if you are using a catalog.
Glad you are enjoying Lawson's book.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 01, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L
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' was because it would help me figure out what
those mystery files are for. I just checked the directory and there are 3
more files with similar names corresponding to the 3 databases we back up on
that machine. I need to talk to the other DBA and find out if he has been
manually deleting them because I haven't noticed this and we have been using
RMAN for over a month now.
In addition, I don't believe these are the snapshot control files as there
are 3 other files in $ORACLE_HOME/dbs named:
-rw-r- 1 oracle dba41213952 Apr 1 00:35 snapcf_ASTU.f
-rw-r- 1 oracle dba14376960 Apr 1 00:08 snapcf_PRD1.f
-rw-r- 1 oracle dba16281600 Apr 1 00:36 snapcf_PRD2.f
The files in question are:
-rw-r- 1 oracle dba16290816 Apr 1 00:36 26eje5g8_1_1
-rw-r- 1 oracle dba14394368 Apr 1 00:08 28eje3r5_1_1
-rw-r- 1 oracle dba41231360 Apr 1 00:35 2seje5e5_1_1
They seem to have corresponding file sizes. I just don't see what statement
in my simple little scripts would cause the files to be written there.
Again here is the backup script I use:
#!/bin/sh
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=ASTU
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/
rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman EOF
set dbid=1337318309
connect target
connect catalog rman_cat/[EMAIL PROTECTED]
run{
allocate channel d1 type disk;
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
}
sql alter system switch logfile;
sql alter system archive log all;
sql alter database backup controlfile to trace;
sql alter database backup controlfile to
''/oracle_backup/ASTU/astu_ctl'';
exit;
EOF
#
Thanks for the input Dennis!!
Ps. I read your review of The Art and Science of Oracle Performance Tuning
on amazon and decided to give it a try myself. I'm about 60 pages into it.
It is easily the best read of any Oracle text I have come across. I
definitely agree it belongs on everyone's bookshelf!!!
[Chris Stephens]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
RE: RMAN question....
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' was because it would help me figure out what those mystery files are for. I just checked the directory and there are 3 more files with similar names corresponding to the 3 databases we back up on that machine. I need to talk to the other DBA and find out if he has been manually deleting them because I haven't noticed this and we have been using RMAN for over a month now.
In addition, I don't believe these are the snapshot control files as there are 3 other files in $ORACLE_HOME/dbs named:
-rw-r- 1 oracle dba 41213952 Apr 1 00:35 snapcf_ASTU.f
-rw-r- 1 oracle dba 14376960 Apr 1 00:08 snapcf_PRD1.f
-rw-r- 1 oracle dba 16281600 Apr 1 00:36 snapcf_PRD2.f
The files in question are:
-rw-r- 1 oracle dba 16290816 Apr 1 00:36 26eje5g8_1_1
-rw-r- 1 oracle dba 14394368 Apr 1 00:08 28eje3r5_1_1
-rw-r- 1 oracle dba 41231360 Apr 1 00:35 2seje5e5_1_1
They seem to have corresponding file sizes. I just don't see what statement in my simple little scripts would cause the files to be written there.
Again here is the backup script I use:
#!/bin/sh
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=ASTU
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/
rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman EOF
set dbid=1337318309
connect target
connect catalog rman_cat/[EMAIL PROTECTED]
run{
allocate channel d1 type disk;
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
}
sql alter system switch logfile;
sql alter system archive log all;
sql alter database backup controlfile to trace;
sql alter database backup controlfile to
''/oracle_backup/ASTU/astu_ctl'';
exit;
EOF
#
Thanks for the input Dennis!!
Ps. I read your review of The Art and Science of Oracle Performance Tuning on amazon and decided to give it a try myself. I'm about 60 pages into it. It is easily the best read of any Oracle text I have come across. I definitely agree it belongs on everyone's bookshelf!!!
[Chris Stephens]
RE: RMAN question....
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
format. I also notice the dates on the mystery files are today's date, so
something must have written to them. Did the size change as well? Is there
any possibility that another backup script is running? Maybe a cron job from
another userid. Have you verified that your RMAN backup files are getting
created in the expected location? You could also check the catalog for
additional backups. And just to be sure, you might connect to the target
database alone and check for backups. A record of recent backups are stored
in the controlfile even if you are using a catalog.
Glad you are enjoying Lawson's book.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 01, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L
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' was because it would help me figure out what
those mystery files are for. I just checked the directory and there are 3
more files with similar names corresponding to the 3 databases we back up on
that machine. I need to talk to the other DBA and find out if he has been
manually deleting them because I haven't noticed this and we have been using
RMAN for over a month now.
In addition, I don't believe these are the snapshot control files as there
are 3 other files in $ORACLE_HOME/dbs named:
-rw-r- 1 oracle dba41213952 Apr 1 00:35 snapcf_ASTU.f
-rw-r- 1 oracle dba14376960 Apr 1 00:08 snapcf_PRD1.f
-rw-r- 1 oracle dba16281600 Apr 1 00:36 snapcf_PRD2.f
The files in question are:
-rw-r- 1 oracle dba16290816 Apr 1 00:36 26eje5g8_1_1
-rw-r- 1 oracle dba14394368 Apr 1 00:08 28eje3r5_1_1
-rw-r- 1 oracle dba41231360 Apr 1 00:35 2seje5e5_1_1
They seem to have corresponding file sizes. I just don't see what statement
in my simple little scripts would cause the files to be written there.
Again here is the backup script I use:
#!/bin/sh
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=ASTU
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/
rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman EOF
set dbid=1337318309
connect target
connect catalog rman_cat/[EMAIL PROTECTED]
run{
allocate channel d1 type disk;
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
}
sql alter system switch logfile;
sql alter system archive log all;
sql alter database backup controlfile to trace;
sql alter database backup controlfile to
''/oracle_backup/ASTU/astu_ctl'';
exit;
EOF
#
Thanks for the input Dennis!!
Ps. I read your review of The Art and Science of Oracle Performance Tuning
on amazon and decided to give it a try myself. I'm about 60 pages into it.
It is easily the best read of any Oracle text I have come across. I
definitely agree it belongs on everyone's bookshelf!!!
[Chris Stephens]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RMAN question....
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 could happen if you did that. I could see backing
it up just to be safe. Was this a test database? Anyway I'm always willing
to learn.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, March 31, 2003 3:54 PM
To: Multiple recipients of list O d RACLE-L
List,
When I got into work this morning I noticed u01 was nearly full on out
production OLTP machine. I found the files and the looked to be RMAN files.
They were all in '$ORACLE_HOME/dbs/.' My first thought was that they were
the snapshot controlfiles. but aren't those automatically deleted? I
double checked the RMAN scripts I use to make sure nothing was explicitly
written there. They weren't. So I deleted those files. I next ran the
following on one of the databases:
RMAN run {
2 allocate channel d1 type disk;
3 restore database validate;
4 }
that returned successfully. (whew)
then:
RMAN run {
2 allocate channel d1 type disk;
3 restore controlfile validate;
4 }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=14 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08518: channel d1: scanning controlfile copy
/oracle_backup/ASTU/astu_ctl
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command:
IRESTORE
RMAN-07004: unhandled exception during command execution on channel d1
RMAN-10035: exception raised in RPC: ORA-00600: internal error code,
arguments:]
ORA-19600: input file is datafile copy 0 ()
RMAN-10031: ORA-600 occurred during call to
DBMS_BACKUP_RESTORE.SCANDATAFILECOPY
RMAN exit
YIKES!!
anybody have an idea why this would happen??
Here is the backup script that is used each night (it's the same for all 3
databases minus the changes is ORACLE_SID and sub-directories):
#!/bin/sh
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=ASTU
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/
rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman EOF
set dbid=1337318309
connect target
connect catalog rman_cat/[EMAIL PROTECTED]
run{
allocate channel d1 type disk;
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
}
sql alter system switch logfile;
sql alter system archive log all;
sql alter database backup controlfile to trace;
sql alter database backup controlfile to
''/oracle_backup/ASTU/astu_ctl'';
exit;
EOF
#
any and all help will be GREATLY appreciated. I won't be sleeping well
until I know the backup process is truly ok.
Thanks
Chris
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RMAN question
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 Message- Sent: 07 February 2003 11:39 To: Multiple recipients of list ORACLE-L Hi! How do I make RMAN delete all obsolete backups? We are using a recovery catalog. Example: RMAN report obsolete; RMAN-03022: compiling command: report Report of obsolete backups and copies Type KeyCompletion TimeFilename/Handle -- -- Backup Set 523573 29012003-16:19:33 Backup Piece 523575 29012003-16:19:33 03ee44q5_1_1 Backup Set 525544 31012003-03:47:24 Backup Piece 525546 31012003-03:47:24 06ee80te_1_1 Backup Set 525545 31012003-08:04:25 Backup Piece 525547 31012003-08:04:25 07ee8d2m_1_1 Backup Set 526282 01022003-03:34:14 Backup Piece 526284 01022003-03:34:14 0aeealdg_1_1 Backup Set 526283 01022003-07:55:02 Backup Piece 526285 01022003-07:55:02 0beeb0m0_1_1 Backup Set 527884 04022003-03:52:28 Backup Piece 527886 04022003-03:52:28 0eeeiiig_1_1 Backup Set 527885 04022003-08:12:52 Backup Piece 527887 04022003-08:12:52 0feeius4_1_1 Backup Set 528851 05022003-03:51:41 Backup Piece 528853 05022003-03:51:41 0ieel6sk_1_1 Backup Set 528852 05022003-08:13:00 Backup Piece 528854 05022003-08:13:00 0jeelj6h_1_1 Backup Set 529486 06022003-03:43:12 Backup Piece 529488 06022003-03:43:12 0meenrds_1_1 Backup Set 529487 06022003-08:00:57 Backup Piece 529489 06022003-08:00:57 0neeo72i_1_1 Now I want to delete those obsolete backups... RMAN delete obsolete; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found obsolete: expecting one of: expired, script RMAN-01007: at line 1 column 9 file: standard input What would be the correct syntax? This is 8.1.7 on solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Question
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 backup files if they already exist. Example generating backup files with the same names each time. Thans Kamel B. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman question(allocating channels)
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 - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 28, 2002 8:38 AM Subject: rman question(allocating channels) I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal), then does it make sense to allocate multiple channels? Are multiple channels related to CPUs or to destinations? thanks, joe
Re: rman question(allocating channels)
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 recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 8:38 AM I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal), then does it make sense to allocate multiple channels? Are multiple channels related to CPUs or to destinations? thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman question(allocating channels)
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 makes sense. Best thing is to try it out and compare timings. Ade -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: 28 August 2002 13:38To: Multiple recipients of list ORACLE-LSubject: rman question(allocating channels) I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal), then does it make sense to allocate multiple channels? Are multiple channels related to CPUs or to destinations? thanks, joe -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
RE: rman question(allocating channels)
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 channels (lets say 4 channel) you can write to take or disk with 4 streams at the same time, which means that you will be able to backup more datafiles concurrently. No channels are not related to CPU or destinations. Yes it makes sense that you allocate more channels because it will shorten you backup time but then again the more channels you use the more resources you will be using on the server that you are backing up the database. I hope this answers your question but if not please let me know. P.S. Each channel willcorrespond toa session in the database that is being backed up. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 28, 2002 8:38 AMTo: Multiple recipients of list ORACLE-LSubject: rman question(allocating channels) I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal), then does it make sense to allocate multiple channels? Are multiple channels related to CPUs or to destinations? thanks, joe
RE: rman question(allocating channels)
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 set a little low so that it doesn't tend to interfere with normal production. If this is true, you might either try increasing the RATE parameter, or allocating a second channel. Of course, if your Oracle is being used during the backup, increasing the I/O for RMAN may interfere with the users. 4) One issue is the read side of the RMAN backup process. The bottleneck may be in reading data blocks, no just writing them. In the worst case you have a single-disk Oracle system so RMAN is reading and writing to/from the same drive. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 28, 2002 7:38 AM To: Multiple recipients of list ORACLE-L I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal), then does it make sense to allocate multiple channels? Are multiple channels related to CPUs or to destinations? thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN QUestion
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 Freeman, Robert Robert_Freeman@cTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sx.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RMAN QUestion [EMAIL PROTECTED] 21-06-2002 18:47 Please respond to ORACLE-L Sorry, posted using wrong subject header, DUH! Use the following Exhibit to answer this question (note: This is not a hacked OCP question. This question came about out of the experience of one of our junior DBA's that I had to come in and figure out...Several Sr. DBA's that I know have gotten it wrong already... but we got some smart fokls here! :-) RMAN backup. Autobackup of control file is not enabled. Time a - Backup of database Time b - Archivelog Backups Time c - Drop tablespace Time d - Archivelog Backup To restore successfully, with RMAN (no manual fiddling) to time point b, you will first need to restore a control file. Which backup would you want to restore the control file from... (more than one answer may well be correct, I'm not telling). a. Control file from point a b. Control file from point b c. Control file from before point c d. Control file from after point c e. Control file from point d f. Recovery is not possible. I'll reveal the answer in the next 2 days...(and this *IS* a trick question, so think carefully). Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en
Re: RMAN QUestion
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 (note: This is not a hacked OCP question. This question came about out of the experience of one of our junior DBA's that I had to come in and figure out...Several Sr. DBA's that I know have gotten it wrong already... but we got some smart fokls here! :-) RMAN backup. Autobackup of control file is not enabled. Time a - Backup of database Time b - Archivelog Backups Time c - Drop tablespace Time d - Archivelog Backup To restore successfully, with RMAN (no manual fiddling) to time point b, you will first need to restore a control file. Which backup would you want to restore the control file from... (more than one answer may well be correct, I'm not telling). a. Control file from point a b. Control file from point b c. Control file from before point c d. Control file from after point c e. Control file from point d f. Recovery is not possible. I'll reveal the answer in the next 2 days...(and this *IS* a trick question, so think carefully). Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN 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 (Oracle 8.1.7 under NT). Following Oracle docs (Server Backup and Recovery Guide), at one step (2) there is a reference to a script '@?/rdbms/admin/catrman', to create the recovery catalog, but I didn't find it ! Is there any missing on my Oracle installation ? Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Question
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 will respond. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Hi ALL, I want to use RMAN (Oracle 8.1.7 under NT). Following Oracle docs (Server Backup and Recovery Guide), at one step (2) there is a reference to a script '@?/rdbms/admin/catrman', to create the recovery catalog, but I didn't find it ! Is there any missing on my Oracle installation ? Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Question
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 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 will respond. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Hi ALL, I want to use RMAN (Oracle 8.1.7 under NT). Following Oracle docs (Server Backup and Recovery Guide), at one step (2) there is a reference to a script '@?/rdbms/admin/catrman', to create the recovery catalog, but I didn't find it ! Is there any missing on my Oracle installation ? Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Question
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; # Limit sets to 1 Gb.
set limit channel ch2 kbytes=100;
# filesperset is used to avoid O R A-04030
backup full database
filesperset=4
tag='daily_full_backup';
allocate channel ch3 type disk format '/bkup5/oracle/%d/arc_s%s_p%p_%t';
allocate channel ch4 type disk format '/bkup1/oracle/%d/arc_s%s_p%p_%t';
set limit channel ch3 kbytes=100;
set limit channel ch4 kbytes=100;
backup filesperset=20
(archivelog from time 'sysdate-12/24'
channel ch3
)
(archivelog until time 'sysdate-12/24' delete input
channel ch4
);
}
The reason that we use RMAN to backup our archive logs is so that we have a complete
backup on our tapes. We backup to disk, which is then backed up to tape. If I want
to restore my database from 3 weeks ago, I know that the tape from that day contains
all of the files I need to restore my database for that day. This is especially
important if I am restoring a hot backup or I am restoring to a specific point in time
(i.e. a point in time that is different from the backup time).
On a separate but related note, I previously posted a script which used SET UNTIL TIME
and TO_DATE. e.g.: #set until time to_date(0125200207,mmddhh24miss);
I obtained this from a note on MetaLink. It turns out that this doesn't work, due to
a bug (1887009). I found it mentioned on a forum under Doc ID: 180832.995. It is
supposedly fixed in 9.0.2. The workaround is to use NLS_DATE_FORMAT. Be sure to set
NLS_LANG as well, otherwise NLS_DATE_FORMAT is ignored (at least on 8.1.7 on Tru64).
Jay Hostetter
Oracle DBA
D. E. Communications
Ephrata, PA USA
[EMAIL PROTECTED] 02/21/02 04:58PM
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 that RMAN leaves
the archive logs on disk after it has backed them up. Also, I believe but
have not tested this, that in case of a recovery, RMAN first looks to the
original unarchived disk location for the archive logs and if it can't find
them there, it will retrieve them from its backup location (disk file or
tape if you are using a media manager), and put them where they should be,
then continue the recovery.
After thinking about this, I decided that using RMAN to backup the
archive logs wasn't buying me anything. Just making my setup more
complicated. If I was backing up to a media manager, then having RMAN back
up the archive logs would be great because it would be moving them to tape.
As it is, RMAN isn't compressing them before moving them to disk. My regular
nightly tape backup will give me a safety copy on tape. If I feel I need a
disk copy, I will just compress the files to another location and end up
with something significantly smaller. If I have overlooked something in my
logic, please point that out to me because I am just beginning to learn RMAN
and am frequently interrupted by other DBA duties, so learning is going very
slowly.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, February 21, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
Greetings,
We are at Oracle 8.1.7 on Sun Solaris 7.
Can we backup all the archive logs at any point of time but not deleting all
these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1)
in the disk so that we don't need to restore the archive logs from rman
backup in case of some recovery up to point within last 2 days.
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandal, Ashoke
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing
Re: RMAN Question
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 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 that RMAN leaves the archive logs on disk after it has backed them up. Also, I believe but have not tested this, that in case of a recovery, RMAN first looks to the original unarchived disk location for the archive logs and if it can't find them there, it will retrieve them from its backup location (disk file or tape if you are using a media manager), and put them where they should be, then continue the recovery. After thinking about this, I decided that using RMAN to backup the archive logs wasn't buying me anything. Just making my setup more complicated. If I was backing up to a media manager, then having RMAN back up the archive logs would be great because it would be moving them to tape. As it is, RMAN isn't compressing them before moving them to disk. My regular nightly tape backup will give me a safety copy on tape. If I feel I need a disk copy, I will just compress the files to another location and end up with something significantly smaller. If I have overlooked something in my logic, please point that out to me because I am just beginning to learn RMAN and am frequently interrupted by other DBA duties, so learning is going very slowly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 21, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Greetings, We are at Oracle 8.1.7 on Sun Solaris 7. Can we backup all the archive logs at any point of time but not deleting all these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) in the disk so that we don't need to restore the archive logs from rman backup in case of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Question
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 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 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 that RMAN leaves the archive logs on disk after it has backed them up. Also, I believe but have not tested this, that in case of a recovery, RMAN first looks to the original unarchived disk location for the archive logs and if it can't find them there, it will retrieve them from its backup location (disk file or tape if you are using a media manager), and put them where they should be, then continue the recovery. After thinking about this, I decided that using RMAN to backup the archive logs wasn't buying me anything. Just making my setup more complicated. If I was backing up to a media manager, then having RMAN back up the archive logs would be great because it would be moving them to tape. As it is, RMAN isn't compressing them before moving them to disk. My regular nightly tape backup will give me a safety copy on tape. If I feel I need a disk copy, I will just compress the files to another location and end up with something significantly smaller. If I have overlooked something in my logic, please point that out to me because I am just beginning to learn RMAN and am frequently interrupted by other DBA duties, so learning is going very slowly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 21, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Greetings, We are at Oracle 8.1.7 on Sun Solaris 7. Can we backup all the archive logs at any point of time but not deleting all these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) in the disk so that we don't need to restore the archive logs from rman backup in case of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
RE: RMAN Question
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 that RMAN leaves the archive logs on disk after it has backed them up. Also, I believe but have not tested this, that in case of a recovery, RMAN first looks to the original unarchived disk location for the archive logs and if it can't find them there, it will retrieve them from its backup location (disk file or tape if you are using a media manager), and put them where they should be, then continue the recovery. After thinking about this, I decided that using RMAN to backup the archive logs wasn't buying me anything. Just making my setup more complicated. If I was backing up to a media manager, then having RMAN back up the archive logs would be great because it would be moving them to tape. As it is, RMAN isn't compressing them before moving them to disk. My regular nightly tape backup will give me a safety copy on tape. If I feel I need a disk copy, I will just compress the files to another location and end up with something significantly smaller. If I have overlooked something in my logic, please point that out to me because I am just beginning to learn RMAN and am frequently interrupted by other DBA duties, so learning is going very slowly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 21, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Greetings, We are at Oracle 8.1.7 on Sun Solaris 7. Can we backup all the archive logs at any point of time but not deleting all these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) in the disk so that we don't need to restore the archive logs from rman backup in case of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN question
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 should look at to uniquely identify a backup set. shown below is the output of the RMANlist backup set of database; List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 378 16 452962659 0 452962651 20 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 379 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/rman/df_BKUPTEST_20_452962651_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 Full 142896 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 384 17 452970568 0 452970560 21 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 385 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_21_452970560_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 Full 142925 04-FEB-02 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0 Full 142925 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 389 18 452971072 0 452971064 23 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 392 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_23_452971064_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 2/ora/data01/bkuptest/dbfiles/temp.1.dbf 0 Full 162954 04-FEB-02 5/ora/data01/bkuptest/dbfiles/rollback.1.dbf 0 Full 162954 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 390 19 452971100 0 452971080 24 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 393 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_24_452971080_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 1/ora/data01/bkuptest/dbfiles/system.1.dbf 0 Full 162955 04-FEB-02 List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- - - 391 20 452971112 0 452971105 25 04-FEB-02 List of Backup Pieces Key Pc# Cp# Status Completion Time Piece Name --- --- --- --- -- - --- 394 1 1 AVAILABLE 04-FEB-02 /ora/backup/bkuptest/dbfiles/BKUPTEST_incr0_25_452971105_1.bkp List of Datafiles Included File Name LV Type Ckp SCNCkp Time - -- -- -- --- 3/ora/data01/bkuptest/dbfiles/admin.1.dbf 0 Full 162956 04-FEB-02 TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail
RE: rman question
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 fractured reads (which in turn necessitates full block redo logging during Hot backup mode). This also means that RMAN can recognize empty blocks and thus skip backup of these blocks - resulting in a small backup set in the beginning that grows with database usage and activity... Lots of interesting stuff / concepts can be found in the Recovery Manager user's guide and reference - a must read if you are planning to user RMAN. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, November 26, 2001 1:05 PM To: Multiple recipients of list ORACLE-L 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 to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman question
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 onwards! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, November 26, 2001 1:05 PMTo: Multiple recipients of list ORACLE-LSubject: rman question 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 to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
RE: rman question
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 November 2001 8:05 AMTo: Multiple recipients of list ORACLE-LSubject: rman question 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 to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
Re: rman question
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 to utilize rman for restore and sign in to sql*plus or svrmgrl to initiate the recovery? Any comments are appreciated. THanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A version:2.1 email;internet:[EMAIL PROTECTED] title:Infrastructure Specialist fn:Anjan Thakuria end:vcard
Re: rman question
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 my archive logs and delete them. We don't have enough room to keep them. This way the archive logs that I might need to restore and recovery from a particular backup are with that backup when I put it on tape. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 3:46 PM 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 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 Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman question
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 recreate control file to rename the reporting database? How rman deal with redo files if we use cold backup? (you know, I can do OS image copy for those files) Is that a tag name can include all the datafiles, control files and redo files image copies)? Joan Janardhana Babu wrote: 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 cases), it would restore the latest backupset with that tag. I haven't found anyother way to restore the old backup. Iam anxious to know if there is anyother possible solution from the list. -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Subject: rman question Hi Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman question
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 List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman question
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 Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman question
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 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 Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman question
Joan, I don't know about about cold backups but I have done this successfully with hot backups. What you can do is restore your hot backups ( could be old ones ) and do a point in time database recovery using rman 'duplicate database' command. It 's fairly straightforward. Dennis Meng Database Administrator Focal Communications 847-954-8328 Joan Hsieh joan.hsieh@tTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ufts.educc: Sent by: Subject: Re: rman question root@fatcity. com 07/13/01 09:10 AM Please respond to ORACLE-L 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 recreate control file to rename the reporting database? How rman deal with redo files if we use cold backup? (you know, I can do OS image copy for those files) Is that a tag name can include all the datafiles, control files and redo files image copies)? Joan Janardhana Babu wrote: 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 cases), it would restore the latest backupset with that tag. I haven't found anyother way to restore the old backup. Iam anxious to know if there is anyother possible solution from the list. -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Subject: rman question Hi Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
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 [EMAIL PROTECTED] 07/13/01 03:46PM 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 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 Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman question
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 cases), it would restore the latest backupset with that tag. I haven't found anyother way to restore the old backup. Iam anxious to know if there is anyother possible solution from the list. -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Subject: rman question Hi Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Question
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 tables/indexes seperate. I hope this helps -Original Message- Sent: 10 May 2001 18:16 To: Multiple recipients of list ORACLE-L DBAs, I have two of my tables and index in nologging mode as I am loading data using SQL*Loader direct path mode. I have scheduled RMAN hot backup everday. When I issue REPORT UNRECOVERABLE, I am getting both the Data and Index datafiles are unrecoverable. I know that I wont be able to recover the tables in nologging mode. What I would like to know is about the recovery possibility of other tables in logging mode. Will there be any problem during recovery as these datafiles are in unrecoverable status? TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: holders INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
