Thank you for visiting my BLOG. Just another ORACLE BLOG. This page contains my experiences about Oracle. The BLOG is open until the last visitor.
Friday, September 24, 2010
Migrating Databases To and From DISK with Recovery Manager
Migrated 600GB with this doc to another ocfs2 disk, with only one restart.
Migrating Databases To and From ASM with Recovery Manager
(Migration BACKUP as COPY doesn't work in 9i, only >=10g)
with rman
run {
allocate channel dev3 type disk;
allocate channel dev4 type disk;
allocate channel dev5 type disk;
BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE
FORMAT '/usr8/oracle/oradata/DWH/%U.dbf' TAG 'ORA_TO_MIGRATION';
}
backup incremental level 1 for recover of copy with tag 'ORA_TO_MIGRATION' database;
recover copy of database with tag 'ORA_TO_MIGRATION';
SHUTDOWN IMMEDIATE;
STARTUP MOUNT
switch database to copy;
recover database;
to migrate controlfile:
SHUTDOWN IMMEDIATE;
STARTUP MOUNT
BACKUP AS COPY CURRENT CONTROLFILE FORMAT '/opt/oracle/pre-ASM-controfile.ctl';
sysdba
alter system set control_files='/opt/oracle/oradata/AIRT/AIRT/controfile1.ctl','/opt/oracle/oradata/AIRT/AIRT/controfile2.ctl','/opt/oracle/oradata/AIRT/AIRT/controfile3.ctl' scope=spfile sid='*';
shutdown immediate
startup nomount
restore controlfile from '/opt/oracle/pre-ASM-controfile.ctl';
shutdown immediate
startup
alter database open resetlogs;
FALLBACK
SET DBID 1827102997;
RUN {
ALLOCATE channel c1 TYPE disk;
ALLOCATE channel c2 TYPE disk;
RESTORE CONTROLFILE FROM autobackup;
}
SHUTDOWN IMMEDIATE;
STARTUP MOUNT
restore controlfile from '/opt/oracle/pre-ASM-controfile.ctl';
alter database mount;
Subscribe to:
Post Comments (Atom)
Does your site have a contact page? I'm having trouble
ReplyDeletelocating it but, I'd like to shoot you an email.
I've got some suggestions for your blog you
might be interested in hearing. Either way,
great website and I look forward to seeing it grow over time.
Look at my website: เครื่องดักยุง
Hmm it appears like your website ate my first comment (it was
ReplyDeletesuper long) so I guess I'll just sum it up what I had written and say, I'm thoroughly enjoying your blog.
I too am an aspiring blog blogger but I'm still new to the whole thing.
Do you have any suggestions for beginner
blog writers? I'd definitely appreciate it.
My blog post - DIY Security System DIY Security System DIY Security System
I loved as much as you'll receive carried out right here.
ReplyDeleteThe sketch is attractive, your authored material stylish.
nonetheless, you command get bought an shakiness over that you wish
be delivering the following. unwell unquestionably come more formerly again as exactly the same
nearly a lot often inside case you shield this hike.
Also visit my web page: seo
suplemen herbal
ReplyDeletecream pembesar penis
obat pembesar penis
Thanks for a wonderful share. Your article has proved your hard work and experience you have got in this field. Brilliant .i love it reading.
ReplyDeleteferragamo shoes
ReplyDeleteferragamo outlet
ferragamo shoes
ferragamo outlet
rolex watches
rolex watches outlet
rolex watches
tiffany and co
tiffany outlet
tiffany outlet
tiffany and co
longchamp outlet
longchamp handbags
longchamp outlet
true religion jeans
true religion outlet
true religion jeans
true religion jeans sale
fitflops clearance
fitflops uk
fitflops uk
michael kors uk
michael kors outlet uk
tiffany jewellery
tiffany jewelry
beats headphones
beats headphones
oakley sunglasses uk
oakley sunglasses sale
ray ban sunglasses
ray-ban sunglasses
hollister shirts
lululemon uk
rolex watches for sale
mulberry bags
lllllyuan20160601
michael kors outlet clearance
ReplyDeletenhl jerseys wholesale
true religion jeans outlet
coach outlet store
cheap nfl jerseys
pandora charms
wholesale nike shoes
nike air force black
michael kors outlet clearance
nike tn
louis vuitton borse
running shoes
fitflops shoes
michael kors outlet
nba jerseys wholesale
adidas pure boost
michael kors handbags outlet
louis vuitton purse
oakley sunglasses
yeezy boost 350
jordan pas cher
asics gel nimbus
nike store uk
yeezy boost 350 white
rolex submariner
coach outlet store online
oakley sunglasses
ray ban sunglasses
true religion uk
rolex watches uk
michael kors handbags outlet
polo ralph lauren
201678yuanyuan
pandora charms sale
ReplyDeletecanada goose pas cher
true religion jeans outlet
jordan uk
rolex watches
louis vuitton handbags
michael kors bags
cheap jordan shoes
coach factory outlet online
cheap jordans for sale
zhi20161126
michael kors uk
ReplyDeletemulberry purse
nike store
christian louboutin shoes
coach outlet
nike blazer low
ralph lauren outlet
michael kors outlet
mulberry handbags
ralph lauren
20170223caiyan
longchamp outlet
ReplyDeletekobe shoes
fitflops
true religion outlet
hermes belt
atlanta falcons jersey
retro jordans
air max 2016
kobe bryant shoes
michael kors outlet
good
ReplyDeletepandora charms outlet
ReplyDeletered bottom
ugg canada
canada goose
puma outlet
tory burch outlet online
timberland boots outlet
nike sneakers
ralph lauren
pandora jewelry
clb20180523
Pil Cytotec
ReplyDeleteObat Aborsi
Obat Penggugur Kandungan Terbukti Manjur
Jual Pil Cytotec Obat Penggugur Kandungan Obat Aborsi Terbukti Manjur
Obat Aborsi
Obat Penggugur Kandungan Manjur & Aman
https://www.bfirstseo.com/تنظيف-سجاد-بالرياض/
ReplyDeletelongchamp
ReplyDeletekyrie 6 shoes
supreme outlet
longchamp bags
jordan shoes
supreme
birkin bag
off-white
supreme clothing
golden goose sneakers
moved here important source check my source web useful content additional reading
ReplyDeletehttps://istanbulolala.biz/
ReplyDeleteQ6SX
F5F6C
ReplyDeleteMuğla Evden Eve Nakliyat
Rize Şehir İçi Nakliyat
Bybit Güvenilir mi
Malatya Lojistik
Mersin Lojistik
Amasya Parça Eşya Taşıma
Kastamonu Şehir İçi Nakliyat
Kucoin Güvenilir mi
Bartın Parça Eşya Taşıma
C52A3
ReplyDeleteSincan Fayans Ustası
Nevşehir Evden Eve Nakliyat
Binance Referans Kodu
Referans Kimliği Nedir
Coinex Güvenilir mi
Ankara Boya Ustası
Çerkezköy Yol Yardım
Yobit Güvenilir mi
Van Evden Eve Nakliyat