RMAN-08591: WARNING: invalid archived log deletion policy

Warning Description:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

Insert to Oracle View failed with ORA-01779: cannot modify a column which maps to a non key-preserved table

Error description:
ORA-01779 error is coming while inserting into view

Solution Description:
Views are two types in terms of update to the view-Updateable and non-updateable. When you try to insert to the non-updateable views you will get the error ORA-01779: cannot modify a column which maps to a non key-preserved table

Where/How to Check Alert Log File in Oracle 12c?

Prior versions as a DBA we used 
to check the alert logs in background_dump_dest directory. But in 11g onwards the alert log file location is changed to different location mentioned below. The second option is adrci which is the easiest way to access the alert log files for the databases which are running on the box.
 

Stop/Enable/Disable Oracle Auto Task Jobs Using SQL – Space advisor, Optimiser stats collection, SQL tuning advisor

Oracle 11g onwards there are three different automatic maintenance tasks:
1.   Automatic Optimizer Stats Collection - Gathers the statistics for all schema objects and the respective database task is called ‘auto optimizer stats collection’
2.   Automatic Segment Advisor – This identifies the segments that could be the candidates for the reorganization to save the space and respective database task is called ‘Space advisor’

Oracle 12c Data Pump: EXPDP IMPDP VIEWS_AS_TABLES Option

Oracle 12c release 1 onwards we can export the view(s) into export dumps and while importing it can be imported as table with the structure of the view with base table data.
Syntax: VIEWS_AS_TABLES=[schema_name.] view_name [:table_name],
Example

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer