Month: October 2017

After an rman duplicate (for standby) disconnect from rman to avoid working on the wrong DB / target

In the case of an RMAN duplicate – whether it is for standby creation or just cloning – remember to immediately disconnect from rman.  The rman syntax uses TARGET and AUXILARY  in the connect syntax.  What can be confusing – is TARGET is the source that you are cloning from and the database you are …

After an rman duplicate (for standby) disconnect from rman to avoid working on the wrong DB / target Read More »

Configure my Oracle sqlnet listener to listen for multiple ports on multiple virtual host names – same physical host

Ok, so why do all that? It’s a primary on a Data Guard pair – the DG replication is played across a private segment (named ggt1-rep.localdomain) on the normal 1521 port.  And a more public segment (named ggt1.localdomain) allows general sqlnet connections on port 1526. Here is the listener.ora and then a listener status: SID_LIST_LISTENER_GGTDG …

Configure my Oracle sqlnet listener to listen for multiple ports on multiple virtual host names – same physical host Read More »

Oracle – Switch from a NON-FRA ( fast recovery area ) db to a db using an FRA

sqlplus / as sysdba … alter system set db_recovery_file_dest_size=25G scope=both; alter system set db_recovery_file_dest=’/oracle/fra’ scope=both;  # yes this path better exist with space allocated to at least “size” above alter system set log_archive_dest_1=’location=USE_DB_RECOVERY_FILE_DEST’ scope=both; alter system set log_archive_dest_state_1=enable scope=both; A sub-directory under “fra” will be created with the SID of the DB.  And under that …

Oracle – Switch from a NON-FRA ( fast recovery area ) db to a db using an FRA Read More »

ora-12514 while creating data guard standby using a VIP with duplicate database for standby – one solution pre-create spfile

I’ve created standby databases many times.  They are not simple but, once you’ve done it a few times it’s not too bad at least for single host non-RAC standby databases. But recently, I was working at a Client that used “VIP” hostnames for single host DBs (not RAC) and wanted me to use them… so …

ora-12514 while creating data guard standby using a VIP with duplicate database for standby – one solution pre-create spfile Read More »

Tell Oracle RMAN where my backups are – backup location – where to write them and where to read them from

Assuming you are just connected to RMAN via the control file as follows: rman target / Recovery Manager: Release 12.1.0.2.0 – Production on Tue Oct 24 15:33:56 2017 … connected to target database: GGTARGET (DBID=2935137373) RMAN generally uses channels for backups, restores and duplicates.  You can define defaults for channels or over ride the defaults.  …

Tell Oracle RMAN where my backups are – backup location – where to write them and where to read them from Read More »

Recovering a Data Guard Standby that has missing archivelog

Recovering a Standby database from a missing archivelog A Physical Standby database needs a contiguous supply of of archivelogs from a Primary Database to be kept in sync with the primary. Starting in Oracle version 10gR2 you can use an incremental backup from the primary to recover the standby using the primary incremental to re-synchronize …

Recovering a Data Guard Standby that has missing archivelog Read More »

Data Guard Commands to stop and start when you are NOT using DGMGRL

# from the standby – to start real time apply sql> startup mount; sql> alter database recover managed standby database using current logfile disconnect; # from the standby to stop real time apply – still open in mount mode sql> alter database recover managed standby database cancel; # on the standby – open in read …

Data Guard Commands to stop and start when you are NOT using DGMGRL Read More »

DBMS_SYSTEM reference

DBMS_SYSTEM pl/sql package does not seem to be documented and may not be supported by Oracle.  Here’s where you can find info on it and more. Reference: Morgan’s Library DBMS_SYSTEM package description 12c Morgan’s Library All