Oracle Database Discussions

Hello Experts
I need to recover the database, details are:

Oracle 10g(relese 2) on RHEL 4.2
The Scinario is:

1. rman>backup database
2. SQL> alter system backup controlfile to trace
3. SQL> ! rm /u01/oracle/app/oradata/orcl/control*
4. SQL> ! rm /u01/oracle/app/oradata/orcl/redo02.lo (only two
group there)
5. SQL> shut abort
6. SQL> @ /u01/oracle/app/admin/orcl/udump/control02.sql( from trace i.e step 2, restlog)


ORA-01081: cannot start already-running ORACLE - shut it down first

Control file created.

ORA-00279: change 1376968 generated at 06/22/2009 09:43:50 needed for thread 1
ORA-00289: suggestion : /u01/oracle/app/oradata/archive/1_37_687881810.dbf
ORA-00280: change 1376968 for thread 1 is in sequence #37


ORA-00308: cannot open archived log '--'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log '--'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log '--'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log '--'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log '--'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log '--'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> create table my_table(id number);
create table my_table(id number)
*
ERROR at line 1:
ORA-01109: database not open


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlog;
alter database open resetlog
*
ERROR at line 1:
ORA-02288: invalid OPEN mode


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oracle/app/oradata/orcl/system01.dbf'


SQL> recover auto database;
ORA-00905: missing keyword


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using backup controlfile;
ORA-00279: change 1376968 generated at 06/22/2009 09:43:50 needed for thread 1
ORA-00289: suggestion : /u01/oracle/app/oradata/archive/1_37_687881810.dbf
ORA-00280: change 1376968 for thread 1 is in sequence #37


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/u01/oracle/app/oradata/archive/1_37_687881810.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


SQL> create table aaa(id number);
create table aaa(id number)
*
ERROR at line 1:
ORA-01109: database not open


SQL> recover database using backup controlfile;
ORA-00279: change 1376968 generated at 06/22/2009 09:43:50 needed for thread 1
ORA-00289: suggestion : /u01/oracle/app/oradata/archive/1_37_687881810.dbf
ORA-00280: change 1376968 for thread 1 is in sequence #37


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
RET
ORA-00308: cannot open archived log 'RET'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/u01/oracle/app/oradata/archive/1_37_687881810.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log
'/u01/oracle/app/oradata/archive/1_37_687881810.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


SQL> create table aaa(id number);
create table aaa(id number)
*
ERROR at line 1:
ORA-01109: database not open


SQL> alter database open resetlog;
alter database open resetlog
*
ERROR at line 1:
ORA-02288: invalid OPEN mode


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oracle/app/oradata/orcl/system01.dbf'


SQL> ' recover database using backup controlfile;
SP2-0734: unknown command beginning "' recover ..." - rest of line ignored.
SQL> recover database using backup controlfile;
ORA-00279: change 1376968 generated at 06/22/2009 09:43:50 needed for thread 1
ORA-00289: suggestion : /u01/oracle/app/oradata/archive/1_37_687881810.dbf
ORA-00280: change 1376968 for thread 1 is in sequence #37


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oracle/app/oradata/orcl/system01.dbf'


SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jun 22 09:58:54 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1215650252, not open)

RMAN> restore database;

Starting restore at 22-JUN-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/22/2009 09:59:04
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN> recover database;

Starting recover at 22-JUN-09
using channel ORA_DISK_1

starting media recovery

unable to find archive log
archive log thread=1 sequence=37
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/22/2009 09:59:24
RMAN-06054: media recovery requesting unknown log: thread 1 seq 37 lowscn 1376968

RMAN> exit

Now I want to recover the database (no manual backup is there)
What to do ?