RMAN Backup script

This is a sample backup script I used, it has already a lot of options. Feel free to make any modification you want. If you add some good enhancements, let me know I can put them here so everybody can profit from them.

RMAN Backup script

 

Intoduction to Oracle Rest Data Services

Presentation

First, let’s talk about REST apis. REST apis are very popular nowdays because they are easily accessible from any client able to make http(s) requests. The beauty of this is that you can access different systems through these rest apis independantly of how the system is built in the backend. For example I can access with a simple curl command the twitter, youtube or any public api which will return me data.

Rest APIs usually present data as a JSON object. If your are not already familiar with JSON here is an example of a JSON object:

Oracle 12.1.0.2 introduced the support of JSON as a datatype and methods to query JSON objects. This make things a lot easier when you have to work with these data structures.

Continue reading Intoduction to Oracle Rest Data Services

Creating an ACFS filesystem

ACFS

About ACFS filesystem

ACFS mean  Automatic Storage Management Cluster File System. This filesystem volume resides inside the ASM database and can be used to store database files but also any type of files with or without direct relation to the database.

Oracle ACFS does not support Oracle Grid Infrastructure or Oracle Cluster Registry voting files.

The ACFS filesystem can be extended dynamically without any service interruption, you just need to add space to the diskgroup hosting the ACFS volume and then extend the filesystem. Continue reading Creating an ACFS filesystem