Archive for 2019
Ghar Fatima Zehra Ka Ajab Shan Ka Ghar Hai
August 29th, 2019, posted in POEtRY.., SufismGhar Fatima zehra ka ajab shan ka ghar hai
Ye wahi ki manzil hai ye quran ka ghar hai
Islam ke mahol may eman ka ghar hai
Momin ki munafiq ki ye pehchan ka ghar hai
Kuch log marejate hai is ranjo mehan mein
Is ghar ka jo darwaza hai masjid ke sehan mein
Allah ne is ghar ko nabuwat se nawaza
Dunya may ise deeno shariyat se nawaza
Ismat se imamat se wilayat se nawaza
Har fard ko quran ki aayat se nawaza
Saanche may mashiyat ke ye afraad dhale hain
Sab chadare tatheer ke saaye may pale hain
Ye azm ke faulaad isi ghar may milenge
Ye noor ke ajsaad isi ghar ay milenge
Jibreel ke ustaad isi ghar may milenge
Is satha ke afraad isi ghar may milenge
Maqlooq ki baat aakhri sarhad nazar aaya
Jis fard ko dekha wo mohamed nazar aaya
Ashaab mukarram hani magar apni jagha par
Ghair apni jagah laqte jigar apni jagha par
Khaar apni jagah ghunchaye tar apni jagha par
Sang apni jagah laal-o-gohar apni jagha par
Pehlu may jo baitha ho usay dil nahi kehte
Rehro kabhi rehbar e manzil nahi kehte
Allah re izzo sharafe Bint e Risalat
Qandeel e haram sham e shabistane imamat
Rehmat jo Mohammed hain to ye para e rehmat
Woh kull e nabuwat hai to ye juzv e nabuwat
Aasaan kaho maarifat e khatm e rasul ko
Jo juzv ko na samjha ho wo kya samjhega kul ko
Mumkin nahi ummat ka qiyas aal-e-nabi par
Yeh log alag loog hain yeh ghar hay alag ghar
Is ghar kay to bacchay bhee badal datay hain aksar
Insan ki taqdeer farishtoon ka muqqadar
Rahib ko kaee lall isi ghar say milay hain
Fitrus ko par o bal isi ghar say milay hain
Enable Pluggable Database(PDB) Archivelog Mode
August 26th, 2019, posted in Oracle QueriesEnabling archive log mode -12c pluggable database/Container database
Since the Redologs are created at container database level in 12c and not at pluggable database level.
(Enabling archivelog at pluggable database level is not possible). Archiving is done at CDB’s.
You can check archive log mode either by querying v$database or archive-log list :
SQL> select name,open_mode,log_mode from v$database; NAME OPEN_MODE LOG_MODE --------- -------------------- ------------ CDB READ WRITE NOARCHIVELOG (OR) SQL> archive log list Database log mode Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 11 Next log sequence to archive 13 Current log sequence 13 *************** *************** To enable the Archive-log mode *************** ***************SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 788529152 bytes Fixed Size 2929352 bytes Variable Size 541068600 bytes Database Buffers 239075328 bytes Redo Buffers 5455872 bytes Database mounted. SQL> ALTER DATABASE ARCHIVELOG; Database altered. SQL> ALTER DATABASE OPEN; Database altered. SQL> select name,open_mode,log_mode from v$database; NAME OPEN_MODE LOG_MODE --------- -------------------- ------------ CDB READ WRITE ARCHIVELOG SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 413 Next log sequence to archive 415 Current log sequence 415 SQL> show parameter DB_RECOVERY_FILE_DEST NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u03/app/oracle/fast_recovery_area db_recovery_file_dest_size big integer 27G