rman恢复所有数据，控制，参数文件，下

一
rman恢复所有数据，控制，参数文件，下
自动恢复spfile文件，自动恢复不了，使用之前备份的文件进行恢复
[oracle@oracle1 ~]$ rman target  /


Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 3 01:41:44 2017


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


connected to target database: SHPOG1 (not mounted)


RMAN> restore spfile  from  autobackup;
Starting restore at 03-APR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=135 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2017 01:43:45
RMAN-06495: must explicitly specify DBID with SET DBID command


RMAN> exit 
[oracle@oracle1 trace]$ ll
total 161592
-rw-r----- 1 oracle oinstall    111946 Apr  3 01:21 alert_shpog1.log
[oracle@oracle1 trace]$ 
[oracle@oracle1 trace]$ vi shpog1_ora_15444.trc
        Compatibility Vsn = 186646528=0xb200000
        Db ID=799280029=0x2fa40b9d, Db Name='SHPOG1'
        Activation ID=799229341=0x2fa3459d
        Control Seq=1934=0x78e, File size=102400=0x19000
        File Number=5, Blksiz=512, File Type=2 LOG


（1）设置dbid
[oracle@oracle1 trace]$ rman target /


connected to target database: SHPOG1 (not mounted)


RMAN> set dbid=799280029;


executing command: SET DBID
（2）强制启动
RMAN> startup nomount  force;


startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/product/11.2/db/dbs/initshpog1.ora'


starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started


Total System Global Area     158662656 bytes
Fixed Size                     2211448 bytes
Variable Size                 92275080 bytes
Database Buffers              58720256 bytes
Redo Buffers                   5455872 bytes
（3）先用自动恢复spfile参数文件，如果恢复不了，再用之前备份的进行恢复
RMAN> restore  spfile from autobackup;


Starting restore at 03-APR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170403
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170402
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170401
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170331
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170330
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170329
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170328
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2017 01:53:16
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
（4）用之前备份的进行恢复
RMAN> restore  spfile  from  '/oracle.bacup/control/cf_c-799280029-20170403-02';


Starting restore at 03-APR-17
using channel ORA_DISK_1


channel ORA_DISK_1: restoring spfile from AUTOBACKUP /oracle.bacup/control/cf_c-799280029-20170403-02
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 03-APR-17

RMAN> exit 
（5）spfile文件已经恢复
[oracle@oracle1 dbs]$ ll
total 2271764
-rw-r----- 1 oracle oinstall 1153318912 Mar 18 04:11 01rvdlk4_1_1
-rw-r----- 1 oracle oinstall 1153351680 Mar 18 04:14 02rvdlum_1_1
-rw-r----- 1 oracle oinstall    9830400 Mar 18 04:14 03rvdm22_1_1
drwxr-xr-x 2 oracle oinstall       4096 Apr  2 23:12 arch
-rw-rw---- 1 oracle oinstall       1544 Mar 18 03:01 hc_DBUA0.dat
-rw-rw---- 1 oracle oinstall       1544 Apr  3 01:52 hc_shpog1.dat
-rw-r--r-- 1 oracle oinstall       2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall         24 Mar 18 03:11 lkSHPOG1
-rw-r----- 1 oracle oinstall       1536 Mar 18 03:19 orapwshpog1
-rw-r----- 1 oracle oinstall    9748480 Apr  3 00:34 snapcf_shpog1.f
-rw-r----- 1 oracle oinstall       2560 Apr  3 01:56 spfileshpog1.ora
（6）关闭数据库，再开启报错少控制文件
[oracle@oracle1 dbs]$ sqlplus  / as sysdba
SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup;  
ORACLE instance started.
Total System Global Area 1586708480 bytes
Fixed Size                  2213736 bytes
Variable Size            1191184536 bytes
Database Buffers          385875968 bytes
Redo Buffers                7434240 bytes
ORA-00205: error in identifying control file, check alert log for more info


SQL> exsit 
SP2-0042: unknown command "exsit" - rest of line ignored.
SQL> exit 
（7）恢复控制文件，先自动恢复，如果没恢复，再用之前备份的进行恢复
RMAN> restore  controlfile  from autobackup;


Starting restore at 03-APR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=572 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2017 02:03:53
RMAN-06495: must explicitly specify DBID with SET DBID command
（8）需要设置dbid，自动恢复再7天内没有找到备份的文件
RMAN> set dbid=799280029;

executing command: SET DBID
RMAN> restore  controlfile  from autobackup;

Starting restore at 03-APR-17
using channel ORA_DISK_1

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170403
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170402
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170401
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170331
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170330
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170329
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170328
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2017 02:05:00
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
（9）之前备份的进行恢复
RMAN> restore  controlfile from '/oracle.bacup/control/cf_c-799280029-20170403-02';


Starting restore at 03-APR-17
using channel ORA_DISK_1


channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oracle/app/oradata/shpog1/control01.ctl
output file name=/oracle/app/oradata/shpog1/control02.ctl
Finished restore at 03-APR-17

将数据库mount起
RMAN> sql 'alter database  mount';


sql statement: alter database  mount
released channel: ORA_DISK_1
[oracle@oracle1 dbs]$ rman target  /


Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 3 02:09:22 2017


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


connected to target database: SHPOG1 (DBID=799280029, not open)


RMAN> restore  database;


Starting restore at 03-APR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=572 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 /oracle/app/oradata/shpog1/system01.dbf
channel ORA_DISK_1: reading from backup piece /oracle.bacup/SHPOG1_25_20170403.bak
channel ORA_DISK_1: piece handle=/oracle.bacup/SHPOG1_25_20170403.bak tag=TAG20170403T002333
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
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 00002 to /oracle/app/oradata/shpog1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oracle/app/oradata/shpog1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /oracle/app/oradata/shpog1/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oracle/app/oradata/shpog1/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /oracle/oracle_tablespace/zhou01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /oracle/app/oradata/shpog1/rman_tbs.dbf
channel ORA_DISK_1: restoring datafile 00008 to /oracle/app/oradata/shpog1/hai01.dbf
channel ORA_DISK_1: reading from backup piece /oracle.bacup/SHPOG1_27_20170403.bak
channel ORA_DISK_1: piece handle=/oracle.bacup/SHPOG1_27_20170403.bak tag=TAG20170403T002452
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:36
Finished restore at 03-APR-17

（11）打开数据库报错，要resetlogs
RMAN> sql 'alter database open';


sql statement: alter database open
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/03/2017 02:17:22
RMAN-11003: failure during parse/execution of SQL statement: alter database open
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
(12)resetlogs  用了一个老的备份，控制文件和数据文件snc号可能不一致。
RMAN> sql 'alter  database open resetlogs';


sql statement: alter  database open resetlogs
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/03/2017 02:18:03
RMAN-11003: failure during parse/execution of SQL statement: alter  database open resetlogs
ORA-01152: file 1 was not restored from a sufficiently old backup 
ORA-01110: data file 1: '/oracle/app/oradata/shpog1/system01.dbf'


RMAN> delete backuppiece  '/oracle.bacup/SHPOG1_27_20170403.bak';

using channel ORA_DISK_1


List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
24      24      1   1   AVAILABLE   DISK        /oracle.bacup/SHPOG1_27_20170403.bak


Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/oracle.bacup/SHPOG1_27_20170403.bak RECID=24 STAMP=940292692
Deleted 1 objects




RMAN> restore database;


Starting restore at 03-APR-17
using channel ORA_DISK_1


skipping datafile 1; already restored to file /oracle/app/oradata/shpog1/system01.dbf
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 00002 to /oracle/app/oradata/shpog1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oracle/app/oradata/shpog1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /oracle/app/oradata/shpog1/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oracle/app/oradata/shpog1/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /oracle/oracle_tablespace/zhou01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /oracle/app/oradata/shpog1/rman_tbs.dbf
channel ORA_DISK_1: restoring datafile 00008 to /oracle/app/oradata/shpog1/hai01.dbf
channel ORA_DISK_1: reading from backup piece /oracle.bacup/hai_full__23_1_940291222
channel ORA_DISK_1: piece handle=/oracle.bacup/hai_full__23_1_940291222 tag=TAG20170403T000022
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:39
Finished restore at 03-APR-17


RMAN> sql 'alter database  open';


sql statement: alter database  open
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/03/2017 02:26:27
RMAN-11003: failure during parse/execution of SQL statement: alter database  open
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


RMAN> sql 'alter  database open  resetlogs'; 


sql statement: alter  database open  resetlogs
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/03/2017 02:27:07
RMAN-11003: failure during parse/execution of SQL statement: alter  database open  resetlogs
ORA-01152: file 1 was not restored from a sufficiently old backup 
ORA-01110: data file 1: '/oracle/app/oradata/shpog1/system01.dbf'

RMAN> restore  database from '/oracle.bacup/SHPOG1_25_20170403.bak';

Starting restore at 03-APR-17
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2017 02:28:15
RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

RMAN> restore  database from autobackup;
Starting restore at 03-APR-17
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2017 02:29:31
RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

RMAN> exit 

Recovery Manager complete.
[oracle@oracle1 dbs]$ sqlplus  / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 3 02:33:08 2017


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


Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
将system.dbf文件offline
SQL> alter datafile  '/oracle/app/oradata/shpog1/system01.dbf' offline;
alter datafile  '/oracle/app/oradata/shpog1/system01.dbf' offline
      *
ERROR at line 1:
ORA-00940: invalid ALTER command

SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup monut;
SP2-0714: invalid combination of STARTUP options
SQL> startup mount;
ORACLE instance started.


Total System Global Area 1586708480 bytes
Fixed Size                  2213736 bytes
Variable Size            1191184536 bytes
Database Buffers          385875968 bytes
Redo Buffers                7434240 bytes
Database mounted.


SQL> alter  database  datafile  '/oracle/app/oradata/shpog1/system01.dbf' offline;

Database altered.

SQL> alter  database  open;
alter  database  open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open




SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01245: offline file 1 will be lost if RESETLOGS is done
ORA-01110: data file 1: '/oracle/app/oradata/shpog1/system01.dbf'


SQL> exit   

[oracle@oracle1 dbs]$ rman target  / 
RMAN> restore database;
Starting restore at 03-APR-17
using channel ORA_DISK_1
skipping datafile 6; already restored to file /oracle/oracle_tablespace/zhou01.dbf
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 00002 to /oracle/app/oradata/shpog1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oracle/app/oradata/shpog1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /oracle/app/oradata/shpog1/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oracle/app/oradata/shpog1/example01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /oracle/app/oradata/shpog1/rman_tbs.dbf
channel ORA_DISK_1: restoring datafile 00008 to /oracle/app/oradata/shpog1/hai01.dbf
channel ORA_DISK_1: reading from backup piece /oracle.bacup/hai_full__23_1_940291222
channel ORA_DISK_1: piece handle=/oracle.bacup/hai_full__23_1_940291222 tag=TAG20170403T000022
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:47
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 /oracle/app/oradata/shpog1/system01.dbf
channel ORA_DISK_1: reading from backup piece /oracle.bacup/SHPOG1_25_20170403.bak
channel ORA_DISK_1: piece handle=/oracle.bacup/SHPOG1_25_20170403.bak tag=TAG20170403T002333
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 03-APR-17


RMAN> sql  'alter  database  open';


sql statement: alter  database  open
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/03/2017 02:50:37
RMAN-11003: failure during parse/execution of SQL statement: alter  database  open
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


RMAN> sql  'alter  database  open resetlogs'; 


sql statement: alter  database  open resetlogs
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/03/2017 02:50:56
RMAN-11003: failure during parse/execution of SQL statement: alter  database  open resetlogs
ORA-01245: offline file 1 will be lost if RESETLOGS is done
ORA-01110: data file 1: '/oracle/app/oradata/shpog1/system01.dbf'


RMAN> exit 
Recovery Manager complete.
[oracle@oracle1 dbs]$ sqlplus  / as sysdba


SQL> alter database datafile  '/oracle/app/oradata/shpog1/system01.dbf'  online;   


Database altered.
SQL> exit 


[oracle@oracle1 dbs]$ rman target  /
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 3 02:53:58 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: SHPOG1 (DBID=799280029, not open)

RMAN> sql  'alter database open'; 

using target database control file instead of recovery catalog
sql statement: alter database open
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/03/2017 02:54:18
RMAN-11003: failure during parse/execution of SQL statement: alter database open
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


RMAN> sql  'alter database open  resetlogs'; 


sql statement: alter database open  resetlogs
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/03/2017 02:54:37
RMAN-11003: failure during parse/execution of SQL statement: alter database open  resetlogs
ORA-01152: file 1 was not restored from a sufficiently old backup 
ORA-01110: data file 1: '/oracle/app/oradata/shpog1/system01.dbf'




（13）数据已经恢复过来了 
RMAN> recover database;


Starting recover at 03-APR-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=572 device type=DISK

starting media recovery

archived log for thread 1 with sequence 19 is already on disk as file /oracle/app/oradata/shpog1/redo04.log
archived log file name=/oracle/app/oradata/shpog1/redo04.log thread=1 sequence=19
media recovery complete, elapsed time: 00:00:01
Finished recover at 03-APR-17
RMAN> sql  'alter database open';                  


sql statement: alter database open
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/03/2017 03:03:42
RMAN-11003: failure during parse/execution of SQL statement: alter database open
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


RMAN> sql  'alter database open  resetlogs'; 


sql statement: alter database open  resetlogs

RMAN> exit 


Recovery Manager complete.
[oracle@oracle1 dbs]$ 
[oracle@oracle1 dbs]$ 
[oracle@oracle1 dbs]$ 
[oracle@oracle1 dbs]$ sqlplus  /  as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 3 03:07:02 2017


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




Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production


SQL> 
SQL> 
SQL> select  * from hai.feng3;


        ID NAME
---------- ------------------------------------------------------------
         2 haifeng
         3 haifeng2
         4 haifeng3
         5 haifeng4
         6 haifeng5
         7 haifeng5
         8 haifeng6
         9 haifeng8
        10 haifeng8


9 rows selected.


SQL> exit 
Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
[oracle@oracle1 dbs]$ cd  /oracle/app/oradata/
[oracle@oracle1 oradata]$ cd shpog1/
[oracle@oracle1 shpog1]$ ls 
a.out          example01.dbf  redo01.log  redo04.log    sysaux01.dbf  undotbs01.dbf
control01.ctl  hai01.dbf      redo02.log  redo05.log    system01.dbf  users01.dbf
control02.ctl  init.ora       redo03.log  rman_tbs.dbf  temp01.dbf
[oracle@oracle1 shpog1]$ ll
total 9918148
-rw-r--r-- 1 oracle oinstall          0 Apr  3 01:40 a.out
-rw-r----- 1 oracle oinstall    9748480 Apr  3 03:07 control01.ctl
-rw-r----- 1 oracle oinstall    9748480 Apr  3 03:07 control02.ctl
-rw-r----- 1 oracle oinstall  104865792 Apr  3 03:04 example01.dbf
-rw-r----- 1 oracle oinstall  104865792 Apr  3 03:04 hai01.dbf
-rw-r--r-- 1 oracle oinstall         15 Apr  3 01:19 init.ora
-rw-r----- 1 oracle oinstall   52429312 Apr  3 03:05 redo01.log
-rw-r----- 1 oracle oinstall   52429312 Apr  3 03:04 redo02.log
-rw-r----- 1 oracle oinstall   52429312 Apr  3 03:04 redo03.log
-rw-r----- 1 oracle oinstall   52429312 Apr  3 03:04 redo04.log
-rw-r----- 1 oracle oinstall   52429312 Apr  3 03:04 redo05.log
-rw-r----- 1 oracle oinstall 5368717312 Apr  3 03:04 rman_tbs.dbf
-rw-r----- 1 oracle oinstall 1073750016 Apr  3 03:04 sysaux01.dbf
-rw-r----- 1 oracle oinstall 1073750016 Apr  3 03:04 system01.dbf
-rw-r----- 1 oracle oinstall   20979712 Apr  3 03:04 temp01.dbf
-rw-r----- 1 oracle oinstall 1073750016 Apr  3 03:04 undotbs01.dbf
-rw-r----- 1 oracle oinstall 1073750016 Apr  3 03:04 users01.dbf


[oracle@oracle1 shpog1]$ sqlplus  /  as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 3 03:09:13 2017


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




Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


SQL> startup;
ORACLE instance started.


Total System Global Area 1586708480 bytes
Fixed Size                  2213736 bytes
Variable Size            1191184536 bytes
Database Buffers          385875968 bytes
Redo Buffers                7434240 bytes
Database mounted.
Database opened.