Топ-100
 
CerebroSQL

Create "StartupFile" in the Oracle

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

The created script contains only the "NORESETLOGS case" section

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

-> Request to retrieve data <-

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

-----