OraFAQ Forum: Backup & Recovery » automated backup of controlfile using RMAN

Home » RDBMS Server » Backup & Recovery » automated backup of controlfile using RMAN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

automated backup of controlfile using RMAN [message #176977]

Mon, 12 June 2006 05:07

tridentadm
Messages: 142
Registered: March 2006

Senior Member

how do i take bakcup of controlfile in automated fashion, ie.
everytime when below event occur

drop tablespace
datafile drop
add tablespaece
begin backup
etc.

??

---
also how do i know the scripts associated with RMAN ??

Report message to a moderator

Re: automated backup of controlfile using RMAN [message #176982 is a reply to message #176977]

Mon, 12 June 2006 05:13

orausern
Messages: 826
Registered: December 2005

Senior Member

part of the automation can be done by :

configure controlfile autobackup on;

this backs up control file, at the time of every backup and image copy command. however when other changes take place, you have to manually ensure, or come up with a way to automate that too..

to know scripts associated with rman: use rc_stored_script

see: http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10770/rcviews29.htm

for description of its columns

[Updated on: Mon, 12 June 2006 05:16]

Report message to a moderator

Re: automated backup of controlfile using RMAN [message #180965 is a reply to message #176977]

Thu, 06 July 2006 01:49

lakher
Messages: 14
Registered: April 2006

Junior Member

configure controlfile autobackup on;
the database version 9i or later

Report message to a moderator

Previous Topic:	RESETLOGS???????
Next Topic:	RMAN recovery catalog

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 14 06:32:41 CST 2026