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”*.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 ‘
# install time)
memory_target=1G
processes = 150
audit_file_dest=’
audit_trail =’db’
db_block_size=8192
db_domain=”
db_recovery_file_dest=’
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
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 /nologSQL*Plus: Release 11.2.0.3.0 Produc免费云主机域名tion on Wed Aug 20 20:24:21 2014Copyright (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;STATUSNAME 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 594SQL> ho
[oracle@athena dbs]$ sqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:27:33 2014Copyright (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;STATUSNAME 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 594SQL> ho
[oracle@athena dbs]$ sqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:45:53 2014Copyright (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 /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:48:46 2014Copyright (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”*.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 /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:51:31 2014Copyright (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;STATUSNAME 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 594SQL> 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 /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:55:31 2014Copyright (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 /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:57:21 2014Copyright (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 /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 20:59:22 2014Copyright (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 /nologSQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 20 21:00:51 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.SQL> conn /as sysdba
Connected.
SQL> col name for a60
SQL> select * from v$controlfile;STATUSNAME 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 594SQL>
这篇文章主要讲解了“MAN备份FORMAT格式中%的含义是什么”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“MAN备份FORMAT格式中%的含义是什么”吧！使用RMAN>show all;可以显示出RMA…
免责声明：本站发布的图片视频文字，以转载和分享为主，文章观点不代表本站立场，本站不承担相关法律责任；如果涉及侵权请联系邮箱：360163164@qq.com举报，并提供相关证据，经查实将立刻删除涉嫌侵权内容。
微信扫一扫 
