The following initialization parameters are new in Oracle Database Release 19c, Version 19.1: ADG_REDIRECT_DML DATA_GUARD_MAX_IO_TIME DATA_GUARD_MAX_LONGIO_TIME ENABLE_IMC_WITH_MIRA LOB_SIGNATURE_ENABLE MAX_DATAPUMP_PARALLEL_PER_JOB The following static data dictionary views are new in Oracle Database Release 19c, Version 19.1: ALL_TRIGGERS_AE, DBA_TRIGGERS_AE, and USER_TRIGGERS_AE DBA_PDB_SNAPSHOTFILE DBA_RAT_CAPTURE_SCHEMA_INFO DBA_REGISTRY_BACKPORTS The following dynamic performance views are new in Oracle Database Release 19c, Version 19.1: GV$AQ_PARTITION_STATS and V$AQ_PARTITION_STATS […]
All posts by Anuradha Mudgal
Anuradha Mudgal
New Features of Security in Oracle Database 19c
The following are changes in the Oracle Security for Oracle Database Release 19c. Signature-Based Security for LOB LocatorsStarting with this release, you can configure signature-based security for large object (LOB) locators. Default User Accounts Now Schema OnlyUsing the schema only account feature from Oracle Database release 18c, most of the Oracle Database supplied schemas (users) now have […]
New Features of Backup & Recovery in Oracle Database 19c
The following are changes in the Oracle Database Backup and Recovery for Oracle Database Release 19c. Recovery catalog support for PDBs You can connect to a recovery catalog when the target database is a pluggable database (PDB). Automatic deletion of flashback logs Flashback logs that are beyond the retention period are automatically deleted. Automatically deleting flashback logs […]
New Features in Oracle Database 19c
Oracle Database supplied user accounts are now schema only accounts Most of the Oracle Database supplied user accounts, except SYS and sample schemas are now schema only accounts, that is, these accounts are created without passwords. This prevents malicious users from logging into these accounts. You can assign passwords to these accounts whenever you want them to be authenticated. […]
New Features in Oracle Multitenant 19c
Enhancements to database-managed PDB snapshots When the initialization parameter CLONEDB is TRUE, database-managed snapshots create sparse copies of the data files of the source PDB. Starting in Oracle Database 19c, you can create database-managed snapshot clone PDBs from a source PDB that is open read/write. In previous releases, the source PDB needed to remain read-only and unchanging for […]
Recreate Database Using Only Datafile and Logfile
Let’s have look on the steps are used by Oracle DBA for “Recreate Database Using Only Datafile and Logfile”. Backup of the control file in trace SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; create password file and service D:\> orapwd file=D:\oracle\product\10.2.0\db_1\database\PWDdba71.ora password=sys entries=10 D:\> oradim -new -sid dba71 -intpwd sys -maxusers 10 -startmode auto -pfile […]
Recover From Redo Log File
This post explains about the steps are used by DBA for recovery From Redo Log File. Check the archive log status SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 2 Current log sequence 4 List the tablespaces SQL> select name from v$tablespace; NAME —————————— […]
Change Default Temporary Tablespace in Oracle
Being Oracle DBA we all are well known about the tablespace. Oracle RDBMS have multiple kinds of a tablespace with a different kind of purpose. We are going to have look on steps use for “Change Default Temporary Tablespace”. Check the current default temporary tablespace SQL> column property_value format a25 SQL> SELECT property_name,property_value FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’; […]
Incomplete Time Based Recovery in Oracle
Oracle provides different multiple options to have a “backup& recovery” as per the organization’s requirements. Incomplete recovery is one of the types of recovery. Let’s have look on the incomplete recovery. Check the archive log status SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 7 Next […]
Hot Backup with RMAN in Oracle
We are going to have look on the backup of Oracle, Which is common in DBA’s life. HOT Backup is the most common way to have a backup. Let’s have look on the steps of Oracle’s HOT Backup. Check the archive status SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination […]