0级表空间后，又有0级全库备份，再1级表空间备份，xtts还认吗？
2023-12-17 23:41:16
0级表空间后，又有0级全库备份，再1级表空间备份，xtts还认吗？
不认。此时需要根据提示报错的scn号再做备份再做恢复：
backup incremental from SCN 1041682 tablespace DATA,USERS filesperset 300 format '/bak/hisdb1_05' tag=hisdb1;
0级表空间后，又1级全库增备份，再1级表空间备份，xtts还认吗？
认。
完整的测试代码：
会话1：
会话1：
SQL> !vi r.sql
set serveroutput on size 1000000
DECLARE
v_dev varchar2(50);
v_done boolean:=FALSE;
type t_fileTable is table of varchar2(255) index by binary_integer;
v_fileTable t_fileTable;
type t_dataTable is table of varchar2(4000) index by binary_integer;
v_dataTable t_dataTable;
v_maxPieces number:=1;
v_maxFiles number:=1;
v_restore_from varchar2(4);
v_file_no number:=0;
v_file_name varchar2(513);
v_debug boolean:=FALSE; -- Optional Change to TRUE to Debug PL/SQL.
v_msr boolean;
BEGIN
-- CHANGE 1.
-- Populate the file table below with datafiles to be restored.
-- This matches the output from logs.
v_dataTable(1):='fno=4 name=/home/db/oracle/oradata/hisdb/users01.dbf';
v_dataTable(2):='fno=9 name=/home/db/oracle/oradata/hisdb/data03.dbf';
v_dataTable(3):='fno=7 name=/home/db/oracle/oradata/hisdb/data01.dbf';
v_dataTable(4):='fno=8 name=/home/db/oracle/oradata/hisdb/data02.dbf';
v_dataTable(5):='fno=5 name=/home/db/oracle/oradata/hisdb/users02.dbf';
v_dataTable(6):='fno=10 name=/home/db/oracle/oradata/hisdb/data04.dbf';
v_dataTable(7):='fno=6 name=/home/db/oracle/oradata/hisdb/users03.dbf';
--
-- CHANGE 2.
-- Set the below to the max number of files to be restored from above table.
v_maxFiles := 7;
-- CHANGE 3.
-- Set the Below To the name of the backup pieces you wish to reference.
-- Use backup.log if available to locate all backup pieces for a backup.
-- If backup is on Disk ensure you have directories as well,
-- If tape then just use the backup piece name.
v_fileTable(1):='/bak/hisdb0_012e3g99_1_1';
v_fileTable(2):='/bak/hisdb0_022e3g99_1_1';
v_fileTable(3):='/bak/hisdb0_032e3g99_1_1';
v_fileTable(4):='/bak/hisdb0_042e3g99_1_1';
-- CHANGE 4.
-- Set the below to the total number of backup pieces in Backup to restore.
--
v_maxPieces:=4;
-- CHANGE 5. (Optional If Tape)
-- Set the below to TAPE if RESTORE FROM TAPE.
--
v_restore_from := 'DISK';
-- CHANGE 6 - change this to TRUE for multi-section backup
--v_msr := TRUE;
v_msr := FALSE;
IF (v_msr) THEN
v_maxFiles := 1;
END IF;
dbms_output.put_line('Restoring All Data Files :');
set serveroutput on size 1000000
DECLARE
v_dev varchar2(50);
v_done boolean:=FALSE;
type t_fileTable is table of varchar2(255) index by binary_integer;
v_fileTable t_fileTable;
type t_dataTable is table of varchar2(4000) index by binary_integer;
v_dataTable t_dataTable;
v_maxPieces number:=1;
v_maxFiles number:=1;
v_restore_from varchar2(4);
v_file_no number:=0;
v_file_name varchar2(513);
v_debug boolean:=FALSE; -- Optional Change to TRUE to Debug PL/SQL.
v_msr boolean;
BEGIN
-- CHANGE 1.
-- Populate the file table below with datafiles to be restored.
-- This matches the output from logs.
v_dataTable(1):='fno=4 name=/home/db/oracle/oradata/hisdb/users01.dbf';
v_dataTable(2):='fno=9 name=/home/db/oracle/oradata/hisdb/data03.dbf';
v_dataTable(3):='fno=7 name=/home/db/oracle/oradata/hisdb/data01.dbf';
v_dataTable(4):='fno=8 name=/home/db/oracle/oradata/hisdb/data02.dbf';
v_dataTable(5):='fno=5 name=/home/db/oracle/oradata/hisdb/users02.dbf';
v_dataTable(6):='fno=10 name=/home/db/oracle/oradata/hisdb/data04.dbf';
v_dataTable(7):='fno=6 name=/home/db/oracle/oradata/hisdb/users03.dbf';
--
-- CHANGE 2.
-- Set the below to the max number of files to be restored from above table.
v_maxFiles := 7;
-- CHANGE 3.
-- Set the Below To the name of the backup pieces you wish to reference.
-- Use backup.log if available to locate all backup pieces for a backup.
-- If backup is on Disk ensure you have directories as well,
-- If tape then just use the backup piece name.
"r.sql" 125L, 3870C written
SQL> @r.sql
Restoring All Data Files :
-----------------
Attempting To Restore :/home/db/oracle/oradata/hisdb/users01.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/users01.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/data03.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/data03.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/data01.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/data01.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/data02.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/data02.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/users02.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0l2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/users02.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/data04.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0l2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/data04.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/users03.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0l2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0n2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/users03.dbf
PL/SQL procedure successfully completed.
SQL> !ls -l /home/db/oracle/oradata/hisdb/
total 1919116
-rw-r-----. 1 oracle oinstall 9748480 Dec 17 22:34 control01.ctl
-rw-r----- 1 oracle oinstall 1056768 Dec 17 22:34 data01.dbf
-rw-r----- 1 oracle oinstall 1056768 Dec 17 22:34 data02.dbf
-rw-r----- 1 oracle oinstall 1056768 Dec 17 22:34 data03.dbf
-rw-r----- 1 oracle oinstall 1056768 Dec 17 22:34 data04.dbf
-rw-r-----. 1 oracle oinstall 209715712 Dec 17 22:32 redo01.log
-rw-r-----. 1 oracle oinstall 209715712 Dec 17 22:30 redo02.log
-rw-r-----. 1 oracle oinstall 209715712 Dec 17 22:30 redo03.log
-rw-r-----. 1 oracle oinstall 513810432 Dec 17 22:30 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 713039872 Dec 17 22:30 system01.dbf
-rw-r-----. 1 oracle oinstall 30416896 Dec 17 22:31 temp01.dbf
-rw-r-----. 1 oracle oinstall 83894272 Dec 17 22:30 undotbs01.dbf
-rw-r----- 1 oracle oinstall 2105344 Dec 17 22:34 users01.dbf
-rw-r----- 1 oracle oinstall 2105344 Dec 17 22:34 users02.dbf
-rw-r----- 1 oracle oinstall 2105344 Dec 17 22:34 users03.dbf
SQL> !vi recover.sql
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_05',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
DBMS_OUTPUT.put_line('Done: RestoreSetPiece');
sys.dbms_backup_restore.restoreBackupPiece(done => done,params => null,outhandle => outhandle,outtag => outtag, failover => failover);
DBMS_OUTPUT.put_line('Done: RestoreBackupPiece');
sys.dbms_backup_restore.restoreCancel(TRUE);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_05',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
DBMS_OUTPUT.put_line('Done: RestoreSetPiece');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/isdb1_05',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/sdb1_05',tag => null,fromdisk => true, recid => 0sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/db1_05',tag => null,fromdisk => true, recid => 0,sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/b1_05',tag => null,fromdisk => true, recid => 0,ssys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/1_05',tag => null,fromdisk => true, recid => 0,stsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/_05',tag => null,fromdisk => true, recid => 0,stasys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/05',tag => null,fromdisk => true, recid => 0,stamsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/5',tag => null,fromdisk => true, recid => 0,stampsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/',tag => null,fromdisk => true, recid => 0,stamp sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb0_0o2e9r7g_1_1',tag => null,fromdisk => true"recover.sql" 29L, 2056C written
SQL> @recover.sql
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: RestoreSetPiece
DECLARE
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error while restoring backup piece /bak/hisdb0_0o2e9r7g_1_1
ORA-19626: backup set type is full datafile - can not be processed by this conversation
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 2335
ORA-06512: at line 22
SQL> conn / as sysdba
Connected.
SQL> !vi recover.sql
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb0_0o2e9r7g_1_1',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
DBMS_OUTPUT.put_line('Done: RestoreSetPiece');
sys.dbms_backup_restore.restoreBackupPiece(done => done,params => null,outhandle => outhandle,outtag => outtag, failover => failover);
DBMS_OUTPUT.put_line('Done: RestoreBackupPiece');
sys.dbms_backup_restore.restoreCancel(TRUE);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb0_0o2e9r7g_1_1',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/isdb0_0o2e9r7g_1_1',tag => null,fromdisk => true,sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/sdb0_0o2e9r7g_1_1',tag => null,fromdisk => true, sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/db0_0o2e9r7g_1_1',tag => null,fromdisk => true, rsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/b0_0o2e9r7g_1_1',tag => null,fromdisk => true, resys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/0_0o2e9r7g_1_1',tag => null,fromdisk => true, recsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/_0o2e9r7g_1_1',tag => null,fromdisk => true, recisys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/0o2e9r7g_1_1',tag => null,fromdisk => true, recidsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/o2e9r7g_1_1',tag => null,fromdisk => true, recid sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/2e9r7g_1_1',tag => null,fromdisk => true, recid =sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/e9r7g_1_1',tag => null,fromdisk => true, recid =>sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/9r7g_1_1',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/r7g_1_1',tag => null,fromdisk => true, recid => 0sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/7g_1_1',tag => null,fromdisk => true, recid => 0,sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/g_1_1',tag => null,fromdisk => true, recid => 0,ssys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/_1_1',tag => null,fromdisk => true, recid => 0,stsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/1_1',tag => null,fromdisk => true, recid => 0,stasys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/_1',tag => null,fromdisk => true, recid => 0,stamsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/1',tag => null,fromdisk => true, recid => 0,stampsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/',tag => null,fromdisk => true, recid => 0,stamp sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb0_0q2e9r9a_1_1',tag => null,fromdisk => true"recover.sql" 29L, 2056C written
SQL> @recover.sql
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: RestoreSetPiece
DECLARE
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error while restoring backup piece /bak/hisdb0_0q2e9r9a_1_1
ORA-19638: file /home/db/oracle/oradata/hisdb/users01.dbf is not current enough to apply this incremental backup
ORA-19642: start SCN of incremental backup is 1047813
ORA-19641: backup datafile checkpoint is SCN 1047878 time 12/17/2023 22:26:50
ORA-19640: datafile checkpoint is SCN 1047630 time 12/17/2023 22:23:42
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 2335
ORA-06512: at line 22
SQL> !vi recover.sql
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb0_0q2e9r9a_1_1',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
DBMS_OUTPUT.put_line('Done: RestoreSetPiece');
sys.dbms_backup_restore.restoreBackupPiece(done => done,params => null,outhandle => outhandle,outtag => outtag, failover => failover);
DBMS_OUTPUT.put_line('Done: RestoreBackupPiece');
sys.dbms_backup_restore.restoreCancel(TRUE);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/isdb0_0q2e9r9a_1_1',tag => null,fromdisk => true,sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/sdb0_0q2e9r9a_1_1',tag => null,fromdisk => true, sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/db0_0q2e9r9a_1_1',tag => null,fromdisk => true, rsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/b0_0q2e9r9a_1_1',tag => null,fromdisk => true, resys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/0_0q2e9r9a_1_1',tag => null,fromdisk => true, recsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/_0q2e9r9a_1_1',tag => null,fromdisk => true, recisys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/0q2e9r9a_1_1',tag => null,fromdisk => true, recidsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/q2e9r9a_1_1',tag => null,fromdisk => true, recid sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/2e9r9a_1_1',tag => null,fromdisk => true, recid =sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/e9r9a_1_1',tag => null,fromdisk => true, recid =>sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/9r9a_1_1',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/r9a_1_1',tag => null,fromdisk => true, recid => 0sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/9a_1_1',tag => null,fromdisk => true, recid => 0,sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/a_1_1',tag => null,fromdisk => true, recid => 0,ssys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/_1_1',tag => null,fromdisk => true, recid => 0,stsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/1_1',tag => null,fromdisk => true, recid => 0,stasys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/_1',tag => null,fromdisk => true, recid => 0,stamsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/1',tag => null,fromdisk => true, recid => 0,stampsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/',tag => null,fromdisk => true, recid => 0,stamp sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_07',tag => null,fromdisk => true, recid =>"recover.sql" 29L, 2046C written
SQL> @recover.sql
Entering RollForward
DECLARE
*
ERROR at line 1:
ORA-19568: a device is already allocated to this session
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 232
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 207
ORA-06512: at line 9
SQL> conn / as sysdba
Connected.
SQL> @recover.sql
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: RestoreSetPiece
DECLARE
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error while restoring backup piece /bak/hisdb1_07
ORA-19638: file /home/db/oracle/oradata/hisdb/users01.dbf is not current enough to apply this incremental backup
ORA-19642: start SCN of incremental backup is 1047878
ORA-19641: backup datafile checkpoint is SCN 1047951 time 12/17/2023 22:28:22
ORA-19640: datafile checkpoint is SCN 1047630 time 12/17/2023 22:23:42
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 2335
ORA-06512: at line 22
SQL> !vi recover.sql
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_07',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
DBMS_OUTPUT.put_line('Done: RestoreSetPiece');
sys.dbms_backup_restore.restoreBackupPiece(done => done,params => null,outhandle => outhandle,outtag => outtag, failover => failover);
DBMS_OUTPUT.put_line('Done: RestoreBackupPiece');
sys.dbms_backup_restore.restoreCancel(TRUE);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_0',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_08',tag => null,fromdisk => true, recid =>"recover.sql" 29L, 2046C written
SQL> @recover.sql
Entering RollForward
DECLARE
*
ERROR at line 1:
ORA-19568: a device is already allocated to this session
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 232
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 207
ORA-06512: at line 9
SQL> conn / as sysdba
Connected.
SQL> @recover.sql
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: RestoreSetPiece
DECLARE
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error while restoring backup piece /bak/hisdb1_08
ORA-19638: file /home/db/oracle/oradata/hisdb/users01.dbf is not current enough to apply this incremental backup
ORA-19642: start SCN of incremental backup is 1047951
ORA-19641: backup datafile checkpoint is SCN 1048074 time 12/17/2023 22:31:43
ORA-19640: datafile checkpoint is SCN 1047630 time 12/17/2023 22:23:42
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 2335
ORA-06512: at line 22
SQL> !vi recover.sql
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_08',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
DBMS_OUTPUT.put_line('Done: RestoreSetPiece');
sys.dbms_backup_restore.restoreBackupPiece(done => done,params => null,outhandle => outhandle,outtag => outtag, failover => failover);
DBMS_OUTPUT.put_line('Done: RestoreBackupPiece');
sys.dbms_backup_restore.restoreCancel(TRUE);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_8',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_',tag => null,fromdisk => true, recid => 0sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_s',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_sc',tag => null,fromdisk => true, recid =>sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_scn',tag => null,fromdisk => true, recid ="recover.sql" 29L, 2047C written
SQL> @recover.sql
Entering RollForward
DECLARE
*
ERROR at line 1:
ORA-19568: a device is already allocated to this session
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 232
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 207
ORA-06512: at line 9
SQL> conn / as sysdba
Connected.
SQL> @recover.sql
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
SQL> @o.sql
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
J1 DATABASE LINK 1
J1 INDEX 1
J1 SYNONYM 1
J1 TABLE 11
J2 DATABASE LINK 1
J2 SEQUENCE 2
J2 SYNONYM 1
J2 TABLE 8
J2 VIEW 1
PUBLIC DATABASE LINK 2
PUBLIC SYNONYM 27699
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
SCOTT INDEX 2
SCOTT TABLE 4
13 rows selected.
SQL>
SQL>
SQL>
SQL> startup mount force;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 452986992 bytes
Database Buffers 1140850688 bytes
Redo Buffers 7360512 bytes
Database mounted.
SQL> flashback database hisdb to restore point before_imp_xtts;
Flashback complete.
SQL> alter database open resetlogs;
Database altered.
SQL> @tbs.sql
SP2-0310: unable to open file "tbs.sql"
SQL> @/home/oracle/tbs.sql
TABLESPACE_NAME SUM_SPACE(M) SUM_BLOCKS USED_SPACE(M) USED_RATE(%) FREE_SPACE(M)
------------------------------ ------------ ---------- ------------- ------------ -------------
SYSTEM 680 87040 674.25 99.15 5.75
UNDOTBS1 80 10240 78 97.5 2
SYSAUX 490 62720 466.06 95.11 23.94
TEMP 29 3712 2 6.9 27
SQL> @o.sql
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
J1 DATABASE LINK 1
J1 SYNONYM 1
J2 DATABASE LINK 1
J2 SEQUENCE 2
J2 SYNONYM 1
J2 TABLE 2
J2 VIEW 1
PUBLIC DATABASE LINK 2
PUBLIC SYNONYM 27699
9 rows selected.
SQL> @r.sql
Restoring All Data Files :
-----------------
Attempting To Restore :/home/db/oracle/oradata/hisdb/users01.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/users01.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/data03.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/data03.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/data01.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/data01.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/data02.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/data02.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/users02.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0l2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/users02.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/data04.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0l2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/data04.dbf
Attempting To Restore :/home/db/oracle/oradata/hisdb/users03.dbf
----------------
Trying : /bak/hisdb0_0k2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0m2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0l2e9r3e_1_1 From : DISK
Data File: Not Found
----------------
Trying : /bak/hisdb0_0n2e9r3e_1_1 From : DISK
Data File : Found
----------------
RESTORED Data File To: /home/db/oracle/oradata/hisdb/users03.dbf
PL/SQL procedure successfully completed.
SQL> !ls -lt /home/db/oracle/oradata/hisdb/*
-rw-r-----. 1 oracle oinstall 9748480 Dec 17 22:47 /home/db/oracle/oradata/hisdb/control01.ctl
-rw-r----- 1 oracle oinstall 2105344 Dec 17 22:46 /home/db/oracle/oradata/hisdb/users03.dbf
-rw-r----- 1 oracle oinstall 1056768 Dec 17 22:46 /home/db/oracle/oradata/hisdb/data04.dbf
-rw-r----- 1 oracle oinstall 2105344 Dec 17 22:46 /home/db/oracle/oradata/hisdb/users02.dbf
-rw-r----- 1 oracle oinstall 1056768 Dec 17 22:46 /home/db/oracle/oradata/hisdb/data02.dbf
-rw-r----- 1 oracle oinstall 1056768 Dec 17 22:46 /home/db/oracle/oradata/hisdb/data01.dbf
-rw-r----- 1 oracle oinstall 1056768 Dec 17 22:46 /home/db/oracle/oradata/hisdb/data03.dbf
-rw-r----- 1 oracle oinstall 2105344 Dec 17 22:46 /home/db/oracle/oradata/hisdb/users01.dbf
-rw-r-----. 1 oracle oinstall 209715712 Dec 17 22:45 /home/db/oracle/oradata/hisdb/redo01.log
-rw-r-----. 1 oracle oinstall 30416896 Dec 17 22:43 /home/db/oracle/oradata/hisdb/temp01.dbf
-rw-r-----. 1 oracle oinstall 513810432 Dec 17 22:43 /home/db/oracle/oradata/hisdb/sysaux01.dbf
-rw-r-----. 1 oracle oinstall 713039872 Dec 17 22:43 /home/db/oracle/oradata/hisdb/system01.dbf
-rw-r-----. 1 oracle oinstall 83894272 Dec 17 22:43 /home/db/oracle/oradata/hisdb/undotbs01.dbf
-rw-r-----. 1 oracle oinstall 209715712 Dec 17 22:43 /home/db/oracle/oradata/hisdb/redo03.log
-rw-r-----. 1 oracle oinstall 209715712 Dec 17 22:43 /home/db/oracle/oradata/hisdb/redo02.log
SQL> @recover.sql
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
SQL> !vi recover.sql
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_scn',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
DBMS_OUTPUT.put_line('Done: RestoreSetPiece');
sys.dbms_backup_restore.restoreBackupPiece(done => done,params => null,outhandle => outhandle,outtag => outtag, failover => failover);
DBMS_OUTPUT.put_line('Done: RestoreBackupPiece');
sys.dbms_backup_restore.restoreCancel(TRUE);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_cn',tag => null,fromdisk => true, recid =>sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_n',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_',tag => null,fromdisk => true, recid => 0sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/isdb1_',tag => null,fromdisk => true, recid => 0,sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/sdb1_',tag => null,fromdisk => true, recid => 0,ssys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/db1_',tag => null,fromdisk => true, recid => 0,stsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/b1_',tag => null,fromdisk => true, recid => 0,stasys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/1_',tag => null,fromdisk => true, recid => 0,stamsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/_',tag => null,fromdisk => true, recid => 0,stampsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/',tag => null,fromdisk => true, recid => 0,stamp sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb0_102e9scs_1_1',tag => null,fromdisk => true"recover.sql" 29L, 2056C written
SQL> @recover.sql
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
SQL> conn / as sysdba
Connected.
SQL> !vi recover.sql
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb0_102e9scs_1_1',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
DBMS_OUTPUT.put_line('Done: RestoreSetPiece');
sys.dbms_backup_restore.restoreBackupPiece(done => done,params => null,outhandle => outhandle,outtag => outtag, failover => failover);
DBMS_OUTPUT.put_line('Done: RestoreBackupPiece');
sys.dbms_backup_restore.restoreCancel(TRUE);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb_102e9scs_1_1',tag => null,fromdisk => true,sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb102e9scs_1_1',tag => null,fromdisk => true, sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb02e9scs_1_1',tag => null,fromdisk => true, rsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb2e9scs_1_1',tag => null,fromdisk => true, resys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdbe9scs_1_1',tag => null,fromdisk => true, recsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb9scs_1_1',tag => null,fromdisk => true, recisys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdbscs_1_1',tag => null,fromdisk => true, recidsys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdbcs_1_1',tag => null,fromdisk => true, recid sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdbs_1_1',tag => null,fromdisk => true, recid =sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb_1_1',tag => null,fromdisk => true, recid =>sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_1',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb_1',tag => null,fromdisk => true, recid => 0sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1',tag => null,fromdisk => true, recid => 0,sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_',tag => null,fromdisk => true, recid => 0sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_0',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_09',tag => null,fromdisk => true, recid =>"recover.sql" 29L, 2046C written
SQL> @recover.sql
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
SQL> !vi recover.sql
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_09',tag => null,fromdisk => true, recid => 0,stamp => 0) ;
DBMS_OUTPUT.put_line('Done: RestoreSetPiece');
sys.dbms_backup_restore.restoreBackupPiece(done => done,params => null,outhandle => outhandle,outtag => outtag, failover => failover);
DBMS_OUTPUT.put_line('Done: RestoreBackupPiece');
sys.dbms_backup_restore.restoreCancel(TRUE);
sys.dbms_backup_restore.deviceDeallocate;
END;
/
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
set serveroutput on;
DECLARE
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
DBMS_OUTPUT.put_line('Entering RollForward');
devtype := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE) ;
DBMS_OUTPUT.put_line('After applySetDataFile');
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>4,toname=>'/home/db/oracle/oradata/hisdb/users01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>9,toname=>'/home/db/oracle/oradata/hisdb/data03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>7,toname=>'/home/db/oracle/oradata/hisdb/data01.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>8,toname=>'/home/db/oracle/oradata/hisdb/data02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>5,toname=>'/home/db/oracle/oradata/hisdb/users02.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>10,toname=>'/home/db/oracle/oradata/hisdb/data04.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
sys.dbms_backup_restore.applyDatafileTo(dfnumber=>6,toname=>'/home/db/oracle/oradata/hisdb/users03.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);
DBMS_OUTPUT.put_line('Done: applyDataFileTo');
sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_9',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_',tag => null,fromdisk => true, recid => 0sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_1',tag => null,fromdisk => true, recid => sys.dbms_backup_restore.restoreSetPiece(handle =>'/bak/hisdb1_10',tag => null,fromdisk => true, recid =>"recover.sql" 29L, 2046C written
SQL> @recover.sql
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
SQL> @o.sql
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
J1 DATABASE LINK 1
J1 INDEX 1
J1 SYNONYM 1
J1 TABLE 12
J2 DATABASE LINK 1
J2 SEQUENCE 2
J2 SYNONYM 1
J2 TABLE 10
J2 VIEW 1
PUBLIC DATABASE LINK 2
PUBLIC SYNONYM 27699
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
SCOTT INDEX 2
SCOTT TABLE 4
13 rows selected.
SQL> @/home/oracle/tbs.sql
TABLESPACE_NAME SUM_SPACE(M) SUM_BLOCKS USED_SPACE(M) USED_RATE(%) FREE_SPACE(M)
------------------------------ ------------ ---------- ------------- ------------ -------------
SYSTEM 680 87040 675.25 99.3 4.75
UNDOTBS1 80 10240 78 97.5 2
SYSAUX 490 62720 467.44 95.4 22.56
USERS 6 768 4.19 69.83 1.81
DATA 4 512 .75 18.75 3.25
TEMP 29 3712 0
6 rows selected.
会话2：
[oracle@11g bak]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 17 22:23:30 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: JYCDB (DBID=592598178)
RMAN> run {
2> allocate channel t1 type disk;
3> allocate channel t2 type disk;
4> allocate channel t3 type disk;
5> allocate channel t4 type disk;
6> backup as backupset incremental level=0 tablespace DATA,USERS format '/bak/hisdb0_%U' tag=hisdb0;
7> release channel t1;
8> release channel t2;
9> release channel t3;
10> release channel t4;
11> }
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=22 device type=DISK
allocated channel: t2
channel t2: SID=149 device type=DISK
allocated channel: t3
channel t3: SID=133 device type=DISK
allocated channel: t4
channel t4: SID=24 device type=DISK
Starting backup at 2023-12-17 22:23:42
channel t1: starting incremental level 0 datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00004 name=/home/db/oracle/oradata/jycdb/users01.dbf
input datafile file number=00009 name=/home/db/oracle/oradata/jycdb/data03.dbf
channel t1: starting piece 1 at 2023-12-17 22:23:42
channel t2: starting incremental level 0 datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00005 name=/home/db/oracle/oradata/jycdb/users02.dbf
input datafile file number=00010 name=/home/db/oracle/oradata/jycdb/data04.dbf
channel t2: starting piece 1 at 2023-12-17 22:23:42
channel t3: starting incremental level 0 datafile backup set
channel t3: specifying datafile(s) in backup set
input datafile file number=00007 name=/home/db/oracle/oradata/jycdb/data01.dbf
input datafile file number=00008 name=/home/db/oracle/oradata/jycdb/data02.dbf
channel t3: starting piece 1 at 2023-12-17 22:23:42
channel t4: starting incremental level 0 datafile backup set
channel t4: specifying datafile(s) in backup set
input datafile file number=00006 name=/home/db/oracle/oradata/jycdb/users03.dbf
channel t4: starting piece 1 at 2023-12-17 22:23:42
channel t1: finished piece 1 at 2023-12-17 22:23:42
piece handle=/bak/hisdb0_0k2e9r3e_1_1 tag=HISDB0 comment=NONE
channel t1: backup set complete, elapsed time: 00:00:00
channel t2: finished piece 1 at 2023-12-17 22:23:43
piece handle=/bak/hisdb0_0l2e9r3e_1_1 tag=HISDB0 comment=NONE
channel t2: backup set complete, elapsed time: 00:00:01
channel t3: finished piece 1 at 2023-12-17 22:23:43
piece handle=/bak/hisdb0_0m2e9r3e_1_1 tag=HISDB0 comment=NONE
channel t3: backup set complete, elapsed time: 00:00:01
channel t4: finished piece 1 at 2023-12-17 22:23:43
piece handle=/bak/hisdb0_0n2e9r3e_1_1 tag=HISDB0 comment=NONE
channel t4: backup set complete, elapsed time: 00:00:01
Finished backup at 2023-12-17 22:23:43
released channel: t1
released channel: t2
released channel: t3
released channel: t4
RMAN> exit
Recovery Manager complete.
[oracle@11g bak]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 17 22:23:59 2023
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table t0 as select * from t2;
Table created.
SQL> drop table t0 purge;
Table dropped.
SQL> create table j1.t0 as select * from j1.t2;
Table created.
SQL> drop table t2;
drop table t2
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> show users;
SP2-0158: unknown SHOW option "users"
SQL> show user;
USER is "SYS"
SQL> create table j2.t0 as select * from j2.t2;
Table created.
SQL> select count(*) from j2.t0;
COUNT(*)
----------
1
SQL> select count(*) from j1.t0;
COUNT(*)
----------
1
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g bak]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 17 22:25:39 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: JYCDB (DBID=592598178)
RMAN> backup as backupset incremental level=0 database format '/bak/hisdb0_%U' tag=hisdb_full0;
Starting backup at 2023-12-17 22:25:51
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/home/db/oracle/oradata/jycdb/system01.dbf
input datafile file number=00002 name=/home/db/oracle/oradata/jycdb/sysaux01.dbf
input datafile file number=00003 name=/home/db/oracle/oradata/jycdb/undotbs01.dbf
input datafile file number=00004 name=/home/db/oracle/oradata/jycdb/users01.dbf
input datafile file number=00005 name=/home/db/oracle/oradata/jycdb/users02.dbf
input datafile file number=00006 name=/home/db/oracle/oradata/jycdb/users03.dbf
input datafile file number=00007 name=/home/db/oracle/oradata/jycdb/data01.dbf
input datafile file number=00008 name=/home/db/oracle/oradata/jycdb/data02.dbf
input datafile file number=00009 name=/home/db/oracle/oradata/jycdb/data03.dbf
input datafile file number=00010 name=/home/db/oracle/oradata/jycdb/data04.dbf
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:25:52
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:25:59
piece handle=/bak/hisdb0_0o2e9r7g_1_1 tag=HISDB_FULL0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:26:00
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:26:01
piece handle=/bak/hisdb0_0p2e9r7n_1_1 tag=HISDB_FULL0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2023-12-17 22:26:01
RMAN> exit
Recovery Manager complete.
[oracle@11g bak]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 17 22:26:10 2023
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table j2.t01 as select * from j2.t2;
Table created.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g bak]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 17 22:26:36 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: JYCDB (DBID=592598178)
RMAN> backup as backupset incremental level=1 database format '/bak/hisdb0_%U' tag=hisdb_full0;
Starting backup at 2023-12-17 22:26:49
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/home/db/oracle/oradata/jycdb/system01.dbf
input datafile file number=00002 name=/home/db/oracle/oradata/jycdb/sysaux01.dbf
input datafile file number=00003 name=/home/db/oracle/oradata/jycdb/undotbs01.dbf
input datafile file number=00004 name=/home/db/oracle/oradata/jycdb/users01.dbf
input datafile file number=00005 name=/home/db/oracle/oradata/jycdb/users02.dbf
input datafile file number=00006 name=/home/db/oracle/oradata/jycdb/users03.dbf
input datafile file number=00007 name=/home/db/oracle/oradata/jycdb/data01.dbf
input datafile file number=00008 name=/home/db/oracle/oradata/jycdb/data02.dbf
input datafile file number=00009 name=/home/db/oracle/oradata/jycdb/data03.dbf
input datafile file number=00010 name=/home/db/oracle/oradata/jycdb/data04.dbf
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:26:50
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:26:51
piece handle=/bak/hisdb0_0q2e9r9a_1_1 tag=HISDB_FULL0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:26:52
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:26:53
piece handle=/bak/hisdb0_0r2e9r9b_1_1 tag=HISDB_FULL0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2023-12-17 22:26:53
RMAN> exit
Recovery Manager complete.
[oracle@11g bak]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 17 22:27:07 2023
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table j1.t01 as select * from j2.t2;.t01 as select * from j2.t2;.t01 as select * from j2SQL> create table j1.t01 as select * from j2.t2; j create table j1.t01 as select * from j2.t2;
*
ERROR at line 1:
ORA-00911: invalid character
SQL> create table j1.t01 as select * from j2.t2;
Table created.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g bak]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 17 22:27:33 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: JYCDB (DBID=592598178)
RMAN> backup incremental level=1 tablespace DATA,USERS filesperset 300 format '/bak/hisdb1_07' tag=hisdb1;
Starting backup at 2023-12-17 22:28:22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/home/db/oracle/oradata/jycdb/users01.dbf
input datafile file number=00005 name=/home/db/oracle/oradata/jycdb/users02.dbf
input datafile file number=00006 name=/home/db/oracle/oradata/jycdb/users03.dbf
input datafile file number=00007 name=/home/db/oracle/oradata/jycdb/data01.dbf
input datafile file number=00008 name=/home/db/oracle/oradata/jycdb/data02.dbf
input datafile file number=00009 name=/home/db/oracle/oradata/jycdb/data03.dbf
input datafile file number=00010 name=/home/db/oracle/oradata/jycdb/data04.dbf
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:28:22
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:28:23
piece handle=/bak/hisdb1_07 tag=HISDB1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2023-12-17 22:28:23
RMAN> exit
Recovery Manager complete.
[oracle@11g bak]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 17 22:28:31 2023
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table j1.t02 as select * from j2.t2;
Table created.
SQL> @o.sql
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
J1 DATABASE LINK 1
J1 INDEX 1
J1 SYNONYM 1
J1 TABLE 11
J2 DATABASE LINK 1
J2 SEQUENCE 2
J2 SYNONYM 1
J2 TABLE 8
J2 VIEW 1
PUBLIC DATABASE LINK 2
PUBLIC SYNONYM 27699
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
SCOTT INDEX 2
SCOTT TABLE 4
13 rows selected.
SQL> alter tablespace user read only;
alter tablespace user read only
*
ERROR at line 1:
ORA-02140: invalid tablespace name
SQL> alter tablespace users read only;
Tablespace altered.
SQL> alter tablespace data read only;
Tablespace altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g bak]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 17 22:31:54 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: JYCDB (DBID=592598178)
RMAN> backup incremental level=1 tablespace DATA,USERS filesperset 300 format '/bak/hisdb1_08' tag=hisdb1;
Starting backup at 2023-12-17 22:32:17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/home/db/oracle/oradata/jycdb/users01.dbf
input datafile file number=00005 name=/home/db/oracle/oradata/jycdb/users02.dbf
input datafile file number=00006 name=/home/db/oracle/oradata/jycdb/users03.dbf
input datafile file number=00007 name=/home/db/oracle/oradata/jycdb/data01.dbf
input datafile file number=00008 name=/home/db/oracle/oradata/jycdb/data02.dbf
input datafile file number=00009 name=/home/db/oracle/oradata/jycdb/data03.dbf
input datafile file number=00010 name=/home/db/oracle/oradata/jycdb/data04.dbf
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:32:17
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:32:18
piece handle=/bak/hisdb1_08 tag=HISDB1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2023-12-17 22:32:18
RMAN> exit
Recovery Manager complete.
[oracle@11g bak]$ ls -lt|head
total 3060476
-rw-r----- 1 oracle oinstall 139264 Dec 17 22:32 hisdb1_08
-rw-r----- 1 oracle oinstall 139264 Dec 17 22:28 hisdb1_07
-rw-r----- 1 oracle oinstall 9830400 Dec 17 22:26 hisdb0_0r2e9r9b_1_1
-rw-r----- 1 oracle oinstall 368640 Dec 17 22:26 hisdb0_0q2e9r9a_1_1
-rw-r----- 1 oracle oinstall 9830400 Dec 17 22:26 hisdb0_0p2e9r7n_1_1
-rw-r----- 1 oracle oinstall 1023377408 Dec 17 22:25 hisdb0_0o2e9r7g_1_1
-rw-r----- 1 oracle oinstall 1089536 Dec 17 22:23 hisdb0_0n2e9r3e_1_1
-rw-r----- 1 oracle oinstall 1335296 Dec 17 22:23 hisdb0_0l2e9r3e_1_1
-rw-r----- 1 oracle oinstall 163840 Dec 17 22:23 hisdb0_0m2e9r3e_1_1
[oracle@11g bak]$ ls -lt|head -30
total 3060476
-rw-r----- 1 oracle oinstall 139264 Dec 17 22:32 hisdb1_08
-rw-r----- 1 oracle oinstall 139264 Dec 17 22:28 hisdb1_07
-rw-r----- 1 oracle oinstall 9830400 Dec 17 22:26 hisdb0_0r2e9r9b_1_1
-rw-r----- 1 oracle oinstall 368640 Dec 17 22:26 hisdb0_0q2e9r9a_1_1
-rw-r----- 1 oracle oinstall 9830400 Dec 17 22:26 hisdb0_0p2e9r7n_1_1
-rw-r----- 1 oracle oinstall 1023377408 Dec 17 22:25 hisdb0_0o2e9r7g_1_1
-rw-r----- 1 oracle oinstall 1089536 Dec 17 22:23 hisdb0_0n2e9r3e_1_1
-rw-r----- 1 oracle oinstall 1335296 Dec 17 22:23 hisdb0_0l2e9r3e_1_1
-rw-r----- 1 oracle oinstall 163840 Dec 17 22:23 hisdb0_0m2e9r3e_1_1
-rw-r----- 1 oracle oinstall 1875968 Dec 17 22:23 hisdb0_0k2e9r3e_1_1
-rw-r--r-- 1 oracle oinstall 456 Dec 17 22:11 o.sql
-rw-r--r-- 1 oracle oinstall 991 Dec 17 22:07 tts-imp1.log
-rw-r--r--. 1 oracle oinstall 831 Dec 17 22:06 tts-imp.log
-rw-r----- 1 oracle oinstall 270336 Dec 17 22:05 tts1.dmp
-rw-r--r--. 1 oracle oinstall 1691 Dec 17 22:05 tts-exp.log
-rw-r--r-- 1 oracle oinstall 2046 Dec 17 22:03 recover.sql
-rw-r----- 1 oracle oinstall 204800 Dec 17 22:02 hisdb1_05
-rw-r----- 1 oracle oinstall 139264 Dec 17 21:54 hisdb1_06
-rw-r----- 1 oracle oinstall 409600 Dec 17 21:52 hisdb1_05_full
-rw-r----- 1 oracle oinstall 9830400 Dec 17 21:50 hisdb0_0e2e9p5n_1_1
-rw-r----- 1 oracle oinstall 1029693440 Dec 17 21:50 hisdb0_0d2e9p5g_1_1
-rw-r----- 1 oracle oinstall 139264 Dec 17 21:21 hisdb1_04
-rw-r----- 1 oracle oinstall 9830400 Dec 17 21:18 hisdb0_0b2e9n94_1_1
-rw-r----- 1 oracle oinstall 5292032 Dec 17 21:18 hisdb0_0a2e9n93_1_1
-rw-r----- 1 oracle oinstall 9830400 Dec 17 21:15 hisdb0_092e9n44_1_1
-rw-r----- 1 oracle oinstall 1014603776 Dec 17 21:15 hisdb0_082e9n3l_1_1
-rw-r-----. 1 oracle oinstall 233472 Dec 15 15:21 tts.dmp
-rw-r-----. 1 oracle oinstall 221184 Dec 15 15:18 hisdb1_03
-rw-r--r--. 1 oracle oinstall 1429 Dec 15 14:25 meta.log
[oracle@11g bak]$ echo $ORACLE_SID
jycdb
[oracle@11g bak]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 17 22:37:46 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: JYCDB (DBID=592598178)
RMAN> backup incremental from scn 1047630 tablespace DATA,USERS filesperset 300 format '/bak/hisdb1_scn' tag=hisdb1;
Starting backup at 2023-12-17 22:38:34
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
backup will be obsolete on date 2023-12-24 22:38:34
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/home/db/oracle/oradata/jycdb/users01.dbf
input datafile file number=00005 name=/home/db/oracle/oradata/jycdb/users02.dbf
input datafile file number=00006 name=/home/db/oracle/oradata/jycdb/users03.dbf
input datafile file number=00007 name=/home/db/oracle/oradata/jycdb/data01.dbf
input datafile file number=00008 name=/home/db/oracle/oradata/jycdb/data02.dbf
input datafile file number=00009 name=/home/db/oracle/oradata/jycdb/data03.dbf
input datafile file number=00010 name=/home/db/oracle/oradata/jycdb/data04.dbf
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:38:34
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:38:35
piece handle=/bak/hisdb1_scn tag=HISDB1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
using channel ORA_DISK_1
backup will be obsolete on date 2023-12-24 22:38:35
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:38:36
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/17/2023 22:38:37
ORA-19504: failed to create file "/bak/hisdb1_scn"
ORA-27038: created file already exists
Additional information: 1
RMAN> exit
Recovery Manager complete.
[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts1.dmp logfile=tts-imp1.log director[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts.dmp logfile=tts-imp.log directory=[oracle@11g bak]$ export ORACLE_SID=hisdb
[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts1.dmp logfile=tts-exp.log clus[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts.dmp logfile=tts-exp.log clust[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp.log clus[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp2.log clu[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp2.log cluster=n transport_tablespaces=DATA,USERS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS
Export: Release 11.2.0.1.0 - Production on Sun Dec 17 22:39:37 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TRANSPORTABLE_01": "/******** AS SYSDBA" directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp2.log cluster=n transport_tablespaces=DATA,USERS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table "SYS"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TRANSPORTABLE_01 is:
/bak/tts2.dmp
******************************************************************************
Datafiles required for transportable tablespace DATA:
/home/db/oracle/oradata/jycdb/data01.dbf
/home/db/oracle/oradata/jycdb/data02.dbf
/home/db/oracle/oradata/jycdb/data03.dbf
/home/db/oracle/oradata/jycdb/data04.dbf
Datafiles required for transportable tablespace USERS:
/home/db/oracle/oradata/jycdb/users01.dbf
/home/db/oracle/oradata/jycdb/users02.dbf
/home/db/oracle/oradata/jycdb/users03.dbf
Job "SYS"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at 22:39:47
[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp2.log clu[oracle@11g bak]$ rman target /
[oracle@11g bak]$ export ORACLE_SID=hisdb
[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp2.log clu[oracle@11g bak]$ rman target /
[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp2.log clu[oracle@11g bak]$ rman target /
[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts1.dmp logfile=tts-imp1.log director[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts1.dmp logfile=tts-imp.log directory[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts1.dmp logfile=tts-imp2.log director[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts.dmp logfile=tts-imp2.log directory[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts2.dmp logfile=tts-imp2.log director[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts2.dmp logfile=tts-imp2.log directory=acfsdmp PARFILE=impdp-par.txt
Import: Release 11.2.0.1.0 - Production on Sun Dec 17 22:41:01 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01": "sys/******** AS SYSDBA" dumpfile=tts2.dmp logfile=tts-imp2.log directory=acfsdmp PARFILE=impdp-par.txt
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 22:41:03
[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts2.dmp logfile=tts-imp2.log director[oracle@11g bak]$ export ORACLE_SID=hisdb
[oracle@11g bak]$ export ORACLE_SID=jycdb
[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts2.dmp logfile=tts-imp2.log director[oracle@11g bak]$ export ORACLE_SID=hisdb
[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp2.log clu[oracle@11g bak]$ rman target /
[oracle@11g bak]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 17 22:41:30 2023
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @o.sql
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
J1 DATABASE LINK 1
J1 INDEX 1
J1 SYNONYM 1
J1 TABLE 11
J2 DATABASE LINK 1
J2 SEQUENCE 2
J2 SYNONYM 1
J2 TABLE 8
J2 VIEW 1
PUBLIC DATABASE LINK 2
PUBLIC SYNONYM 27699
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
SCOTT INDEX 2
SCOTT TABLE 4
13 rows selected.
SQL>
SQL>
SQL>
SQL> alter tablespace users read only;
alter tablespace users read only
*
ERROR at line 1:
ORA-01644: tablespace 'USERS' is already read-only
SQL> alter tablespace users read write;
Tablespace altered.
SQL> alter tablespace data read write;
Tablespace altered.
SQL> create table j1.t03 as select * from j1.t2;
Table created.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g bak]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 17 22:45:17 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: JYCDB (DBID=592598178)
RMAN> backup as backupset incremental level=1 database format '/bak/hisdb0_%U' tag=hisdb_full0;
Starting backup at 2023-12-17 22:45:48
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/home/db/oracle/oradata/jycdb/system01.dbf
input datafile file number=00002 name=/home/db/oracle/oradata/jycdb/sysaux01.dbf
input datafile file number=00003 name=/home/db/oracle/oradata/jycdb/undotbs01.dbf
input datafile file number=00004 name=/home/db/oracle/oradata/jycdb/users01.dbf
input datafile file number=00005 name=/home/db/oracle/oradata/jycdb/users02.dbf
input datafile file number=00006 name=/home/db/oracle/oradata/jycdb/users03.dbf
input datafile file number=00007 name=/home/db/oracle/oradata/jycdb/data01.dbf
input datafile file number=00008 name=/home/db/oracle/oradata/jycdb/data02.dbf
input datafile file number=00009 name=/home/db/oracle/oradata/jycdb/data03.dbf
input datafile file number=00010 name=/home/db/oracle/oradata/jycdb/data04.dbf
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:45:48
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:45:49
piece handle=/bak/hisdb0_102e9scs_1_1 tag=HISDB_FULL0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:45:51
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:45:52
piece handle=/bak/hisdb0_112e9scu_1_1 tag=HISDB_FULL0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2023-12-17 22:45:52
RMAN> exit
Recovery Manager complete.
[oracle@11g bak]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 17 22:45:59 2023
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table jcreate table j2.t03 as select * from j1.t2;
create table jcreate table j2.t03 as select * from j1.t2
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> create table j2.t03 as select * from j1.t2;
Table created.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g bak]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 17 22:46:19 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: JYCDB (DBID=592598178)
RMAN> backup incremental level=1 tablespace DATA,USERS filesperset 300 format '/bak/hisdb1_09' tag=hisdb1;
Starting backup at 2023-12-17 22:46:32
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/home/db/oracle/oradata/jycdb/users01.dbf
input datafile file number=00005 name=/home/db/oracle/oradata/jycdb/users02.dbf
input datafile file number=00006 name=/home/db/oracle/oradata/jycdb/users03.dbf
input datafile file number=00007 name=/home/db/oracle/oradata/jycdb/data01.dbf
input datafile file number=00008 name=/home/db/oracle/oradata/jycdb/data02.dbf
input datafile file number=00009 name=/home/db/oracle/oradata/jycdb/data03.dbf
input datafile file number=00010 name=/home/db/oracle/oradata/jycdb/data04.dbf
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:46:32
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:46:33
piece handle=/bak/hisdb1_09 tag=HISDB1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2023-12-17 22:46:33
RMAN> exit
Recovery Manager complete.
[oracle@11g bak]$ ls -lt|head
total 3073660
-rw-r----- 1 oracle oinstall 139264 Dec 17 22:46 hisdb1_09
-rw-r----- 1 oracle oinstall 9830400 Dec 17 22:45 hisdb0_112e9scu_1_1
-rw-r----- 1 oracle oinstall 2883584 Dec 17 22:45 hisdb0_102e9scs_1_1
-rw-r--r-- 1 oracle oinstall 991 Dec 17 22:41 tts-imp2.log
-rw-r----- 1 oracle oinstall 335872 Dec 17 22:39 tts2.dmp
-rw-r--r-- 1 oracle oinstall 1692 Dec 17 22:39 tts-exp2.log
-rw-r--r-- 1 oracle oinstall 2047 Dec 17 22:39 recover.sql
-rw-r----- 1 oracle oinstall 303104 Dec 17 22:38 hisdb1_scn
-rw-r--r-- 1 oracle oinstall 3870 Dec 17 22:34 r.sql
[oracle@11g bak]$ ls -lt|more
total 3073660
-rw-r----- 1 oracle oinstall 139264 Dec 17 22:46 hisdb1_09
-rw-r----- 1 oracle oinstall 9830400 Dec 17 22:45 hisdb0_112e9scu_1_1
-rw-r----- 1 oracle oinstall 2883584 Dec 17 22:45 hisdb0_102e9scs_1_1
-rw-r--r-- 1 oracle oinstall 991 Dec 17 22:41 tts-imp2.log
-rw-r----- 1 oracle oinstall 335872 Dec 17 22:39 tts2.dmp
-rw-r--r-- 1 oracle oinstall 1692 Dec 17 22:39 tts-exp2.log
-rw-r--r-- 1 oracle oinstall 2047 Dec 17 22:39 recover.sql
-rw-r----- 1 oracle oinstall 303104 Dec 17 22:38 hisdb1_scn
-rw-r--r-- 1 oracle oinstall 3870 Dec 17 22:34 r.sql
-rw-r----- 1 oracle oinstall 139264 Dec 17 22:32 hisdb1_08
-rw-r----- 1 oracle oinstall 139264 Dec 17 22:28 hisdb1_07
-rw-r----- 1 oracle oinstall 9830400 Dec 17 22:26 hisdb0_0r2e9r9b_1_1
-rw-r----- 1 oracle oinstall 368640 Dec 17 22:26 hisdb0_0q2e9r9a_1_1
-rw-r----- 1 oracle oinstall 9830400 Dec 17 22:26 hisdb0_0p2e9r7n_1_1
-rw-r----- 1 oracle oinstall 1023377408 Dec 17 22:25 hisdb0_0o2e9r7g_1_1
-rw-r----- 1 oracle oinstall 1089536 Dec 17 22:23 hisdb0_0n2e9r3e_1_1
-rw-r----- 1 oracle oinstall 1335296 Dec 17 22:23 hisdb0_0l2e9r3e_1_1
-rw-r----- 1 oracle oinstall 163840 Dec 17 22:23 hisdb0_0m2e9r3e_1_1
-rw-r----- 1 oracle oinstall 1875968 Dec 17 22:23 hisdb0_0k2e9r3e_1_1
-rw-r--r-- 1 oracle oinstall 456 Dec 17 22:11 o.sql
-rw-r--r-- 1 oracle oinstall 991 Dec 17 22:07 tts-imp1.log
-rw-r--r--. 1 oracle oinstall 831 Dec 17 22:06 tts-imp.log
-rw-r----- 1 oracle oinstall 270336 Dec 17 22:05 tts1.dmp
-rw-r--r--. 1 oracle oinstall 1691 Dec 17 22:05 tts-exp.log
-rw-r----- 1 oracle oinstall 204800 Dec 17 22:02 hisdb1_05
-rw-r----- 1 oracle oinstall 139264 Dec 17 21:54 hisdb1_06
-rw-r----- 1 oracle oinstall 409600 Dec 17 21:52 hisdb1_05_full
-rw-r----- 1 oracle oinstall 9830400 Dec 17 21:50 hisdb0_0e2e9p5n_1_1
-rw-r----- 1 oracle oinstall 1029693440 Dec 17 21:50 hisdb0_0d2e9p5g_1_1
-rw-r----- 1 oracle oinstall 139264 Dec 17 21:21 hisdb1_04
-rw-r----- 1 oracle oinstall 9830400 Dec 17 21:18 hisdb0_0b2e9n94_1_1
-rw-r----- 1 oracle oinstall 5292032 Dec 17 21:18 hisdb0_0a2e9n93_1_1
-rw-r----- 1 oracle oinstall 9830400 Dec 17 21:15 hisdb0_092e9n44_1_1
-rw-r----- 1 oracle oinstall 1014603776 Dec 17 21:15 hisdb0_082e9n3l_1_1
-rw-r-----. 1 oracle oinstall 233472 Dec 15 15:21 tts.dmp
-rw-r-----. 1 oracle oinstall 221184 Dec 15 15:18 hisdb1_03
-rw-r--r--. 1 oracle oinstall 1429 Dec 15 14:25 meta.log
-rw-r-----. 1 oracle oinstall 172032 Dec 15 14:23 meta.dmp
-rw-r--r--. 1 oracle oinstall 324 Dec 15 13:43 impdp-par.txt
-rw-r-----. 1 oracle oinstall 212992 Dec 15 13:37 tts.bakdmp
-rw-r-----. 1 oracle oinstall 139264 Dec 15 13:28 hisdb1_02
-rw-r-----. 1 oracle oinstall 6350 Dec 15 13:20 imp-full_meta.log
-rw-r-----. 1 oracle oinstall 360448 Dec 15 13:13 full_meta.dmp
-rw-r--r--. 1 oracle oinstall 2540 Dec 15 13:13 full_meta.log
-rw-r-----. 1 oracle oinstall 139264 Dec 15 13:02 hisdb1_01
-rw-r--r--. 1 oracle oinstall 16 Dec 15 12:54 h.ora
-rw-r-----. 1 oracle oinstall 1089536 Dec 15 12:42 hisdb0_042e3g99_1_1
-rw-r-----. 1 oracle oinstall 1187840 Dec 15 12:42 hisdb0_022e3g99_1_1
-rw-r-----. 1 oracle oinstall 163840 Dec 15 12:42 hisdb0_032e3g99_1_1
-rw-r-----. 1 oracle oinstall 1564672 Dec 15 12:42 hisdb0_012e3g99_1_1
[oracle@11g bak]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 17 22:49:19 2023
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string jycdb
db_unique_name string jycdb
global_names boolean FALSE
instance_name string jycdb
lock_name_space string
log_file_name_convert string
service_names string jycdb
SQL> create table j2.ttt as select * from j2.t2;
Table created.
SQL> alter tablespace users read only;
Tablespace altered.
SQL> alter tablespace data read only;
Tablespace altered.
SQL> @o.sql
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
J1 DATABASE LINK 1
J1 INDEX 1
J1 SYNONYM 1
J1 TABLE 12
J2 DATABASE LINK 1
J2 SEQUENCE 2
J2 SYNONYM 1
J2 TABLE 10
J2 VIEW 1
PUBLIC DATABASE LINK 2
PUBLIC SYNONYM 27699
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
SCOTT INDEX 2
SCOTT TABLE 4
13 rows selected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@11g bak]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Dec 17 22:50:11 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: JYCDB (DBID=592598178)
RMAN> backup incremental level=1 tablespace DATA,USERS filesperset 300 format '/bak/hisdb1_10' tag=hisdb1;
Starting backup at 2023-12-17 22:50:23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/home/db/oracle/oradata/jycdb/users01.dbf
input datafile file number=00005 name=/home/db/oracle/oradata/jycdb/users02.dbf
input datafile file number=00006 name=/home/db/oracle/oradata/jycdb/users03.dbf
input datafile file number=00007 name=/home/db/oracle/oradata/jycdb/data01.dbf
input datafile file number=00008 name=/home/db/oracle/oradata/jycdb/data02.dbf
input datafile file number=00009 name=/home/db/oracle/oradata/jycdb/data03.dbf
input datafile file number=00010 name=/home/db/oracle/oradata/jycdb/data04.dbf
channel ORA_DISK_1: starting piece 1 at 2023-12-17 22:50:23
channel ORA_DISK_1: finished piece 1 at 2023-12-17 22:50:24
piece handle=/bak/hisdb1_10 tag=HISDB1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2023-12-17 22:50:24
RMAN> exit
Recovery Manager complete.
[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts2.dmp logfile=tts-imp2.log director[oracle@11g bak]$ export ORACLE_SID=hisdb
[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp2.log clu[oracle@11g bak]$ rman target /
[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts2.dmp logfile=tts-exp2.log clu[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts.dmp logfile=tts-exp2.log clus[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts3.dmp logfile=tts-exp2.log clu[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts3.dmp logfile=tts-exp.log clus[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts3.dmp logfile=tts-exp3.log clu[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts3.dmp logfile=tts-exp3.log cluster=n transport_tablespaces=DATA,USERS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS
Export: Release 11.2.0.1.0 - Production on Sun Dec 17 22:51:07 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TRANSPORTABLE_01": "/******** AS SYSDBA" directory=acfsdmp dumpfile=tts3.dmp logfile=tts-exp3.log cluster=n transport_tablespaces=DATA,USERS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table "SYS"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TRANSPORTABLE_01 is:
/bak/tts3.dmp
******************************************************************************
Datafiles required for transportable tablespace DATA:
/home/db/oracle/oradata/jycdb/data01.dbf
/home/db/oracle/oradata/jycdb/data02.dbf
/home/db/oracle/oradata/jycdb/data03.dbf
/home/db/oracle/oradata/jycdb/data04.dbf
Datafiles required for transportable tablespace USERS:
/home/db/oracle/oradata/jycdb/users01.dbf
/home/db/oracle/oradata/jycdb/users02.dbf
/home/db/oracle/oradata/jycdb/users03.dbf
Job "SYS"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at 22:51:17
[oracle@11g bak]$ export ORACLE_SID=hisdb
[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts3.dmp logfile=tts-exp3.log clu[oracle@11g bak]$ rman target /
[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts2.dmp logfile=tts-imp2.log director[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts2.dmp logfile=tts-imp.log directory[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts2.dmp logfile=tts-imp3.log director[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts.dmp logfile=tts-imp3.log directory[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts3.dmp logfile=tts-imp3.log director[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts3.dmp logfile=tts-imp3.log directory=acfsdmp PARFILE=impdp-par.txt
Import: Release 11.2.0.1.0 - Production on Sun Dec 17 22:51:41 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01": "sys/******** AS SYSDBA" dumpfile=tts3.dmp logfile=tts-imp3.log directory=acfsdmp PARFILE=impdp-par.txt
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 22:51:43
[oracle@11g bak]$ impdp \'sys/"abcd1234" as sysdba\' dumpfile=tts3.dmp logfile=tts-imp3.log director[oracle@11g bak]$ export ORACLE_SID=hisdb
[oracle@11g bak]$ expdp \'/ as sysdba\' directory=acfsdmp dumpfile=tts3.dmp logfile=tts-exp3.log clu[oracle@11g bak]$ rman target /
[oracle@11g bak]$ export ORACLE_SID=jycdb
[oracle@11g bak]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 17 22:52:13 2023
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @o.sql
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
J1 DATABASE LINK 1
J1 INDEX 1
J1 SYNONYM 1
J1 TABLE 12
J2 DATABASE LINK 1
J2 SEQUENCE 2
J2 SYNONYM 1
J2 TABLE 10
J2 VIEW 1
PUBLIC DATABASE LINK 2
PUBLIC SYNONYM 27699
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
SCOTT INDEX 2
SCOTT TABLE 4
13 rows selected.
SQL> @/home/oracle/tbs.sql
TABLESPACE_NAME SUM_SPACE(M) SUM_BLOCKS USED_SPACE(M) USED_RATE(%) FREE_SPACE(M)
------------------------------ ------------ ---------- ------------- ------------ -------------
SYSTEM 680 87040 675.44 99.33 4.56
SYSAUX 500 64000 471.62 94.32 28.38
USERS 6 768 4.12 68.67 1.88
UNDOTBS1 75 9600 25.75 34.33 49.25
DATA 4 512 .75 18.75 3.25
TEMP 29 3712 0
6 rows selected.
文章来源:https://blog.csdn.net/jycjyc/article/details/135052135
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。 如若内容造成侵权/违法违规/事实不符，请联系我的编程经验分享网邮箱：veading@qq.com进行投诉反馈，一经查实，立即删除！
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。 如若内容造成侵权/违法违规/事实不符，请联系我的编程经验分享网邮箱：veading@qq.com进行投诉反馈，一经查实，立即删除！