Code Listing 2: Sample RMAN repository database-creation script


set echo on
set feedback on

spool createRMAN.log


connect / as sysdba

host orapwd file=$ORACLE_HOME/dbs/orapwRMAN password=manager entries=5

startup nomount pfile=$ORACLE_BASE/admin/RMAN/pfile/initRMAN.ora


create database RMAN
default temporary tablespace TEMP
undo tablespace UNDO;

create tablespace RMAN;

create user RMAN

identified by manager
default tablespace RMAN;

grant resource, connect, recovery_catalog_owner to RMAN;

@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/catexp.sql


shutdown immediate

startup mount pfile=$ORACLE_BASE/admin/RMAN/pfile/initRMAN.ora

alter database archivelog;

alter database open


archive log list

spool off

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy