Control file Backup

It is very important that you back up your control file, Bacause the control file records the physical structure of the database,you should make a backup of your control file after making changes to the physical structure of the database. You can create backup of control file by using this statement:
 
Alter database backup controlfile '/opt/nit/conback.ctl'

You can also backup of a control file to trace file.

Alter database backup controlfile to trace
 
You backup a control file after any change the physical structure of your database. Such includes as:
  • Adding, dropping or renaming datafiles
  • Adding or dropping redo log files or group
  • Adding or dropping a tablespace 
  You can obtain control file information using these views as follows:
  • V$CONTROLFILE
  • V$PARAMETER
  • V$CONTROLFILE_RECORD_SECTION
  • SHOW PARAMETERS CONTROL_FILES

People who read this post also read :



0 comments:

Post a Comment

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More