RMAN-06059 / ORA-19625 / ORA-27037 While trying to do an rman backup

Got this error message when trying to do a full rman backup in archivelog mode of a migration database… big DB I’m taking in and out of archivelog mode all the time.  Put it in archivelog mode to get a “gold” backup, out of archivelog mode to run the migration test – it’s faster that…

On Linux Clone a 12c $ORACLE_HOME + patches, $ORACLE_BASE, and a database to a new server

Without running runInstaller, dbca, opatch, or rman, pick up an existing DB and the Oracle binaries and move them to another server, here is one way (without all the screen shots): Assumption are: You only have one home and database under your $ORACLE_BASE – this example only does one DB – but you could modify…

Can’t get your oracle database to shutdown clean with immediate – do this

start another sqlplus session if need be: shutdown abort; startup restrict; shutdown immediate; startup;

Oracle – how to connect as to a database as another user

CONN / AS SYSDBA CREATE USER user2 IDENTIFIED BY user2; ALTER USER user1 GRANT CONNECT THROUGH user2; We can now connect to the user1 user, using the credentials of the proxy user. SQL> CONN user2[user1]/user2 SQL> SHOW USER USER is “user1” SQL> Proxy users can be identified using the PROXY_USERS view. SELECT * FROM proxy_users;…