Month: May 2016

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 …

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

Oracle – how to connect 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; …

Oracle – how to connect to a database as another user Read More »

Oracle – How to find the max seqeunce # for a clone with open resetlogs using rman backup log file

If you have the rman log file produced with a rman full backup and you want to know what the max sequence number in backup / archivelogs is for a rman duplicate database or recover until. ┬áThis command assumes there are archivelog backups included in your rman log. Here is a little unix command to …

Oracle – How to find the max seqeunce # for a clone with open resetlogs using rman backup log file Read More »