using RMAN and standby DB simultaneously

[clinton]

I'm currently using a standby as my DR and Backup and Recovery.
Due to business requirements, I would be implementing RMAN in addition
to the standby so that they co-exist simultaneously.

So when this is fully implemented, RMAN would be for my backups
and the standby would be my D/R. Rman would be used to perform
a hot backup every night and after the backup, Rman would
delete the old archival files.
The standby on the other hand would have a lag time of 1 hour.


My question is after fully Implementing RMAN, how would this
affect the archival logs that the standby needs? What would be
the impact on the Standby when RMAN deletes the old archivals.
I'm really confused in this area and how to aproach this.

Can any one share with me some ideas, work around, suggestions,etc?

Thanks,
Clinton

[Axr2]

It's straightforward to maintain such an enviroment. I manage several of these.

In your case, bunch of questions -
What's your d/b version?
How do you maintain your standby? Manually or Managed? If it's managed, what it your log transport mode?

Read the architectural overview of a standby again. With a ARCH Xptmode - The ARCH process transmits the logs via the Net8 service. It then invoked the RFS on the target.

Bottom line - you would be wise to have a reasonable window before deleting your archivelogs. This is coz, should there be a problem during Net8 transmission (read network issues usually), and you need to manually fix things, you have the archivelogs on disk to ftp across..else, you're gonna have to restore from RMAN and copy over..

[clinton]

Thanks for the respnse.
Answers to your questions are as follows:

What's your d/b version?
ANSWER: 8.1.7.4

How do you maintain your standby?
ANSWER: Manual Recovery Mode

If it's managed, what it your log transport mode?
ANSWER: FTP logs from Primary to standby evry hour

Thanks,
Clinton

[Axr2]

If you are maintaing the standby manually, the answer ought to be obvious. If you delete an archivelog file on source, before transmitting (ftping in ur case) it; the recovery will fail or stop. It is as simple as that.

So make sure your RMAN scripts don't delete your archivelogs before your ftp-to-standby script has run.

Look up RMAN syntax for deleting archivelogs..they offer a variety of options. In your case "the COMPLETED BEFORE"; or "UNTIL TIME" clause will do the job.