Code Listing 1: Sample init.ora file for RMAN repository database


db_name=RMAN
instance_name=RMAN
service_names=RMAN

compatible=9.2.0.0.0


control_files=(/u01/oradata/RMAN/control01.ctl, /u04/oradata/RMAN/control02.ctl)

db_block_size=8192

shared_pool_size=100M

db_cache_size=100M

background_dump_dest=/u01/app/oracle/admin/RMAN/bdump
core_dump_dest=/u01/app/oracle/admin/RMAN/cdump
user_dump_dest=/u01/app/oracle/admin/RMAN/udump

# Oracle Managed File parameters

db_create_file_dest='/u02/oradata/RMAN'
db_create_online_log_dest_1='/u01/oradata/RMAN'
db_create_online_log_dest_2='/u03/oradata/RMAN'

# System Managed Undo parameters
undo_management=AUTO
undo_tablespace=UNDO
undo_retention=1200

undo_suppress_errors=TRUE

log_archive_dest_1  = 'LOCATION=/u01/app/oracle/admin/RMAN/arch/'
log_archive_format  = RMAN_%s.arc
log_archive_start   = true
 
remote_login_passwordfile=EXCLUSIVE
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