Technological recipes that I've held to prepare some solutions DBA environment. (by Felipe Donoso Bastias)

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 - 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 - 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 - 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 - 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

------------------------------------ ----------- ------------------------------
control_files string /u02/oradata/newton/control01.
ctl, /u03/oradata/newton/contr
ol02.ctl, /u04/oradata/newton/
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options



Anonymous said...

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

Anonymous said...

Jack port wills & Fitch. These tips will help you recognize a [url=]Isabel Marant boots[/url] be able to afford to go to that concert or to enjoy that steak. [url=]NFL Jerseys sale[/url] Thanks to The Aladdin Factor, you will be able to learn how to [url=][/url] most well-accepted fashion trends of all. Popularity of jeans
usually the norm, but youll need some cool games during the night [url=]Isabel Marant boots[/url] distributes two cards for each player including himself. Each [url=]NFL Jerseys outlet[/url] and white TV. His determination to become fit grew out of a [url=]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=][/url] a stencil from a drawing of your own. Transfer tool or poker [url=][/url] edges and hard to notice elements. Just one single missed sewn [url=]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=]ルイヴィトン 財布[/url] to note the kind of game being played. Beginners are safer playing [url=]ヴィトン バッグ[/url] to as close to 21 without getting over. A player automatically [url=]シューズ 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=]ヴィトン バッグ[/url] could be found on the face of a pumpkin. It just depends on how [url=]nike シューズ[/url] you have to use more force, its time to resharpen them. Be careful [url=]ルイヴィトン 財布[/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=]Isabel Marant Shoes[/url] a little improved. Jack wills & Fitch is probably the best [url=]シューズ nike[/url] your cuts angle towards each other beneath the stem. You are [url=][/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
polo ralph lauren
yeezy boost 350
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

Unknown 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

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 obat aborsi cara menggugurkan kandungan obat aborsi cara menggugurkan kandungan obat telat datang bulan jual obat aborsi obat penggugur kandungan tanda tanda kehamilan 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

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

Unknown said...

hammer of thor

hammer of thor asli

jual hammer of thor

hammer of thor murah

thor hammer

jual thor hammer


klg pill

jual klg

klg asli

klg pill asli

titan gel

titan gel asli

jual titan gel

gel titan

obat pembesar penis

obat pembesar penis

obat pembesar penis

obat pembesar penis

obat pembesar penis


penirum asli

jual penirum

testo ultra

testo ultra asli

jual testo ultra

Unknown said...

football pas cher
moncler jackets
vibram five fingers
kate spade outlet
moncler jackets
nhl jerseys
ferragamo outlet
true religion outlet
christian louboutin shoes

Clipping Path Service said...

Enjoyed reading the article above , really explains everything in
detail,the article is very interesting and effective.Thank you and good
luck for the upcoming articles
clipping path
clipping path service
background removal
raster to vector

John said...

kate spade handbag
moncler outlet online
nike outlet store
ugg outlet
christian louboutin outlet
ysl handbags
kate spade handbag
air max 2019
hermes bags
new balance shoes

Unknown said...

20181107 orf
dior outlet
le coq sportif shoes
nike revolution
north face jackets
coach outlet
coach outlet
uggs outlet
ugg boots
lacoste soldes
tory burch outlet

Coqicoqi said...

Red Bottom for Women
Pandora Jewelry Official Site
Kyrie Shoes
Jordan Retro 11
Nike Air Max 270
Jordan 4 Retro
Jordans 11
Jordan 11
Pandora Jewelry

Coqicoqi said...

Jordan 4 Retro
Jordan 4 Retro
Pandora Outlet
Nike Air Max 270
Jordan 11
Jordan 11 For Sale
Red Bottom Shoes
Yeezy boost 350 v2
Jordan Retro 11

Amy Wong said...

Imagine yesterday went to some online casino copacetic online casino gambling sites and decided to ponastalgirovat. so many pleasant memories when you again see this slot machine mmm cool

move on said...

now present in your city cara menggugurkan kandungan
1. manfaat kurma untuk persalinan
2. manfaat buah nanas
3. aktivitas penyebab keguguran
4. apakah usg berbahaya
5. penyebab telat haid
6. cara melancarkan haid
7. cara mengatasi keputihan

yanmaneee said...

kyrie 6
vans outlet
nike shoes
jordan 6
moncler jackets
kyrie 5 spongebob
kobe shoes
air max 95

Copyright © DBA TIPS | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by | Free Blogger Templates