Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HOTBACKUP Help!

HOTBACKUP Help!

From: Chuckster <chuckycarson_at_yahoo.com>
Date: Tue, 27 Aug 2002 13:17:05 -0700
Message-ID: <3d6bdbe4_5@corp-goliath.newsgroups.com>

Can anyone point me to some online resources or recommend any books that cover everything a dummy need to know about hot backups? I have the Oracle Press Backup and Recovery Handbook and it devotes one whole paragraph to hotbackups.

I am a Unix veteran turned DBA maintaining some very busy databases. I frequently have to build test databases using the hotbackups from production databases and I am having frequent problems. (ie: recovery not working, control file problems, etc..)

After I have placed all tablespaces/datafiles into backup mode and copied them, I back up the control file as follows:

alter database backup controlfile to /my/backup/dest/control.08272002

When I go and build a database from this hotbackup, I merely rename and use the file created above ($CONTROL_FILE)
ie:

cp control08272002 control01.ctl
cp control08272002 control02.ctl
cp control08272002 control03.ctl

Am I not doing this correctly?

Thanks,
CC

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Aug 27 2002 - 15:17:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US