Топ-100
 
CerebroSQL

Create "StartupFile" in the Oracle

StartupFile is a SQL script that allows you to recreate the Controlfile of the database and run it.

The generated script contains only the section " NORESETLOGS case "

A similar script can be obtained by running the command:

alter database backup controlfile to trace as '<FilePath>';

StartupFile.jpg

 

Requests used to generate the file

select min(group#) as min1, max(group#) as max1

  from v$logfile;

select lf.GROUP#,
       lf.member "member",
       l.BYTES/1024/1024||'M' "size"
  from v$logfile lf,
       v$log l
where l.GROUP#=lf.GROUP#
   and lf.type ='ONLINE' 
order by lf.GROUP#;

select file_name from dba_data_files;


select value 
  from nls_database_parameters 
where PARAMETER='NLS_CHARACTERSET';


select file_name, 
       bytes, 
       autoextensible, 
       increment_by * (select value

                         from v$parameter

                        where name ='db_block_size') "INCR",
       round(maxbytes/1024/1024) "MAX"  
  from dba_temp_files  
where status='ONLINE';

select sys_context('USERENV','DB_UNIQUE_NAME') "Name",
       sys_context('USERENV','SERVER_HOST') "Host" from dual;