Oracle Database Backup and Restore Using RMAN

                             


BACK UP STEP–
1- We have to check database recovery size.
   C:UsersAdministrator>d:
   D:>cd appAdministratorproduct11.2.0dbhome_1BIN
2-Increase database recovery size using this command.    
   
    First connect to database using sqlplus sys@databasename as sysdba
   
    ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID=’databasename’;
D:appAdministratorproduct11.2.0dbhome_1BIN>set ORACLE_SID=DBNAME
D:appAdministratorproduct11.2.0dbhome_1BIN>ECHO %ORACLE_SID%
SIEBELDB
D:appAdministratorproduct11.2.0dbhome_1BIN>rman target
                      OR
D:appAdministratorproduct11.2.0dbhome_1BIN>rman target ‘sys@DBNAMEas sysdba’;
Recovery Manager: Release 11.2.0.1.0 – Production on Tue May 12 13:51:05 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
target database Password:
connected to target database: DBNAME(DBID=1837164085)
RMAN> shutdown immediate
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area    3373858816 bytes
Fixed Size                     2180424 bytes
Variable Size               1862273720 bytes
Database Buffers            1493172224 bytes
Redo Buffers                  16232448 bytes
RMAN> backup database;
RMAN>startup

Upgrade Oracle Database from version 11.2.0.2 To 11.2.0.4 and Higher Version


1. Before Upgrading Database we should Take backup of database .If something goes wrong then we can recover it.


2.Download patch file 11.2.0.4 and higher version which you want to upgrade from
oracle partner site.


3. Unzip all file into one folder then install software.


4. Right click on setup.exe and run as Administrator.





Uncheck check box and click next



Click on next.


Click on Skip Software update.



Check install database software only and click next.


Select single instance database installation.






Save the detail and click on install .
Open command prompt and Go to This path and run dbua.bat file.




Gave username and password.













sql>SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
sql>select name from v$database;
sql> select open_mode from v$database;