ORA-01245: offline file string will be lost if RESETLOGS is done
Answers were Sorted based on User's Feedback
Answer / guest
Cause: Attempting to do an OPEN RESETLOGS with a file that
will be lost because it is offline. The file was not taken
offline with the FOR DROP option.
Action: Either bring the file online and recover it, or take
it offline with the FOR DROP option.
Please add more information about this Error
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / amit goyal
for example
alter database datafile
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\O10G127\SYSTEM01.DBF'
offline for drop;
Is This Answer Correct ? | 2 Yes | 3 No |
ORA-25126: Invalid name specified for BUFFER_POOL
NCR-04017: NCRR: Unable to find the interface instance handle
ORA-00250: archiver not started
display details of employee's who are seniour to there own manager ? ( In a Emp Table )
ORA-16801: Some log transport related property is inconsistent.
ORA-15072: command requires at least string failure groups, specified only string
ORA-26077: direct path column array is not initialized
ORA-01002: fetch out of sequence
RMAN-06182: archive log larger than MAXSETSIZE: thread string seq string string
SQL-02103: Inconsistent cursor cache. Out of range cursor cache reference
SQL-02120: First and second arguments to SQLRCN both null
ORA-24508: Buffer is not aligned correctly.