Thanks for replying,
Yes I did delete all the archive log files thro the script itself.
but I had not set the time now it works,thank you very much.
Can you give some practical example of how I can do a recovery when I have
done incremental backup.
If you can point me to some white paper also will be good
Thanks again
Arun
>From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re:
>Date: Fri, 02 Jun 2000 11:43:36 -0800
>
>You will need to do a recovery "until time" which is earlier than the time
>you 'lost' the database. But more to your point, did you delete the
>archivelogs after you backed them up. If not you are trying to restore
>archivelogs which are already there which is what the errors indicate.
>Ruth
>----- Original Message -----
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Sent: Friday, June 02, 2000 1:36 PM
>
>
> > Hi dba's,
> > I am have just started working on RMAN on 8.1.5 on sun solaris.
> > I have problems doing the disaster recovery wherein I loose all the
>files
> > including the controlfiles.
> > I did go according to the RMAN doc which was given by oracle.
> > but still I am getting errors.
> > Can somebody please let me know as to how I should recover properly
>using
> > the RMAN.
> > Down below is the scenario,
> > I have two databases HDRD which is the prod database and TEST which is
>the
> > catalog database.
> > The HDRD is register and is in snyc with the catalog.
> > I did a full backup of the database using the rman and seperately backed
>up
> > all the archive log files also and again resynced the catalog manager.
> > I deleted all the files in the prod ie HDRD database and then started
>the
> > database in nomount stage,connected thro rman and ran the sql which does
>the
> > recovery down below is the sql
> >
> > run {
> > allocate channel t1 type disk;
> > restore
> > controlfile to '/jaguar12/oradata/HDRD/control01.ctl';
> > restore
> > controlfile to '/jaguar12/oradata/HDRD/control02.ctl';
> > sql 'alter database mount';
> > restore (database);
> > recover database;
> > }
> >
> > It recovers the controlfiles and restores the database upto the last
> > database and then starts giving error which is as below
> > Can somebody please help me out as to how I can solve this probs.
> > I have to manually say recover database using backup controlfile until
> > cancel and then open the database with resetlogs. then it works
> > Please let me know as to what I should do
> > Thanks in advance
> > Arun
> >
> >
> >
> > RMAN-06050: archivelog thread 1 sequence 7 is already on disk as file
> > /opt/app/oracle/admin/HDRD/arc
> > h/1_7.dbf
> > RMAN-03023: executing command: recover(4)
> > RMAN-08017: channel t1: starting archivelog restore to default
>destination
> > RMAN-08022: channel t1: restoring archivelog
> > RMAN-08510: archivelog thread=1 sequence=1
> > RMAN-08022: channel t1: restoring archivelog
> > RMAN-08510: archivelog thread=1 sequence=2
> > RMAN-08022: channel t1: restoring archivelog
> > RMAN-08510: archivelog thread=1 sequence=3
> > RMAN-08022: channel t1: restoring archivelog
> > RMAN-08510: archivelog thread=1 sequence=4
> > RMAN-08022: channel t1: restoring archivelog
> > RMAN-08510: archivelog thread=1 sequence=5
> > RMAN-08022: channel t1: restoring archivelog
> > RMAN-08510: archivelog thread=1 sequence=6
> > RMAN-08023: channel t1: restored backup piece 1
> > RMAN-08511: piece handle=/jaguar12/oradata/HDRD/RMAN_BACKUP/%a
>params=NULL
> > RMAN-08024: channel t1: restore complete
> > RMAN-08515: archivelog filename=/opt/app/oracle/admin/HDRD/arch/1_1.dbf
> > thread=1 sequence=0
> > RMAN-08515: archivelog filename=/opt/app/oracle/admin/HDRD/arch/1_2.dbf
> > thread=1 sequence=2
> > RMAN-08515: archivelog filename=/opt/app/oracle/admin/HDRD/arch/1_3.dbf
> > thread=1 sequence=3
> > RMAN-08515: archivelog filename=/opt/app/oracle/admin/HDRD/arch/1_4.dbf
> > thread=1 sequence=4
> > RMAN-08515: archivelog filename=/opt/app/oracle/admin/HDRD/arch/1_5.dbf
> > thread=1 sequence=5
> > RMAN-08515: archivelog filename=/opt/app/oracle/admin/HDRD/arch/1_6.dbf
> > thread=1 sequence=6
> > RMAN-08515: archivelog filename=/opt/app/oracle/admin/HDRD/arch/1_7.dbf
> > thread=1 sequence=7
> > RMAN-08060: unable to find archivelog
> > RMAN-08510: archivelog thread=1 sequence=7
> > RMAN-03026: error recovery releasing channel resources
> > RMAN-08031: released channel: t1
> > RMAN-00571: ===========================================================
> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> > RMAN-00571: ===========================================================
> > RMAN-03002: failure during compilation of command
> > RMAN-03013: command type: recover
> > RMAN-03006: non-retryable error occurred during execution of command:
> > recover(4)
> > RMAN-07004: unhandled exception during command execution on channel
>default
> > RMAN-20000: abnormal termination of job step
> > RMAN-06054: media recovery requesting unknown log: thread 1 scn 34982
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: ARUN K C
> > INET: arun_k_c_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Fri Jun 02 2000 - 15:35:09 CDT
