Welcome to alphageek369
Be persistent in what you do !
Latest from the Blog
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
