Database Backup恢複--快速恢複地區的使用

標籤：imm   開啟   備份恢複   sid   nbsp   des   資料庫配置   備份   file   

 

1.建立FRA地區
[[email protected] u01]$ cd /u01
[[email protected] u01]$ mkdir FRA
[[email protected] u01]$ chown oracle:dba /u01/FRA

2.登入資料庫配置
[[email protected] ~]# su - oracle
[[email protected] ~]$ export ORACLE_SID=ocp
[[email protected] ~]$ sqlplus / as sysdba

3.配置FRA
[email protected]> alter system set db_recovery_file_dest_size=2g;
System altered.

[email protected]> alter system set db_recovery_file_dest=‘/u01/FRA‘;
System altered.

4.將資料庫於archivelog模式
4.1關閉資料庫
[email protected]> shutdown immediate

4.2掛載資料庫
[email protected]> startup mount

4.3開啟歸檔模式
[email protected]> alter database archivelog;
Database altered.

4.4開啟資料庫
[email protected]> alter database open;
Database altered.

Database Backup恢複--快速恢複地區的使用