フラッシュリカバリエリアを利用可能に
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment