Tuesday, February 17, 2009

2 Enable Archivelog and hotbackup with rman

フラッシュリカバリエリアを利用可能に

mkdir /u01/oracle/myoracle/oradata/flash_recovery_area

sqlplus "/ as sysdba"

alter system set db_recovery_file_dest_size=10g scope=both;
alter system set db_recovery_file_dest='/u01/oracle/myoracle/oradata/flash_recovery_data' scope=both;

quit

アーカイブログを利用可能に

mkdir /u01/oracle/myoracle/oradata/mynewdb/arch

sqlplus "/ as sysdba"

alter system set log_archive_dest_1='location=/u01/oracle/myoracle/oradata/mynewdb/arch'

shutdown immediate;
startup mount;
alter database archivelog;
alter database open;

quit

RMANでオンラインバックアップ

rman target / nocatalog

configure controlfile autobackup on;
backup database plus archivelog delete input;

quit

No comments: