Control file info

<

  
 alter session set tracefile_identifier='control';

 alter database backup controlfile to trace;
  
 alter database backup controlfile to trace noresetlogs;
  
  
 Generate the trace file of control file.


alter database backup controlfile to trace as '/tmp/control.txt' ;

grep "CREATE CONTROLFILE" *
	
col name for a60	
select v.*, round(block_size*file_size_blks/1024/1024, 2) MB from v$controlfile v;
	  
select v.*, round(record_size*records_total/1024/1024, 2) MB from v$controlfile_record_section v 
order by MB desc;
 
 set linesize 300
col DISPLAY_VALUE for a20
col DEFAULT_VALUE for a20
col DESCRIPTION for a20 
col VALUE for a15
col UPDATE_COMMENT for a20
col NAME for a30
  
select * from v$parameter where name = 'control_file_record_keep_time';