Shulou(Shulou.com)06/01 Report--

[oracle@oracle01 ~] $

[oracle@oracle01 ~] $rman target /

Recovery Manager: Release 11.2.0.4.0-Production on Fri Jul 13 10:25:19 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to target database: ORA11GR2 (DBID=297877687)

RMAN > backup database

Starting backup at 2018-07-13 10:25:28

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=38 device type=DISK

Channel ORA_DISK_1: starting full datafile backup set

Channel ORA_DISK_1: specifying datafile (s) in backup set

Input datafile file number=00001 name=/u01/app/oracle/oradata/ora11gr2/system01.dbf

Input datafile file number=00002 name=/u01/app/oracle/oradata/ora11gr2/sysaux01.dbf

Input datafile file number=00005 name=/u01/app/oracle/oradata/ora11gr2/example01.dbf

Input datafile file number=00003 name=/u01/app/oracle/oradata/ora11gr2/undotbs01.dbf

Input datafile file number=00004 name=/u01/app/oracle/oradata/ora11gr2/users01.dbf

Channel ORA_DISK_1: starting piece 1 at 2018-07-13 10:25:28

Channel ORA_DISK_1: finished piece 1 at 2018-07-13 10:26:15

Piece handle=/u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_nnndf_TAG20180713T102528_fnj3dsn6_.bkp tag=TAG20180713T102528 comment=NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:47

Channel ORA_DISK_1: starting full datafile backup set

Channel ORA_DISK_1: specifying datafile (s) in backup set

Including current control file in backup set

Including current SPFILE in backup set

Channel ORA_DISK_1: starting piece 1 at 2018-07-13 10:26:16

Channel ORA_DISK_1: finished piece 1 at 2018-07-13 10:26:17

Piece handle=/u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_ncsnf_TAG20180713T102528_fnj3g8bv_.bkp tag=TAG20180713T102528 comment=NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 2018-07-13 10:26:17

RMAN > quit

Recovery Manager complete.

[oracle@oracle01 ~] $cd / u01/app/oracle/oradata/ora11gr2/

[oracle@oracle01 ora11gr2] $rm-rf system01.dbf

[oracle@oracle01 ora11gr2] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 13 10:27:13 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > shutdow abort

ORACLE instance shut down.

SQL > startup

ORACLE instance started.

Total System Global Area 1653518336 bytes

Fixed Size 2253784 bytes

Variable Size 1006636072 bytes

Database Buffers 637534208 bytes

Redo Buffers 7094272 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1-see DBWR trace file

ORA-01110: data file 1:'/ u01 *

SQL > startup mount

ORA-01081: cannot start already-running ORACLE-shut it down first

SQL > shut immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL > startup mount

ORACLE instance started.

Total System Global Area 1653518336 bytes

Fixed Size 2253784 bytes

Variable Size 1006636072 bytes

Database Buffers 637534208 bytes

Redo Buffers 7094272 bytes

Database mounted.

SQL > quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracle01 ora11gr2] $rman target /

Recovery Manager: Release 11.2.0.4.0-Production on Fri Jul 13 10:28:24 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to target database: ORA11GR2 (DBID=297877687, not open)

RMAN > restore database

Starting restore at 2018-07-13 10:28:41

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=20 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 00001 to / u01/app/oracle/oradata/ora11gr2/system01.dbf

Channel ORA_DISK_1: restoring datafile 00002 to / u01/app/oracle/oradata/ora11gr2/sysaux01.dbf

Channel ORA_DISK_1: restoring datafile 00003 to / u01/app/oracle/oradata/ora11gr2/undotbs01.dbf

Channel ORA_DISK_1: restoring datafile 00004 to / u01/app/oracle/oradata/ora11gr2/users01.dbf

Channel ORA_DISK_1: restoring datafile 00005 to / u01/app/oracle/oradata/ora11gr2/example01.dbf

Channel ORA_DISK_1: reading from backup piece / u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_nnndf_TAG20180713T102528_fnj3dsn6_.bkp

Channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_nnndf_TAG20180713T102528_fnj3dsn6_.bkp tag=TAG20180713T102528

Channel ORA_DISK_1: restored backup piece 1

Channel ORA_DISK_1: restore complete, elapsed time: 00:00:45

Finished restore at 2018-07-13 10:29:28

RMAN > recover database

Starting recover at 2018-07-13 10:29:38

Using channel ORA_DISK_1

Starting media recovery

Media recovery complete, elapsed time: 00:00:01

Finished recover at 2018-07-13 10:29:39

RMAN > quit

Recovery Manager complete.

[oracle@oracle01 ora11gr2] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 13 10:29:53 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > alter database open

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.