数据库基础运维

cp control01.ctl control02.ctl
Spfile' 1.6-&$"3 spfile57.scope=spfileboth 2.(2 $+ ")#
0 CREATE PFILE=‘/tmp/pfile’ FROM SPFILE; OR CREATE SPFILE=‘/tmp/spfile’ FROM pfile;
0 CREATE PFILE=‘/tmp/pfile’ FROM SPFILE; OR CREATE SPFILE=‘/tmp/spfile’ FROM pfile;



select decode(count(*),1,'spfile','pfile’) from v$spparameter where rownum=1 and isspecified ='TRUE’; OR Show parameter pfile
select * from v$controlfile_record_section ;
1 RMAN 1
2
1
1
0
0

SQLPLUS: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; --- User_dump_dest ALTER DATABASE BACKUP CONTROLFILE TO TRACE RESETLOGS; ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS; ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/tmp/create_ctl.sql'; ALTER DATABASE BACKUP CONTROLFILE TO '/tmp/ctl.ora'; ALTER DATABASE BACKUP CONTROLFILE TO '/tmp/ctl.ora‘ REUSE;--
(
$!9/14,%*
8 1)SPFILESID.ora 2) SPFILE.ora 3) INITSID.ora 4) INIT.ora $!4,% startup pfile=’/tmp/pfile’
Spfile' 1.6-&$"3 spfile57.scope=spfileboth 2.(2 $+ ")#
:$ORACLE_HOME/dbs/spfile{sid}.ora
:$ORACLE_HOME/dbs/orapw{sid}
:
/control0X.ctl
:
:
1
:

ORACLE
1.Istance 2.Database Instance Database


'),!7@)(10MB)-(&</
# %(&:SID1>
(&)*") = (& 7+B$ =;B
# A *") 2*"
# 306
# 547?<. (&)
#
09')8 Select * from v$controlfile OR Show parameter control
spfile:*'(Server Parameter Files
(-! spfileSID.ora (6#$ORACLE_HOME/dbs (1
:(+( ;9stings ,0$47pfile,0 Oracle 9i Oracle" Spfile(5;9SQL 2&
Spfile scope 1. scope=spfile 2. scope=memory 3. scope=both
(
$!9/14,%*
8 1)SPFILESID.ora 2) SPFILE.ora 3) INITSID.ora 4) INIT.ora $!4,% startup pfile=’/tmp/pfile’
SHUTDOWN
Instance started
SHUTDOWN

pfile: '(Initialization Parameters Files
(-! initSID.ora (6#$ORACLE_HOME/dbs (1(+( /%,038 Oracle 9iORACLE/<.pfile)!'
From 19c db concepts

STARTUP
OPEN
MOUNT
All files opened as described by the control file for this instance
Leabharlann Baidu
NOMOUNT
Control file opened for this instance


01 02



RAC

2




SAN






0
1.
-- /RAC
2.
--
3.
- RAC
eg asm,symantec cfs
1. 2. 3. 0 4. 5. 6.
RMAN: BACKUP CURRENT CONTROLFILE; BACKUP CURRENT CONTROLFILE FORMAT '/tmp/ctl_%d_%T_%s_%p.bak'; BACKUP AS COPY CURRENT CONTROLFILE FORMAT '/tmp/ctl.bak'; BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;