[Veritas-bu] Oracle Backups - Online Agent Advice
Could I possibly seek advice from anyone that has done Oracle Online backups, or knows how to configure them? Although I am going through the guide, I am struggling. Also moreso, that I dont have anyone from DBA side to assist me with some of this. Its a single box, DB is only 550MB in size at the moment, but dont want to keep taking services down, as it causes issues with end users. Any advice is better than no advice.. Regards Simon This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Oracle Backups - Online Agent Advice
Just to add to this... I created a .tpl file using the BAR Tool, as Oracle installed locally. So I am running with this, trial and error at the moment. I just want to be sure what I am doing sounds right, and importantly, I can recover! Thanks _ From: WEAVER, Simon (external) Sent: Tuesday, July 19, 2011 2:16 PM To: VERITAS-BU@mailman.eng.auburn.edu Subject: Oracle Backups - Online Agent Advice Could I possibly seek advice from anyone that has done Oracle Online backups, or knows how to configure them? Although I am going through the guide, I am struggling. Also moreso, that I dont have anyone from DBA side to assist me with some of this. Its a single box, DB is only 550MB in size at the moment, but dont want to keep taking services down, as it causes issues with end users. Any advice is better than no advice.. Regards Simon This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Oracle Backups - Online Agent Advice
What version of Oracle on what OS? -Jonathan From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of WEAVER, Simon (external) Sent: Tuesday, July 19, 2011 9:16 AM To: VERITAS-BU@mailman.eng.auburn.edu Subject: [Veritas-bu] Oracle Backups - Online Agent Advice Could I possibly seek advice from anyone that has done Oracle Online backups, or knows how to configure them? Although I am going through the guide, I am struggling. Also moreso, that I dont have anyone from DBA side to assist me with some of this. Its a single box, DB is only 550MB in size at the moment, but dont want to keep taking services down, as it causes issues with end users. Any advice is better than no advice.. Regards Simon This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Oracle Backups - Online Agent Advice
Windows 2003 SP2 Oracle hmmm. unsure myself... ORA10G ? I dont even have a login ! S From: Martin, Jonathan [mailto:jmart...@intersil.com] Sent: Tuesday, July 19, 2011 2:41 PM To: WEAVER, Simon (external); VERITAS-BU@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] Oracle Backups - Online Agent Advice What version of Oracle on what OS? -Jonathan From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of WEAVER, Simon (external) Sent: Tuesday, July 19, 2011 9:16 AM To: VERITAS-BU@mailman.eng.auburn.edu Subject: [Veritas-bu] Oracle Backups - Online Agent Advice Could I possibly seek advice from anyone that has done Oracle Online backups, or knows how to configure them? Although I am going through the guide, I am struggling. Also moreso, that I dont have anyone from DBA side to assist me with some of this. Its a single box, DB is only 550MB in size at the moment, but dont want to keep taking services down, as it causes issues with end users. Any advice is better than no advice.. Regards Simon This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Oracle Backups - Online Agent Advice
Jonathan Ok, from BAR tool on the client, created a template. That is now configured in my Oracle Policy, and so far so good. Ran the job, got status 29. I think the Template may have been bad, so I have deleted and created a new one, as per this: http://www.symantec.com/business/support/index?page=contentid=TECH44190 Because I am very limited in the understanding of Oracle and what I should / should not be using, I have a test VM to play with, which is what I am doing now. So at least no harm can come to this setup. Looking into the logs I got setup, it looks like its 10.2.0 (INF - Using: e:\oracle\product\10.2.0\bin\rman.exe ) ? S. From: Martin, Jonathan [mailto:jmart...@intersil.com] Sent: Tuesday, July 19, 2011 2:41 PM To: WEAVER, Simon (external); VERITAS-BU@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] Oracle Backups - Online Agent Advice What version of Oracle on what OS? -Jonathan From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of WEAVER, Simon (external) Sent: Tuesday, July 19, 2011 9:16 AM To: VERITAS-BU@mailman.eng.auburn.edu Subject: [Veritas-bu] Oracle Backups - Online Agent Advice Could I possibly seek advice from anyone that has done Oracle Online backups, or knows how to configure them? Although I am going through the guide, I am struggling. Also moreso, that I dont have anyone from DBA side to assist me with some of this. Its a single box, DB is only 550MB in size at the moment, but dont want to keep taking services down, as it causes issues with end users. Any advice is better than no advice.. Regards Simon This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
[Veritas-bu] Oracle Backups
Ok, need some help from Oracle/Linux people here. I am running an oracle backup using NB client 5.1 and Oracle client. Our dba has created RMAN scripts to do hot backups of the databases. I am wondering if the oracle client works like other database clients (exchange, sql) in such that it will clear transaction logs after a good backup. This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Oracle Backups
That's not configurable in the Oracle client, per se. That's configured in your RMAN scripts. Dave Brown wrote: Ok, need some help from Oracle/Linux people here. I am running an oracle backup using NB client 5.1 and Oracle client. Our dba has created RMAN scripts to do hot backups of the databases. I am wondering if the oracle client works like other database clients (exchange, sql) in such that it will clear transaction logs after a good backup. This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ 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 Backups
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The oracle client does nothing like that, all the management of archive and redo logs is always handled within Oracle. The agent simply understands both RMAN and Oracle API and executes a RMAN script. Keep in mind that at times some house cleaning is needed between the RMAN catalogs and the NetBackup catalogs in reference to expired images to RMAN backup id names. Thanks Peter Peter DrakeUnderkoffler Xinupro, LLC 617-834-2352 Dave Brown wrote: Ok, need some help from Oracle/Linux people here. I am running an oracle backup using NB client 5.1 and Oracle client. Our dba has created RMAN scripts to do hot backups of the databases. I am wondering if the oracle client works like other database clients (exchange, sql) in such that it will clear transaction logs after a good backup. This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFFW1djl+lekZRM55oRAqvnAKCJ4wsuefwxNPdhgND5PLG23iIj3gCgjCzV EqAYw/YTNQ3sSCsmdbw97rM= =zaI+ -END PGP SIGNATURE- ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Oracle Backups
I just got off the phone with my NetBackup support. Excuse me for my lack of knowledge here. Not an Oracle/Linux guy at all. That being said, here is scenario of what happened nearest I can tell. Oracle backups have been failing. What ever function tells Oracle that it is ok to clean up transaction logs has not been saying it is ok. Log disk filled up Oracle/dba guy deleted files to make room Job fails with new error stating the log file it is supposed to backup does not exist. My NBSupport says he deleted the logs from the file system and not from Oracle so when agent queries Oracle, it says backup this file but when it goes to do it, file does not exist. Make any sense at all ? Dave -Original Message- From: Peter DrakeUnderkoffler [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 12:08 PM To: Dave Brown Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The oracle client does nothing like that, all the management of archive and redo logs is always handled within Oracle. The agent simply understands both RMAN and Oracle API and executes a RMAN script. Keep in mind that at times some house cleaning is needed between the RMAN catalogs and the NetBackup catalogs in reference to expired images to RMAN backup id names. Thanks Peter Peter DrakeUnderkoffler Xinupro, LLC 617-834-2352 Dave Brown wrote: Ok, need some help from Oracle/Linux people here. I am running an oracle backup using NB client 5.1 and Oracle client. Our dba has created RMAN scripts to do hot backups of the databases. I am wondering if the oracle client works like other database clients (exchange, sql) in such that it will clear transaction logs after a good backup. This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFFW1djl+lekZRM55oRAqvnAKCJ4wsuefwxNPdhgND5PLG23iIj3gCgjCzV EqAYw/YTNQ3sSCsmdbw97rM= =zaI+ -END PGP SIGNATURE- This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Oracle Backups
Need more information. A-logs will not be deleted by "default" - that needs to be explicitly defined. So does backing up a-logs. I suppose that it is possible that your script is asking RMAN to truncate the logs, but your script doesn't back them up with the backup set. I'm not sure that truncating logs will work, if you're not backing them up. Just a thought.. Let's see your script and maybe we can help troubleshoot your problem. Let's also see the exact RMAN/Oracle error strings from your RMAN log. --Steve Dave Brown wrote: I just got off the phone with my NetBackup support. Excuse me for my lack of knowledge here. Not an Oracle/Linux guy at all. That being said, here is scenario of what happened nearest I can tell. Oracle backups have been failing. What ever function tells Oracle that it is ok to clean up transaction logs has not been saying it is ok. Log disk filled up Oracle/dba guy deleted files to make room Job fails with new error stating the log file it is supposed to backup does not exist. My NBSupport says he deleted the logs from the file system and not from Oracle so when agent queries Oracle, it says backup this file but when it goes to do it, file does not exist. Make any sense at all ? Dave -Original Message- From: Peter DrakeUnderkoffler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2006 12:08 PM To: Dave Brown Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The oracle client does nothing like that, all the management of archive and redo logs is always handled within Oracle. The agent simply understands both RMAN and Oracle API and executes a RMAN script. Keep in mind that at times some house cleaning is needed between the RMAN catalogs and the NetBackup catalogs in reference to expired images to RMAN backup id names. Thanks Peter Peter DrakeUnderkoffler Xinupro, LLC 617-834-2352 Dave Brown wrote: Ok, need some help from Oracle/Linux people here. I am running an oracle backup using NB client 5.1 and Oracle client. Our dba has created RMAN scripts to do hot backups of the databases. I am wondering if the oracle client works like other database clients (exchange, sql) in such that it will clear transaction logs after a good backup. This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFFW1djl+lekZRM55oRAqvnAKCJ4wsuefwxNPdhgND5PLG23iIj3gCgjCzV EqAYw/YTNQ3sSCsmdbw97rM= =zaI+ -END PGP SIGNATURE- This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ 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 Backups
You can't just delete archive logs, you have to use RMAN to remove them. Per one of my oracle DBAs. Go into RMAN, Connect to Catalog Run change archivelog all validate; then resynch catalog; Run full backup. I'm not an Oracle DBA but I know if you've manually deleted Oracle Archive logs that's not a good thing. -Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Brown Sent: Wednesday, November 15, 2006 1:20 PM To: Peter DrakeUnderkoffler Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups I just got off the phone with my NetBackup support. Excuse me for my lack of knowledge here. Not an Oracle/Linux guy at all. That being said, here is scenario of what happened nearest I can tell. Oracle backups have been failing. What ever function tells Oracle that it is ok to clean up transaction logs has not been saying it is ok. Log disk filled up Oracle/dba guy deleted files to make room Job fails with new error stating the log file it is supposed to backup does not exist. My NBSupport says he deleted the logs from the file system and not from Oracle so when agent queries Oracle, it says backup this file but when it goes to do it, file does not exist. Make any sense at all ? Dave -Original Message- From: Peter DrakeUnderkoffler [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 12:08 PM To: Dave Brown Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The oracle client does nothing like that, all the management of archive and redo logs is always handled within Oracle. The agent simply understands both RMAN and Oracle API and executes a RMAN script. Keep in mind that at times some house cleaning is needed between the RMAN catalogs and the NetBackup catalogs in reference to expired images to RMAN backup id names. Thanks Peter Peter DrakeUnderkoffler Xinupro, LLC 617-834-2352 Dave Brown wrote: Ok, need some help from Oracle/Linux people here. I am running an oracle backup using NB client 5.1 and Oracle client. Our dba has created RMAN scripts to do hot backups of the databases. I am wondering if the oracle client works like other database clients (exchange, sql) in such that it will clear transaction logs after a good backup. This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFFW1djl+lekZRM55oRAqvnAKCJ4wsuefwxNPdhgND5PLG23iIj3gCgjCzV EqAYw/YTNQ3sSCsmdbw97rM= =zaI+ -END PGP SIGNATURE- This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ 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 Backups
So I hear but I am not sure this is what he did. I have sent and asked this question of him but have not received answer back as of yet. I did tell him that backups will not complete until this is resolved -Original Message- From: Martin, Jonathan (Contractor) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 12:39 PM To: Dave Brown; Peter DrakeUnderkoffler Cc: veritas-bu@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] Oracle Backups You can't just delete archive logs, you have to use RMAN to remove them. Per one of my oracle DBAs. Go into RMAN, Connect to Catalog Run change archivelog all validate; then resynch catalog; Run full backup. I'm not an Oracle DBA but I know if you've manually deleted Oracle Archive logs that's not a good thing. -Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Brown Sent: Wednesday, November 15, 2006 1:20 PM To: Peter DrakeUnderkoffler Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups I just got off the phone with my NetBackup support. Excuse me for my lack of knowledge here. Not an Oracle/Linux guy at all. That being said, here is scenario of what happened nearest I can tell. Oracle backups have been failing. What ever function tells Oracle that it is ok to clean up transaction logs has not been saying it is ok. Log disk filled up Oracle/dba guy deleted files to make room Job fails with new error stating the log file it is supposed to backup does not exist. My NBSupport says he deleted the logs from the file system and not from Oracle so when agent queries Oracle, it says backup this file but when it goes to do it, file does not exist. Make any sense at all ? Dave -Original Message- From: Peter DrakeUnderkoffler [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 12:08 PM To: Dave Brown Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The oracle client does nothing like that, all the management of archive and redo logs is always handled within Oracle. The agent simply understands both RMAN and Oracle API and executes a RMAN script. Keep in mind that at times some house cleaning is needed between the RMAN catalogs and the NetBackup catalogs in reference to expired images to RMAN backup id names. Thanks Peter Peter DrakeUnderkoffler Xinupro, LLC 617-834-2352 Dave Brown wrote: Ok, need some help from Oracle/Linux people here. I am running an oracle backup using NB client 5.1 and Oracle client. Our dba has created RMAN scripts to do hot backups of the databases. I am wondering if the oracle client works like other database clients (exchange, sql) in such that it will clear transaction logs after a good backup. This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFFW1djl+lekZRM55oRAqvnAKCJ4wsuefwxNPdhgND5PLG23iIj3gCgjCzV EqAYw/YTNQ3sSCsmdbw97rM= =zaI+ -END PGP SIGNATURE- This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu
Re: [Veritas-bu] Oracle Backups
ARCHIVELOG ALL NOT BACKED UP 3 TIMES; This means that RMAN will backup a-logs that have been backed up less than three times. DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 3 TIMES TO DEVICE TYPE SBT_TAPE; This means that RMAN will delete archive logs that have been backed up at least three times (to the same device) If you or your DBAs are manually deleting a-logs, that's probably not a good thing, as your catalog will be out of sync. Run the RMAN code that Jonathan passed along top you. --Steve Martin, Jonathan (Contractor) wrote: You can't just delete archive logs, you have to use RMAN to remove them. Per one of my oracle DBAs. Go into RMAN, Connect to Catalog Run "change archivelog all validate;" then "resynch catalog;" Run full backup. I'm not an Oracle DBA but I know if you've manually deleted Oracle Archive logs that's not a good thing. -Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Brown Sent: Wednesday, November 15, 2006 1:20 PM To: Peter DrakeUnderkoffler Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups I just got off the phone with my NetBackup support. Excuse me for my lack of knowledge here. Not an Oracle/Linux guy at all. That being said, here is scenario of what happened nearest I can tell. Oracle backups have been failing. What ever function tells Oracle that it is ok to clean up transaction logs has not been saying it is ok. Log disk filled up Oracle/dba guy deleted files to make room Job fails with new error stating the log file it is supposed to backup does not exist. My NBSupport says he deleted the logs from the file system and not from Oracle so when agent queries Oracle, it says backup this file but when it goes to do it, file does not exist. Make any sense at all ? Dave -Original Message- From: Peter DrakeUnderkoffler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2006 12:08 PM To: Dave Brown Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The oracle client does nothing like that, all the management of archive and redo logs is always handled within Oracle. The agent simply understands both RMAN and Oracle API and executes a RMAN script. Keep in mind that at times some house cleaning is needed between the RMAN catalogs and the NetBackup catalogs in reference to expired images to RMAN backup id names. Thanks Peter Peter DrakeUnderkoffler Xinupro, LLC 617-834-2352 Dave Brown wrote: Ok, need some help from Oracle/Linux people here. I am running an oracle backup using NB client 5.1 and Oracle client. Our dba has created RMAN scripts to do hot backups of the databases. I am wondering if the oracle client works like other database clients (exchange, sql) in such that it will clear transaction logs after a good backup. This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFFW1djl+lekZRM55oRAqvnAKCJ4wsuefwxNPdhgND5PLG23iIj3gCgjCzV EqAYw/YTNQ3sSCsmdbw97rM= =zaI+ -END PGP SIGNATURE- This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu mai
Re: [Veritas-bu] Oracle Backups
RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of backup command at 11/14/2006 22:36:29 RMAN-06059: expected archived log not found, lost of archived log compromises recoverability ORA-19625: error identifying file /s03/archivelogs/prod/DEST1/archPROD124130.arc.0001 ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 This indicates that you (or someone) did manually delete archive logs. RMAN is expecting /s03/archivelogs/prod/DEST1/archPROD124130.arc.0001 to exist, because according to the catalog, it has backed it up at least once. It's trying a subsequent time, but it's been manually removed - hence, the job is failing. Martin, Jonathan (Contractor) wrote: You can't just delete archive logs, you have to use RMAN to remove them. Per one of my oracle DBAs. Go into RMAN, Connect to Catalog Run "change archivelog all validate;" then "resynch catalog;" Run full backup. I'm not an Oracle DBA but I know if you've manually deleted Oracle Archive logs that's not a good thing. -Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Brown Sent: Wednesday, November 15, 2006 1:20 PM To: Peter DrakeUnderkoffler Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups I just got off the phone with my NetBackup support. Excuse me for my lack of knowledge here. Not an Oracle/Linux guy at all. That being said, here is scenario of what happened nearest I can tell. Oracle backups have been failing. What ever function tells Oracle that it is ok to clean up transaction logs has not been saying it is ok. Log disk filled up Oracle/dba guy deleted files to make room Job fails with new error stating the log file it is supposed to backup does not exist. My NBSupport says he deleted the logs from the file system and not from Oracle so when agent queries Oracle, it says backup this file but when it goes to do it, file does not exist. Make any sense at all ? Dave -Original Message- From: Peter DrakeUnderkoffler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2006 12:08 PM To: Dave Brown Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] Oracle Backups -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The oracle client does nothing like that, all the management of archive and redo logs is always handled within Oracle. The agent simply understands both RMAN and Oracle API and executes a RMAN script. Keep in mind that at times some house cleaning is needed between the RMAN catalogs and the NetBackup catalogs in reference to expired images to RMAN backup id names. Thanks Peter Peter DrakeUnderkoffler Xinupro, LLC 617-834-2352 Dave Brown wrote: Ok, need some help from Oracle/Linux people here. I am running an oracle backup using NB client 5.1 and Oracle client. Our dba has created RMAN scripts to do hot backups of the databases. I am wondering if the oracle client works like other database clients (exchange, sql) in such that it will clear transaction logs after a good backup. This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to the specified business of Worknet shall be understood as neither given by nor endorsed by Worknet or its employees. Any cost estimates or estimated quotes included in this message are considered non-binding estimates only and must not be considered final costs unless contained within an official proposal document. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFFW1djl+lekZRM55oRAqvnAKCJ4wsuefwxNPdhgND5PLG23iIj3gCgjCzV EqAYw/YTNQ3sSCsmdbw97rM= =zaI+ -END PGP SIGNATURE- This message (including any attachments) is intended for the sole use of the individual to whom it is addressed and may contain confidential information. You are hereby notified that any dissemination, distribution, or duplication of this message by someone other than the intended addressee or their designated agent is strictly prohibited. Information included in this message that does not relate to th
Re: [Veritas-bu] Oracle Backups
Job fails with new error stating the log file it is supposed to backup
does not exist.
My NBSupport says he deleted the logs from the file system and not
from
Oracle so when agent queries Oracle, it says backup this file but
when
it goes to do it, file does not exist.
You (or your DBA) will need to run a crosscheck on the instances that
are failing, or on the instances where the archivelogs were deleted.
This is done in the RMAN shell.
Here's the RMAN command:
RMAN change archivelog all crosscheck ;
This will force RMAN to validate what's physically present in the
archivelog directories and discard what's been deleted. RMAN thinks the
old (deleted) archive logs are still there, so it pukes when it can't
find them.
Also, I included our RMAN script (modified from the examples Symantec
gives you) that does incrementals and fulls depending on what control
job spawns it. In my policy, my schedule types are Cumulative-Inc and
Full (with appropriate tape pools, devices, frequencies and time
windows), and then Full-Application-Backup and Incr-Application-Backup
with the time windows wide open. In backup selections I have the shell
script below placed in /usr/openv/netbackup/scripts/ and call it
accordingly in the policy.
The important bit in your RMAN script is in the archive log portion to
have the DELETE INPUT part added to your ARCHIVELOG ALL line in
backing up your archive logs on a FULL.
The script below assumes that you also want to keep your archivelogs for
your FULL retention period, not for your INCREMENTAL retention period.
= shell script here
#!/bin/sh
# $Header: hot_database_backup.sh,v 1.2 2002/08/06 23:51:42 $
#
#bcpyrght
#***
#* $VRTScprght: Copyright 1993 - 2005 VERITAS Software Corporation, All
Rights Reserved $ *
#***
#ecpyrght
#
#
---
# hot_database_backup.sh
#
---
# This script uses Recovery Manager to take a hot (inconsistent)
database
# backup. A hot backup is inconsistent because portions of the database
are
# being modified and written to the disk while the backup is
progressing.
# You must run your database in ARCHIVELOG mode to make hot backups. It
is
# assumed that this script will be executed by user root. In order for
RMAN
# to work properly we switch user (su -) to the oracle dba account
before
# execution. If this script runs under a user account that has Oracle
dba
# privilege, it will be executed using this user's account.
#
---
#
---
# Determine the user which is executing this script.
#
---
CUSER=`id |cut -d( -f2 | cut -d ) -f1`
#
---
# Put output in this file name.out. Change as desired.
# Note: output directory requires write permission.
#
---
RMAN_LOG_FILE=${0}.out
#
---
# You may want to delete the output file so that backup information does
# not accumulate. If not, delete the following lines.
#
---
if [ -f $RMAN_LOG_FILE ]
then
rm -f $RMAN_LOG_FILE
fi
# -
# Initialize the log file.
# -
echo $RMAN_LOG_FILE
chmod 666 $RMAN_LOG_FILE
#
---
# Log the start of this script.
#
---
echo Script $0 $RMAN_LOG_FILE
echo started on `date` $RMAN_LOG_FILE
echo $RMAN_LOG_FILE
#
---
# Replace /db/oracle/product/ora81, below, with the Oracle home path.
#
---
ORACLE_HOME=/opt6/apps/oracle/ora92
export ORACLE_HOME
#
---
# Replace ora81, below, with the Oracle SID of the target database.
#
---
ORACLE_SID=TAGI2
export ORACLE_SID
#
---
# Replace ora81, below, with the Oracle DBA user id (account).
#
[Veritas-bu] Oracle Backups.
Title: Message Some questions about RMAN Scripts and Netbackup Agent. If an Netbackup Job Fails(RMAN job) does this get sent back to RMAN in any way? Tivoli TSM supposedly does this now. Netbackup didn't in the past has anything changed. Can you do a RMAN duplex_copy directing streams to tape and disk with Netbackup Agent? Or whould you use bpduplicate? Thanks, Jim ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
