广告

扫码关注官方微信

扫码下载APP
返回顶部
首页 > 资讯 > 数据库 >oracle controlfile路径修改
  • 466

0
分享到

oracle controlfile路径修改

2024-04-02 19:04:59 466人浏览 八月长安
摘要

sql> startup;oracle instance started.Total System Global Area  835104768 bytesFixed Size &

sql> startup;
oracle instance started.

Total System Global Area  835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
Database mounted.
Database opened.
SQL> ho
[oracle@athena ~]$ cd $ORACLE_HOME
[[oracle@athena db_home1]$ cd dbs/
[oracle@athena dbs]$ ll
total 9560
-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:12 hc_athena.dat
-rw-r--r-- 1 oracle oinstall     921 Feb 26 21:18 initathena.ora
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall      24 Oct 25  2013 lkATHENA
-rw-r----- 1 oracle oinstall    1536 Oct 25  2013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul  8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall    3584 Aug 20 20:12 spfileathena.ora
[oracle@athena dbs]$ cat initathena.ora -------------------pfile
athena.__db_cache_size=197132288
athena.__java_pool_size=4194304
athena.__large_pool_size=4194304
athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
athena.__pga_aggregate_target=335544320
athena.__sga_target=503316480
athena.__shared_io_pool_size=0
athena.__shared_pool_size=289406976
athena.__streams_pool_size=0
*.audit_file_dest='/s01/oracle/admin/athena/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/s01/oracle/oradata/athena/control01.ctl','/s01/oracle/fast_recovery_area/athena/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='athena'
*.db_recovery_file_dest='/s01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/s01/oracle'
*.dispatchers='(PROTOCOL=tcp) (SERVICE=athenaXDB)'
*.memory_target=838860800
*.open_cursors=300
*.processes=850
*.remote_login_passWordfile='EXCLUSIVE'
*.sessions=940
*.undo_tablespace='UNDOTBS1'
[oracle@athena dbs]$ ll
total 9560
-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:12 hc_athena.dat
-rw-r--r-- 1 oracle oinstall     921 Feb 26 21:18 initathena.ora
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall      24 Oct 25  2013 lkATHENA
-rw-r----- 1 oracle oinstall    1536 Oct 25  2013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul  8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall    3584 Aug 20 20:12 spfileathena.ora
[oracle@athena dbs]$ cat spfileathena.ora -----spfile
C"R8$4j3CC"aathena.__db_cache_size=197132288
athena.__java_pool_size=4194304
athena.__large_pool_size=4194304
athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
athena.__pga_aggregate_target=335544320
athena.__sga_target=503316480
athena.__shared_io_pool_size=0
athena.__shared_pool_size=289406976
athena.__streams_pool_size=0
*.audit_file_dest='/s01/oracle/admin/athena/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/s01/oracle/oradata/athena/control01.ctl','CC"<}/s01/oracle/oradata/athena/control03.ctl','/s01/oracle/fast_recovery_area/athena/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='athena'
*.db_recovery_file_dest='/s01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=10737418240
*.diagnostic_dest='/s01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=athenaXDB)'
*.log_arcHive_dest_1='location=/oracle/archive1/'
*.log_archive_fORMat='arch_%d_%t_%r_%s.log'
*.memory_target=838860800
*.open_cursors=300
*.processes=850
*CC"ka.remote_login_passwordfile='EXCLUSIVE'
*.sessions=940
*.undo_tablespace='UNDOTBS1'
[oracle@athena dbs]$
[oracle@athena dbs]$ cd /s01/oracle/oradata/athena/
[oracle@athena athena]$ ll
total 5699580
-rw-r----- 1 oracle oinstall   89137152 Aug 20 20:12 chenjh.dbf
-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:15 control01.ctl
-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:15 control03.ctl
-rw-r----- 1 oracle oinstall  328343552 Aug 20 20:12 example01.dbf
-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo01.log
-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo02.log
-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo03.log
-rw-r----- 1 oracle oinstall  587210752 Aug 20 20:12 sysaux01.dbf
-rw-r----- 1 oracle oinstall  744497152 Aug 20 20:12 system01.dbf
-rw-r----- 1 oracle oinstall   30416896 Jun 23 21:54 temp01.dbf
-rw-r----- 1 oracle oinstall   99622912 Aug 20 20:12 undotbs01.dbf
-rw-r----- 1 oracle oinstall 3803717632 Aug 20 20:12 users01.dbf
SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ho
[oracle@athena athena]$ cd /s01/oracle/oradata/athena/
[oracle@athena athena]$ ll
total 5699580
-rw-r----- 1 oracle oinstall   89137152 Aug 20 20:16 chenjh.dbf
-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control01.ctl
-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control03.ctl
-rw-r----- 1 oracle oinstall  328343552 Aug 20 20:16 example01.dbf
-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo01.log
-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:16 redo02.log
-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo03.log
-rw-r----- 1 oracle oinstall  587210752 Aug 20 20:16 sysaux01.dbf
-rw-r----- 1 oracle oinstall  744497152 Aug 20 20:16 system01.dbf
-rw-r----- 1 oracle oinstall   30416896 Jun 23 21:54 temp01.dbf
-rw-r----- 1 oracle oinstall   99622912 Aug 20 20:16 undotbs01.dbf
-rw-r----- 1 oracle oinstall 3803717632 Aug 20 20:16 users01.dbf
[oracle@athena athena]$ cp control01.ctl control04.ctl-----------增加控制文件
[oracle@athena athena]$ ll
total 5709116
-rw-r----- 1 oracle oinstall   89137152 Aug 20 20:16 chenjh.dbf
-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control01.ctl
-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control03.ctl
-rw-r----- 1 oracle oinstall    9748480 Aug 20 20:16 control04.ctl
-rw-r----- 1 oracle oinstall  328343552 Aug 20 20:16 example01.dbf
-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo01.log
-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:16 redo02.log
-rw-r----- 1 oracle oinstall   52429312 Aug 20 20:12 redo03.log
-rw-r----- 1 oracle oinstall  587210752 Aug 20 20:16 sysaux01.dbf
-rw-r----- 1 oracle oinstall  744497152 Aug 20 20:16 system01.dbf
-rw-r----- 1 oracle oinstall   30416896 Jun 23 21:54 temp01.dbf
-rw-r----- 1 oracle oinstall   99622912 Aug 20 20:16 undotbs01.dbf
-rw-r----- 1 oracle oinstall 3803717632 Aug 20 20:16 users01.dbf
[oracle@athena athena]$ cd $ORACLE_HOME
[oracle@athena db_home1]$ cd dbs/
[oracle@athena dbs]$ ll
total 9560
-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:16 hc_athena.dat
-rw-r--r-- 1 oracle oinstall     921 Feb 26 21:18 initathena.ora
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall      24 Oct 25  2013 lkATHENA
-rw-r----- 1 oracle oinstall    1536 Oct 25  2013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul  8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall    3584 Aug 20 20:12 spfileathena.ora
[oracle@athena dbs]$ vi spfileathena.ora
[oracle@athena dbs]$ vi spfileathena.ora
[oracle@athena dbs]$ cat init.ora
#
# $Header: rdbms/admin/init.ora /main/23 2009/05/15 13:35:38 ysarig Exp $
#
# Copyright (c) 1991, 1997, 1998 by Oracle Corporation
# NAME
#   init.ora
# FUNCTION
# NOTES
# MODIFIED
#     ysarig     05/14/09  - Updating compatible to 11.2
#     ysarig     08/13/07  - Fixing the sample for 11g
#     atsukerm   08/06/98 -  fix for 8.1.
#     hpiao      06/05/97 -  fix for 803
#     glavash    05/12/97 -  add oracle_trace_enable comment
#     hpiao      04/22/97 -  remove ifile=, events=, etc.
#     alingelb   09/19/94 -  remove vms-specific stuff
#     dpawson    07/07/93 -  add more comments regarded archive start
#     maporter   10/29/92 -  Add vms_sga_use_gblpagfile=TRUE
#     jloaiza    03/07/92 -  change ALPHA to BETA
#     danderso   02/26/92 -  change db_block_cache_protect to _db_block_cache_p
#     ghallmar   02/03/92 -  db_directory -> db_domain
#     maporter   01/12/92 -  merge changes from branch 1.8.308.1
#     maporter   12/21/91 -  bug 76493: Add control_files parameter
#     wbridge    12/03/91 -  use of %c in archive format is discouraged
#     ghallmar   12/02/91 -  add global_names=true, db_directory=us.acme.com
#     thayes     11/27/91 -  Change default for cache_clone
#     jloaiza    08/13/91 -         merge changes from branch 1.7.100.1
#     jloaiza    07/31/91 -         add debug stuff
#     rlim       04/29/91 -         removal of char_is_varchar2
#   Bridge     03/12/91 - log_allocation no longer exists
#   Wijaya     02/05/91 - remove obsolete parameters
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you start by providing
# a starting point to customize your RDBMS installation for your site.
#
# NOTE: The values that are used in this file are only intended to be used
# as a starting point. You may want to adjust/tune those values to your
# specific hardware and needs. You may also consider using Database
# Configuration Assistant tool (DBCA) to create INIT file and to size your
# initial set of tablespaces based on the user input.
###############################################################################

# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
[oracle@athena dbs]$ ll
total 9560
-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:16 hc_athena.dat
-rw-r--r-- 1 oracle oinstall     921 Feb 26 21:18 initathena.ora
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall      24 Oct 25  2013 lkATHENA
-rw-r----- 1 oracle oinstall    1536 Oct 25  2013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul  8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall    3584 Aug 20 20:12 spfileathena.ora
[oracle@athena dbs]$ cat initathena.ora
athena.__db_cache_size=197132288
athena.__java_pool_size=4194304
athena.__large_pool_size=4194304
athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
athena.__pga_aggregate_target=335544320
athena.__sga_target=503316480
athena.__shared_io_pool_size=0
athena.__shared_pool_size=289406976
athena.__streams_pool_size=0
*.audit_file_dest='/s01/oracle/admin/athena/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/s01/oracle/oradata/athena/control01.ctl','/s01/oracle/fast_recovery_area/athena/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='athena'
*.db_recovery_file_dest='/s01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/s01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=athenaXDB)'
*.memory_target=838860800
*.open_cursors=300
*.processes=850
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=940
*.undo_tablespace='UNDOTBS1'
[oracle@athena dbs]$ vi initathena.ora
[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:22:40 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup initathena.ora
SP2-0714: invalid combination of STARTUP options
SQL> ho
[oracle@athena dbs]$ ll
total 9560
-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:16 hc_athena.dat
-rw-r--r-- 1 oracle oinstall    1007 Aug 20 20:22 initathena.ora
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall      24 Oct 25  2013 lkATHENA
-rw-r----- 1 oracle oinstall    1536 Oct 25  2013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul  8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall    3584 Aug 20 20:12 spfileathena.ora
[oracle@athena dbs]$ pwd
/s01/oracle/proudct/11.2.0.1/db_home1/dbs
[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:24:21 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora';
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
Database mounted.
Database opened.
SQL> select * from v$controlfile;

STATUS NAME            IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------------------------ --- ---------- --------------
 /s01/oracle/oradata/athena/control01.ctl       NO       16384        594
 /s01/oracle/fast_recovery_area/athena/control02.ctl      NO       16384        594
 /s01/oracle/oradata/athena/control03.ctl       NO       16384        594
 /s01/oracle/oradata/athena/control04.ctl       NO       16384        594

SQL> ho
[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:27:33 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
Database mounted.
Database opened.
SQL> col name for a60
SQL> select * from v$controlfile;

STATUS NAME            IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------------------------ --- ---------- --------------
 /s01/oracle/oradata/athena/control01.ctl       NO       16384        594
 /s01/oracle/oradata/athena/control03.ctl       NO       16384        594
 /s01/oracle/fast_recovery_area/athena/control02.ctl      NO       16384        594

SQL> ho
[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:45:53 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora';---默认从pfile启动
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
ORA-00214: control file '/s01/oracle/oradata/athena/control01.ctl' version 2617 inconsistent with file '/s01/oracle/oradata/athena/control04.ctl' version 2602------版本不对，原因是复制控制文件的时候数据库没有关闭


SQL> ho
[oracle@athena dbs]$ cd /s01/oracle/oradata/athena/
[oracle@athena athena]$ cp control01.ctl control04.ctl;
[oracle@athena athena]$ sqplus /nolog
bash: sqplus: command not found
[oracle@athena athena]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:48:46 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> startup^H^H
SP2-0714: invalid combination of STARTUP options
SQL> startup pfile=''/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'
LRM-00109: could not open parameter file ''/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'
ORA-01078: failure in processing system parameters
SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
Database mounted.
Database opened.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
Database mounted.
Database opened.
SQL> ho
c[oracle@athena athena]$ cd $ORACLE_HOME
[[oracle@athena dbs]$ ll
total 9560
-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:50 hc_athena.dat
-rw-r--r-- 1 oracle oinstall    1007 Aug 20 20:22 initathena.ora
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall      24 Oct 25  2013 lkATHENA
-rw-r----- 1 oracle oinstall    1536 Oct 25  2013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul  8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall    3584 Aug 20 20:50 spfileathena.ora
[oracle@athena dbs]$ cat spfileathena.ora
C"y!$s3CC"aathena.__db_cache_size=197132288
athena.__java_pool_size=4194304
athena.__large_pool_size=4194304
athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
athena.__pga_aggregate_target=335544320
athena.__sga_target=503316480
athena.__shared_io_pool_size=0
athena.__shared_pool_size=289406976
athena.__streams_pool_size=0
*.audit_file_dest='/s01/oracle/admin/athena/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/s01/oracle/oradata/athena/control01.ctl','CC"<}/s01/oracle/oradata/athena/control03.ctl','/s01/oracle/fast_recovery_area/athena/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='athena'
*.db_recovery_file_dest='/s01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=10737418240
*.diagnostic_dest='/s01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=athenaXDB)'
*.log_archive_dest_1='location=/oracle/archive1/'
*.log_archive_format='arch_%d_%t_%r_%s.log'
*.memory_target=838860800
*.open_cursors=300
*.processes=850
*CC"ka.remote_login_passwordfile='EXCLUSIVE'
*.sessions=940
*.undo_tablespace='UNDOTBS1'
CC"FeCC"EeCC"DeC[oracle@athena dbs]$ Xshell
bash: Xshell: command not found
[oracle@athena dbs]$
[oracle@athena dbs]$ ll
total 9560
-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:50 hc_athena.dat
-rw-r--r-- 1 oracle oinstall    1007 Aug 20 20:22 initathena.ora
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall      24 Oct 25  2013 lkATHENA
-rw-r----- 1 oracle oinstall    1536 Oct 25  2013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul  8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall    3584 Aug 20 20:50 spfileathena.ora
[oracle@athena dbs]$ cat initathena.ora
athena.__db_cache_size=197132288
athena.__java_pool_size=4194304
athena.__large_pool_size=4194304
athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
athena.__pga_aggregate_target=335544320
athena.__sga_target=503316480
athena.__shared_io_pool_size=0
athena.__shared_pool_size=289406976
athena.__streams_pool_size=0
*.audit_file_dest='/s01/oracle/admin/athena/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/s01/oracle/oradata/athena/control01.ctl','/s01/oracle/fast_recovery_area/athena/control02.ctl','/s01/oracle/oradata/athena/control03.ctl','/s01/oracle/oradata/athena/control04.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='athena'
*.db_recovery_file_dest='/s01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/s01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=athenaXDB)'
*.memory_target=838860800
*.open_cursors=300
*.processes=850
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=940
*.undo_tablespace='UNDOTBS1'
[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:51:31 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.

SQL> sl
SP2-0042: unknown command "sl" - rest of line ignored.
SQL> select * from v$controlfile;

STATUS NAME            IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------------------------ --- ---------- --------------
 /s01/oracle/oradata/athena/control01.ctl       NO       16384        594
 /s01/oracle/oradata/athena/control03.ctl       NO       16384        594
 /s01/oracle/fast_recovery_area/athena/control02.ctl      NO       16384        594

SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
ORA-00214: control file '/s01/oracle/oradata/athena/control01.ctl' version 2647 inconsistent with file '/s01/oracle/oradata/athena/control04.ctl' version 2632


SQL> ho
[oracle@athena dbs]$ shutdown immediate;
bash: shutdown: command not found
[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:55:31 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> ho
[oracle@athena dbs]$ cd $ORACLE_HOME
[oracle@athena db_home1]$ cd dbs/
[oracle@athena dbs]$ ls
hc_athena.dat  initathena.ora  init.ora  lkATHENA  orapwathena  snapcf_athena.f  spfileathena.ora
[oracle@athena dbs]$ cd ~
[oracle@athena ~]$ cd ..
[oracle@athena home]$ cd oracle/
[oracle@athena ~]$ ll
total 0
[oracle@athena ~]$ cd/s01
bash: cd/s01: No such file or directory
[oracle@athena ~]$ cd /s01/
controlbak.txt  oracle/         oraInventory/  
[oracle@athena ~]$ cd /s01/oracle/oradata/
[oracle@athena oradata]$ ll
total 4
drwxr-x--- 2 oracle oinstall 4096 Aug 20 20:16 athena
[oracle@athena oradata]$ cd athena/
[oracle@athena athena]$ cp control01.ctl control04.ctl
[oracle@athena athena]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:57:21 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba;
Connected to an idle instance.
SQL> startup pfile='/s01/oracle/proudct/11.2.0.1/db_home1/dbs/initathena.ora'
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
Database mounted.
Database opened.
SQL> SQL> create spfile from pfile;

File created.

SQL> ho
c[oracle@athena athena]$ cd $ORACLE_HOME
[oracle@athena db_home1]$ cd dbs/
[oracle@athena dbs]$ ll
total 9560
-rw-rw---- 1 oracle oinstall    1544 Aug 20 20:58 hc_athena.dat
-rw-r--r-- 1 oracle oinstall    1007 Aug 20 20:22 initathena.ora
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall      24 Oct 25  2013 lkATHENA
-rw-r----- 1 oracle oinstall    1536 Oct 25  2013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul  8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall    3584 Aug 20 20:58 spfileathena.ora
[oracle@athena dbs]$ cat spfileathena.ora
C"??u3CC"aathena.__db_cache_size=197132288
athena.__java_pool_size=4194304
athena.__large_pool_size=4194304
athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
athena.__pga_aggregate_target=335544320
athena.__sga_target=503316480
athena.__shared_io_pool_size=0
athena.__shared_pool_size=289406976
athena.__streams_pool_size=0
*.audit_file_dest='/s01/oracle/admin/athena/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/s01/oracle/oradata/athena/control01.ctl','CC">/s01/oracle/fast_recovery_area/athena/control02.ctl','/s01/oracle/oradata/athena/control03.ctl','/s01/oracle/oradata/athena/control04.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='athena'
*.db_recovery_file_dest='/s01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/s01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=athenaXDB)'
*.memory_target=838860800
*.open_cursors=300
*.processes=850
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=94CC"6,0
*.undo_tablespace='UNDOTBS1'
CC"FeCC"EeCC"DeC[oracle@athena dbs]$ Xshell
bash: Xshell: command not found
[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:59:22 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
Database mounted.
Database opened.
SQL> ho
[oracle@athena dbs]$ cd $ORACLE_HOME
[oracle@athena db_home1]$ LL
bash: LL: command not found
[oracle@athena db_home1]$ cd dbs/
[oracle@athena dbs]$ ll
total 9560
-rw-rw---- 1 oracle oinstall    1544 Aug 20 21:00 hc_athena.dat
-rw-r--r-- 1 oracle oinstall    1007 Aug 20 20:22 initathena.ora
-rw-r--r-- 1 oracle oinstall    2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall      24 Oct 25  2013 lkATHENA
-rw-r----- 1 oracle oinstall    1536 Oct 25  2013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul  8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall    3584 Aug 20 21:00 spfileathena.ora
[oracle@athena dbs]$ cat spfileathena.ora
C"??Vu3CC"aathena.__db_cache_size=197132288
athena.__java_pool_size=4194304
athena.__large_pool_size=4194304
athena.__oracle_base='/s01/oracle'#ORACLE_BASE set from environment
athena.__pga_aggregate_target=335544320
athena.__sga_target=503316480
athena.__shared_io_pool_size=0
athena.__shared_pool_size=289406976
athena.__streams_pool_size=0
*.audit_file_dest='/s01/oracle/admin/athena/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/s01/oracle/oradata/athena/control01.ctl','CC">/s01/oracle/fast_recovery_area/athena/control02.ctl','/s01/oracle/oradata/athena/control03.ctl','/s01/oracle/oradata/athena/control04.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='athena'
*.db_recovery_file_dest='/s01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/s01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=athenaXDB)'
*.memory_target=838860800
*.open_cursors=300
*.processes=850
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=94CC"6,0
*.undo_tablespace='UNDOTBS1'
CC"FeCC"EeCC"DeC[oracle@athena dbs]$ Xshell
bash: Xshell: command not found
[oracle@athena dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 21:00:51 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> col name for a60
SQL> select * from v$controlfile;

STATUS NAME            IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------------------------ --- ---------- --------------
 /s01/oracle/oradata/athena/control01.ctl       NO       16384        594
 /s01/oracle/fast_recovery_area/athena/control02.ctl      NO       16384        594
 /s01/oracle/oradata/athena/control03.ctl       NO       16384        594
 /s01/oracle/oradata/athena/control04.ctl       NO       16384        594

SQL>

 

您可能感兴趣的文档:
点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: oracle controlfile路径修改

本文链接: https://www.lsjlt.com/news/43417.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档
去做题
猜你喜欢
  • oracle controlfile路径修改
    SQL> startup;ORACLE instance started.Total System Global Area  835104768 bytesFixed Size &...
    99+
    2022-10-18
  • oracle修改redo log files路径
    如果可以关闭数据库，可以采用下述步骤。如果不能关闭数据库，只能采用新建redo log files的方式来实现修改该redo 的路径了。一、shutdown the database 二、拷贝re...
    99+
    2022-10-18
  • oracle 修改数据文件路径
    一、关库修改文件位置 1.连接到数据库  [oracle@linux]$ ./sqlplus /nolog  SQL> conn / as sysdba   2. 查看数据文件位置 SQL> select name ...
    99+
    2017-11-21
    oracle 修改数据文件路径
  • sublime nodejs路径修改
    Sublime Text 是一款流行的集成开发环境（IDE）软件，被广泛用于编程和开发。在 Sublime Text 中使用 Node.js 进行开发时，我们需要配置 Node.js 的路径。本文将介绍如何在 Sublime Text 中修...
    99+
    2023-05-18
  • Oracle修改控制文件路径的方法
    这篇文章主要介绍“Oracle修改控制文件路径的方法”，在日常操作中，相信很多人在Oracle修改控制文件路径的方法问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”Oracle...
    99+
    2022-10-18
  • Gitlab如何修改路径
    这篇文章主要讲解了“Gitlab如何修改路径”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“Gitlab如何修改路径”吧！关闭Gitlab服务在进行路径修改之前，请先关闭Gitlab服务。我们...
    99+
    2023-07-05
  • 如何查看修改oracle归档日志路径
    这篇文章将为大家详细讲解有关如何查看修改oracle归档日志路径，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。1.修改归档日志的格式默认格式是：“ %t_%s_%r.db...
    99+
    2022-10-18
  • 四步修改jupyter的工作路径/存储路径
    四步修改jupyter的工作路径/存储路径 在jupyter终端（Anaconda Prompt）输入：jupyter notebook --generate-config ，回车查看路径，根据路径找...
    99+
    2023-09-17
    jupyter python
  • Android修改默认gradle路径
    Android Studio每次新建项目，都会默认在C盘生成并下载gradle相关文件，由于C盘空间有限，没多久C盘就飘红了，于是就需要把gradle相关文件转移到其他盘 1、到C盘找到gradle文...
    99+
    2023-09-23
    android
  • Python工作路径sys.path修改
      刚开始学习Python的时候，我们会使用命令行，而我们编辑的模块（脚本）往往会放在另外的文件夹中，包括路径也可能与python所安装的路径不同，因此跟着教材或者视频敲实验的时候，会导师有些函数无法直接调用脚本，入import、reloa...
    99+
    2023-01-31
    路径 工作 Python
  • composer如何修改php路径
    本篇内容介绍了“composer如何修改php路径”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！composer修改php路径的方法：1、搜...
    99+
    2023-07-04
  • composer 怎么修改php路径
    本教程操作环境：windows7系统、PHP8.1版、Dell G3电脑。composer 怎么修改php路径？更改Composer的PHP路径开发PHP应用程序时，您可能需要更改Composer使用的PHP版本。由于composer命令使...
    99+
    2022-10-24
  • cmd python 默认路径修改
    如果电脑里装了多个版本的python时，要想在cmd python时进入需要的python版本，可以通过 修改系统环境变量，将原有路径修改为想要的路径即可 例如环境变量里的路径为：D:\Anaconda\Anaconda3\ 当路径为...
    99+
    2023-01-31
    路径 cmd python
  • tomcat怎么修改jdk路径
    要修改Tomcat的JDK路径，需要编辑Tomcat的启动脚本。以下是在Windows操作系统中修改Tomcat的JDK路径的步骤：...
    99+
    2023-08-17
    tomcat
  • pip install 安装路径的修改
    一般我们需要安装第三方库的时候，都是进入cmd中用pip命令来进行安装。 安装各类包，但是默认安装路径在C盘，极大占用空间，下面我们就来修改一下默认的安装路径。 1，查看pip默认的安装路径 打开命令提示符（win+r），输入cmd，输入命...
    99+
    2023-09-03
    pip python
  • 如何修改mysql服务路径
    这篇文章主要介绍“如何修改mysql服务路径”的相关知识，小编通过实际案例向大家展示操作过程，操作方法简单快捷，实用性强，希望这篇“如何修改mysql服务路径”文章能帮助大家解决问题。 ...
    99+
    2022-10-19
  • 如何修改mysql日志路径
    这篇文章给大家分享的是有关如何修改mysql日志路径的内容。小编觉得挺实用的，因此分享给大家做个参考，一起跟随小编过来看看吧。 1、修改mysql日志路径 vim /etc/my.cnf log-bi...
    99+
    2022-10-19
  • rocketmq如何修改存储路径
    一、下载rocketmq对应版本源码 修改消息存储路径需要修改rocketmq源码，因为rocketmq取的默认路径是user.home路径，也就是用户的根目录，如下所示 直接修改...
    99+
    2022-11-12
  • pip安装路径如何修改
    这篇文章主要介绍了pip安装路径如何修改的相关知识，内容详细易懂，操作简单快捷，具有一定借鉴价值，相信大家阅读完这篇pip安装路径如何修改文章都会有所收获，下面我们一起来看看吧。前言当我们需要安装python的第三方库时，通常都是打开cmd...
    99+
    2023-07-02
  • gitee怎么修改仓库路径
    这篇文章主要讲解了“gitee怎么修改仓库路径”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“gitee怎么修改仓库路径”吧！一、什么是Gitee仓库路径？Gitee的仓库路径指的是存储代码仓...
    99+
    2023-07-05
软考高级职称资格查询
软考职称历年真题下载
软考职称资料下载
热门wiki
近期文章
推荐阅读
热门问答
热门标签
编程网，编程工程师的家园，是目前国内优秀的开源技术社区之一，形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容，为IT开发者提供了一个发现、使用、并交流开源技术的平台。

  • 官方手机版

  • 微信公众号

  • 商务合作