RE: full recovery

2004-01-21 Thread Hemant K Chitale
lf Of > DENNIS WILLIAMS > Sent: Friday, November 07, 2003 3:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: full recovery > > Rich - Could you point to the place where Robert states that bit about > controlfiles to trace? Thanks. > > Dennis Williams > DBA >

RE: full recovery

2004-01-21 Thread Rich Holland
print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > DENNIS WILLIAMS > Sent: Friday, November 07, 2003 3:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: f

Re: full recovery

2003-11-09 Thread Tanel Poder
gt; Rich Holland(913) 645-1950SAP Technical Consultant > print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Mercadante, Thomas F > >

Re: full recovery

2003-11-09 Thread Tanel Poder
e- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Mercadante, Thomas F > > Sent: Friday, October 24, 2003 2:35 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: full recovery > > > > > > AK, > > >

RE: full recovery

2003-11-07 Thread DENNIS WILLIAMS
13) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Mercadante, Thomas F > Sent: Friday, October 24, 2003 2:35 PM > To: Mult

RE: full recovery

2003-11-07 Thread Rich Holland
) Rich -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Mercadante, Thomas F > Sent: Friday, October

RE: full recovery

2003-10-24 Thread Andy Rivenes
I haven't followed this whole thread, but here's the answer to restoring the control file from an RMAN backup pre-9i. In 9i it's much easier using controlfile autobackups. Restoring the Control File from a Backup Set Without Using RMAN The following is taken straight from the Oracle documentation:

RE: full recovery

2003-10-24 Thread Mercadante, Thomas F
AK, First, your normal backup should backup your database in the following order: Database, archivelogs and then control file. I actually do this in three separate Rman steps. This is so that the most recent control file is backups up after all of the data. This allows your to perform an inc

RE: full recovery

2003-10-24 Thread DENNIS WILLIAMS
AK Since extracting the controlfile from your backup seems to be your major issue, perhaps someone on this list that mastered that issue will reply -- how about it? You could also Google for Oracle-L and RMAN, you might find where they posted it. 8i? Check Appendix C of Freeman's book. The ma

Re: full recovery

2003-10-24 Thread Joe Testa
1. Get a beer. 2. Tell damagement to go away and you'll call them when its done. 3. Get out Robert Freeman's book on RMAN, you do have that right and its all worn out from being dogeared and spilling beer on it, RIGHT? 4. restore the controlfile manually from the backup, you may have to figur

Re: full recovery

2003-10-24 Thread AK
More Info : OS : HP-UX oracle :8.1.7.4. Dennis , We are using controlfile and not recov catalog. Now Since I am on 8.1.7.4 , no different then you. If I dont have a explicit control file backup then finding SNCF ( snapshot control file ) is another way . Since we have a file system backup which

RE: full recovery

2003-10-24 Thread DENNIS WILLIAMS
AK - This sounds like a disaster recovery test. Be sure to buy Robert Freeman's Oracle9i RMAN Backup & Recovery if you don't have it already. I am on 8.1.6, and had difficulty extracting the control file from the backup (others on this list have done it, this is better on 9i). So I just "cheated" b