I already wrote about auto-completion in the MySQL/MaiaDB command-line client using an auto-rehash feature.
From my mailbag: Dear nixCraft, I run a Debian Linux 8.x on my Desktop and Ubuntu Linux 16.04 LTS on my Linode cloud server for my personal website.
What if the current (default) location for Pluggable Databases is running out of space and, yet, you want to create an Oracle Managed Files Pluggable Database ?
I’ve created a short video on manually starting up a RAC database that has a PDB with two custom services.
Earlier this week (10-April), I had done a Switchover from the 2node RAC database to a SingleInstance database.
Yesterday, I demonstrated a DataGuard Switchover from a 2node RAC(ASM) database to a SingleInstance(FileSystem) Database.
Continuing this series of posts where I have a SingleInstance/FileSystem Standby database for a RAC/ASM database … Checking the status of the configuration : DGMGRL> show configuration;Configuration - rac Protection Mode: MaxPerformance Members: rac - Primary database stby - Physical standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESS (status updated 28 seconds ago)DGMGRL>SQL> select thread#, max(sequence#) 2 from v$archived_log 3 group by thread# 4 order by 1 5 / THREAD# MAX(SEQUENCE#)---------- -------------- 1 66 2 36SQL> alter system archive log current;System altered.RFS: Selected log 8 for thread 2 sequence 38 dbid 2519807290 branch 931825279Mon Apr 10 23:03:17 2017Archived Log entry 39 added for thread 2 sequence 37 ID 0x96312536 dest 1:Mon Apr 10 23:03:18 2017Media Recovery Waiting for thread 2 sequence 38 (in transit)Mon Apr 10 23:03:18 2017Recovery of Online Redo Log: Thread 2 Group 8 Seq 38 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/STBY/onlinelog/group_8.300.937936389 Mem# 1: /u01/app/oracle/fast_recovery_area/STBY/onlinelog/group_8.306.937936389RFS: Selected log 6 for thread 1
Apparently, the error : alter pluggable database pdb open*ERROR at line 1:ORA-44309: unknown failureORA-44777: Pluggable database service cannot be started.