Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Satish Ahirkar on Sep 14 at 2:53 AM Dear Santosh,
Thanks for your reply. Please check the below:
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 7867006976 bytes
Fixed Size 2270552 bytes
Variable Size 3976202920 bytes
Database Buffers 3875536896 bytes
Redo Buffers 12996608 bytes
Database mounted.
SQL>
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 resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:\ORACLE\SMP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 9;
SQL> recover database using backup controlfile until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'F:\ORACLE\SMP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 9;
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:\ORACLE\SMP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 9;
SQL> select * from V$TABLESPACE;
TS# NAME INC BIG FLA ENC
- - -
0 SYSTEM YES NO YES
1 SYSAUX YES NO YES
2 PSAPUNDO YES NO YES
* 3 PSAPTEMP NO NO YES*
4 PSAPSR3 YES NO YES
5 PSAPSR3702 YES NO YES
6 PSAPSR3USR YES NO YES
7 PSAPSR3DB YES NO YES
8 rows selected.
Thanks & Regards,
Satish
| | | ---------------Original Message---------------
From: Santosh Kumar
Sent: Monday, September 14, 2015 1:30 AM
Subject: SAP not working
Dear Satish,
You run the command at mount stage, first open your database (alter
database open) and add the temp table space.
Regards,
Santosh |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.  _.____.__ |
