Re: TDP ORACLE Backup
Hi,
sorry for the late answer, I hope these informations are still useful for you.
RMAN is able to restore to any Point Of Time on wich you have the backup.
There are many RMAN script options that can be used to set the Point of Time:
- until time 'date_string' wich specifies a time as an upper limit.
- until scn integer wich specifies an SCN as an upper limit.
- until logseq integer wich specifies a redo log sequence number as an upper
limit.
The until clause can be specified on the Restore and on the Recover commands
or, more usefull, with a Set command like the below script:
run
{
set until time "to_date('07-DEC-2004 09:00:00','DD-MON- HH24:MI:SS')";
allocate channel TsmCh1 type 'sbt_tape';
allocate channel TsmCh2 type 'sbt_tape';
restore database;
sql "alter database mount";
recover database;
sql "alter database open resetlogs";
}
As shown in the script, after a Point in Time recover the database must be
opened with the resetlogs option.
For all informations regarding this issue there is the Oracle manual:
Oracle8i Backup and Recovery Guide Release 8.1.5 - a67773.pdf
and the RedBook manual:
Backing Up Oracle Using Tivoli Storage Management - sg246249.pdf
Regards,
Mike Angel
Aix and Oracle System Engineer
-Messaggio originale-
Da: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] conto di
Pawel Wozniczka
Inviato: giovedl 21 ottobre 2004 11.09
A: ADSM-L@VM.MARIST.EDU
Oggetto: Re: TDP Oracle Restore
>Question is :
>when i go about restore, how would i know which backup is being restored..
the
>active backup?? what would i need to do to restore any inactive backup??
Hello
As far as I know "rman" always uses the latest available backupsets, and
there is no official and supported way to restore previous versions of a
database.
But, as usually, there is a trick that makes is possibile, I use it quite
frequently in order to test & verify my oracle-tdp backups.
The trick is based on the fact that if the "rman" finds that the latest
backupsets are marked "unavailable" it will search its database backwards
until available backupsets are found and those backupsets will be used for
restore operations.
To summarize:
a) change status of the rman backupsets that You do NOT want to be used to
unavailable (change backupset xxx unavailable)
b) restore database
c) change status of the rman backupsets that were modified in step "a" back
to available (change backupset xxx available)
To make it easier I created a shell/rman script. (It's strongly hard-coded
to my environment, but with a little effort can be adjusted to be useful in
other environments).
Please let me know whether You are interested, if yes I can send that script
and try to assist in customizing it.
kind regards
Pawel W.
[EMAIL PROTECTED]
Mike Angel
Unix and Tsm Specialist
-
Nuovo Yahoo! Messenger E' molto piy divertente: Audibles, Avatar, Webcam,
Giochi, Rubrica Scaricalo ora!
Re: TDP/ORACLE Backup
Yes there is a way to change this. By specifying the option: TDPO_AVG_SIZE n (where 'n' is the size estimate, in MB, you want TDP Oracle to use with the TSM Server) Using this option overrides any size that Oracle specifies and can cause other performance problems on the the TSM Server. However, this option is very useful if you are using compression and the TSM Server is up against the wall with regards to availabe storage space for backups. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] "Wholey, Joseph (IDS DM&DS)" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/06/2004 09:24 AM Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Re: TDP/ORACLE Backup Is it possible to change the estimated size? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Neil Rasmussen Sent: Monday, December 06, 2004 12:07 PM To: [EMAIL PROTECTED] Subject: Re: TDP/ORACLE Backup Keep in mind that TDP Oracle just passes on what Oracle/Rman asks it to. So for DB estimation, TDP Oracle uses the value that Oracle passes to it (which probably is overestimated). If compression is turned on then this value is grossly overestimated. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] "Wholey, Joseph (IDS DM&DS)" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/06/2004 08:08 AM Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject TDP/ORACLE Backup When running a TDP for Oracle backup, does TDP lock the estimated amount of the storage pool which it thinks it needs to complete the backup? If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
Re: TDP/ORACLE Backup
Is it possible to change the estimated size? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Neil Rasmussen Sent: Monday, December 06, 2004 12:07 PM To: [EMAIL PROTECTED] Subject: Re: TDP/ORACLE Backup Keep in mind that TDP Oracle just passes on what Oracle/Rman asks it to. So for DB estimation, TDP Oracle uses the value that Oracle passes to it (which probably is overestimated). If compression is turned on then this value is grossly overestimated. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] "Wholey, Joseph (IDS DM&DS)" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/06/2004 08:08 AM Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject TDP/ORACLE Backup When running a TDP for Oracle backup, does TDP lock the estimated amount of the storage pool which it thinks it needs to complete the backup? If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
Re: TDP/ORACLE Backup
Keep in mind that TDP Oracle just passes on what Oracle/Rman asks it to. So for DB estimation, TDP Oracle uses the value that Oracle passes to it (which probably is overestimated). If compression is turned on then this value is grossly overestimated. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] "Wholey, Joseph (IDS DM&DS)" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/06/2004 08:08 AM Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject TDP/ORACLE Backup When running a TDP for Oracle backup, does TDP lock the estimated amount of the storage pool which it thinks it needs to complete the backup? If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
Re: TDP/ORACLE Backup
Yes. And in my experience it tends to slightly overestimate what is needed. Maybe 5 or 10 % I have seen, depends a lot on the Oracle DB size and version I think. I guess it's better to overestimate than underestimate. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5509 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 12/06/2004 11:08:24 AM >>> When running a TDP for Oracle backup, does TDP lock the estimated amount of the storage pool which it thinks it needs to complete the backup? If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/ ## This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ##
Re: TDP Oracle backup/restore question
Most likely the backed up data is all on one tape, and could therefore
be considered a "single threaded" process (my analogy).
To be able to multiple simultaneous restore sessions, the client
must be sent to a storage pool with collocation, or in the case of
RMAN which is just ONE filespace to TSM server, go directly to
tape - and you must have enough tape drives etc to do this.
Quick answer.
David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH 321.434.5536
Pager 321.634.8230
Fax:321.434.5509
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 08/21/03 03:55PM >>>
Our environment:
IBM AIX 4.3.3
TDP- Oracle 2.2.0
Oracle Database 8.1.7.4
Question:
We are using Oracle RMAN with Tivoli for our backups. In our RMAN scripts
we defined 5 Channels to use for backups. It takes about one and half hours
to complete the backups.
During the Database recovery process, we are using 5 channels. All the time
only one channel is active restoring files and rest of the channels will be
waiting on the current active channel to complete. It's taking about six to
seven hours for the database restore to complete.
Any one had previous experience with RMAN/Tivoli, waiting for allocating
channels during the restore process?
RMAN backup script:
===
run {
sql 'alter system archive log current';
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
allocate channel t3 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
allocate channel t4 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
allocate channel t5 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
backup tag='UFOM_20030731164207' filesperset 3
format "dbase%d_%u"
(database);
backup current controlfile;
sql 'alter system archive log current';
backup filesperset 10 archivelog all delete input ;
backup current controlfile;
}
RMAN Restor script:
==
run {
set until logseq 5029 thread 1;
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
allocate channel t3 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
allocate channel t4 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
allocate channel t5 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
restore controlfile;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
}
Thanks,
Samba Chebrolu,
Senior Oracle DBA,
Technical Services
FDC Enterprise Systems
402-222-5662
##
This message is for the named person's use only. It may
contain confidential, proprietary, or legally privileged
information. No confidentiality or privilege is waived or
lost by any mistransmission. If you receive this message
in error, please immediately delete it and all copies of it
from your system, destroy any hard copies of it, and notify
the sender. You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of this message
if you are not the intended recipient. Health First reserves
the right to monitor all e-mail communications through its
networks. Any views or opinions expressed in this message
are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of
a particular entity; and (2) the sender is authorized by
the entity to give such views or opinions.
##
