 |
|
| Computers Forum Index » Computer - Databases - Oracle (Misc) » Dataguard... |
|
Page 1 of 1 |
|
| Author |
Message |
| tanveer... |
 Posted: Wed Sep 30, 2009 10:39 am |
|
|
|
Guest
|
Dear All
I need to know that can we schedule archived log to be deleted
automatically for instance i want to delete one month archived log
from primary and standby database with out RMAN.
Thanks in advanced for your participation
Regards |
|
|
| Back to top |
|
|
|
| joel garry... |
| Posted: Wed Sep 30, 2009 6:28 pm |
|
|
|
Guest
|
On Sep 30, 3:39 am, tanveer <tano... at (no spam) gmail.com> wrote:
Quote: Dear All
I need to know that can we schedule archived log to be deleted
automatically for instance i want to delete one month archived log
from primary and standby database with out RMAN.
Thanks in advanced for your participation
Regards
You can, but you need to tell RMAN about it, otherwise restoration
will be confusing. See the docs about crosscheck and delete expired.
More details would be required to give more advice, including the
platform, the exact operating system, the exact version of Oracle,
whether you are using a catalog, and what you really want to
accomplish.
jg
--
at (no spam) home.com is bogus.
Always be sure and use hand sanitizers with at least 60% alcohol.
http://catless.ncl.ac.uk/Risks/25.79.html#subj6 |
|
|
| Back to top |
|
|
|
| ... |
| Posted: Wed Sep 30, 2009 10:40 pm |
|
|
|
Guest
|
On Wed, 30 Sep 2009 03:39:50 -0700 (PDT), tanveer <tano786 at (no spam) gmail.com>
wrote:
Quote: Dear All
I need to know that can we schedule archived log to be deleted
automatically for instance i want to delete one month archived log
from primary and standby database with out RMAN.
Thanks in advanced for your participation
Regards
Deleting backups and other RMAN objects screws the catalog and can
possible end up in disaster in the time of peril.
You should either only use RMAN to delete backups, or not use RMAN at
all. You can't have it both ways!
--
--
Sybrand Bakker
Senior Oracle DBA |
|
|
| Back to top |
|
|
|
| tanveer... |
| Posted: Sat Oct 03, 2009 9:40 am |
|
|
|
Guest
|
On Sep 30, 9:40 pm, sybra... at (no spam) hccnet.nl wrote:
Quote: On Wed, 30 Sep 2009 03:39:50 -0700 (PDT), tanveer <tano... at (no spam) gmail.com
wrote:
Dear All
I need to know that can we schedule archived log to be deleted
automatically for instance i want to delete one month archived log
from primary and standby database with out RMAN.
Thanks in advanced for your participation
Regards
Deleting backups and other RMAN objects screws the catalog and can
possible end up in disaster in the time of peril.
You should either only use RMAN to delete backups, or not use RMAN at
all. You can't have it both ways!
--
--
Sybrand Bakker
Senior Oracle DBA
Thanks for your reply. I am not using RMAN at all. Can I delete
Archived log using Windows Explorer if yes, database should be down or
up. Please guide me how i can schedule to delete archived log.
Waiting for your reply
Regards |
|
|
| Back to top |
|
|
|
| tanveer... |
| Posted: Sat Oct 03, 2009 11:41 am |
|
|
|
Guest
|
On Sep 30, 9:28 pm, joel garry <joel-ga... at (no spam) home.com> wrote:
Quote: On Sep 30, 3:39 am, tanveer <tano... at (no spam) gmail.com> wrote:
Dear All
I need to know that can we schedule archived log to be deleted
automatically for instance i want to delete one month archived log
from primary and standby database with out RMAN.
Thanks in advanced for your participation
Regards
You can, but you need to tell RMAN about it, otherwise restoration
will be confusing. See the docs about crosscheck and delete expired.
More details would be required to give more advice, including the
platform, the exact operating system, the exact version of Oracle,
whether you are using a catalog, and what you really want to
accomplish.
jg
--
at (no spam) home.com is bogus.
Always be sure and use hand sanitizers with at least 60% alcohol.http://catless.ncl.ac.uk/Risks/25.79.html#subj6
Thanks for your reply. I am not using RMAN at all. We perform cold
backup weekly and hot backup daily (Database export dump).
Operating system windows 2000 Advance Server. Oracle 9.2.0.5.0. Not
using Catalog.
We are going to implement Data guard very soon what I want to know is
that If we don't use RMAN at all. How I can delete archive log can i
use windows explorer |
|
|
| Back to top |
|
|
|
| ... |
| Posted: Sun Oct 04, 2009 9:26 am |
|
|
|
Guest
|
On Sat, 3 Oct 2009 04:41:12 -0700 (PDT), tanveer <tano786 at (no spam) gmail.com>
wrote:
Quote: On Sep 30, 9:28Â pm, joel garry <joel-ga... at (no spam) home.com> wrote:
On Sep 30, 3:39Â am, tanveer <tano... at (no spam) gmail.com> wrote:
Dear All
I need to know that can we schedule archived log to be deleted
automatically for instance i want to delete one month archived log
from primary and standby database with out RMAN.
Thanks in advanced for your participation
Regards
You can, but you need to tell RMAN about it, otherwise restoration
will be confusing. Â See the docs about crosscheck and delete expired.
More details would be required to give more advice, including the
platform, the exact operating system, the exact version of Oracle,
whether you are using a catalog, and what you really want to
accomplish.
jg
--
at (no spam) home.com is bogus.
Always be sure and use hand sanitizers with at least 60% alcohol.http://catless.ncl.ac.uk/Risks/25.79.html#subj6
Thanks for your reply. I am not using RMAN at all. We perform cold
backup weekly and hot backup daily (Database export dump).
Operating system windows 2000 Advance Server. Oracle 9.2.0.5.0. Not
using Catalog.
We are going to implement Data guard very soon what I want to know is
that If we don't use RMAN at all. How I can delete archive log can i
use windows explorer
As you can know, an export does NOT constitute a backup at all. Also
your export will be INconsistent.
I'm not sure why you implemented these procedures, they are completely
irresponsible.
Dataguard without using RMAN is nonsense.
Why are you putting your company's data at risk????
--
--
Sybrand Bakker
Senior Oracle DBA |
|
|
| Back to top |
|
|
|
| joel garry... |
| Posted: Sun Oct 04, 2009 7:39 pm |
|
|
|
Guest
|
On Oct 3, 4:41 am, tanveer <tano... at (no spam) gmail.com> wrote:
Quote: On Sep 30, 9:28 pm, joel garry <joel-ga... at (no spam) home.com> wrote:
On Sep 30, 3:39 am, tanveer <tano... at (no spam) gmail.com> wrote:
Dear All
I need to know that can we schedule archived log to be deleted
automatically for instance i want to delete one month archived log
from primary and standby database with out RMAN.
Thanks in advanced for your participation
Regards
You can, but you need to tell RMAN about it, otherwise restoration
will be confusing. See the docs about crosscheck and delete expired.
More details would be required to give more advice, including the
platform, the exact operating system, the exact version of Oracle,
whether you are using a catalog, and what you really want to
accomplish.
jg
--
at (no spam) home.com is bogus.
Always be sure and use hand sanitizers with at least 60% alcohol.http://catless.ncl.ac.uk/Risks/25.79.html#subj6
Thanks for your reply. I am not using RMAN at all. We perform cold
backup weekly and hot backup daily (Database export dump).
Operating system windows 2000 Advance Server. Oracle 9.2.0.5.0. Not
using Catalog.
We are going to implement Data guard very soon what I want to know is
that If we don't use RMAN at all. How I can delete archive log can i
use windows explorer
I second what Sybrand says. The entire purpose of archiving logs is
for recovery. Standby databases are nothing more than recovery. You
must understand what is happening in order to not use RMAN. You
obviously don't. You would be much better off using RMAN. It is that
simple.
export is a type of backup called a logical backup. It is not the
type of backup you can use to save your company data, it is merely an
old clunky way to move data around and have some redundancy, and
sometimes fix certain user errors. It is most certainly not a hot
backup. A hot backup is an inconsistent backup that can be made
consistent through recovery. An export is an inconsistent backup.
Sometimes parts of it can be made consistent.
You need to implement a better physical backup procedure, otherwise
you risk losing transactional data. Has your management really said
"it's ok to lose a weeks data?"
Please read the manuals about backup, you need to learn the basic
concepts. Get one of the third party backup books, too. Read the
concepts manual about transactions.
You can delete archived logs however you want as long as you
understand what you are doing.
10g is significantly better in both backups and standby, by the way.
jg
--
at (no spam) home.com is bogus.
http://www3.signonsandiego.com/stories/2009/oct/04/symphony-your-fingers/?uniontrib |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Fri Dec 11, 2009 1:20 pm
|
|