RE: hot-backup recovery question

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Holland Sent: Monday, March 14, 2005 9:24 AM
To: hkchital_at_singnet.com.sg; oracle-l_at_freelists.org 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_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org] On


> Behalf Of Hemant K Chitale

> Sent: Monday, March 14, 2005 10:11 AM

> To: holland_at_guidancetech.com; oracle-l_at_freelists.org

> 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