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