複習 DBA Skills/Oracle -- 進深 1
晚上7:19
複習 DBA Skills/Oracle -- 進深 1
A. 在我整理的Nodepad Plus Plus Projects for JDFD的DBA ITEMS中的第31項：31_allbackups(備份)
1. %ORACLE_HOME%\product\11.2.0\dbhome_1\assistants\dbca\templates (Ref : Oracle -- Database Configuration Assistant (DBCA) templates)中有兩個 file：
(1). Oracle Database's Control File：Seed_Database.ctl
(2). Oracle Database's Data File：Seed_Database.dfb
它們被回復成：
a. SYSTEM01.DBF
b. SYSAUX01.DBF
1. 執行 %ORACLE_HOME%\product\11.2.0\dbhome_1\assistants\dbca\templates (Ref : Oracle -- Database Configuration Assistant (DBCA) templates) 回復的 SQL Script：
A. 在我整理的Nodepad Plus Plus Projects for JDFD的DBA ITEMS中的第31項：31_allbackups(備份)
1. %ORACLE_HOME%\product\11.2.0\dbhome_1\assistants\dbca\templates (Ref : Oracle -- Database Configuration Assistant (DBCA) templates)中有兩個 file：
(1). Oracle Database's Control File：Seed_Database.ctl
(2). Oracle Database's Data File：Seed_Database.dfb
它們被回復成：
a. SYSTEM01.DBF
b. SYSAUX01.DBF
c. UNDOTBS01.DBF
d. USERS01.DBF (存儲/表空間/USERS/資料檔案Data File*)
(可以查看：cloneDBCreation.log)
(可以查看：cloneDBCreation.log)
1. 執行 %ORACLE_HOME%\product\11.2.0\dbhome_1\assistants\dbca\templates (Ref : Oracle -- Database Configuration Assistant (DBCA) templates) 回復的 SQL Script：
set verify off;
set echo off;
set serveroutput on;
select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual;
variable devicename varchar2(255);
declare
omfname varchar2(512) := NULL;
done boolean;
begin
dbms_output.put_line(' ');
dbms_output.put_line(' Allocating device.... ');
dbms_output.put_line(' Specifying datafiles... ');
:devicename := dbms_backup_restore.deviceAllocate;
dbms_output.put_line(' Specifing datafiles... ');
dbms_backup_restore.restoreSetDataFile;
dbms_backup_restore.restoreDataFileTo(1, '%ORACLE_HOME%\oradata\orcl4\SYSTEM01.DBF', 0, 'SYSTEM');
dbms_backup_restore.restoreDataFileTo(2, '%ORACLE_HOME%\oradata\orcl4\SYSAUX01.DBF', 0, 'SYSAUX');
dbms_backup_restore.restoreDataFileTo(3, '%ORACLE_HOME%\oradata\orcl4\UNDOTBS01.DBF', 0, 'UNDOTBS1');
dbms_backup_restore.restoreDataFileTo(4, '%ORACLE_HOME%\oradata\orcl4\USERS01.DBF', 0, 'USERS');
dbms_output.put_line(' Restoring ... ');
dbms_backup_restore.restoreBackupPiece('%ORACLE_HOME%\product\11.2.0\dbhome_1/assistants/dbca/templates\Seed_Database.dfb', done);
if done then
dbms_output.put_line(' Restore done.');
else
dbms_output.put_line(' ORA-XXXX: Restore failed ');
end if;
dbms_backup_restore.deviceDeallocate;
end;
/
select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual;
發表文章
0 意見