hot-backup recovery question 2005-03-14 - By Hollis, Les
We do this very thing every night plus we rename the database and add
indexes for reporting purposes.
Are you copying over any logfiles and applying them before you try to
open? I didn't see that in your steps.
You will need to copy over the logfiles n use when yopu started the
alter tablespace begin backup, any logfiles generated during the mirror
copy and the last logfile generated . When you do the alter tablespace
end backup, immediately do an alter system switch logfile and copy that
one over as well.
Apply the logfiles and after the last one is applied then type cancel;
Then you can do your alter database open resetlogs.
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Rich Holland
Sent: Monday, March 14, 2005 9:24 AM
To: hkchital@(protected); oracle-l@(protected)
Subject: RE: hot-backup recovery question
The storage system is a pair of EMC DMX-1000's with an SRDF connection
(between
buildings). It's a certified solution, and I've checked metalink about
the
"fuzzy" file errors -- the articles there all suggest putting the
tablespaces
in hot backup mode first (which I've done and verified).
Any other ideas?
--
Rich Holland (913) 645-1950 SAP Technical Consultant
print unpack("u","92G5S\=3D\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");
> -- --Original Message-- --
> From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On
> Behalf Of Hemant K Chitale
> Sent: Monday, March 14, 2005 10:11 AM
> To: holland@(protected); oracle-l@(protected)
> Subject: Re: hot-backup recovery question
>=20
> Which is the storage system that you are using ? Only certain storage
> systems
> are "certified". Start with
> http://www.oracle.com/technology/deploy/availability/htdocs/oscp.html
> and
http://www.oracle.com/technology/deploy/availability/htdocs/vendors.html
>=20
> For each vendor, there are links to documents on how to take Hot
Backups.
>=20
> Hemant
>=20
> >At 11:09 PM Monday, Rich Holland wrote:
> >I=3D92m trying to use a hot backup to make a copy of our production
817_32 =3D
> >database
> >using a 3rd disk mirror split operation. Here are the steps I=3D92m =
=3D
> >taking:
>=20
> Hemant K Chitale
> http://web.singnet.com.sg/~hkchital
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
|
|
