Oracle Database and Linux Commands Summary

Oracle Database Commands:

1. Change SYSTEM user password:

   ALTER USER system IDENTIFIED BY new_password;

1. Unlock SYSBACKUP user:

   ALTER USER SYSBACKUP ACCOUNT UNLOCK;

1. Set Fast Recovery Area size to 10GB:

   ALTER SYSTEM SET db_recovery_file_dest_size = 10G;

1. Set Fast Recovery Area destination path:

   ALTER SYSTEM SET db_recovery_file_dest = 'C:\app\yourname\fast_recovery_area\orcl';

1. Check if the database is in archive log mode:

   ARCHIVE LOG LIST;

1. Shutdown the database:

   SHUTDOWN IMMEDIATE;

1. Startup and mount the database:

   STARTUP MOUNT;

1. Backup the database:

   BACKUP DATABASE;

1. List all backups:

   LIST BACKUP;

1. Delete backups:

    DELETE BACKUP;

1. Enable ARCHIVELOG mode:

    ALTER DATABASE ARCHIVELOG;

1. Open the database:

    ALTER DATABASE OPEN;

1. Backup database including archive logs:

    BACKUP DATABASE PLUS ARCHIVELOG;

1. View RMAN configuration settings:

    SHOW ALL;

1. Set default device type to disk:

    CONFIGURE DEFAULT DEVICE TYPE TO DISK;

1. Verify default device type:

    SHOW DEFAULT DEVICE TYPE;

1. List backup summary:

    LIST BACKUP SUMMARY;

1. View backup information for a specific datafile:

    LIST BACKUP OF DATAFILE specific_datafile_ID;

1. Validate backup for a specific datafile:

    VALIDATE DATAFILE specific_datafile_ID;

1. Validate if tablespace's datafiles can be restored:

    RESTORE TABLESPACE tableSpaceName VALIDATE;

Linux Commands:

1. Copy a directory to another location:

   cp -r /path/to/source_folder /path/to/target_folder