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.