Shulou(Shulou.com)06/02 Report--

[root@rhel5 ~] # su-oracle

[oracle@rhel5 ~] $rman catalog scott/tiger@wailon

Recovery Manager: Release 10.2.0.5.0-Production on Thu Sep 5 04:20:38 2013

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to recovery catalog database

RMAN > create catalog

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user SCOTT

RMAN >-- catalog administrative users must have a RECOVERY_CATALOG_OWNER role

RMAN > exit

Recovery Manager complete.

[oracle@rhel5 ~] $sqlplus / as sysdba

SQL > grant recovery_catalog_owner to scott

Grant succeeded.

-- create CATALOG again after authorization

[oracle@rhel5 ~] $rman catalog scott/tiger@wailon

RMAN > create catalog

Recovery catalog created

-- create a CATALOG administrative user

[oracle@rhel5 ~] $sqlplus / as sysdba

SQL > create user rman identified by rman

User created.

SQL > grant recovery_catalog_owner to rman

Grant succeeded.

SQL > alter user rman quota 100m on user01

User altered.

SQL > grant connect,resource to rman

Grant succeeded.

[oracle@rhel5 ~] $rman catalog scott/tiger@wailon

RMAN >-- Delete catalog

RMAN > drop catalog

Recovery catalog owner is SCOTT

Enter DROP CATALOG command again to confirm catalog removal

RMAN > drop catalog

Recovery catalog dropped

-- establish a CATALOG managed by RMAN users

[oracle@rhel5 ~] $rman catalog rman/rman@wailon

RMAN > create catalog

Recovery catalog created

-- RMAN users generate related objects for CATALOG management

[oracle@rhel5 ~] $sqlplus rman/rman

SQL*Plus: Release 10.2.0.5.0-Production on Thu Sep 5 04:26:46 2013

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > select * from tab

TNAME TABTYPE CLUSTERID

RC_BACKUP_SET_SUMMARY VIEW

RC_BACKUP_DATAFILE_SUMMARY VIEW

RC_BACKUP_CONTROLFILE_SUMMARY VIEW

RC_BACKUP_ARCHIVELOG_SUMMARY VIEW

RC_BACKUP_SPFILE_SUMMARY VIEW

RC_BACKUP_COPY_SUMMARY VIEW

RC_PROXY_COPY_SUMMARY VIEW

RC_PROXY_ARCHIVELOG_SUMMARY VIEW

RC_UNUSABLE_BACKUPFILE_DETAILS VIEW

RC_RMAN_BACKUP_TYPE VIEW

XAL TABLE

RSR TABLE

FB TABLE

GRSP TABLE

RC_DATABASE VIEW

RC_DATABASE_INCARNATION VIEW

RC_RESYNC VIEW

RC_CHECKPOINT VIEW

RC_TABLESPACE VIEW

RC_DATAFILE VIEW

RC_TEMPFILE VIEW

RC_REDO_THREAD VIEW

RC_REDO_LOG VIEW

RC_LOG_HISTORY VIEW

RC_ARCHIVED_LOG VIEW

RC_BACKUP_SET VIEW

RC_BACKUP_PIECE VIEW

RC_BACKUP_DATAFILE VIEW

RC_BACKUP_CONTROLFILE VIEW

RC_BACKUP_SPFILE VIEW

RC_DATAFILE_COPY VIEW

RC_CONTROLFILE_COPY VIEW

RC_BACKUP_REDOLOG VIEW

RC_BACKUP_CORRUPTION VIEW

RC_COPY_CORRUPTION VIEW

RC_OFFLINE_RANGE VIEW

RC_STORED_SCRIPT VIEW

RC_STORED_SCRIPT_LINE VIEW

RC_PROXY_DATAFILE VIEW

RC_PROXY_CONTROLFILE VIEW

RC_RMAN_CONFIGURATION VIEW

RC_DATABASE_BLOCK_CORRUPTION VIEW

RC_PROXY_ARCHIVEDLOG VIEW

RC_RMAN_STATUS VIEW

ROUT TABLE

RC_RMAN_OUTPUT VIEW

RCVER TABLE

RC_BACKUP_FILES VIEW

RC_RMAN_BACKUP_SUBJOB_DETAILS VIEW

RC_RMAN_BACKUP_JOB_DETAILS VIEW

RC_BACKUP_SET_DETAILS VIEW

RC_BACKUP_PIECE_DETAILS VIEW

RC_BACKUP_COPY_DETAILS VIEW

RC_PROXY_COPY_DETAILS VIEW

RC_PROXY_ARCHIVELOG_DETAILS VIEW

RC_BACKUP_DATAFILE_DETAILS VIEW

RC_BACKUP_CONTROLFILE_DETAILS VIEW

RC_BACKUP_ARCHIVELOG_DETAILS VIEW

RC_BACKUP_SPFILE_DETAILS VIEW

DB TABLE

NODE TABLE

CONF TABLE

DBINC TABLE

CKP TABLE

TS TABLE

TSATT TABLE

DF TABLE

DFATT TABLE

TF TABLE

TFATT TABLE

OFFR TABLE

RR TABLE

RT TABLE

ORL TABLE

RLH TABLE

AL TABLE

BS TABLE

BP TABLE

BCF TABLE

CCF TABLE

XCF TABLE

BSF TABLE

BDF TABLE

CDF TABLE

XDF TABLE

BRL TABLE

BCB TABLE

CCB TABLE

SCR TABLE

SCRL TABLE

CONFIG TABLE

91 rows selected.

-- registering the target library for CATALOG management

[oracle@rhel5 ~] $rman target / catalog rman/rman@wailon

Recovery Manager: Release 10.2.0.5.0-Production on Thu Sep 5 04:27:09 2013

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to target database: WAILON (DBID=2747751647)

Connected to recovery catalog database

RMAN >-- Register catalog

RMAN > register database

Database registered in recovery catalog

Starting full resync of recovery catalog

Full resync complete

-- after using CATALOG management, you can set up backup scripts managed by RMAN

RMAN > create script full_backup

2 > {

3 > backup database

4 > delete obsolete

5 >}

-- execute backup script

RMAN > run {execute script full_backup;}

Executing script: full_backup

Starting backup at 05-SEP-13

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=21 devtype=DISK

Channel ORA_DISK_1: starting compressed full datafile backupset

Channel ORA_DISK_1: specifying datafile (s) in backupset

Input datafile fno=00001 name=/u01/app/oracle/oradata/wailon/system01.dbf

Input datafile fno=00003 name=/u01/app/oracle/oradata/wailon/sysaux01.dbf

Input datafile fno=00002 name=/u01/app/oradata/wailon/untotbs01.dbf

Input datafile fno=00004 name=/u01/app/oracle/oradata/wailon/user01.dbf

Channel ORA_DISK_1: starting piece 1 at 05-SEP-13

Channel ORA_DISK_1: finished piece 1 at 05-SEP-13

Piece handle=/u01/app/flash_recovery_area/0coj2dmt_1_1.bkp tag=TAG20130905T042812 comment=NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15

Channel ORA_DISK_1: starting compressed full datafile backupset

Channel ORA_DISK_1: specifying datafile (s) in backupset

Including current control file in backupset

Including current SPFILE in backupset

Channel ORA_DISK_1: starting piece 1 at 05-SEP-13

Channel ORA_DISK_1: finished piece 1 at 05-SEP-13

Piece handle=/u01/app/flash_recovery_area/0doj2dnc_1_1.bkp tag=TAG20130905T042812 comment=NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 05-SEP-13

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03015: error occurred in stored script full_backup

RMAN-03002: failure of delete command at 09/05/2013 04:28:31

RMAN-06525: RMAN retention policy is set to none

-- View the backup script

RMAN > print script full_backup

Printing stored script: full_backup

{backup database

Delete obsolete

}

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.