Re: Help in Recovery

is the source database up? What about the archive logs generated after the time frame you listed? the changes might be in those?

On Sat, Oct 18, 2008 at 1:58 PM, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:

> Also i issued the below command on QC database to detrmine what archive log
> sequences are needed. It returned no rows
>
> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YY HH24:MI';
>
> SQL> select SEQUENCE#, THREAD#, FIRST_CHANGE#, NEXT_CHANGE#,
> to_char(FIRST_TIME, 'Dy DD-Mon-YYYY HH24:MI') TIME
> 2 from v$log_history
> 3 where FIRST_TIME >= '02-OCT-08 20:00'
> 4 and FIRST_TIME <= '02-OCT-08 23:49';
>
> no rows selected
>
> On Sun, Oct 19, 2008 at 12:00 AM, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
>
>> 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
>>>
>>
>>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l