How to backup Oracle control files

The principle of backing up a control file is to back up the control file after the physical structure of the database has changed.

1. Trace: Used to control file rebuilding (generated trace file in Udump)

sql> ALTER DATABASE backup Controlfile to trace;

Database altered.

The following is a backup of the control file:

CREATE controlfile Reuse DATABASE "LX01" Noresetlogs Archivelog

Maxlogfiles 16

Maxlogmembers 3

Maxdatafiles 100

Maxinstances 1

Maxloghistory 292

LOGFILE

GROUP 1 (

'/disk2/lx01/oradata/redo01a.log ',

'/disk1/lx01/oradata/redo01b.log '

) SIZE 10M,

GROUP 2 (

'/disk2/lx01/oradata/redo02a.log ',

'/disk1/lx01/oradata/redo02b.log '

) SIZE 10M,

GROUP 3 (

'/disk2/lx01/oradata/redo03a.log ',

'/disk1/lx01/oradata/redo03b.log '

) SIZE 10M,

GROUP 4 (

'/disk2/lx01/oradata/redo04a.log ',

'/disk1/lx01/oradata/redo04b.log '

) SIZE 10M,

GROUP 5 (

'/disk1/lx01/oradata/redo05b.log ',

'/disk2/lx01/oradata/redo05a.log '

) SIZE 10M