Size of rman backup on the volumes
Hello World, how can i calculate the size of my database rman backup on the tape for each operation. i'm doing an incremntal backup every day with different levels, and i wish pridicate the total space nedder for a mounth TSM server 5.3.4 TDP for oracle 5.2 AIX 5.2 Oracle 8.1.7.4 tnk u for your reponses. _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- Moulay Rachid BOUSSETA Database system administrator WAFASALAF Morocco Til: +212 22 545128 _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- From: Keith Arbogast [EMAIL PROTECTED] Reply-To: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Cannot backup mapped drive contents Date: Sat, 10 Feb 2007 15:03:08 -0500 Yiannakis, We had a similar problem. The solution was to change the account under which the scheduler runs. By default the scheduler service uses the local system account which does not have access to remote drives. We used an ADS domain account. Keith Arbogast Indaina University _ MSN Messenger: appels gratuits de PC ` PC ! http://www.msn.fr/msger/default.asp
archive or backup date on the tape conetents
hi all, how can i display the date of archiving or backup when i list the tape content. tnks in advance _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- Moulay Rachid BOUSSETA Database system administrator WAFASALAF Morocco Til: +212 22 545128 _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- _ MSN Messenger: appels gratuits de PC ` PC ! http://www.msn.fr/newhotmail/Default.asp?Ath=f
Re: archive or backup date on the tape conetents
Tnks 4 your replay Mztt. but i have one problem is the same files are taken every mounth, so i have the same name in the tape content, q content tape 1 URANUS Arch /u13 10 /backup/WSF_PROD/ control01.ctl.Z URANUS Arch /u13 10 /backup/WSF_PROD/ gestion01.dbf.Z URANUS Arch /u13 10 /backup/WSF_PROD/ gestion02.dbf.Z URANUS Arch /u13 10 /backup/WSF_PROD/ rbs01.dbf.Z URANUS Arch /u13 10 /backup/WSF_PROD/ usr01.dbf.Z q content tape 2 URANUS Arch /u13 10 /backup/WSF_PROD/ control01.ctl.Z URANUS Arch /u13 10 /backup/WSF_PROD/ gestion01.dbf.Z URANUS Arch /u13 10 /backup/WSF_PROD/ gestion02.dbf.Z URANUS Arch /u13 10 /backup/WSF_PROD/ rbs01.dbf.Z URANUS Arch /u13 10 /backup/WSF_PROD/ usr01.dbf.Z how can i supparate between the two conetnts?? _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- Moulay Rachid BOUSSETA Database system administrator WAFASALAF Morocco Til: +212 22 545128 _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- From: Matthew Warren [EMAIL PROTECTED] Reply-To: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] archive or backup date on the tape conetents Date: Tue, 31 Oct 2006 16:01:52 - Hi, query content will not show you the date an object was inserted to the library no matter how you ask it. You could do something similar to; tsm: SOFASAP30_SERVER1q content S00810L1 Node NameType Filespace FSID Client's Name for File Name --- -- -- SOFASAP04_TDPArch tdpmux 2 \ DB2P01A0ETLXG4NS_1368 SOFASAP04_TDPArch tdpmux 2 \ DB2P01A0ETNCW0BD_1378 SOFASAP04_TDPArch tdpmux 2 \ DB2P01A0ETOSBUUL_1384 SOFASAP04_TDPArch tdpmux 2 \ DB2P01A0ETQ7RP0T_1387 SOFASAP04_TDPArch tdpmux 2 \ DB2P01A0ETRN7RRL_1393 SOFASAP04_TDPArch tdpmux 2 \ DB2P01A0ETUI4TJJ_1404 SOFASAP04_TDPArch tdpmux 2 \ DB2P01A0ETVZPVNV_1411 tsm: SOFASAP30_SERVER1select * from archives where ll_name like '%DB2P01A0ETVZPVNV_1411%' NODE_NAME: SOFASAP04_TDP FILESPACE_NAME: tdpmux FILESPACE_ID: 2 TYPE: FILE HL_NAME: \ LL_NAME: DB2P01A0ETVZPVNV_1411 OBJECT_ID: 929762 ARCHIVE_DATE: 2006-10-29 22:00:48.00 OWNER: DESCRIPTION: DB2P01A0ETVZPVNV_10.134.0.230:[EMAIL PROTECTED] CLASS_NAME: SAPMC Beware making such open ended queries against the archives or backps table. It's much better to narrow things down by node_name if possible. Matt. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Moulay rachid BOUSSETA Sent: 31 October 2006 14:51 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] archive or backup date on the tape conetents hi all, how can i display the date of archiving or backup when i list the tape content. tnks in advance _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- Moulay Rachid BOUSSETA Database system administrator WAFASALAF Morocco Til: +212 22 545128 _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- _ MSN Messenger: appels gratuits de PC ` PC ! http://www.msn.fr/newhotmail/Default.asp?Ath=f This email is confidential and may be privileged. If you are not the intended recipient please notify the sender immediately and delete the email from your computer. You should not copy the email, use it for any purpose or disclose its contents to any other person. Please note that any views or opinions presented in this email may be personal to the author and do not necessarily represent the views or opinions of Digica. It is the responsibility of the recipient to check this email for the presence of viruses. Digica accepts no liability for any damage caused by any virus transmitted by this email. UK: Phoenix House, Colliers Way, Nottingham, NG8 6AT UK Reception Tel: + 44 (0) 115 977 1177 Support Centre: 0845 607 7070 Fax: + 44 (0) 115 977 7000 http://www.digica.com SOUTH AFRICA: Building 3, Parc du Cap, Mispel Road, Bellville, 7535, South Africa Tel: + 27 (0) 21 957 4900 Fax: + 27 (0) 21 948 3135 http://www.digica.com _ MSN Messenger : appels gratuits de PC ` PC ! http://www.msn.fr/newhotmail/Default.asp?Ath=f
restoring from an other node
Hello, I would like recover a volume saved by a server A on a server B. here is the descritpion of the two servers: Server A: LTO 5383, two drives. Serevur B: LTO 3581, a drive. the two servers are the version 4.2. can you guide me in this operation, by giving me step by step howto make this? any document, paper or link will be welcome. tnks in advance _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- Moulay Rachid BOUSSETA Database and system administrator WAFASALAF Morocco Til: +212 22 545128 _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- _ MSN Search, le moteur de recherche qui pense comme vous ! http://search.msn.fr/worldwide.asp
Re: restoring from an other node
Hi, tnks for replaying, moving data from server A to Server B i have a backup server in a remote location non attached with WAN. my manager decide to restore everey day's backup of the main server into the backup server. i must restore the TSM database in the backup server, restore the config files, and redifine the labrary and drive on the backup server. but i have some troublshouting doing this. i need a step by step instruction to acheive this. Hi Moulay, What are you exactly trying to achieve : disaster recovery from server A, or simply moving client data from one server to the other ? Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Moulay rachid BOUSSETA Sent: Wednesday, 29 September, 2004 11:19 To: [EMAIL PROTECTED] Subject: restoring from an other node Hello, I would like recover a volume saved by a server A on a server B. here is the descritpion of the two servers: Server A: LTO 5383, two drives. Serevur B: LTO 3581, a drive. the two servers are the version 4.2. can you guide me in this operation, by giving me step by step howto make this? any document, paper or link will be welcome. tnks in advance _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- Moulay Rachid BOUSSETA Database and system administrator WAFASALAF Morocco Til: +212 22 545128 _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- _ MSN Search, le moteur de recherche qui pense comme vous ! http://search.msn.fr/worldwide.asp _ MSN Messenger : discutez en direct avec vos amis ! http://www.msn.fr/msger/default.asp