Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

windows xp with 10g 10.2.0.1.0

753926Apr 29 2010 — edited Apr 29 2010
after 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>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2010
Added on Apr 29 2010
1 comment
1,338 views