Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Santosh.Vukkalkar on Sep 14 at 3:05 AM Dear Satish,
Have you performed restore and recovery process ?
1. Restore the database with successful backup.
2. Recovery the database until the last archive log file you have.
Regards,
Santosh.
| | | ---------------Original Message---------------
From: Satish Ahirkar
Sent: Monday, September 14, 2015 3:02 AM
Subject: SAP not working
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 |
| Reply to this email to post your response. __.____._ |  _.____.__ |
