RMAN Backup Based Duplication

RMAN Backup Based Duplication

RMAN Backup Based

How to start expdp without password

How to start expdp without password

expdp_passwordless

RMAN Active Duplicate

RMAN Active Duplicate 

Active_Duplicate

How to check Standby Status

How to check Standby Status

STANDBY_STATUS

How to set EBS Version in Profile

How to set EBS Version in Profile

EBS_PROFILE

Cloning A Schema

Cloning A Schema

Example:

SQL> @cln_user.sql

Enter user to model new user to: SCOTT -----> Existing User

Enter new user name: MQMTEST -----> New User

Enter new user's password: TEST123! -----> New User Password

create user MQMTEST identified by TEST123! default tablespace USERS temporary tablespace TEMP profile DEFAULT;

grant RESOURCE to MQMTEST;

grant CONNECT to MQMTEST;

grant UNLIMITED TABLESPACE to MQMTEST;

alter user MQMTEST default role RESOURCE;

alter user MQMTEST default role CONNECT;

Cloning_User 

RMAN Complete Backup Status Script

RMAN Complete Backup Status Script

Rman_Monitoring

Startup & Shutdown Script

Startup & Shutdown Script

vi start_db.sh

vi stop_db.sh

and save it!

startup&shutdown

Health Check Script

Health Check Script

Using below script we can database status, lsnrctl status and mountpoint.

vi status.sh

and save!

STATUS

Below Script To Check Alertlog Errors

Below Script To Check Alertlog Errors

vi alert.sh

and save!

ALERT

Tablespace Monitoring Scripts

Tablespace Monitoring Scripts

Tablespace_Monitoring