Re: RMAN archivelog restore

kechup schrieb:
> Autobackup controlfile on will not backup controlfile after archivelog
> backup. just after database backap. It needs to be done in script.
>
> Robert
>

This is incorrect.

<quote>
If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and the current server parameter file (if used) in the following circumstances:

• After every BACKUP or COPY command issued at the RMAN prompt.
• Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY.
• At the end of every RUN block if the last command in the block was either BACKUP or COPY.
• After database structural changes such as adding a new tablespace, altering the state of a tablespace or datafile (for example, bringing it online), adding a new online redo log, renaming a file, adding a new redo thread, and so forth. This type of autobackup, unlike autobackups that occur in the preceding circumstances, is only on disk. You can run CONFIGURE CONTROLFILE AUTOBACKUP FOR DEVICE TYPE DISK to set a nondefault disk location. Note that the autobackup never causes the associated structural change to fail. For example, if you add a datafile, and if the resulting autobackup fails, then the datafile addition is still successful. </quote>

You can verify it at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconfg.htm#453424

Best regards

Maxim Received on Wed Aug 10 2005 - 09:37:49 CDT