ALPHAGEEK369
SHELL SCRIPT TO MONITOR RESTORE PROGRESS FROM RMAN IN ORACLE
Use this shell script to get the restore progress of database from rman and get an approximate value of the progress Here if you know the size of the database then in place of variable ‘ dbsz ‘ use the database size . This is because during restore, the output of ‘report schema’ command will … Continue reading SHELL SCRIPT TO MONITOR RESTORE PROGRESS FROM RMAN IN ORACLE
SHELL SCRIPT TO MONITOR BACKUP AND RESTORE IN ORACLE
One of junior dba corrupted the ASM disk header by adding an exisiting candidate disk secured under vormetric due to space constraint in tablespace. This lead to a huge escalation from the customers and we would had to wipe out the ASM from OS and were restoring the whole database. The customer was screaming for … Continue reading SHELL SCRIPT TO MONITOR BACKUP AND RESTORE IN ORACLE
ORA-01081: cannot start already-running ORACLE – shut it down first
This error is observed when you try to start already started instance Already the database instance is up Shutdown the database and then try –Warning – use this command with caution. Think twice before execute the statement in production
ORA-02288: invalid OPEN mode
The error below is syntactical error Give proper syntax while database open
SHELL SCRIPT TO GET DATABASE SIZE IN ORACLE
Its often a requirement for DBA to get the size for a database for determining various plans or activity prechecks to conclude the fastness,capacity,criticality feature of performing a critical change. I was researching a way to find out the size of database when the database is in mount stage. As we cannot access any dba_* … Continue reading SHELL SCRIPT TO GET DATABASE SIZE IN ORACLE
RMAN-06004: Oracle error from recovery catalog database: ORA-02296: cannot enable (RCAT.) – null values found
Multiple databases were upgraded to a new version in our project and our catalog version was older ( RCAT.DBMS_RCVCAT version 11.02.00.04 ) than database version. So we tried upgrade the catalog database And this weird error was thrown After deeper analysis for long time, we come to know that we enabled guarantee restore point on … Continue reading RMAN-06004: Oracle error from recovery catalog database: ORA-02296: cannot enable (RCAT.) – null values found
RMAN-03014: implicit resync of recovery catalog failed RMAN-06004: Oracle error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
I connected to rman catalog and run controlfile backup in a new database. Below error was thrown I forgot to register the new database to catalog. So register it my friend Backup happen normally after registration of database to catalog
SQL QUERY TO CHECK STATUS OF BACKUP AND DATABASES REGISTERED TO RMAN CATALOG
If you use rman catalog and need to check the status of backups in catalog for different database or need a daily report , use this script Output:
DROP A DATABASE IN ORACLE
High level steps of database drop in oracle Shutdown the database instance Startup database in exclusive restrict to block incoming client connections to the database Drop the database Then you can use dbca to delete the SID and other entries from the server
ORA-01152: file 1 was not restored from a sufficiently old backupORA-01110: data file 1: ‘/apps01/oradata/orcl19xsystem01.dbf’
Cause: Due to inconsistent state of the datafile, i was not able to open the database without recover of archivelogs apply Workaround: After recover of the database, i was able to open the database Open the database
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
