CONNECTIVITY

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@sridevinocatalog

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 / catalogrman/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:ORACLEORA92DATABASE