oracle controlfile路径修改
SQL> startup;ORACLE instance started.
Total System Global Area835104768 bytes
Fixed>
Variable> Database Buffers 197132288 bytes
Redo Buffers 2396160 bytes
Database mounted.
Database opened.
SQL> ho
$ cd $ORACLE_HOME
[$ cd 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 152009 init.ora
-rw-r----- 1 oracle oinstall 24 Oct 252013 lkATHENA
-rw-r----- 1 oracle oinstall 1536 Oct 252013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall 3584 Aug 20 20:12 spfileathena.ora
$ 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'
$ 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 152009 init.ora
-rw-r----- 1 oracle oinstall 24 Oct 252013 lkATHENA
-rw-r----- 1 oracle oinstall 1536 Oct 252013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall 3584 Aug 20 20:12 spfileathena.ora
$ 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/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$ Xshell
bash: Xshell: command not found
$ sqlplus /nolog
SQL*Plus:> 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 Area835104768 bytes
Fixed>
Variable> Database Buffers 197132288 bytes
Redo Buffers 2396160 bytes
Database mounted.
Database opened.
SQL> ho
$ cd $ORACLE_HOME
$ LL
bash: LL: command not found
$ cd 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 152009 init.ora
-rw-r----- 1 oracle oinstall 24 Oct 252013 lkATHENA
-rw-r----- 1 oracle oinstall 1536 Oct 252013 orapwathena
-rw-r----- 1 oracle oinstall 9748480 Jul8 23:07 snapcf_athena.f
-rw-r----- 1 oracle oinstall 3584 Aug 20 21:00 spfileathena.ora
$ 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$ Xshell
bash: Xshell: command not found
$ sqlplus /nolog
SQL*Plus:> 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>
页:
[1]