when dropping, recreating, granting access to a pl/sql procedure the entire call specification (including parameters or parameter data types) is required to insure you are affecting the appropriate procedure – this is also referred to as footprint, and or procedure specification or signature.
https://aws.amazon.com/blogs/database/migrating-oracle-autonomous-transactions-to-postgresql/ in other words how to write a error log to a table and separately commit that record
https://oracle-patches.com/en/databases/oracle/oracle-rac-networking-concepts-and-components
alter pluggable database orclpdb open; Of course you will want to connect as sys “sqlplus / as sysdba” or equivalent to issue this command. Here is a link to Oracle’s views on pluggable DBs: https://docs.oracle.com/database/121/ADMIN/cdb_mon.htm#ADMIN13933 SELECT * FROM DBA_PDBS;
of course you had better be certain you don’t need the archivelog BEFORE you remove it, you can put it back if you have a copy – you would just have to do another rman crosscheck (see below) to tell rman it is back Archivelog sub-directories are typically of the form: YYYY_MM_DD and contain archivelog. …
removing old un-necessary archivelog from fast_recovery_area Read More »
select * from v$diag_info; The Oracle alert log can be found in the same sub-directory as Default Trace File which usually ends in …/trace/alert_.log
Here is an example function showing the maximum difference between a timestamp field in row for a given partition (the SQL dialect is old Oracle 11gR2): cat fgreat.sql set line 232 SELECT process_running, run_number, exec_seq, exec_timestamp as station_time, lead(exec_timestamp) OVER (partition by run_number order by exec_timestamp) – exec_timestamp as time_to_next_row FROM benchmark where run_number=&1 order …
Well, there are a lot of new requirements to unload data from Oracle into a non-proprietary format like CSV given the vast # of migrations away from Oracle these days. Conner MacDonald sums the options up nicely in this youtube video. It is worth it’s a weight in gold if you need to export large …
assuming you have the control FILE and after a “startup mount;” using the controlfile to restore/RECOVERABLE rman target /restore database UNTIL TIME“to_date(’12/31/2021 11:34:50 am’,’mm/dd/yyyy hh:mi:ss am’)”; recover database UNTIL TIME“to_date(’12/31/2021 11:34:50 am’,’mm/dd/yyyy hh:mi:ss am’)”; alter database open resetlogs; OR run{set UNTIL TIME “to_date(’12/31/2021 11:34:50 am’,’mm/dd/yyyy hh:mi:ss am’)”;restore database;recover database;alter database open resetlogs;}
Nice little article on how to restore from DDBoost with no catalog and a lost control file. Key is to have the DBID and the RMAN backup logs – so that you can find a backup of the control file from DDBoost. So make sure you have both the RMAN logs, and DBID – copies …
Recovering DDBoost & Oracle RMAN with no catalog or control file Read More »