C:\Users\rajib.pradhan>SET ORACLE_SID=ORCL
C:\Users\rajib.pradhan>SQLPLUS /NOLOG
SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 1 01:56:39 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> CONN /AS SYSDBA
Connected.
1. Checking Archive Log Mode Enable/Disable.
=============================================
SQL> SELECT LOG_MODE FROM V$DATABASE;
LOG_MODE
------------
NOARCHIVELOG
2. Enable Archive Log Mode.
=============================================
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2177456 bytes
Variable Size 1291847248 bytes
Database Buffers 838860800 bytes
Redo Buffers 5001216 bytes
Database mounted.
SQL> ALTER DATABASE ARCHIVELOG;
Database altered.
SQL> ALTER DATABASE OPEN;
Database altered.
3. Checking Parameter recovery file
=============================================
SQL> SHOW PARAMETER db_recovery_file_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string D:\app\flash_recovery_area
db_recovery_file_dest_size big integer 3912M
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Now Configure In RMAN
=============================================
C:\Users\rajib.pradhan>SET ORACLE_SID=ORCL
C:\Users\rajib.pradhan>RMAN TARGET /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Feb 1 02:03:58 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1397951475)
RMAN> SHOW ALL;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFORCL.ORA'; # default
Configure Control File Auto backup Mode.
=============================================
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
Configure Control File Backup Destination
=============================================
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\app\RMAN_BACKUP\cf_%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\app\RMAN_BACKUP\cf_%F';
new RMAN configuration parameters are successfully stored
Configure Datafile Backup Destination
=============================================
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\df_%d_%t_%s_%p';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'K:\ORCL_RMAN_BACKUP\df_%d_%t_%s_%p';
new RMAN configuration parameters are successfully stored
Backup Database.
=============================================
RMAN> BACKUP DATABASE;
Starting backup at 01-FEB-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\APP\ORADATA\ORCL\SYSTEM01.DBF
input datafile file number=00002 name=D:\APP\ORADATA\ORCL\SYSAUX01.DBF
input datafile file number=00005 name=D:\APP\ORADATA\ORCL\EXAMPLE01.DBF
input datafile file number=00003 name=D:\APP\ORADATA\ORCL\UNDOTBS01.DBF
input datafile file number=00004 name=D:\APP\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=D:\APP\RMAN_BACKUP\DF_ORCL_870488830_4_1 tag=TAG20150201T022710 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 01-FEB-15
Starting Control File and SPFILE Autobackup at 01-FEB-15
piece handle=D:\APP\RMAN_BACKUP\CF_C-1397951475-20150201-01 comment=NONE
Finished Control File and SPFILE Autobackup at 01-FEB-15
Checking Backup List.
=============================================
RMAN> LIST BACKUP;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 1.04G DISK 00:00:49 01-FEB-15
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20150201T022710
Piece Name: D:\APP\RMAN_BACKUP\DF_ORCL_870488830_4_1
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1170457 01-FEB-15 D:\APP\ORADATA\ORCL\SYSTEM01.DBF
2 Full 1170457 01-FEB-15 D:\APP\ORADATA\ORCL\SYSAUX01.DBF
3 Full 1170457 01-FEB-15 D:\APP\ORADATA\ORCL\UNDOTBS01.DBF
4 Full 1170457 01-FEB-15 D:\APP\ORADATA\ORCL\USERS01.DBF
5 Full 1170457 01-FEB-15 D:\APP\ORADATA\ORCL\EXAMPLE01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 9.36M DISK 00:00:01 01-FEB-15
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20150201T022806
Piece Name: D:\APP\RMAN_BACKUP\CF_C-1397951475-20150201-01
SPFILE Included: Modification time: 01-FEB-15
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1170900 Ckp time: 01-FEB-15
RMAN> EXIT
Recovery Manager complete.
C:\Users\rajib.pradhan>
No comments:
Post a Comment