Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle controlfile path modification

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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'

* .GetWord ("control_files='/s01/oracle/oradata/athena/control01.ctl','CC");; "s01Universe Universe fastening; recoveryrecovery; area;

* .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'

* .girls = 94CC "610 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'

* .ctlUniverse "> / s01Universe Universe fastening fastening recoveryActionaUniverse control02.ctllemagenatives01byoraclelemadataUniverse control_files='/s01/oracle/oradata/athena/control01.ctl','CC" > / s01aporacleUniplicasedbyfastfastening oracleUniplicatareaUniverse control 04.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'

* .girls = 94CC "610 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 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report