Friday, July 29, 2011

.::: How To Backup And Restore Database Oracle Using RMAN ( Oracle Backup Tool ) And Fix ORA-19602 :::.

How To Backup And Restore Database Oracle Using RMAN Tool And Fix

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)

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> archivelog list;
        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>
C:\>cd C:\oracle\product\10.2.0\db_1

C:\oracle\product\10.2.0\db_1>dir
 Volume in drive C has no label.
 Volume Serial Number is 94E9-D1D5

 Directory of C:\oracle\product\10.2.0\db_1

07/20/2011  10:52 AM    <DIR>          .
07/20/2011  10:52 AM    <DIR>          ..
07/16/2011  04:07 PM    <DIR>          admin
07/16/2011  04:07 PM    <DIR>          assistants
07/20/2011  10:37 AM    <DIR>          BIN
07/16/2011  04:13 PM    <DIR>          cdata
07/16/2011  04:23 PM    <DIR>          cfgtoollogs
07/16/2011  04:07 PM    <DIR>          clone
07/16/2011  04:07 PM    <DIR>          com
07/16/2011  04:13 PM    <DIR>          config
07/16/2011  04:07 PM    <DIR>          crs
07/16/2011  04:07 PM    <DIR>          css
07/16/2011  04:13 PM    <DIR>          ctx
07/20/2011  10:51 AM    <DIR>          database
07/20/2011  10:51 AM    <DIR>          dbs
07/16/2011  04:07 PM    <DIR>          demo
07/16/2011  04:07 PM    <DIR>          diagnostics
07/16/2011  04:07 PM    <DIR>          has
07/16/2011  04:07 PM    <DIR>          hs
07/20/2011  10:52 AM    <DIR>          install
07/16/2011  04:07 PM                43 install.platform
07/16/2011  04:15 PM    <DIR>          inventory
07/16/2011  04:07 PM    <DIR>          javavm
07/16/2011  04:12 PM    <DIR>          jdbc
07/16/2011  04:13 PM    <DIR>          jdk
07/16/2011  04:13 PM    <DIR>          jlib
07/16/2011  04:07 PM    <DIR>          jre
07/16/2011  04:13 PM    <DIR>          ldap
07/16/2011  04:12 PM    <DIR>          LIB
07/16/2011  04:15 PM    <DIR>          log
07/16/2011  04:07 PM    <DIR>          md
07/16/2011  04:08 PM    <DIR>          mesg
07/16/2011  04:07 PM    <DIR>          mgw
07/16/2011  04:10 PM    <DIR>          MMC Snap-Ins
07/16/2011  04:14 PM    <DIR>          NETWORK
07/16/2011  04:07 PM    <DIR>          nls
07/16/2011  04:15 PM    <DIR>          oc4j
07/16/2011  04:07 PM    <DIR>          OCI
07/16/2011  04:13 PM    <DIR>          odbc
07/16/2011  04:07 PM    <DIR>          odp.net
07/16/2011  04:07 PM    <DIR>          olap
07/16/2011  04:07 PM    <DIR>          oledb
07/16/2011  04:13 PM    <DIR>          oo4o
07/16/2011  04:13 PM    <DIR>          OPatch
07/16/2011  04:13 PM    <DIR>          opmn
07/16/2011  04:10 PM    <DIR>          oraconfig
07/16/2011  04:07 PM    <DIR>          oracore
07/16/2011  04:13 PM    <DIR>          oradata
07/16/2011  04:14 PM    <DIR>          ORAINST
07/16/2011  04:07 PM    <DIR>          ord
07/16/2011  04:13 PM    <DIR>          oui
07/16/2011  04:07 PM    <DIR>          owm
07/16/2011  04:07 PM    <DIR>          perl
07/16/2011  04:08 PM    <DIR>          plsql
07/16/2011  04:07 PM    <DIR>          precomp
07/16/2011  04:13 PM    <DIR>          racg
07/16/2011  04:15 PM    <DIR>          RDBMS
07/16/2011  04:12 PM    <DIR>          relnotes
07/16/2011  04:07 PM    <DIR>          slax
07/16/2011  04:07 PM    <DIR>          sqlj
07/20/2011  10:38 AM             2,285 sqlnet.log
07/16/2011  04:13 PM    <DIR>          sqlplus
07/16/2011  04:13 PM    <DIR>          srvm
07/16/2011  04:13 PM    <DIR>          sysman
07/20/2011  10:54 AM    <DIR>          TEGUHTH_TGH
07/16/2011  04:07 PM    <DIR>          uix
07/16/2011  04:07 PM    <DIR>          wwg
07/16/2011  04:07 PM    <DIR>          xdk
               2 File(s)          2,328 bytes
              66 Dir(s)   3,079,868,416 bytes free

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>
C:\>cd C:\oracle\product\10.2.0\db_1

C:\oracle\product\10.2.0\db_1>dir
 Volume in drive C has no label.
 Volume Serial Number is 94E9-D1D5

 Directory of C:\oracle\product\10.2.0\db_1

07/20/2011  10:52 AM    <DIR>          .
07/20/2011  10:52 AM    <DIR>          ..
07/16/2011  04:07 PM    <DIR>          admin
07/16/2011  04:07 PM    <DIR>          assistants
07/20/2011  10:37 AM    <DIR>          BIN
07/16/2011  04:13 PM    <DIR>          cdata
07/16/2011  04:23 PM    <DIR>          cfgtoollogs
07/16/2011  04:07 PM    <DIR>          clone
07/16/2011  04:07 PM    <DIR>          com
07/16/2011  04:13 PM    <DIR>          config
07/16/2011  04:07 PM    <DIR>          crs
07/16/2011  04:07 PM    <DIR>          css
07/16/2011  04:13 PM    <DIR>          ctx
07/20/2011  10:51 AM    <DIR>          database
07/20/2011  10:51 AM    <DIR>          dbs
07/16/2011  04:07 PM    <DIR>          demo
07/16/2011  04:07 PM    <DIR>          diagnostics
07/16/2011  04:07 PM    <DIR>          has
07/16/2011  04:07 PM    <DIR>          hs
07/20/2011  10:52 AM    <DIR>          install
07/16/2011  04:07 PM                43 install.platform
07/16/2011  04:15 PM    <DIR>          inventory
07/16/2011  04:07 PM    <DIR>          javavm
07/16/2011  04:12 PM    <DIR>          jdbc
07/16/2011  04:13 PM    <DIR>          jdk
07/16/2011  04:13 PM    <DIR>          jlib
07/16/2011  04:07 PM    <DIR>          jre
07/16/2011  04:13 PM    <DIR>          ldap
07/16/2011  04:12 PM    <DIR>          LIB
07/16/2011  04:15 PM    <DIR>          log
07/16/2011  04:07 PM    <DIR>          md
07/16/2011  04:08 PM    <DIR>          mesg
07/16/2011  04:07 PM    <DIR>          mgw
07/16/2011  04:10 PM    <DIR>          MMC Snap-Ins
07/16/2011  04:14 PM    <DIR>          NETWORK
07/16/2011  04:07 PM    <DIR>          nls
07/16/2011  04:15 PM    <DIR>          oc4j
07/16/2011  04:07 PM    <DIR>          OCI
07/16/2011  04:13 PM    <DIR>          odbc
07/16/2011  04:07 PM    <DIR>          odp.net
07/16/2011  04:07 PM    <DIR>          olap
07/16/2011  04:07 PM    <DIR>          oledb
07/16/2011  04:13 PM    <DIR>          oo4o
07/16/2011  04:13 PM    <DIR>          OPatch
07/16/2011  04:13 PM    <DIR>          opmn
07/16/2011  04:10 PM    <DIR>          oraconfig
07/16/2011  04:07 PM    <DIR>          oracore
07/16/2011  04:13 PM    <DIR>          oradata
07/16/2011  04:14 PM    <DIR>          ORAINST
07/16/2011  04:07 PM    <DIR>          ord
07/16/2011  04:13 PM    <DIR>          oui
07/16/2011  04:07 PM    <DIR>          owm
07/16/2011  04:07 PM    <DIR>          perl
07/16/2011  04:08 PM    <DIR>          plsql
07/16/2011  04:07 PM    <DIR>          precomp
07/16/2011  04:13 PM    <DIR>          racg
07/16/2011  04:15 PM    <DIR>          RDBMS
07/16/2011  04:12 PM    <DIR>          relnotes
07/16/2011  04:07 PM    <DIR>          slax
07/16/2011  04:07 PM    <DIR>          sqlj
07/20/2011  10:38 AM             2,285 sqlnet.log
07/16/2011  04:13 PM    <DIR>          sqlplus
07/16/2011  04:13 PM    <DIR>          srvm
07/16/2011  04:13 PM    <DIR>          sysman
07/20/2011  10:54 AM    <DIR>          TEGUHTH_TGH
07/16/2011  04:07 PM    <DIR>          uix
07/16/2011  04:07 PM    <DIR>          wwg
07/16/2011  04:07 PM    <DIR>          xdk
               2 File(s)          2,328 bytes
              66 Dir(s)   3,079,868,416 bytes free

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>
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

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>

 3. Restore Database Oracle
You can visit backup and restore oracle other post in
http://fakta-dan-unik.blogspot.com/search/label/Oracle

Posted by at
Labels: , , , , ,
Location: Jakarta Capital Region, Indonesia

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)