Re: Help in Recovery

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Sat, 18 Oct 2008 23:49:22 +0530
Message-ID: <e921f8570810181119q710d363bj7984c63967a6e3b5@mail.gmail.com>


Thanks for your reply. No i don't have archivelogs on primary server, i have removed by mistake on OS level without taking backup

On Sat, Oct 18, 2008 at 11:44 PM, Johnson, William L (TEIS) < WLJohnson_at_tycoelectronics.com> wrote:

> Check your alert log for the time frame when the backup was running. If
> you cut archive logs during the time frame the backup ran (start until
> finish inclusive), you must have them to recover the database. I don't
> believe the database will open if you cut logs during the hot backup and
> don't have them for the recovery. (What happened with your archive logs?)
>
>
>
> If you have not done anything in this database since your backup, and no
> new archive logs were cut, you may get lucky and be able to use your on-line
> redo logs as the logs that it wants for the recovery.
>
>
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Nagaraj S
> *Sent:* Saturday, October 18, 2008 2:05 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Help in Recovery
>
>
>
> I need to restore the QC hot backup to development database. I restored all
> the datafiles that were backed up in hotbackup. But i could able to restore
> the archive files that were backed during my hot backup.
> Once the database has been restored in development server,i have recreated
> control file and brought the database in mount stage.
> When i issue reset logs it gives me the below error. Also i don't have any
> archive files.. it is possible to open my database. Kindly help me
>
> SQL> alter database open resetlogs;
> alter database open resetlogs
> *
> ERROR at line 1:
> ORA-01194: file 1 needs more recovery to be consistent
> ORA-01110: data file 1: '/u01/oracle/data01/system00.dbf'
>
> Also when i issue recover database command it ask me the below archice file
>
> SQL> recover database using backup controlfile until cancel;
> ORA-00279: change 5402817860687 generated at 10/04/2008 20:14:22 needed for
> thread 1
> ORA-00289: suggestion : /u01/oracle/arch/archGAYA47771664133887.log
> ORA-00280: change 5402817860687 for thread 1 is in sequence #4777
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> cancel
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
> below
> ORA-01194: file 1 needs more recovery to be consistent
> ORA-01110: data file 1: '/u01/oracle/data01/system00.dbf'
>
>
>
> Regards,
>
> Nagaraj
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 18 2008 - 13:19:22 CDT

Original text of this message