Skip to main content

Posts

Showing posts from 2015

Sample RMAN backup

connect target / RUN {   ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/oradata/backup/backup_%T_%u_%s_%p' MAXPIECESIZE 2G;   BACKUP DATABASE PLUS ARCHIVELOG;   crosscheck archivelog all;   delete noprompt expired archivelog all; } connect target / Connect to the Default RMAN database RUN { //command } To start RMAN command ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/oradata/backup/backup_%T_%u_%s_%p' MAXPIECESIZE 2G;  Specify the backup location and the RMAN backup file format Indicate that the max size of each backup file is 2Gb. BACKUP DATABASE PLUS ARCHIVELOG; backup the database datafile and archivelog crosscheck archivelog all; delete noprompt expired archivelog all; Check archivelog  and delete the expired archivelog 

Easy and Fast way to install Oracle 11g R2 or Oracle 12c R1

Automatic configure your pre-installation setup before installing your database? This is good right? This are what the  RPM package do when you run below command: For oracle 11g R2 #yum install oracle-rdbms-server-11gR2-preinstall  For oracle 12cR1 #yum install oracle-rdbms-server-12cR1-preinstall Please follow these blog. The steps are very clear and informative http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html https://blogs.oracle.com/wim/entry/easily_install_oracle_rdbms_12cr1

How to Get MSSQL Database Edition

Run below command select @@version You will get below result: Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)