RMAN Connectivity and default database backup
Connect to RMAN take backup.

Using NOCATALOG, which is the default method of connecting to RMAN, one can connect using operating system authentication or Oracle Net Authentication.

D:oracleOra92bin>rman target / nocatalog

Recovery Manager: Release 9.2.0.6.0 – Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: SRIDEVI (DBID=937156271)
using target database controlfile instead of recovery catalog

RMAN>

D:oracleOra92bin>rem using net authentication

D:oracleOra92bin>rman target sys/sys@sridevi nocatalog

Recovery Manager: Release 9.2.0.6.0 – Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: SRIDEVI (DBID=937156271)
using target database controlfile instead of recovery catalog

RMAN>

D:oracleOra92bin>rman target /

Recovery Manager: Release 9.2.0.6.0 – Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: SRIDEVI (DBID=937156271)

RMAN>

This is to know if net authentication is used.

D:oracleOra92bin>rman target sys/sys@sridevi

Recovery Manager: Release 9.2.0.6.0 – Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: SRIDEVI (DBID=937156271)

RMAN>

This is when catalog database is connected

D:oracleOra92bin>rman target / catalog rman/rman@sridevi

Recovery Manager: Release 9.2.0.6.0 – Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: SRIDEVI (DBID=937156271)
connected to recovery catalog database

RMAN> CONFIGURE BACKUP OPTIMIZATION ON;

new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN>

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;

new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> CONFIGURE RETENTION POLICY CLEAR;

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
RMAN configuration parameters are successfully reset to default value
starting full resync of recovery catalog
full resync complete

RMAN>

RMAN> BACKUP ARCHIVELOG ALL;

Starting backup at 11-DEC-04
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=27 devtype=DISK >>>>>every channel is a server process
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=29 devtype=DISK >>>>>every channel is a server process
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=30 devtype=DISK >>>>>every channel is a server process
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=466 recid=450 stamp=544631994
input archive log thread=1 sequence=467 recid=451 stamp=544631994
input archive log thread=1 sequence=468 recid=397 stamp=537204300
input archive log thread=1 sequence=469 recid=399 stamp=537204591
input archive log thread=1 sequence=470 recid=401 stamp=537204932
channel ORA_DISK_1: starting piece 1 at 11-DEC-04
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=1 sequence=471 recid=403 stamp=537205214
input archive log thread=1 sequence=472 recid=407 stamp=537207149
input archive log thread=1 sequence=473 recid=405 stamp=537207149
input archive log thread=1 sequence=474 recid=409 stamp=537207150
input archive log thread=1 sequence=475 recid=411 stamp=537208856
input archive log thread=1 sequence=476 recid=413 stamp=537208858
input archive log thread=1 sequence=477 recid=415 stamp=537208864
input archive log thread=1 sequence=478 recid=417 stamp=537276492
input archive log thread=1 sequence=479 recid=418 stamp=537302960
input archive log thread=1 sequence=480 recid=421 stamp=537367863
input archive log thread=1 sequence=481 recid=423 stamp=537735710
input archive log thread=1 sequence=482 recid=424 stamp=538002916
channel ORA_DISK_2: starting piece 1 at 11-DEC-04
channel ORA_DISK_3: starting archive log backupset
channel ORA_DISK_3: specifying archive log(s) in backup set
input archive log thread=1 sequence=483 recid=425 stamp=538576405
input archive log thread=1 sequence=484 recid=426 stamp=538688419
input archive log thread=1 sequence=485 recid=427 stamp=538780607
input archive log thread=1 sequence=486 recid=428 stamp=540300882
input archive log thread=1 sequence=487 recid=435 stamp=540572063
input archive log thread=1 sequence=488 recid=437 stamp=543321009
input archive log thread=1 sequence=489 recid=439 stamp=543411402
input archive log thread=1 sequence=490 recid=440 stamp=543781680
input archive log thread=1 sequence=491 recid=441 stamp=544099676
input archive log thread=1 sequence=492 recid=442 stamp=544307697
input archive log thread=1 sequence=493 recid=443 stamp=544307922
input archive log thread=1 sequence=494 recid=444 stamp=544308474
channel ORA_DISK_3: starting piece 1 at 11-DEC-04
channel ORA_DISK_2: finished piece 1 at 11-DEC-04
piece handle=D:ORACLEORA92DATABASEBG7CR5U_1_1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:09:57
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=1 sequence=495 recid=445 stamp=544391541
input archive log thread=1 sequence=496 recid=446 stamp=544564492
input archive log thread=1 sequence=497 recid=447 stamp=544625455
input archive log thread=1 sequence=498 recid=448 stamp=544631633
input archive log thread=1 sequence=499 recid=449 stamp=544631989
channel ORA_DISK_2: starting piece 1 at 11-DEC-04
channel ORA_DISK_1: finished piece 1 at 11-DEC-04
piece handle=D:ORACLEORA92DATABASEAG7CR5U_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:10:32
channel ORA_DISK_3: finished piece 1 at 11-DEC-04
piece handle=D:ORACLEORA92DATABASECG7CR5U_1_1 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:11:30
channel ORA_DISK_2: finished piece 1 at 11-DEC-04
piece handle=D:ORACLEORA92DATABASEDG7CROM_1_1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:55
Finished backup at 11-DEC-04

RMAN> BACKUP DEVICE TYPE DISK DATABASE;

Starting backup at 11-DEC-04
using channel ORA_DISK_2 >>>> that same server process is used as rman is not exited
using channel ORA_DISK_3 >>>> that same server process is used as rman is not exited
using channel ORA_DISK_1 >>>> that same server process is used as rman is not exited
channel ORA_DISK_1: starting full datafile backupset
#### >>>>>>starting piece 1 at 11-DEC-04 backup set has backup pieces
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00009 name=D:ORACLEORADATASRIDEVIUSERS01.DBF
input datafile fno=00011 name=D:ORACLEORADATASRIDEVIRCVCAT.DBF
input datafile fno=00012 name=D:ORACLEORADATASRIDEVIFOR_CONVERSION.DBF
input datafile fno=00024 name=D:ORACLEORADATASRIDEVISCOTT_OLD_01.DBF
input datafile fno=00013 name=D:ORACLEORADATASRIDEVIUSERS02.DBF
input datafile fno=00021 name=D:ORACLEORADATASRIDEVIL_AUTO.DBF
input datafile fno=00008 name=D:ORACLEORADATASRIDEVITOOLS01.DBF
input datafile fno=00015 name=D:ORACLEORADATASRIDEVIFGAC_TEST_2.DBF
input datafile fno=00018 name=D:ORACLEORADATASRIDEVIFGAC_TEST_5.DBF
input datafile fno=00023 name=D:ORACLEORADATASRIDEVIINDEXES.DBF
channel ORA_DISK_1:
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=D:ORACLEORADATASRIDEVISYSTEM01.DBF
input datafile fno=00005 name=D:ORACLEORADATASRIDEVIEXAMPLE01.DBF
input datafile fno=00010 name=D:ORACLEORADATASRIDEVIXDB01.DBF
input datafile fno=00026 name=D:ORACLEORADATASRIDEVIOEM_REP.DBF
input datafile fno=00014 name=D:ORACLEORADATASRIDEVIFGAC_TEST_1.DBF
input datafile fno=00017 name=D:ORACLEORADATASRIDEVIFGAC_TEST_4.DBF
input datafile fno=00022 name=D:ORACLEORADATASRIDEVITEST_THIS.DBF
input datafile fno=00020 name=D:ORACLEORADATASRIDEVIL_UNIFORM.DBF
input datafile fno=00007 name=D:ORACLEORADATASRIDEVIODM01.DBF
channel ORA_DISK_2: starting piece 1 at 11-DEC-04
channel ORA_DISK_3: starting full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=D:ORACLEORADATASRIDEVIUNDO_AUTO_1_01.DBF
input datafile fno=00025 name=D:ORACLEORADATASRIDEVIPERFSTAT_01.DBF
input datafile fno=00027 name=D:ORACLEORADATASRIDEVILOGMNRTS_1.ORA
input datafile fno=00006 name=D:ORACLEORADATASRIDEVIINDX01.DBF
input datafile fno=00016 name=D:ORACLEORADATASRIDEVIFGAC_TEST_3.DBF
input datafile fno=00019 name=D:ORACLEORADATASRIDEVIL_U_TEST_1.DBF
input datafile fno=00003 name=D:ORACLEORADATASRIDEVICWMLITE01.DBF
input datafile fno=00004 name=D:ORACLEORADATASRIDEVIDRSYS01.DBF
channel ORA_DISK_3: starting piece 1 at 11-DEC-04
channel ORA_DISK_1: finished piece 1 at 11-DEC-04
piece handle=D:ORACLEORA92DATABASEEG7CRSE_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:23:34
channel ORA_DISK_2: finished piece 1 at 11-DEC-04
piece handle=D:ORACLEORA92DATABASEFG7CRSE_1_1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:30:01
channel ORA_DISK_3: finished piece 1 at 11-DEC-04
piece handle=D:ORACLEORA92DATABASEGG7CRUS_1_1 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:30:09
Finished backup at 11-DEC-04

RMAN>

Total time taken to backup a database of 8 GB is 1 hour 23 minutes

In the next part let us discuss all the important components of backup and recovery strategies with case study.