오라클백업과복구/파라미터파일장애복구
피파일, 에스피파일 만들기
로큰롤러
2015. 12. 21. 14:32
* 에스피파일이 있을 경우 피파일 생성 가능 *
* 피파일이 있을 경우 에스피파일 생성 가능 *
** 요약 **
1. pfile from spfile
2. spfile from pfile
1. 파라미터 파일 조회 후 피파일 생성(spfile).
/oracle/product/11.2.0/dbhome_1/dbs>ls -rlt
total 20
-rw-r--r-- 1 oracle dba 2851 May 15 2009 init.ora
-rw-r----- 1 oracle dba 1536 Aug 24 15:50 orapwARK11G
-rw-r----- 1 oracle dba 24 Aug 24 15:50 lkARK11G
-rw-rw---- 1 oracle dba 1544 Dec 21 15:24 hc_ARK11G.dat
-rw-r----- 1 oracle dba 2560 Dec 21 15:24 spfileARK11G.ora
/oracle/product/11.2.0/dbhome_1/dbs>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 21 15:43:52 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/product/11.2.0/dbhome_
1/dbs/spfileARK11G.ora
SQL> create pfile from spfile;
File created.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
/oracle/product/11.2.0/dbhome_1/dbs>ls -rlt
total 24
-rw-r--r-- 1 oracle dba 2851 May 15 2009 init.ora
-rw-r----- 1 oracle dba 1536 Aug 24 15:50 orapwARK11G
-rw-r----- 1 oracle dba 24 Aug 24 15:50 lkARK11G
-rw-rw---- 1 oracle dba 1544 Dec 21 15:24 hc_ARK11G.dat
-rw-r----- 1 oracle dba 2560 Dec 21 15:24 spfileARK11G.ora
-rw-r--r-- 1 oracle dba 834 Dec 21 15:43 initARK11G.ora
/oracle/product/11.2.0/dbhome_1/dbs>rm spfileARK11G.ora
/oracle/product/11.2.0/dbhome_1/dbs>ls -rlt
total 20
-rw-r--r-- 1 oracle dba 2851 May 15 2009 init.ora
-rw-r----- 1 oracle dba 1536 Aug 24 15:50 orapwARK11G
-rw-r----- 1 oracle dba 24 Aug 24 15:50 lkARK11G
-rw-rw---- 1 oracle dba 1544 Dec 21 15:24 hc_ARK11G.dat
-rw-r--r-- 1 oracle dba 834 Dec 21 15:43 initARK11G.ora
/oracle/product/11.2.0/dbhome_1/dbs>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 21 15:44:11 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 313159680 bytes
Fixed Size 2252824 bytes
Variable Size 222302184 bytes
Database Buffers 83886080 bytes
Redo Buffers 4718592 bytes
Database mounted.
Database opened.
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
2. 파라미터 파일 조회 후 에스피파일 생성(pfile).
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> create spfile from pfile;
File created.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
/oracle/product/11.2.0/dbhome_1/dbs>ls -rlt
total 24
-rw-r--r-- 1 oracle dba 2851 May 15 2009 init.ora
-rw-r----- 1 oracle dba 1536 Aug 24 15:50 orapwARK11G
-rw-r----- 1 oracle dba 24 Aug 24 15:50 lkARK11G
-rw-r--r-- 1 oracle dba 834 Dec 21 15:43 initARK11G.ora
-rw-rw---- 1 oracle dba 1544 Dec 21 15:44 hc_ARK11G.dat
-rw-r----- 1 oracle dba 2560 Dec 21 15:48 spfileARK11G.ora
/oracle/product/11.2.0/dbhome_1/dbs>rm initARK11G.ora
/oracle/product/11.2.0/dbhome_1/dbs>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 21 15:48:21 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 313159680 bytes
Fixed Size 2252824 bytes
Variable Size 222302184 bytes
Database Buffers 83886080 bytes
Redo Buffers 4718592 bytes
Database mounted.
Database opened.
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/product/11.2.0/dbhome_
1/dbs/spfileARK11G.ora