Oracle: StartUp file and PFile manager
[EN]
StartupFile [controlfile - text]
StartupFile is an SQL script that allows you to recreate the Controlfile of a database and start it.
The created script contains only the "NORESETLOGS case" section
The file is generated when connecting to the database by the main monitoring kernel.
A similar script can be obtained by running the command:
alter database backup controlfile to trace as '<FilePath>';
Queries 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;
PFile - parameters file
PFile is an Oracle DBMS parameters file used when manually starting the database. Based on PFile, SPFile is created
select type, name, value
from V$SYSTEM_PARAMETER
where isdefault='FALSE'
and value is not null
order by name;
select sys_context('USERENV','DB_UNIQUE_NAME') "Name",
sys_context('USERENV','SERVER_HOST') "Host" from dual;
[RU]
StartupFile [controlfile - text]
StartupFile - это SQL скрипт позволяющий пересоздать Controlfile базы данных и запустить ее.
В создаваемом скрипте содержится только секция "NORESETLOGS case"
Формирование файла осуществляется при подключении к базе данных основным ядром мониторинга.
Аналогичный скрипт можно получить выполнив команду:
alter database backup controlfile to trace as '<FilePath>';
Запросы используемые для формирования файла
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;
PFile - файл параметров
PFile - это файл параметров СУБД Oracle, используемый при ручном запуске базы данных. На основе PFile создается SPFile
select type, name, value
from V$SYSTEM_PARAMETER
where isdefault='FALSE'
and value is not null
order by name;
select sys_context('USERENV','DB_UNIQUE_NAME') "Name",
sys_context('USERENV','SERVER_HOST') "Host" from dual;