Home » RDBMS Server » Backup & Recovery » restore the data from rman (oralce 9.0)
restore the data from rman [message #424254] Thu, 01 October 2009 02:27 Go to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Hi,
I backup the database by rman in below

input datafile fno=00003 name=/database/oradata2/DEMO/TOOL_FRWK_001_00.dbf
input datafile fno=00011 name=/database/oradata2/DEMO/USER_FRWK_001_00.dbf
input datafile fno=00019 name=/database/oradata2/DEMO/USER_GCCM_00.dbf
input datafile fno=00025 name=/database/oradata2/DEMO/USER_SAS_REF_001_00.dbf
input datafile fno=00035 name=/database/oradata2/DEMO/USER_MBRCA_001_00.dbf
input datafile fno=00048 name=/database/oradata2/DEMO/USER_RCA_001_00.dbf
channel ORA_DISK_1: starting piece 1 at 01-OCT-09
channel ORA_DISK_1: finished piece 1 at 01-OCT-09
piece handle=/opt/oracle/9.2.0/dbs/04kqmtgv_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:05:57
Finished backup at 01-OCT-09

RMAN> list backup ;


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
52 Full 64K DISK 00:00:02 30-SEP-09
BP Key: 53 Status: AVAILABLE Tag: TAG20090930T222421
Piece Name: /opt/oracle/9.2.0/dbs/02kqis4l_1_1
List of Datafiles in backup set 52
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 1114345 30-SEP-09 /database/oradata2/DEMO/TOOL_FRWK_001_00.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
56 Full 183M DISK 00:05:49 01-OCT-09
BP Key: 57 Status: AVAILABLE Tag: TAG20091001T111230
Piece Name: /opt/oracle/9.2.0/dbs/04kqmtgv_1_1
Controlfile Included: Ckp SCN: 1114692 Ckp time: 01-OCT-09
List of Datafiles in backup set 56
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1114693 01-OCT-09 /database/oradata1/DEMO/SYSTEM_FRWK_001_00.dbf
2 Full 1114693 01-OCT-09 /database/oradata2/DEMO/RBS_FRWK_001_00.dbf
3 Full 1114693 01-OCT-09 /database/oradata2/DEMO/TOOL_FRWK_001_00.dbf
4 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_REP_FRWK_00.dbf
5 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_REP_FRWK_00.dbf
6 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_INV_FRWK_00.dbf
7 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_TRAIL_FRWK_00.dbf
8 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_CI_FRWK_00.dbf
9 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_CI_FRWK_00.dbf
10 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_INV_FRWK_00.dbf
11 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_FRWK_001_00.dbf
12 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_TRAIL_FRWK_P_00.dbf
13 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_INV_FRWK_P_00.dbf
14 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_INV_FRWK_P_00.dbf
15 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_REP_GCCM_00.dbf
16 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_REP_GCCM_00.dbf
17 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_REP_GCCM_00.dbf
18 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_TARGET_GCCM_00.dbf
19 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_GCCM_00.dbf
20 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_SERVICE_GCCM_P_00.dbf
21 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_TARGET_GCCM_P_00.dbf
22 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_TARGET_GCCM_P_00.dbf
23 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_SERVICE_GCCM_P_00.dbf
24 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_SAS_REF_001_00.dbf
25 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_SAS_REF_001_00.dbf
26 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_SAS_REF_001_00.dbf
27 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_SAS_REF_001_00.dbf
28 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_MB_REP_RCA_00.dbf
29 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_MB_CSD_RCA_00.dbf
30 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_MB_CSD_RCA_00.dbf
31 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_MB_KEY_RCA_00.dbf
32 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_MB_KEY_RCA_00.dbf
33 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_MB_SYNC_RCA_00.dbf
34 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_MB_SYNC_RCA_00.dbf
35 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_MBRCA_001_00.dbf
36 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_CFM_RCA_00.dbf
37 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_FILE_RCA_00.dbf
38 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_FILE_RCA_00.dbf
39 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_APPLI_RCA_00.dbf
40 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_JAVA_RCA_00.dbf
41 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_JAVA_RCA_00.dbf
42 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_APPLI_RCA_00.dbf
43 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_SWAP_RCA_00.dbf
44 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_CFM_RCA_00.dbf
45 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_REP_RCA_00.dbf
46 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_REP_RCA_00.dbf
47 Full 1114693 01-OCT-09 /database/oradata4/DEMO/LOB_REP_RCA_00.dbf
48 Full 1114693 01-OCT-09 /database/oradata2/DEMO/USER_RCA_001_00.dbf
49 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_SWAP_RCA_P_00.dbf
50 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_ACTION_RCA_P_00.dbf
51 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_ACTION_RCA_P_00.dbf
52 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_FILE_RCA_P_00.dbf
53 Full 1114693 01-OCT-09 /database/oradata5/DEMO/INDX_FILE_RCA_P_00.dbf
54 Full 1114693 01-OCT-09 /database/oradata4/DEMO/DATA_SWAP_RCA_P_00.dbf
55 Full 1114693 01-OCT-09 /database/oradata_rman/rman_01.dbf

RMAN> quit

If I delete the file /database/oradata1/DEMO/SYSTEM_FRWK_001_00.dbf
, Can I still restore the data by rman without problem ??
If I delete the file /opt/oracle/9.2.0/dbs/04kqmtgv_1_1
,Can I still restore the data by rman without problem ???

Please advice

Re: restore the data from rman [message #424420 is a reply to message #424254] Fri, 02 October 2009 05:06 Go to previous message
mohd_dba
Messages: 19
Registered: October 2009
Junior Member
Yes you can restore that file.

If that is a system datafile.You can restore like by using the command.
First shutdown the target database by using the command like ;

shutdown abort.

Then connect to the target database through catalog like.

rman>rman catalog rman/rman target sys/admin@<alias name>

rman> startup nomount
rman>restore datafile 1;
rman>alter database mount;
rman>recover datafile 1;
rman>alter database open;

If the backups are insufficient then it will be impossible to retore that datafile.And we lose the database.

Please correct me if I am wrong.

Thanks,
Afroze.
Previous Topic: ora-01110: data file 10
Next Topic: Alter Database Begin backup flow (merged)
Goto Forum:
  


Current Time: Wed Sep 28 14:17:52 CDT 2016

Total time taken to generate the page: 0.07111 seconds