Moving Control Files


sqlplus "/ as sysdba"
SQL> shutdown immediate
bash-3.2$ mv /u01/app/oracle/oradata/ANARDB/control01.ctl 
/data/ANARDB/controlfile/control01.ctl
bash-3.2$ mv /u01/app/oracle/fast_recovery_area/ANARDB/control02.ctl 
/data/ANARDB/controlfile/control02.ctl
sqlplus / as sysdba;
create pfile from spfile;
exit
bash-3.2$ vi initANARDB.ora 
"initANARDB.ora" 27 lines, 1048 characters 
ANARDB.__db_cache_size=3388997632
ANARDB.__java_pool_size=16777216
ANARDB.__large_pool_size=16777216
ANARDB.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
ANARDB.__pga_aggregate_target=158779572224
ANARDB.__sga_target=4294967296
ANARDB.__shared_io_pool_size=0
ANARDB.__shared_pool_size=788529152
ANARDB.__streams_pool_size=16777216
*.audit_file_dest='/u01/app/oracle/admin/ANARDB/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/data/ANARDB/controlfile/control01.ctl',
'/data/ANARDB/controlfile/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='PREAZKKD'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.db_unique_name='ANARDB'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ANARDBXDB)'
*.open_cursors=300
*.pga_aggregate_target=158765940736
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=4293918720
*.undo_tablespace='UNDOTBS1'
:wq!
SQL> create spfile from pfile;
File created.
SQL> startup;
ORACLE instance started.
Total System Global Area 4277059584 bytes
Fixed Size 2166160 bytes
Variable Size 838865520 bytes
Database Buffers 3388997632 bytes
Redo Buffers 47030272 bytes
Database mounted.
Database opened.
SQL> 
SQL> 
SQL>

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: