Wednesday, July 31, 2013

Managing 12c with SQL Developer : RMAN Full Backup

Read me before you start 

Managing Backups from RMAN is very easy and that too with SQL Developer too good.
All the necessary commands necessary for RMAN operations are generated by SQL Developer.
Now backups are just few click away. Let us see how it gets completed.



















Now we have made a backup with SQL Developer.


Monday, July 29, 2013

Managing 12c with SQL Developer : Configure RMAN for an Action

Read me before you start 

To start using RMAN with SQL Developer there is a pre-task which needs to be completed. This option works with 11.1, 11.2 , 12c and all future releases. Here are the detailed steps;

- Create a operating system user credentials , this can be done with the SQL Developer or DBMS_SCHEDULER.CREATE_CREDENTIAL package.
- Configure Action options creates necessary script under $ORACLE_HOME/sqldeveloper/dbascripts folder










Now that we have configured in the next post we will test a full backup.

Sunday, July 28, 2013

Managing 12c with SQL Developer :Enabling Archive Log Mode for CDB

Read me before you start 

Enabling Archive Log Mode with SQL Developer is an easy way if the listener is configured correctly since database will be restarted.
Two points , a Static SID_DESC for the database that needs to be connected and a directive parameter DIRECT_HANDOFF_TTC_LISTENER=OFF.

SID_DESC is used to specify service information for a specific database instance or a non-database service.

These changes are required if CDB has to be shutdown or startup with the help of JDBC client.
If you have access to the oracle server environment then you can do it and restart the listener otherwise please contact your administrator.

We will look into it in detail.






If you have access to the oracle server environment then you can do it and restart the listener otherwise please contact your administrator.




 



Verifying if Archiver is started in CDB



Verifying if Archiver is started in PDB001



Verifying if Archiver is started in PDB002






Managing 12c with SQL Developer : Cloning PDB

Read me before you start 

Let us now see how to clone a PDB with the help of SQL Developer

Modify the State to Read Only (If Open then Shutdown and Open in Read Only)
Use the Clone Pluggable Database Option

In my case PDB001 was open so will shutdown it first.















pduser1 was created in PDB001 , so after cloning it appears






With this we have seen how to clone a PDB with SQL Developer.

Popular Posts