Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

rman

rman

I'm trying to switch over to rman and use that functionality to backup my oracle 9i DB. I ran the following after all the basic configurations were set up:

run
{
backup database plus archivelog;
}

I then deleted all the db files and tried to restore them. The temp db file wasn't restored or backed up. Nor were any of the redo logs backed up and restored. This is only a test DB that I'm doing it with at the moment. Do I have to back up these files explicitly?

Also I zip up my offline redo logs and leave them in the same directory. Now when I run the same statement above rman is trying to find archivelogs that I've already zipped up from a few days ago. Does anyone know how rman decides what archive log files to backup?

thanks in advance.
4 REPLIES
Steve Steel
Honored Contributor

Re: rman

Hi

Start at

http://www.oracle.com/ip/std_infrastructure/blueprints/emailonhp/blueprint_email/Design/Key_Components/Oracle_Recovery_Manager.htm


Have a nice read


steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
T G Manikandan
Honored Contributor

Re: rman

There are several backup scripts of RMAN located at
The $ORACLE_HOME/rdbms/demo
directory.

Customize to your env.

R. Allan Hicks
Trusted Contributor

Re: rman

I recommend Oracle 9i: RMAN Backup and Recovery Configure and Use Oracle Recovery Manager by Robert G. Freeman and Matthew Hart published by Oracle Press ISBN 0-07-222662-5

It has some good workshops in it.


It makes for excellent *yawn* bedtime reading.

-Good Luck
"Only he who attempts the absurd is capable of achieving the impossible
kyoha
Occasional Visitor

Re: rman

Hi all,

I am a fresh man.
Can you give me some advise
in using rman.
Is there any sample backup plan , recovery plan and scripts?

Thank a lot