windows xp with 10g 10.2.0.1.0
753926Apr 29 2010 — edited Apr 29 2010after I had rman duplicate database. I run some procedure on auxiliary database as below.
On target database, I have a username as "susame". Should I try user name "susame".
I can login as sys/password as sysdba on auxiliary but not regular users.
Please help.
SQL> shutdown;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 184552324 bytes
Database Buffers 419430400 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
*'C:\ORACLE\PRODUCT\10.2.0\DB_1\ORCL\SYS\O1_MF_SYSTEM_.DBF'*
SQL> recover datafile 'C:\ORACLE\PRODUCT\10.2.0\DB_1\ORCL\SYS\O1_MF_SYSTEM_.DBF'
Media recovery complete.
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> Recover Database
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SQL> select from dual;*
ADDR INDX INST_ID D
-------- ---------- ---------- -
0366CD54 0 1 X
SQL>