Backup Controlfile in oracle database

 

SQL>

SQL>

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/DB1/control01.ctl

/u01/app/oracle/fast_recovery_area/DB1/control02.ctl

/u01/app/oracle/oradata/DB1/control03.ctl

SQL>

SQL>

SQL> alter database backup controlfile to trace ;

Database altered.

SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

2025-05-24T08:23:47.505162+00:00

alter database backup controlfile to trace

2025-05-24T08:23:47.508044+00:00

Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_ora_11837.trc

Completed: alter database backup controlfile to trace

2025-05-24T08:23:49.290103+00:00