Re: Help in Recovery

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 20 Oct 2008 11:53:10 -0700
Message-ID: <bf46380810201153xa91cb0ftb517ba2260dd775a@mail.gmail.com>


On Mon, Oct 20, 2008 at 5:34 AM, Vishal Gupta <vishal_at_vishalgupta.com>wrote:

> Nagaraj,
>
> From the looks of erros below, you have not had a successfull archivelog
> backup. This is because you deleted/compresses the archive logs before they
> could be backed up by RMAN. You need to run "crosscheck archivelog all"
> before running RMAN backup. So that RMAN knows about missing/deleted
> archivelogs, and can successfully backup all archivelogs generated during
> RMAN backup.
>
> Regards,
> Vishal Gupta
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org on behalf of Nagaraj S
> *Sent:* Sat 18/10/2008 19:30
> *To:* Johnson, William L (TEIS)
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Help in Recovery
>
> 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 Mon Oct 20 2008 - 13:53:10 CDT

Original text of this message