| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)
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.dbfthread=1 sequence=0
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
From: bill thater <thaterw_at_telergy.net> Date: Fri, 2 Jun 2000 12:12:57 -0400 (Eastern Daylight Time) Subject: RE: Work vs marriage
On Jun 2, Stephane Faroult scribbled on the wall in glitter crayon:
->I have watched this thread, interestingly started by a Brit but mainly
->followed by Americans (which is probably why nobody referred to one's
->supposedly better half as 'the trouble and strife') with much curiosity.
->Given the idyllic picture ("The little IT shop in the prairie") one
->wonders how the US manage to have so high a divorce rate. Must be SAs,
->developers and end-users who push the average up.
->
->Very refreshing.
->
sorry, but some of us don't have one worth saving.
-- Bill Thater Certified ORACLE DBAReceived on Fri Jun 02 2000 - 11:11:48 CDT
 |
 |