Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Windows\System32>set ORACLE_SID=NEW1
C:\Windows\System32>set PATH=%ORACLE_HOME%\BIN;%PATH%
C:\Windows\System32>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 16 23:58:05 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 96469672 bytes
Database Buffers 188743680 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
C:\Windows\System32>rman target sys/sys@new1 catalog rman/rman@rman01
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jun 16 23:59:20 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: NEW1 (DBID=1583816731)
connected to recovery catalog database
RMAN>
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE = 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
starting full resync of recovery catalog
full resync complete
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE = 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default
RMAN>
SQL> alter database enable block change tracking using file 'F:\oracle\admin\NEW1\pfile\bct.i';
Database altered.
RMAN> backup as compressed backupset incremental level 0 database;
Starting backup at 17-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=F:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_3: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_216.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_2: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_217.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:41
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_215.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:41
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_218.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-11
RMAN> backup as compressed backupset incremental level 1 cumulative database;
Starting backup at 17-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=F:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_3: starting piece 1 at 17-JUN-11
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_219.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_220.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_3: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_221.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_222.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-11
RMAN> backup as compressed backupset incremental level 1 database;
Starting backup at 17-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=F:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_3: starting piece 1 at 17-JUN-11
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_223.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_224.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_3: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_225.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_226.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-11
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Windows\System32>set ORACLE_SID=NEW1
C:\Windows\System32>set PATH=%ORACLE_HOME%\BIN;%PATH%
C:\Windows\System32>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 16 23:58:05 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 96469672 bytes
Database Buffers 188743680 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
C:\Windows\System32>rman target sys/sys@new1 catalog rman/rman@rman01
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jun 16 23:59:20 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: NEW1 (DBID=1583816731)
connected to recovery catalog database
RMAN>
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE = 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
starting full resync of recovery catalog
full resync complete
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE = 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "F:\oracle\tmp\control%F";
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 500 M FORMAT "F:\oracle\tmp\%d_%s.dbf";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFNEW1.ORA'; # default
RMAN>
SQL> alter database enable block change tracking using file 'F:\oracle\admin\NEW1\pfile\bct.i';
Database altered.
RMAN> backup as compressed backupset incremental level 0 database;
Starting backup at 17-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=F:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_3: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_216.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_2: starting compressed incremental level 0 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_217.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:41
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_215.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:41
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_218.DBF tag=TAG20110617T002416 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-11
RMAN> backup as compressed backupset incremental level 1 cumulative database;
Starting backup at 17-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=F:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_3: starting piece 1 at 17-JUN-11
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_219.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_220.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_3: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_221.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_222.DBF tag=TAG20110617T002507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-11
RMAN> backup as compressed backupset incremental level 1 database;
Starting backup at 17-JUN-11
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\NEW1\SYSTEM.DBF
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=F:\ORACLE\ORADATA\NEW1\SYSAUX.DBF
channel ORA_DISK_2: starting piece 1 at 17-JUN-11
channel ORA_DISK_3: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\NEW1\UNDO.DBF
channel ORA_DISK_3: starting piece 1 at 17-JUN-11
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_223.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 17-JUN-11
channel ORA_DISK_2: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_224.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_3: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_225.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 17-JUN-11
piece handle=F:\ORACLE\TMP\NEW1_226.DBF tag=TAG20110617T002518 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-11
No comments:
Post a Comment