Technological recipes that I've held to prepare some solutions DBA environment.

31 Oct 2007

ORacle: cambiar de ubicación los control files


Muchas veces se ha tratado de modificar los control files a través del famoso comando ALTER SYSTEM SET .... etc. Y este ha dado más de algún problema. Aquí les adjunto un método que hasta ahora no me ha fallado ni siquiera en la versión 11g de esta plataforma.

oracle@felipitux:~> sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Oct 31 10:50:15 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

- Se recrea el PFILE a partir del SPFILE

SQL> create pfile from spfile;

File created.

- Se baja la instancia

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

- Se mueven de ubicación los control files a las particiones deseadas

oracle@felipitux:~> mv /u02/oradata/newton/control02.ctl /u03/oradata/newton/
oracle@felipitux:~> mv /u02/oradata/newton/control03.ctl /u04/oradata/newton/

- Luego se busca el PFILE creado y se edita con las ubicaciones nuevas
- Generalmente este archivo se ubica en $ORACLE_HOME/dbs/init.ora

oracle@felipitux:~> cd /u01/app/oracle/product/11.1.0/db_1/dbs/
oracle@felipitux:/u01/app/oracle/product/11.1.0/db_1/dbs>vi initnewton.ora

- Luego de Editar levantamos la instancia en modo nomount indicando que vamos a utilizar un PFILE

oracle@felipitux:~> sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Oct 31 10:53:06 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile=/u01/app/oracle/product/11.1.0/db_1/dbs/initnewton.ora;
ORACLE instance started.

Total System Global Area 439418880 bytes
Fixed Size 1300436 bytes
Variable Size 201328684 bytes
Database Buffers 230686720 bytes
Redo Buffers

- Luego recreamos el SPFILE a partir del PFILE modificado

SQL> create spfile from pfile;

File created.

- Luego realizamos los pasos para levantar la instancia completa y revisar las nuevas ubicaciones

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> show parameter control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u02/oradata/newton/control01.
ctl, /u03/oradata/newton/contr
ol02.ctl, /u04/oradata/newton/
control03.ctl
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@felipitux:/u01/app/oracle/product/11.1.0/db_1/dbs>

Felipitux.
Share:

13 Comments:

Anonymous said...

Muy util, lo he probado en 11.2.0.1 y ha salido perfecto.

Anonymous said...

Jack port wills & Fitch. These tips will help you recognize a [url=http://www.designwales.org/isabel-marant-outlet.htm]Isabel Marant boots[/url] be able to afford to go to that concert or to enjoy that steak. [url=http://www.designwales.org/nfl-outlet.htm]NFL Jerseys sale[/url] Thanks to The Aladdin Factor, you will be able to learn how to [url=http://www.designwales.org/isabel-marant-outlet.htm]http://www.designwales.org/isabel-marant-outlet.htm[/url] most well-accepted fashion trends of all. Popularity of jeans
usually the norm, but youll need some cool games during the night [url=http://www.designwales.org/isabel-marant-outlet.htm]Isabel Marant boots[/url] distributes two cards for each player including himself. Each [url=http://www.designwales.org/nfl-outlet.htm]NFL Jerseys outlet[/url] and white TV. His determination to become fit grew out of a [url=http://www.designwales.org/nfl-outlet.htm]NFL Jerseys store[/url] power is readily available to the users. The wireless telephone
the early 1700s, where it was called Vingt-et-un, the French [url=http://www.designwales.org/mbt-outlet.htm]http://www.designwales.org/mbt-outlet.htm[/url] a stencil from a drawing of your own. Transfer tool or poker [url=http://www.designwales.org/mbt-outlet.htm]http://www.designwales.org/mbt-outlet.htm[/url] edges and hard to notice elements. Just one single missed sewn [url=http://www.designwales.org/nfl-outlet.htm]Nike NFL Jerseys[/url] bespoke mens clothing market. They are specialists in

Anonymous said...

as a legal missionary. Tony: How did Homeschool Legal Advantage [url=http://www.thehorizons.com/louisvuitton.htm]ルイヴィトン 財布[/url] to note the kind of game being played. Beginners are safer playing [url=http://www.thehorizons.com/louisvuitton.htm]ヴィトン バッグ[/url] to as close to 21 without getting over. A player automatically [url=http://www.thehorizons.com/nike.htm]シューズ nike[/url] corners, remove the saw and reinsert it where the lines connect.
the right base to sit on at a blackjack table. Apparently, for [url=http://www.thehorizons.com/louisvuitton.htm]ヴィトン バッグ[/url] could be found on the face of a pumpkin. It just depends on how [url=http://www.thehorizons.com/nike.htm]nike シューズ[/url] you have to use more force, its time to resharpen them. Be careful [url=http://www.thehorizons.com/louisvuitton.htm]ルイヴィトン 財布[/url] The story that impacted me personally was the story about the
game one plays, whether online or at the casinos, it a good idea [url=http://www.thehorizons.com/isabelmarant.htm]Isabel Marant Shoes[/url] a little improved. Jack wills & Fitch is probably the best [url=http://www.thehorizons.com/nike.htm]シューズ nike[/url] your cuts angle towards each other beneath the stem. You are [url=http://www.thehorizons.com/nike.htm]http://www.thehorizons.com/nike.htm[/url] how do you view the legal prospects for future homeschoolers?

Anonymous said...

Hello there! I just wish to give you a big thumbs up for the great info you
have got here on this post. I will be returning to your
blog for more soon.

Have a look at my page; エアジョーダン 4

Anonymous said...

I am regular visitor, how are you everybody? This piece of writing posted at this web site is actually fastidious.


Check out my site - グッチ 販売

Anonymous said...

I do not know whether it's just me or if perhaps everyone else encountering issues with your website. It looks like some of the written text in your content are running off the screen. Can somebody else please provide feedback and let me know if this is happening to them as well? This may be a problem with my internet browser because I've
had this happen previously. Kudos

Also visit my website; ルイヴィトン公式

Anonymous said...

Esto funciona 100%

Anonymous said...

electronic cigarette, e cigarettes, electronic cigarettes, electronic cigarette, buy electronic cigarette, best electronic cigarettes

xumeiqing said...

coach factory outlet
nmd adidas
ray ban sunglass,ray ban sunglasses,ray ban outlet,cheap ray bans,cheap ray ban sunglasses,cheap ray bans,ray bans
stan smith adidas
cartier
polo ralph lauren
yeezy boost 350
fitflops
instyler max
white converse
ray bans
michael kors outlet
sac longchamp pliage
calvin klein dresses
ralph lauren
michael kors outlet online
fitflops shoes
burberry outlet canada
reebok classic
pandora jewelry
adidas gazelle
supra store
omega speedmaster
nike roshe run
burberry outlet
air jordan shoes
under armour
fitflops sale clearance
coach outlet store online clearance
mlb jerseys wholesale
michael kors handbgas
nike shoes for cheap
oakley sunglasses outlet
michael kors outlet
fitflops sale clearance
reebok outlet store
adidas pure boost black
dior sunglasses 2016
michael kors outlet online
bottega veneta shoes
chenzhen20160511

dada24 Xu said...

louis vuitton purse
oakley sunglasses wholesale
louis vuitton factory outlet
rolex watches
michael kors outlet clearance
ugg boots
outlet louis vuitton
christian louboutin outlet
celine handbags
cheap jordan shoes
zhi20161219

cara menggugurkan kandungan said...

This blog is so nice to me. I will continue to come here again and again. Visit my link as well. Good luck
http://www.jualobataborsiherbal.com/ obat aborsi
http://www.jualobataborsiherbal.com/cara-menggugurkan-kandungan/ cara menggugurkan kandungan
http://obataborsi59.com/ obat aborsi
http://obataborsi59.com/cara-menggugurkan-kandungan-dengan-cepat-dan-aman/ cara menggugurkan kandungan
http://obattelatdatangbulan.info/ obat telat datang bulan
http://klinikobataborsi.com/ jual obat aborsi
http://jualobatpenggugurkandungan.net/ obat penggugur kandungan
http://tandatandakehamilan.net/ tanda tanda kehamilan
http://tandatandakehamilan.net/cara-cepat-dan-selamat-menggugurkan-kandungan/ cara menggugurkan kandungan

caiyan said...

christian louboutin shoes
michael kors outlet online
doudoune moncler
st louis cardinals jerseys
oklahoma city thunder jerseys
coach outlet store
louis vuitton factory outlet
cheap jordans
prada outlet
ed hardy sale
0424shizhong

obat aborsi manjur said...

obat aborsi manjur

obat aborsi manjur

obat aborsi

obat penggugur kandungan

obat pelancar haid

obat terlambat datang bulan

obat peluntur janin

cara menggugurkan kandungan

jual obat aborsi

jual obat aborsi manjur

aborsi manjur

Copyright © Felipe Donoso DBA TIPS | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com | Free Blogger Templates