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.

Popular posts from this blog

OracleRemExecService available Windows only

Implementation of a GoldenGate Replicate Hub: GoldenGate Remote Capture and Deliver Goldengate processes

Dynamic listener registration (instance registration) - Connections via the Listener to the Database [TNS-12526 - TNS-12527 - TNS-12528 ]