Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:

Re:

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Mon, 5 Jun 2000 08:13:20 -0400
Message-Id: <10519.107688@fatcity.com>


If you are using rman with a recovery catalog then rman knows which backups to use to do a point in time recovery. If you point in time need an incremental than rman will use it.
Ruth
----- Original Message -----
From: ARUN K C <arun_k_c_at_hotmail.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, June 02, 2000 5:45 PM
Subject: Re:

> 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).
>
> ________________________________________________________________________
> 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
Received on Mon Jun 05 2000 - 07:13:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US