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 »
The “alter database backup controlfile to trace;” will create a text based file – human readable – that contains the steps necessary to recreate an Oracle controlfile for a specific database (the database you were connected to when you issue the alter command). See Oracle’s documentation on how to use this file. It actually has …
The following link to Oracle-Base provides basic instruction on backups, restore and recover operations. While it applies to 9i and version newer, it is a very good reference. https://oracle-base.com/articles/9i/recovery-manager-9i
create or replace trigger sys.after_startup after startup on database begin execute immediate ‘alter pluggable database all open’; end after_startup; /