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.
No comments:
Post a Comment