oracle controlfile路径修改
admin
2023-05-13 19:42:20
0次

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 '' to point to the oracle base (the one you specify at
# install time)

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest=''
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>

 

上一篇：科普关于新众乐牛牛必赢神器,微乐甘肃麻将辅助破解版,wepoker透视挂辅助器—教你开挂规律

下一篇：通过案例学调优之--Oracle参数（db_file_multiblock_read_count）

相关内容

热门资讯

空调连续工作多久需要停机休息 空调连续工作的时间取决于多个因素，包括空调的型号、功率、使用环境和维护情况等。一般来说，空调可以连续...
空调哪个符号是除湿的 空调除湿功能通常用一个水滴形状的符号表示。不同品牌和型号的空调遥控器可能会有所差异，但一般来说，除湿...
格力空调多长时间加一次氟利昂 1、一般情况下，空调对氟利昂的使用量是非常小的，所以在空调使用了四年左右的时候再考虑加也没问题。2、...
空调用多长时间需要加氟一次 一般情况下是五年。当出现以下这几种情况时，空调才需要加氟。1、空调的室内机和室外机各有两个接口，当接...
格调生活·C标思享荟：卡萨帝在... 9月12日的郑州龙湖金融岛，夜风轻拂，灯光璀璨。“C标时刻共传奇——卡萨帝思享荟暨20周年品牌盛典郑...
品牌价值破千亿、高端份额持续领... 9月12日，“C标时刻共传奇——卡萨帝思享荟暨20周年品牌盛典郑州站”在郑州龙湖金融岛举办。2026...
空调主板坏了修800还是换新的 空调主板坏了是修还是换新，需要考虑多个因素，以下是一些建议：1. 维修成本：如果维修费用较低，比如 ...
空调开多久需要休息多长时间 问题：空调开多久需要休息多长时间回答：1、在使用空调的过程中，一般空调开7~8个小时左右需要休息2~...
中央空调多长时间清洗一次 1、一般空调开机前清洗一次即可，空调开机中间时段再清洗一次，空调关机时清洗一次，这样比较合理。2、空...
中央空调氟利昂多久加一次 看空调制热和制冷程度，很多人的观点认为氟利昂必须一年放一次，其实这个观点是错误的，理解上面有点偏差，...