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 -----
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 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
Received on Fri Jun 02 2000 - 13:31:13 CDT
