Control file Backup Option

Controlfile Backup Option





when database running in NO ARCHIVE LOG MODE


1. Shutdown database with immediate,transactional,normal option.
2. through OS copy command copy controlfiles to backup location
3. startup database.


when database running in ARCHIVELOG MODE

Text based controlfile backup

SQL> alter session set tracefile_identifier = ctrlbkp;

Session altered.

SQL> alter database backup controlfile to trace;

Database altered.

Note
1. Tracefile created with tracefile_identifier name like "ORA_SID_XXX_ctrlbkp.trc".
2. Above created backup controlfile is text file.

Exact copy or binary controlfile backup

alter database backup controlfile to 'PATH';

Note
Above statement created binary format controlfile backup.