ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
Cause: You tried to copy or backup a file that was not closed cleanly, and the database was in NOARCHIVELOG mode. This is not allowed because when restored, the file will require redo application before it is usable, and redo is not currently being saved beyond the contents of the online redo logs.
Action: Take the tablespace offline clean or close the database and retry the copy or backup. ( so Please Run Pre Backup Oracle Using SQL Command Before Backup)
You can download The Study Case & solution Lab Oracle & SQL Expert
Dowmload Video Backup & Restore Oracle Using RMAN
1. Download Video How to backup and Restore 11g Oracle database # 1 of 4
2. Download Video How to backup and Restore 11g Oracle database # 2 of 4
3. Download Video How to backup and Restore 11g Oracle database # 3 of 4
4. Download Video How to backup and Restore 11g Oracle database # 4 of 4
5. Download Video How to backup and Restore an Oracle database with RMAN (basic)
6. Download Video How to backup and Restore 11g Oracle database cold
7. Download Video How To Backup Oracle
A. Step by Step Backup And Restore Oracle Using RMAN Tool
- Run Pre Backup Oracle Using SQL Command
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list;
SQL> alter system archive log start;
- Backup Database
RMAN> backup database ;
or you can use
RMAN> backup database plus archivelog;
- Check Database Backup
RMAN> list backup;
RMAN> list backup summary;
RMAN> list backup by file;
- Restore Database
SQL> startup;
SQL> shutdown abort;
RMAN> startup nomount;
RMAN> restore controlfile from <name_file_backup>
- Check Database Restore
B. Backup Database Oracle Sample from Lab
1. Backup Database Oracle Without PreBackup
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>cd c:\
C:\>
C:\>cd C:\oracle\product\10.2.0\db_1
C:\oracle\product\10.2.0\db_1>cd BIN
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>dir
C:\oracle\product\10.2.0\db_1\BIN>dir rman.exe
Volume in drive C has no label.
Volume Serial Number is 94E9-D1D5
Directory of C:\oracle\product\10.2.0\db_1\BIN
08/29/2005 08:38 PM 1,552,384 rman.exe
1 File(s) 1,552,384 bytes
0 Dir(s) 3,079,995,392 bytes free
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>set ORACLE_SID=TGH
C:\oracle\product\10.2.0\db_1\BIN>echo %ORACLE_SID%
TGH
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 20 11:26:03 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: TGH (DBID=941403268)
RMAN>
RMAN> backup database;
Starting backup at 20-JUL-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/20/2011 11:26:
47
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 20-JUL-11
channel ORA_DISK_1: finished piece 1 at 20-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
20\O1_MF_NCSNF_TAG20110720T112647_72DP89MK_.BKP tag=TAG20110720T112647 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/20/2011 11:26:
47
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN>
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>cd c:\
C:\>
C:\>cd C:\oracle\product\10.2.0\db_1
C:\oracle\product\10.2.0\db_1>cd BIN
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>dir rman.exe
Volume in drive C has no label.
Volume Serial Number is 94E9-D1D5
Directory of C:\oracle\product\10.2.0\db_1\BIN
08/29/2005 08:38 PM 1,552,384 rman.exe
1 File(s) 1,552,384 bytes
0 Dir(s) 3,079,995,392 bytes free
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>set ORACLE_SID=TGH
C:\oracle\product\10.2.0\db_1\BIN>echo %ORACLE_SID%
TGH
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jul 20 11:26:03 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: TGH (DBID=941403268)
RMAN>
RMAN> backup database;
Starting backup at 20-JUL-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/20/2011 11:26:
47
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 20-JUL-11
channel ORA_DISK_1: finished piece 1 at 20-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
20\O1_MF_NCSNF_TAG20110720T112647_72DP89MK_.BKP tag=TAG20110720T112647 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/20/2011 11:26:
47
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN>
RMAN>
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 6.80M DISK 00:00:03 20-JUL-11
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20110720T102427
Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_20\O1_MF_NCSNF_TAG20110720T102427_72DLMFG5_.BKP
Control File Included: Ckp SCN: 633348 Ckp time: 20-JUL-11
SPFILE Included: Modification time: 20-JUL-11
RMAN>
RMAN> quit
Recovery Manager complete
2. Backup Database Oracle With PreBackup
2.1 Pre Backup Database Oracle
2.1 Pre Backup Database Oracle
C:\oracle\product\10.2.0\db_1\BIN>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 21 11:52:59 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 100663976 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archivelog list;
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
SQL> alter system archive log start;
System altered.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
2.2 Backup Database Oracle With PreBackup
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>cd c:\
C:\>cd C:\oracle\product\10.2.0\db_1\BIN
C:\oracle\product\10.2.0\db_1\BIN>rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 21 14:00:34 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: TGH (DBID=941491037)
RMAN> backup database plus archivelog;
Starting backup at 21-JUL-11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=148 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2 recid=1 stamp=757080494
input archive log thread=1 sequence=3 recid=2 stamp=757087335
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_ANNNN_TAG20110721T140232_72HMS02G_.BKP tag=TAG20110721T140232 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:27
Finished backup at 21-JUL-11
Starting backup at 21-JUL-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSTEM01.DBF
input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSAUX01.DBF
input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\EXAMPLE01.DBF
input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\UNDOTBS01.DBF
input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_NNNDF_TAG20110721T140414_72HMWSJ3_.BKP tag=TAG20110721T140414 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:12:08
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_NCSNF_TAG20110721T140414_72HNLK0H_.BKP tag=TAG20110721T140414 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:12
Finished backup at 21-JUL-11
Starting backup at 21-JUL-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=3 stamp=757088198
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_ANNNN_TAG20110721T141639_72HNLS3F_.BKP tag=TAG20110721T141639 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-JUL-11
RMAN>
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 55.59M DISK 00:01:21 21-JUL-11
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20110721T140232
Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_ANNNN_TAG20110721T140232_72HMS02G_.BKP
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 2 567803 21-JUL-11 585347 21-JUL-11
1 3 585347 21-JUL-11 592362 21-JUL-11
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 605.70M DISK 00:11:59 21-JUL-11
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20110721T140414
Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_NNNDF_TAG20110721T140414_72HMWSJ3_.BKP
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSTEM0
1.DBF
2 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\UNDOTBS
01.DBF
3 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSAUX0
1.DBF
4 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\USERS01
.DBF
5 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\EXAMPLE
01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 6.80M DISK 00:00:11 21-JUL-11
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20110721T140414
Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_NCSNF_TAG20110721T140414_72HNLK0H_.BKP
Control File Included: Ckp SCN: 593395 Ckp time: 21-JUL-11
SPFILE Included: Modification time: 21-JUL-11
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4 998.50K DISK 00:00:01 21-JUL-11
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20110721T141639
Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_ANNNN_TAG20110721T141639_72HNLS3F_.BKP
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 4 592362 21-JUL-11 593403 21-JUL-11
RMAN>
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1 B A A DISK 21-JUL-11 1 1 NO TAG201107
21T140232
2 B F A DISK 21-JUL-11 1 1 NO TAG201107
21T140414
3 B F A DISK 21-JUL-11 1 1 NO TAG201107
21T140414
4 B A A DISK 21-JUL-11 1 1 NO TAG201107
21T141639
RMAN> list backup by file;
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
2 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
3 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
4 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
5 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
List of Archived Log Backups
============================
Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1 2 567803 21-JUL-11 1 A 1 1 NO TAG201107
21T140232
1 3 585347 21-JUL-11 1 A 1 1 NO TAG201107
21T140232
1 4 592362 21-JUL-11 4 A 1 1 NO TAG201107
21T141639
List of Control File Backups
============================
CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
593395 21-JUL-11 3 A 1 1 NO TAG20110721T140414
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
21-JUL-11 3 A 1 1 NO TAG20110721T140414
RMAN>
RMAN> quit
Recovery Manager complete.
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>cd ..
C:\oracle\product\10.2.0\db_1>cd ..
C:\oracle\product\10.2.0>cd flash_recovery_area\TGH
C:\oracle\product\10.2.0\flash_recovery_area\TGH>dir
Volume in drive C has no label.
Volume Serial Number is 94E9-D1D5
Directory of C:\oracle\product\10.2.0\flash_recovery_area\TGH
07/21/2011 02:02 PM <DIR> .
07/21/2011 02:02 PM <DIR> ..
07/21/2011 12:08 PM <DIR> ARCHIVELOG
07/21/2011 02:02 PM <DIR> BACKUPSET
07/21/2011 11:10 AM <DIR> ONLINELOG
0 File(s) 0 bytes
5 Dir(s) 2,642,710,528 bytes free
C:\oracle\product\10.2.0\flash_recovery_area\TGH>cd BACKUPSET\2011_07_21
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>dir
Volume in drive C has no label.
Volume Serial Number is 94E9-D1D5
Directory of C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07
_21
07/21/2011 02:16 PM <DIR> .
07/21/2011 02:16 PM <DIR> ..
07/21/2011 02:04 PM 58,292,736 O1_MF_ANNNN_TAG20110721T140232_72HMS02G_.
BKP
07/21/2011 02:16 PM 1,022,976 O1_MF_ANNNN_TAG20110721T141639_72HNLS3F_.
BKP
07/21/2011 02:16 PM 7,143,424 O1_MF_NCSNF_TAG20110721T140414_72HNLK0H_.
BKP
07/21/2011 02:16 PM 635,133,952 O1_MF_NNNDF_TAG20110721T140414_72HMWSJ3_.
BKP
4 File(s) 701,593,088 bytes
2 Dir(s) 2,642,710,528 bytes free
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>cd ..
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET>cd ..
C:\oracle\product\10.2.0\flash_recovery_area\TGH>cd ..
C:\oracle\product\10.2.0\flash_recovery_area>cd ..
C:\oracle\product\10.2.0>cd oradata/
C:\oracle\product\10.2.0\oradata>cd TGH
C:\oracle\product\10.2.0\oradata\TGH>dir
Volume in drive C has no label.
Volume Serial Number is 94E9-D1D5
Directory of C:\oracle\product\10.2.0\oradata\TGH
07/21/2011 11:11 AM <DIR> .
07/21/2011 11:11 AM <DIR> ..
07/21/2011 02:20 PM 7,061,504 CONTROL01.CTL
07/21/2011 02:20 PM 7,061,504 CONTROL02.CTL
07/21/2011 02:20 PM 7,061,504 CONTROL03.CTL
07/21/2011 02:20 PM 104,865,792 EXAMPLE01.DBF
07/21/2011 11:54 AM 52,429,312 REDO01.LOG
07/21/2011 11:54 AM 52,429,312 REDO02.LOG
07/21/2011 11:54 AM 52,429,312 REDO03.LOG
07/21/2011 02:20 PM 251,666,432 SYSAUX01.DBF
07/21/2011 02:20 PM 503,324,672 SYSTEM01.DBF
07/21/2011 11:13 AM 20,979,712 TEMP01.DBF
07/21/2011 02:20 PM 36,708,352 UNDOTBS01.DBF
07/21/2011 02:20 PM 22,290,432 USERS01.DBF
12 File(s) 1,118,307,840 bytes
2 Dir(s) 2,642,722,816 bytes free
C:\oracle\product\10.2.0\oradata\TGH>
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>cd c:\
C:\>cd C:\oracle\product\10.2.0\db_1\BIN
C:\oracle\product\10.2.0\db_1\BIN>rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 21 14:00:34 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: TGH (DBID=941491037)
RMAN> backup database plus archivelog;
Starting backup at 21-JUL-11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=148 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2 recid=1 stamp=757080494
input archive log thread=1 sequence=3 recid=2 stamp=757087335
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_ANNNN_TAG20110721T140232_72HMS02G_.BKP tag=TAG20110721T140232 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:27
Finished backup at 21-JUL-11
Starting backup at 21-JUL-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSTEM01.DBF
input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSAUX01.DBF
input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\EXAMPLE01.DBF
input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\UNDOTBS01.DBF
input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_NNNDF_TAG20110721T140414_72HMWSJ3_.BKP tag=TAG20110721T140414 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:12:08
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_NCSNF_TAG20110721T140414_72HNLK0H_.BKP tag=TAG20110721T140414 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:12
Finished backup at 21-JUL-11
Starting backup at 21-JUL-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=3 stamp=757088198
channel ORA_DISK_1: starting piece 1 at 21-JUL-11
channel ORA_DISK_1: finished piece 1 at 21-JUL-11
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2011_07_
21\O1_MF_ANNNN_TAG20110721T141639_72HNLS3F_.BKP tag=TAG20110721T141639 comment=N
ONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-JUL-11
RMAN>
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 55.59M DISK 00:01:21 21-JUL-11
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20110721T140232
Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_ANNNN_TAG20110721T140232_72HMS02G_.BKP
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 2 567803 21-JUL-11 585347 21-JUL-11
1 3 585347 21-JUL-11 592362 21-JUL-11
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 605.70M DISK 00:11:59 21-JUL-11
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20110721T140414
Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_NNNDF_TAG20110721T140414_72HMWSJ3_.BKP
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSTEM0
1.DBF
2 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\UNDOTBS
01.DBF
3 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\SYSAUX0
1.DBF
4 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\USERS01
.DBF
5 Full 592750 21-JUL-11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TGH\EXAMPLE
01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 6.80M DISK 00:00:11 21-JUL-11
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20110721T140414
Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_NCSNF_TAG20110721T140414_72HNLK0H_.BKP
Control File Included: Ckp SCN: 593395 Ckp time: 21-JUL-11
SPFILE Included: Modification time: 21-JUL-11
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4 998.50K DISK 00:00:01 21-JUL-11
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20110721T141639
Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TGH\BACKUPSET\2
011_07_21\O1_MF_ANNNN_TAG20110721T141639_72HNLS3F_.BKP
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 4 592362 21-JUL-11 593403 21-JUL-11
RMAN>
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1 B A A DISK 21-JUL-11 1 1 NO TAG201107
21T140232
2 B F A DISK 21-JUL-11 1 1 NO TAG201107
21T140414
3 B F A DISK 21-JUL-11 1 1 NO TAG201107
21T140414
4 B A A DISK 21-JUL-11 1 1 NO TAG201107
21T141639
RMAN> list backup by file;
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
2 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
3 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
4 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
5 2 B F A 592750 21-JUL-11 1 1 NO TAG20110721
T140414
List of Archived Log Backups
============================
Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1 2 567803 21-JUL-11 1 A 1 1 NO TAG201107
21T140232
1 3 585347 21-JUL-11 1 A 1 1 NO TAG201107
21T140232
1 4 592362 21-JUL-11 4 A 1 1 NO TAG201107
21T141639
List of Control File Backups
============================
CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
593395 21-JUL-11 3 A 1 1 NO TAG20110721T140414
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
21-JUL-11 3 A 1 1 NO TAG20110721T140414
RMAN>
RMAN> quit
Recovery Manager complete.
C:\oracle\product\10.2.0\db_1\BIN>
C:\oracle\product\10.2.0\db_1\BIN>cd ..
C:\oracle\product\10.2.0\db_1>cd ..
C:\oracle\product\10.2.0>cd flash_recovery_area\TGH
C:\oracle\product\10.2.0\flash_recovery_area\TGH>dir
Volume in drive C has no label.
Volume Serial Number is 94E9-D1D5
Directory of C:\oracle\product\10.2.0\flash_recovery_area\TGH
07/21/2011 02:02 PM <DIR> .
07/21/2011 02:02 PM <DIR> ..
07/21/2011 12:08 PM <DIR> ARCHIVELOG
07/21/2011 02:02 PM <DIR> BACKUPSET
07/21/2011 11:10 AM <DIR> ONLINELOG
0 File(s) 0 bytes
5 Dir(s) 2,642,710,528 bytes free
C:\oracle\product\10.2.0\flash_recovery_area\TGH>cd BACKUPSET\2011_07_21
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>dir
Volume in drive C has no label.
Volume Serial Number is 94E9-D1D5
Directory of C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07
_21
07/21/2011 02:16 PM <DIR> .
07/21/2011 02:16 PM <DIR> ..
07/21/2011 02:04 PM 58,292,736 O1_MF_ANNNN_TAG20110721T140232_72HMS02G_.
BKP
07/21/2011 02:16 PM 1,022,976 O1_MF_ANNNN_TAG20110721T141639_72HNLS3F_.
BKP
07/21/2011 02:16 PM 7,143,424 O1_MF_NCSNF_TAG20110721T140414_72HNLK0H_.
BKP
07/21/2011 02:16 PM 635,133,952 O1_MF_NNNDF_TAG20110721T140414_72HMWSJ3_.
BKP
4 File(s) 701,593,088 bytes
2 Dir(s) 2,642,710,528 bytes free
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET\2011_07_21>cd ..
C:\oracle\product\10.2.0\flash_recovery_area\TGH\BACKUPSET>cd ..
C:\oracle\product\10.2.0\flash_recovery_area\TGH>cd ..
C:\oracle\product\10.2.0\flash_recovery_area>cd ..
C:\oracle\product\10.2.0>cd oradata/
C:\oracle\product\10.2.0\oradata>cd TGH
C:\oracle\product\10.2.0\oradata\TGH>dir
Volume in drive C has no label.
Volume Serial Number is 94E9-D1D5
Directory of C:\oracle\product\10.2.0\oradata\TGH
07/21/2011 11:11 AM <DIR> .
07/21/2011 11:11 AM <DIR> ..
07/21/2011 02:20 PM 7,061,504 CONTROL01.CTL
07/21/2011 02:20 PM 7,061,504 CONTROL02.CTL
07/21/2011 02:20 PM 7,061,504 CONTROL03.CTL
07/21/2011 02:20 PM 104,865,792 EXAMPLE01.DBF
07/21/2011 11:54 AM 52,429,312 REDO01.LOG
07/21/2011 11:54 AM 52,429,312 REDO02.LOG
07/21/2011 11:54 AM 52,429,312 REDO03.LOG
07/21/2011 02:20 PM 251,666,432 SYSAUX01.DBF
07/21/2011 02:20 PM 503,324,672 SYSTEM01.DBF
07/21/2011 11:13 AM 20,979,712 TEMP01.DBF
07/21/2011 02:20 PM 36,708,352 UNDOTBS01.DBF
07/21/2011 02:20 PM 22,290,432 USERS01.DBF
12 File(s) 1,118,307,840 bytes
2 Dir(s) 2,642,722,816 bytes free
C:\oracle\product\10.2.0\oradata\TGH>
3. Restore Database Oracle
You can visit backup and restore oracle other post in
http://fakta-dan-unik.blogspot.com/search/label/Oracle
4. Video backup Oracle
1. Video How to backup and Restore 11g Oracle database # 1 of 4
2. Video How to backup and Restore 11g Oracle database # 2 of 4
3. Video How to backup and Restore 11g Oracle database # 3 of 4
4. Video How to backup and Restore 11g Oracle database # 4 of 4
http://fakta-dan-unik.blogspot.com/search/label/Oracle
4. Video backup Oracle
1. Video How to backup and Restore 11g Oracle database # 1 of 4
2. Video How to backup and Restore 11g Oracle database # 2 of 4
3. Video How to backup and Restore 11g Oracle database # 3 of 4
4. Video How to backup and Restore 11g Oracle database # 4 of 4
No comments:
Post a Comment