incremental backup RMAN with multiple channels

below is the command in oracle to take rman incremental backup.

RMAN> run

{

   allocate channel c1  device type disk format 'I:\RMAN_BACKUP\rman_bkp_%U';

   allocate channel c2  device type disk format 'I:\RMAN_BACKUP\rman_bkp_%U';

   allocate channel c3  device type disk format 'I:\RMAN_BACKUP\rman_bkp_%U';

   backup incremental from scn 5768934213 database;

}

where 'rman_bkp_%U' is format of backup piece whose name will start with 'rman_bkp'.

above command used to allocate multiple channels to take incremental backup.

If you want to take incremental backup with single channel then below is the command which is executed using rman utitlity.

RMAN > backup device type disk incremental from scn 5768934213 database format 'I:\RMAN_BACKUP\rman_bkp_%U';

scn specifies from where to start backup.

By: Unknown On 11:46 AM

Continue Reading

tracing ip address to capture successful / unsuccessful login attempts oracle by enable auditing

In this tutorial, I will explain how to capture ip address of the users trying to connect to database.

We can do this task using enabling the auditing in database. By enabling the auditing, we can trace ip

address of all the users having successful or unsuccessful login attempt. Below is the step by step procedure to enable auditing in oracle database.

Step 1: login to database

set the value of audit_trail parameter to DB.

Step2: bounce the database to make the above changes effective in database.

Step 3: audit the create session by executing below commands.

Step 4: now auditing has been enabled.

Now its time to see all  successful/unsuccessful login attempts made by users.

See the view sys.aud$ table which shows all the details of users made attempt to connect to database.

Select * from sys.aud$;

In this view , returncode column specifies the successful/unsuccessful login .

if any row contains value 1017 for column returncode then the user in that row has specified

incorrect username/password , in other word user has attempted unsuccessful login attempt.

By: Unknown On 10:42 AM

Continue Reading