Namaz E Jafar-e-Tayyar Long and Short Way
May 9th, 2024, posted in DuaTumhaaraa Hijr Manaa Luon Agar Ijaazat Ho By Jaun Eliya
May 6th, 2024, posted in Jaun Eliatumhārā hijr manā luuñ agar ijāzat ho
maiñ dil kisī se lagā luuñ agar ijāzat ho
tumhāre baad bhalā kyā haiñ vaada-o-paimāñ
bas apnā waqt gañvā luoñ agar ijāzat ho
tumhāre hijr kī shab-hā-e-kār meñ jānāñ
koī charāġh jalā luuñ agar ijāzat ho
junūñ vahī hai vahī maiñ magar hai shahr nayā
yahāñ bhī shor machā luuñ agar ijāzat ho
kise hai ḳhvāhish-e-marham-garī magar phir bhī
maiñ apne zaḳhm dikhā luuñ agar ijāzat ho
tumhārī yaad meñ jiine kī aarzū hai abhī
kuch apnā haal sambhālūñ agar ijāzat ho
ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP’
April 15th, 2024, posted in Oracle QueriesORA-01552: cannot use system rollback segment for non-system tablespace “string”
Cause: Used the system rollback segment for non-system tablespace operations.
If this is a clone database, this will happen when attempting any data modification outside the UNDOTBS tablespace.
Solution :
1) Switch to Automatic Undo Management
$ sqlplus / as sysdba
alter system set undo_management=auto scope=spfile;
2) Restart the database.
SQL> Shutdown immediate;
SQL> startup
Happy Birthday I am Not A Subtle Person
March 7th, 2024, posted in COMiCS, DAtEs iN a YeAR, UncategorizedORA-27037: Unable To Obtain File Status
February 4th, 2024, posted in Oracle QueriesRMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 12/24/2023 09:23:19
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u03/archive2/1_4134_983485279.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
This ORA-19625 errors are related with file specified as input to a copy or backup operation, or as the target for an incremental restore, could not be identified as an Oracle file. An OS-specific error accompanies this error to help pinpoint the problem.
To solve this error, Specify an different file and retry the operation.
Try to run the following commands.
RMAN> crosscheck copy of archivelog all
RMAN> crosscheck archivelog all
RMAN> resync catalog
RMAN> delete force obsolete;
RMAN> delete expired archivelog all ;
If the problem is not solved,then Files were deleted at OS level and Archive log files were deleted at OS level. To solve this error, Run the following commands.
RMAN> Change archivelog '' UNCATALOG ;
Please note the first archive log name would be present in the error message ORA-19625:
For example :-
RMAN-06059: expected archived log not found, lost of archived log
ORA-19625: error identifying file /var/opt/arch_oltp28_1_744738.arc
ORA-27037: unable to obtain file status
RMAN> Change archivelog '/var/opt/arch_oltp28_1_744738.arc' uncatalog;
Run the archive log backup command check if you still get the error
Keeping specify the archive log file name reported in ORA-19625 till backup of archive log goes fine
Or
RMAN> Change Archivelog all Uncatalog ;
Please note the above command will uncatalog the information about the Archive log from catalog database.