Re: Help in Recovery

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Sun, 19 Oct 2008 00:00:51 +0530
Message-ID: <e921f8570810181130u15d3aafdl9969cc45f66a2798@mail.gmail.com>

I have checked my rman hot backup log on QC server

channel tape2: finished piece 1 at 02-OCT-08 piece handle=ORA_lvl0_j1jsbbd3_1_1_667266467 tag=LEVEL_0_BACKUP_DATABASE comment=API Version 2.0,MMS Version 5.0.0.0 channel tape2: backup set complete, elapsed time: 00:00:41 Finished backup at 02-OCT-08
sql statement: alter system archive log current Starting backup at 02-OCT-08
current log archived
released channel: tape1
released channel: tape2

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 10/02/2008 23:50:30 RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/oracle/arch/GAYA44081664133887.log ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory Additional information: 3
Recovery Manager complete.

        End level 0 backup for [ GAYA ] at Sat Oct 2 23:50:43 EDT 2008

I can see after the hot backup has been completed. It throughs error for archive file missing

Regards,
Nagaraj
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:30:51 CDT