RE: Help in Recovery

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@xxxxxxxxxxxxx on behalf of Nagaraj S
Sent: Sat 18/10/2008 19:30
To: Johnson, William L (TEIS)
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nagaraj S
        Sent: Saturday, October 18, 2008 2:05 PM
        To: oracle-l@xxxxxxxxxxxxx
        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

Other related posts: