Re: Cheap Cheap Database Recovery
From: <johnbhurley_at_sbcglobal.net>
Date: Fri, 20 Feb 2009 07:28:13 -0800 (PST)
Message-ID: <5bb03688-ebc0-490d-a205-4c31ad0c4204_at_d2g2000pra.googlegroups.com>
On Feb 20, 12:19 am, pitufo <vandr..._at_gmail.com> wrote:
> Jim, thanks for replying.
> No special reason for not using RMAN, I haven't got time to practice
> it.....
>
> Regarding this method: You are right, shame on me....cron was suppose
> to alter databse create controlfile to 'filename';
>
> Ok, I did it like that and created a consistent backed up controlfile.
>
> I moved it to the recovery server, and replace the old ones. After
> that I recover database using bacup controlfile until cancel.
> (here a parenthesis, before doing the recovery I queried v
> $recovery_log and it showed 56 rows, after the recover it shows no
> rows, but the recover produced exactly the same result, it only appied
> one archive log and then stopped with 'media recovery complete')
> Can you see what is wrong here ? (I can't, I really can't)
> Thank you so much,
Date: Fri, 20 Feb 2009 07:28:13 -0800 (PST)
Message-ID: <5bb03688-ebc0-490d-a205-4c31ad0c4204_at_d2g2000pra.googlegroups.com>
On Feb 20, 12:19 am, pitufo <vandr..._at_gmail.com> wrote:
> Jim, thanks for replying.
> No special reason for not using RMAN, I haven't got time to practice
> it.....
>
> Regarding this method: You are right, shame on me....cron was suppose
> to alter databse create controlfile to 'filename';
>
> Ok, I did it like that and created a consistent backed up controlfile.
>
> I moved it to the recovery server, and replace the old ones. After
> that I recover database using bacup controlfile until cancel.
> (here a parenthesis, before doing the recovery I queried v
> $recovery_log and it showed 56 rows, after the recover it shows no
> rows, but the recover produced exactly the same result, it only appied
> one archive log and then stopped with 'media recovery complete')
> Can you see what is wrong here ? (I can't, I really can't)
> Thank you so much,
When you do a recover database until cancel using backup controlfile it should prompt you 1 by 1 for each archive log and you hit enter if you want to keep applying.
Actually enter CANCEL when you want to stop applying archive logs OR when you don't have anymore.
Then alter database open resetlogs ... Received on Fri Feb 20 2009 - 09:28:13 CST