Showing posts with label Oracle Backup Recovery Controlfile Trace Reset Logs. Show all posts
Showing posts with label Oracle Backup Recovery Controlfile Trace Reset Logs. Show all posts

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.