RESTORE A PARTICULAR TABLESPACE USING RMAN :
C:\Documents and Settings\USERPRO>set oracle_sid=orcl
C:\Documents and Settings\USERPRO>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 21 16:14:47 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Documents and Settings\USERPRO>set oracle_sid=orcl
C:\Documents and Settings\USERPRO>set oracle_sid=orcl
C:\Documents and Settings\USERPRO>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 21 16:15:47 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 343934376 bytes
Database Buffers 427819008 bytes
Redo Buffers 5259264 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: 'D:\APP\USERPRO\ORADATA\ORCL\USERS01.DBF'
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Documents and Settings\USERPRO>rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 21 16:16:30 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1402635108, not open)
RMAN> restore tablespace users;
Starting restore at 21-MAR-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to D:\APP\USERPRO\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: reading from backup piece D:\APP\USERPRO\PRODUCT\11.2.0\DBHOME_1\DATABASE\02Q2D3R1_1_1
channel ORA_DISK_1: piece handle=D:\APP\USERPRO\PRODUCT\11.2.0\DBHOME_1\DATABASE\02Q2D3R1_1_1 tag=TAG20150321T153143
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 21-MAR-15
C:\Documents and Settings\USERPRO>sqlplus sys/sys@orcl as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 21 16:20:45 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database open;
Database altered.
C:\Documents and Settings\USERPRO>set oracle_sid=orcl
C:\Documents and Settings\USERPRO>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 21 16:14:47 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Documents and Settings\USERPRO>set oracle_sid=orcl
C:\Documents and Settings\USERPRO>set oracle_sid=orcl
C:\Documents and Settings\USERPRO>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 21 16:15:47 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 343934376 bytes
Database Buffers 427819008 bytes
Redo Buffers 5259264 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: 'D:\APP\USERPRO\ORADATA\ORCL\USERS01.DBF'
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Documents and Settings\USERPRO>rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 21 16:16:30 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1402635108, not open)
RMAN> restore tablespace users;
Starting restore at 21-MAR-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to D:\APP\USERPRO\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: reading from backup piece D:\APP\USERPRO\PRODUCT\11.2.0\DBHOME_1\DATABASE\02Q2D3R1_1_1
channel ORA_DISK_1: piece handle=D:\APP\USERPRO\PRODUCT\11.2.0\DBHOME_1\DATABASE\02Q2D3R1_1_1 tag=TAG20150321T153143
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 21-MAR-15
C:\Documents and Settings\USERPRO>sqlplus sys/sys@orcl as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 21 16:20:45 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database open;
Database altered.
No comments:
Post a Comment