Search This Blog

Sunday, September 23, 2007

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.

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';

Above statement created binary format controlfile backup.

No comments: