RMAN Output to file Many situations we may want to save the RMAN output to file . There are multiple ways to do this task By using RMAN Log command By using RMAN spool log command   In this document we will discuss about RMAN 'Spool Log ' command (adsbygoogle = window.adsbygoogle || []).push({}); Using The Spool Command Use the 'spool log' command to direct RMAN output to a file .…

Steps  to audit sys operations in Oracle SQL> ALTER SYSTEM SET audit_sys_operations=true SCOPE=spfile; SQL> ALTER SYSTEM SET audit_trail=OS SCOPE=spfile; SQL> SHUTDOWN IMMEDIATE SQL> STARTUP   Where  is the log files located The sys audit log will be available in the operating system path specified by  AUDIT_FILE_DEST AUDIT_SYS_OPERATIONS enables or disables the auditing of operations issued by user SYS, and users connecting with SYSDBA or SYSOPER privileges. The audit records are written…

Relocate database files using RMAN In this example we will see how to relocate database files using RMAN from one location to another.In this blog we will see , how to relocate the entire database. Existing Location /wysheid/mydb Target location /data/mydb Startup the database in mount stage SQL> Shutdown immediate; SQL> Startup Mount; Make a copy of the database using RMAN RMAN> BACKUP AS COPY DB_FILE_NAME_CONVERT (‘/wysheid/mydb’,’/data/mydb/’) database; Switch to the…

Script to delete the older files automatically in linux In this post we explain how to schedule a job in linux  to delete older  files automatically in Linux or Unix. Here , we are creating  a script to delete the  30 days old database audit files. This activity has two steps Create the script to delete the older files Schedule the script run automatically using ‘cron’ script to delete the older…