Friday, October 2, 2009

backup controlfile to trace options

The following execute commands generate a trace file from controlfile.

Option 1:
ALTER DATABASE BACKUP CONTROLFILE
             TO TRACE AS '<file location and filename>' RESETLOGS;

A script is generated with only the RESETLOG clause.

Option 2:
ALTER DATABASE BACKUP CONTROLFILE
             TO TRACE AS '<file location and filename>' NORESETLOGS;

A script is generated with only the NORESETLOG clause.

Option 3:
ALTER DATABASE BACKUP CONTROLFILE
             TO TRACE AS '<file location and filename> ';

A script is generated with both options RESETLOG and NORESETLOG clauses.