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