Re: [Veritas-bu] Oracle hot backup with yearly retention: redo logs?
Like the previous responder said, the retention of the redo logs are controlled by RMAN and not Netbackup. Have the DBA's change the retention of the RMAN backups to match their requirement if a hot backup is the only way you can backup the data. If you can bring down the database so that there are no open tables or transactions being performed, you can perform a full cold backup of all the required filesystems inside Netbackup and then set the retention of that backup to match the new requirements. One thing to note here is that in order for you to capture all the files required to restart the database from this backup, you will need to make sure that any files currently excluded from your OS backups (such as redo logs, dbf's etc..) are not excluded in your cold backup. Your DBA's should know which files they'll need and which ones they won't. Mark Glazerman Desk: 314-889-8282 Cell: 618-520-3401 please don't print this e-mail unless you really need to -Original Message- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of jjperry Sent: Wednesday, September 22, 2010 2:08 PM To: VERITAS-BU@MAILMAN.ENG.AUBURN.EDU Subject: [Veritas-bu] Oracle hot backup with yearly retention: redo logs? robmod wrote: Hello everybody, we have many oracle instances in archivelog mode. We keep archivelogs for 30 days. Now we have to backup some oracle instance only with full hot backups with long retention (up to 3 years). As oracle man says redo logs are needed for restore, so we have to change the retention of the archivelogs created during long retention hot backup. How would you backup oracle in this way? I would suggest that you take a look at http://www.symantec.com/business/support/index?page=contentid=TECH49868 as a possible reference. While this pertains mostly to NetBackup, the RMAN information on retentions should be independent of the backup product used as it resides in the RMAN setup. From reading the article, not using RMAN myself as that is relegated to the DBAs, it would seem that you would have to change the retention on all backup in RMAN to support just the yearly backups you need to keep. Another way I would suggest that might possibly work is to backup the database offline for the yearly backup instead of the hot backup as it should not require the archive logs at that point, at least it seems that you would not need them with the DB down. +-- |This was sent by jjpe...@water.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
[Veritas-bu] Oracle hot backup with yearly retention: redo logs?
Hello everybody, we have many oracle instances in archivelog mode. We keep archivelogs for 30 days. Now we have to backup some oracle instance only with full hot backups with long retention (up to 3 years). As oracle man says redo logs are needed for restore, so we have to change the retention of the archivelogs created during long retention hot backup. How would you backup oracle in this way? +-- |This was sent by roberto.mod...@t-systems.it via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
[Veritas-bu] Oracle hot backup with yearly retention: redo logs?
robmod wrote: Hello everybody, we have many oracle instances in archivelog mode. We keep archivelogs for 30 days. Now we have to backup some oracle instance only with full hot backups with long retention (up to 3 years). As oracle man says redo logs are needed for restore, so we have to change the retention of the archivelogs created during long retention hot backup. How would you backup oracle in this way? I would suggest that you take a look at http://www.symantec.com/business/support/index?page=contentid=TECH49868 as a possible reference. While this pertains mostly to NetBackup, the RMAN information on retentions should be independent of the backup product used as it resides in the RMAN setup. From reading the article, not using RMAN myself as that is relegated to the DBAs, it would seem that you would have to change the retention on all backup in RMAN to support just the yearly backups you need to keep. Another way I would suggest that might possibly work is to backup the database offline for the yearly backup instead of the hot backup as it should not require the archive logs at that point, at least it seems that you would not need them with the DB down. +-- |This was sent by jjpe...@water.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] oracle hot backup
Recovery Catalog DB. Best to put it on a different machine to avoid the all eggs in one basket issue. RMAN is fully functional and is designed to work best with the DB. = Carl Stehman IT Distributed Services Team Pepco Holdings, Inc. 202-331-6619 Pager 301-765-2703 [EMAIL PROTECTED] dy018 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 01:25 AM Please respond to VERITAS-BU@mailman.eng.auburn.edu To VERITAS-BU@mailman.eng.auburn.edu cc Subject [Veritas-bu] Re: oracle hot backup Can anyone explain the advantage and disadvantage of using control file as compare to using Recovery Catalog DB? I heard from one DBA is that using Recovery Catalog DB will enable more RMAN features as compare to using control file? izit true? +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates (PHI). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this Email is strictly prohibited. If you have received this message in error, please immediately notify the sender and permanently delete this Email and any copies. PHI policies expressly prohibit employees from making defamatory or offensive statements and infringing any copyright or any other legal right by Email communication. PHI will not accept any liability in respect of such communications. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] oracle hot backup
Gurus, I have configured the Oracle backup script , but it is failing with the error :- aloe:root-$PS2 cat oracle_backup.out oracle Script /opt/app/oracle/hot_database_backup.sh started on Mon Jun 4 17:08:31 PDT 2007 RMAN: /opt/app/oracle/product/9.2.0.4_32bit/bin/rman ORACLE_SID: EVRS ORACLE_USER: 60075 ORACLE_HOME: /opt/app/oracle/product/9.2.0.4_32bit NB_ORA_FULL: NB_ORA_INCR: NB_ORA_CINC: NB_ORA_SERV: NB_ORA_POLICY: Default - Full backup requested RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN RS (DBID=554365534) using target database controlfile instead of recovery catalog RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on ch00 channel at 06/04/2007 17:08:34 ORA-19554: error allocating device, device type: SBT_TYPE, device name: ORA-27001: unsupported device type Additional information: 1 RMAN Recovery Manager complete. Script /opt/app/oracle/hot_database_backup.sh ended in error on Mon Jun 4 17:08:34 PDT 2007 Any suggestions what could be the issue. --Abhishek [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 05:20 PM To VERITAS-BU@mailman.eng.auburn.edu cc Subject Re: [Veritas-bu] oracle hot backup Recovery Catalog DB. Best to put it on a different machine to avoid the all eggs in one basket issue. RMAN is fully functional and is designed to work best with the DB. = Carl Stehman IT Distributed Services Team Pepco Holdings, Inc. 202-331-6619 Pager 301-765-2703 [EMAIL PROTECTED] dy018 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 01:25 AM Please respond to VERITAS-BU@mailman.eng.auburn.edu To VERITAS-BU@mailman.eng.auburn.edu cc Subject [Veritas-bu] Re: oracle hot backup Can anyone explain the advantage and disadvantage of using control file as compare to using Recovery Catalog DB? I heard from one DBA is that using Recovery Catalog DB will enable more RMAN features as compare to using control file? izit true? +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates (PHI). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this Email is strictly prohibited. If you have received this message in error, please immediately notify the sender and permanently delete this Email and any copies. PHI policies expressly prohibit employees from making defamatory or offensive statements and infringing any copyright or any other legal right by Email communication. PHI will not accept any liability in respect of such communications. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] oracle hot backup
delete input); release channel t1; release channel t2; } exit; Regards, Clem Kruger 'Listen to what is said, not he who speaks.' Arab Proverb. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 05 June 2007 14:22 PM To: [EMAIL PROTECTED] Cc: VERITAS-BU@mailman.eng.auburn.edu; [EMAIL PROTECTED] Subject: Re: [Veritas-bu] oracle hot backup Gurus, I have configured the Oracle backup script , but it is failing with the error :- aloe:root-$PS2 cat oracle_backup.out oracle Script /opt/app/oracle/hot_database_backup.sh started on Mon Jun 4 17:08:31 PDT 2007 RMAN: /opt/app/oracle/product/9.2.0.4_32bit/bin/rman ORACLE_SID: EVRS ORACLE_USER: 60075 ORACLE_HOME: /opt/app/oracle/product/9.2.0.4_32bit NB_ORA_FULL: NB_ORA_INCR: NB_ORA_CINC: NB_ORA_SERV: NB_ORA_POLICY: Default - Full backup requested RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN RS (DBID=554365534) using target database controlfile instead of recovery catalog RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on ch00 channel at 06/04/2007 17:08:34 ORA-19554: error allocating device, device type: SBT_TYPE, device name: ORA-27001: unsupported device type Additional information: 1 RMAN Recovery Manager complete. Script /opt/app/oracle/hot_database_backup.sh ended in error on Mon Jun 4 17:08:34 PDT 2007 Any suggestions what could be the issue. --Abhishek [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 05:20 PM To VERITAS-BU@mailman.eng.auburn.edu cc Subject Re: [Veritas-bu] oracle hot backup Recovery Catalog DB. Best to put it on a different machine to avoid the all eggs in one basket issue. RMAN is fully functional and is designed to work best with the DB. = Carl Stehman IT Distributed Services Team Pepco Holdings, Inc. 202-331-6619 Pager 301-765-2703 [EMAIL PROTECTED] dy018 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 01:25 AM Please respond to VERITAS-BU@mailman.eng.auburn.edu To VERITAS-BU@mailman.eng.auburn.edu cc Subject [Veritas-bu] Re: oracle hot backup Can anyone explain the advantage and disadvantage of using control file as compare to using Recovery Catalog DB? I heard from one DBA is that using Recovery Catalog DB will enable more RMAN features as compare to using control file? izit true? +- - |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +- - ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates (PHI). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this Email is strictly prohibited. If you have received this message in error, please immediately notify the sender and permanently delete this Email and any copies. PHI policies expressly prohibit employees from making defamatory or offensive statements and infringing any copyright or any other legal right by Email communication. PHI will not accept any liability in respect of such communications. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ~~ This e-mail and its contents are subject to the Telkom SA Limited e-mail legal notice available at http://www.telkom.co.za/TelkomEMailLegalNotice.PDF ~~___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] oracle hot backup
Do you have a Policy of type Oracle with a Application Backup type schedule? This is in addition to the Automatic Full Backup type Schedule which triggers the RMAN script. Austin On 6/5/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Gurus, I have configured the Oracle backup script , but it is failing with the error :- === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on ch00 channel at 06/04/2007 17:08:34 ORA-19554: error allocating device, device type: SBT_TYPE, device name: ORA-27001: unsupported device type Additional information: 1 ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] oracle hot backup
Have you created the link from Oracle's /lib/libobk.so binary to the /usr/openv/netbackup/bin/libobk.sio64.1 binary installed by the Oracle agent? = Carl Stehman IT Distributed Services Team Pepco Holdings, Inc. 202-331-6619 Pager 301-765-2703 [EMAIL PROTECTED] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 08:22 AM To [EMAIL PROTECTED] cc VERITAS-BU@mailman.eng.auburn.edu, [EMAIL PROTECTED] Subject Re: [Veritas-bu] oracle hot backup Gurus, I have configured the Oracle backup script , but it is failing with the error :- aloe:root-$PS2 cat oracle_backup.out oracle Script /opt/app/oracle/hot_database_backup.sh started on Mon Jun 4 17:08:31 PDT 2007 RMAN: /opt/app/oracle/product/9.2.0.4_32bit/bin/rman ORACLE_SID: EVRS ORACLE_USER: 60075 ORACLE_HOME: /opt/app/oracle/product/9.2.0.4_32bit NB_ORA_FULL: NB_ORA_INCR: NB_ORA_CINC: NB_ORA_SERV: NB_ORA_POLICY: Default - Full backup requested RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN RS (DBID=554365534) using target database controlfile instead of recovery catalog RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on ch00 channel at 06/04/2007 17:08:34 ORA-19554: error allocating device, device type: SBT_TYPE, device name: ORA-27001: unsupported device type Additional information: 1 RMAN Recovery Manager complete. Script /opt/app/oracle/hot_database_backup.sh ended in error on Mon Jun 4 17:08:34 PDT 2007 Any suggestions what could be the issue. --Abhishek [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 05:20 PM To VERITAS-BU@mailman.eng.auburn.edu cc Subject Re: [Veritas-bu] oracle hot backup Recovery Catalog DB. Best to put it on a different machine to avoid the all eggs in one basket issue. RMAN is fully functional and is designed to work best with the DB. = Carl Stehman IT Distributed Services Team Pepco Holdings, Inc. 202-331-6619 Pager 301-765-2703 [EMAIL PROTECTED] dy018 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 01:25 AM Please respond to VERITAS-BU@mailman.eng.auburn.edu To VERITAS-BU@mailman.eng.auburn.edu cc Subject [Veritas-bu] Re: oracle hot backup Can anyone explain the advantage and disadvantage of using control file as compare to using Recovery Catalog DB? I heard from one DBA is that using Recovery Catalog DB will enable more RMAN features as compare to using control file? izit true? +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates (PHI). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this Email is strictly prohibited. If you have received this message in error, please immediately notify the sender and permanently delete this Email and any copies. PHI policies expressly prohibit employees from making defamatory or offensive statements and infringing any copyright or any other legal right by Email communication. PHI will not accept any liability in respect of such communications. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates (PHI). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any
Re: [Veritas-bu] oracle hot backup
SBT_TYPE should be SBT_TAPE --Steve [EMAIL PROTECTED] wrote: Gurus, I have configured the Oracle backup script , but it is failing with the error :- aloe:root-$PS2 cat oracle_backup.out oracle Script /opt/app/oracle/hot_database_backup.sh started on Mon Jun 4 17:08:31 PDT 2007 RMAN: /opt/app/oracle/product/9.2.0.4_32bit/bin/rman ORACLE_SID: EVRS ORACLE_USER: 60075 ORACLE_HOME: /opt/app/oracle/product/9.2.0.4_32bit NB_ORA_FULL: NB_ORA_INCR: NB_ORA_CINC: NB_ORA_SERV: NB_ORA_POLICY: Default - Full backup requested RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN RS (DBID=554365534) using target database controlfile instead of recovery catalog RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on ch00 channel at 06/04/2007 17:08:34 ORA-19554: error allocating device, device type: SBT_TYPE, device name: ORA-27001: unsupported device type Additional information: 1 RMAN Recovery Manager complete. Script /opt/app/oracle/hot_database_backup.sh ended in error on Mon Jun 4 17:08:34 PDT 2007 Any suggestions what could be the issue. --Abhishek [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 05:20 PM To VERITAS-BU@mailman.eng.auburn.edu cc Subject Re: [Veritas-bu] oracle hot backup Recovery Catalog DB. Best to put it on a different machine to avoid the all eggs in one basket issue. RMAN is fully functional and is designed to work best with the DB. = Carl Stehman IT Distributed Services Team Pepco Holdings, Inc. 202-331-6619 Pager 301-765-2703 [EMAIL PROTECTED] *dy018 [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 06/05/2007 01:25 AM Please respond to VERITAS-BU@mailman.eng.auburn.edu To VERITAS-BU@mailman.eng.auburn.edu cc Subject [Veritas-bu] Re: oracle hot backup Can anyone explain the advantage and disadvantage of using control file as compare to using Recovery Catalog DB? I heard from one DBA is that using Recovery Catalog DB will enable more RMAN features as compare to using control file? izit true? +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates (PHI). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this Email is strictly prohibited. If you have received this message in error, please immediately notify the sender and permanently delete this Email and any copies. PHI policies expressly prohibit employees from making defamatory or offensive statements and infringing any copyright or any other legal right by Email communication. PHI will not accept any liability in respect of such communications. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -- === Steven L. Sesar Lead Operating Systems Programmer/Analyst UNIX Application Services R101 The MITRE Corporation 202 Burlington Road - MS K101 Bedford, MA 01730 tel: (781) 271-7702 fax: (781) 271-2600 mobile: (617) 519-8933 email: [EMAIL PROTECTED] === ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] oracle hot backup
Yes Thanks for the help. It was SBT_TYPE and i Changed it to SBT_TAPE and backup went fine. Thanks Abhishek Steven L. Sesar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 06:33 PM To [EMAIL PROTECTED] cc [EMAIL PROTECTED], VERITAS-BU@mailman.eng.auburn.edu, [EMAIL PROTECTED] Subject Re: [Veritas-bu] oracle hot backup SBT_TYPE should be SBT_TAPE --Steve [EMAIL PROTECTED] wrote: Gurus, I have configured the Oracle backup script , but it is failing with the error :- aloe:root-$PS2 cat oracle_backup.out oracle Script /opt/app/oracle/hot_database_backup.sh started on Mon Jun 4 17:08:31 PDT 2007 RMAN: /opt/app/oracle/product/9.2.0.4_32bit/bin/rman ORACLE_SID: EVRS ORACLE_USER: 60075 ORACLE_HOME: /opt/app/oracle/product/9.2.0.4_32bit NB_ORA_FULL: NB_ORA_INCR: NB_ORA_CINC: NB_ORA_SERV: NB_ORA_POLICY: Default - Full backup requested RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN RS (DBID=554365534) using target database controlfile instead of recovery catalog RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on ch00 channel at 06/04/2007 17:08:34 ORA-19554: error allocating device, device type: SBT_TYPE, device name: ORA-27001: unsupported device type Additional information: 1 RMAN Recovery Manager complete. Script /opt/app/oracle/hot_database_backup.sh ended in error on Mon Jun 4 17:08:34 PDT 2007 Any suggestions what could be the issue. --Abhishek [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 05:20 PM To VERITAS-BU@mailman.eng.auburn.edu cc Subject Re: [Veritas-bu] oracle hot backup Recovery Catalog DB. Best to put it on a different machine to avoid the all eggs in one basket issue. RMAN is fully functional and is designed to work best with the DB. = Carl Stehman IT Distributed Services Team Pepco Holdings, Inc. 202-331-6619 Pager 301-765-2703 [EMAIL PROTECTED] dy018 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 01:25 AM Please respond to VERITAS-BU@mailman.eng.auburn.edu To VERITAS-BU@mailman.eng.auburn.edu cc Subject [Veritas-bu] Re: oracle hot backup Can anyone explain the advantage and disadvantage of using control file as compare to using Recovery Catalog DB? I heard from one DBA is that using Recovery Catalog DB will enable more RMAN features as compare to using control file? izit true? +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates (PHI). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this Email is strictly prohibited. If you have received this message in error, please immediately notify the sender and permanently delete this Email and any copies. PHI policies expressly prohibit employees from making defamatory or offensive statements and infringing any copyright or any other legal right by Email communication. PHI will not accept any liability in respect of such communications. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -- === Steven L. Sesar Lead Operating Systems Programmer/Analyst UNIX Application Services R101 The MITRE Corporation 202 Burlington Road - MS K101 Bedford, MA 01730 tel: (781) 271-7702 fax: (781) 271-2600 mobile: (617) 519-8933 email: [EMAIL PROTECTED] === ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] oracle hot backup
Abhishek, Have you linked Oracle? I remember seeing these errors when Oracle was not linked correctly. Create a dbclient log on the host. If no logs are created when you run the backup then Oracle is not linked correctly. Dwayne Adams From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven L. Sesar Sent: Tuesday, June 05, 2007 6:03 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; VERITAS-BU@mailman.eng.auburn.edu; [EMAIL PROTECTED] Subject: Re: [Veritas-bu] oracle hot backup SBT_TYPE should be SBT_TAPE --Steve [EMAIL PROTECTED] wrote: Gurus, I have configured the Oracle backup script , but it is failing with the error :- aloe:root-$PS2 cat oracle_backup.out oracle Script /opt/app/oracle/hot_database_backup.sh started on Mon Jun 4 17:08:31 PDT 2007 RMAN: /opt/app/oracle/product/9.2.0.4_32bit/bin/rman ORACLE_SID: EVRS ORACLE_USER: 60075 ORACLE_HOME: /opt/app/oracle/product/9.2.0.4_32bit NB_ORA_FULL: NB_ORA_INCR: NB_ORA_CINC: NB_ORA_SERV: NB_ORA_POLICY: Default - Full backup requested RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN RS (DBID=554365534) using target database controlfile instead of recovery catalog RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on ch00 channel at 06/04/2007 17:08:34 ORA-19554: error allocating device, device type: SBT_TYPE, device name: ORA-27001: unsupported device type Additional information: 1 RMAN Recovery Manager complete. Script /opt/app/oracle/hot_database_backup.sh ended in error on Mon Jun 4 17:08:34 PDT 2007 Any suggestions what could be the issue. --Abhishek [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 05:20 PM To VERITAS-BU@mailman.eng.auburn.edu cc Subject Re: [Veritas-bu] oracle hot backup Recovery Catalog DB. Best to put it on a different machine to avoid the all eggs in one basket issue. RMAN is fully functional and is designed to work best with the DB. = Carl Stehman IT Distributed Services Team Pepco Holdings, Inc. 202-331-6619 Pager 301-765-2703 [EMAIL PROTECTED] dy018 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/05/2007 01:25 AM Please respond to VERITAS-BU@mailman.eng.auburn.edu To VERITAS-BU@mailman.eng.auburn.edu cc Subject [Veritas-bu] Re: oracle hot backup Can anyone explain the advantage and disadvantage of using control file as compare to using Recovery Catalog DB? I heard from one DBA is that using Recovery Catalog DB will enable more RMAN features as compare to using control file? izit true? +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +-- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates (PHI). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this Email is strictly prohibited. If you have received this message in error, please immediately notify the sender and permanently delete this Email and any copies. PHI policies expressly prohibit employees from making defamatory or offensive statements and infringing any copyright or any other legal right by Email communication. PHI will not accept any liability in respect of such communications. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -- === Steven L. Sesar Lead Operating Systems Programmer/Analyst UNIX Application Services R101 The MITRE Corporation 202 Burlington Road - MS K101 Bedford, MA 01730 tel: (781) 271-7702 fax: (781) 271
Re: [Veritas-bu] oracle hot backup
On 6/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Needed help to configure Oracle Hot backup using the netbackup orcale agent, Please suggest the steps to follow. Netbackup Oracle pdf doesnot clearly specify the steps. and also i am not aware of Oracle This user guide has been helpful for me in the past for RMAN things: http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96566/toc.htm Most people just start with the sample scripts from Veritas and replace the DB names, logins, password. Austin ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] oracle hot backup
Needed help to configure Oracle Hot backup using the netbackup orcale agent, Please suggest the steps to follow. Netbackup Oracle pdf doesnot clearly specify the steps. and also i am not aware of Oracle Then you should not be doing this--your DBA(s) should. If your DBA can't figure it out from the manual, from the simple, heavily commented supplied scripts and from the wizard-GUI thing, your company doesn't have the right personnel to manage this part of the business. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu