2012-11-28 - 11-29 11gR2 "Backup and Recovery User's Guide" page 485 - 529

 

 

Checking the Database Before Cross-Platform Database Conversion -- CONVERT DATABASE之前先检查可行性

DECLARE
db_ready BOOLEAN;
BEGIN
db_ready :=
DBMS_TDB.CHECK_DB('Microsoft Windows IA (32-bit)',DBMS_TDB.SKIP_READONLY); -- 转化到WINDOWS平台，READ ONLY不检查
END;
/
PL/SQL procedure successfully completed.

Execute the DBMS_TDB.CHECK_EXTERNAL function to identify any external
tables, directories, or BFILEs. RMAN cannot automate the transport of these files,
so you must copy the files manually and re-create the database directories.
-- 检查是否有EXTERNAL TABLES等，这些表无法TRANSAPORT

DECLARE
external BOOLEAN;
BEGIN
/* value of external is ignored, but with SERVEROUTPUT set to ON
* dbms_tdb.check_external displays report of external objects
* on console */
external := DBMS_TDB.CHECK_EXTERNAL;
END;
/

 

Backing Up to Raw Devices on Linux and UNIX -- 用DD命令备份裸设备