从11.1.0.7 32bit ASM OMF rman backup恢复数据到11.1.0.7 64bit filesystem OMF

 

准备工作
安装64bit软件
Install 11.1.0.6 db software
Upgrate to 11.1.0.7

复制rman备份到新机器
复制init.ora到新机器,修改相关路径如下

*.control_files=’/apps/oradata/DESTDB/controlfile/control01.ctl’
*.db_create_file_dest=’/apps/oradata’
*.db_create_online_log_dest_1=’/apps/oradata’

开始恢复

[oracle@adcgdh01 dbs]$ rman target /

Recovery Manager: Release 11.1.0.7.0 – Production on Tue Jun 21 23:13:57 2011

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

connected to target database (not started)

RMAN> startup nomount;

Oracle instance started

Total System Global Area    3691425792 bytes

Fixed Size                     2171152 bytes
Variable Size               1324584688 bytes
Database Buffers            2348810240 bytes
Redo Buffers                  15859712 bytes

恢复controlfile
RMAN> restore controlfile from ‘/home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0bjt623d_1_1’;

Starting restore at 21-JUN-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=985 device type=DISK

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/21/2011 23:15:18
ORA-19870: error while restoring backup piece /home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0bjt623d_1_1
ORA-19504: failed to create file "/apps/oradata/DESTDB/controlfile/control01.ctl"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory

RMAN>

报错,路径未创建
create directory:
bash-3.2$ mkdir -p /apps/oradata/DESTDB/controlfile/

restore control file again:

RMAN>  restore controlfile from ‘/home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0bjt623d_1_1’;

Starting restore at 21-JUN-11
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=/apps/oradata/DESTDB/controlfile/control01.ctl
Finished restore at 21-JUN-11

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

catalog复制过来的rman backup文件
RMAN> catalog backuppiece ‘/home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0bjt623d_1_1’;
catalog backuppiece ‘/home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0ajt5ul4_1_1’;

cataloged backup piece
backup piece handle=/home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0bjt623d_1_1 RECID=5 STAMP=754442236

RMAN>
cataloged backup piece
backup piece handle=/home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0ajt5ul4_1_1 RECID=6 STAMP=754442236

RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1997 device type=DISK
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/home/mchen/backup/10gR2-ASM-Single-DESTDB-NoStreams/01j7iviu_1_1 RECID=1 STAMP=645496414
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/home/mchen/backup/DESTDB-10.2.0.4tc14-ASM-Single/04j8vqul_1_1 RECID=2 STAMP=646966230
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/home/mchen/backup/DESTDB-11gPROD-ASM-Single/07jk8oci_1_1 RECID=3 STAMP=658792850
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/home/mchen/backup/DESTDB-11g11107Rel-ASM-Single/0ajt5ul4_1_1 RECID=4 STAMP=668138149
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0ajt5ul4_1_1 RECID=6 STAMP=754442236
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0bjt623d_1_1 RECID=5 STAMP=754442236
Crosschecked 6 objects

RMAN>

生成rman setnew语句
bash-3.2$ sqlplus /nolog

SQL*Plus: Release 11.1.0.7.0 – Production on Tue Jun 21 23:20:38 2011

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

SQL> conn / as sysdba
Connected.
SQL> set pagesize 100
SQL> select ‘set newname for datafile ‘||file#||’ to NEW;’ from v$datafile;

‘SETNEWNAMEFORDATAFILE’||FILE#||’TONEW;’
——————————————————————————–
set newname for datafile 1 to NEW;
set newname for datafile 2 to NEW;
set newname for datafile 3 to NEW;
set newname for datafile 4 to NEW;
set newname for datafile 5 to NEW;
set newname for datafile 6 to NEW;
set newname for datafile 7 to NEW;
set newname for datafile 8 to NEW;
set newname for datafile 9 to NEW;
set newname for datafile 10 to NEW;
set newname for datafile 11 to NEW;
set newname for datafile 12 to NEW;
set newname for datafile 13 to NEW;
set newname for datafile 14 to NEW;
set newname for datafile 15 to NEW;
set newname for datafile 16 to NEW;
set newname for datafile 17 to NEW;
set newname for datafile 18 to NEW;
set newname for datafile 19 to NEW;
set newname for datafile 20 to NEW;
set newname for datafile 21 to NEW;
set newname for datafile 22 to NEW;
set newname for datafile 23 to NEW;
set newname for datafile 24 to NEW;
set newname for datafile 25 to NEW;
set newname for datafile 26 to NEW;
set newname for datafile 27 to NEW;
set newname for datafile 28 to NEW;
set newname for datafile 29 to NEW;
set newname for datafile 30 to NEW;
set newname for datafile 31 to NEW;

31 rows selected.

SQL>

rman restore
RMAN> run
{
set newname for datafile 1 to NEW;
set newname for datafile 2 to NEW;
set newname for datafile 3 to NEW;
set newname for datafile 4 to NEW;
set newname for datafile 5 to NEW;
set newname for datafile 6 to NEW;
set newname for datafile 7 to NEW;
set newname for datafile 8 to NEW;
set newname for datafile 9 to NEW;
set newname for datafile 10 to NEW;
set newname for datafile 11 to NEW;
set newname for datafile 12 to NEW;
set newname for datafile 13 to NEW;
set newname for datafile 14 to NEW;
set newname for datafile 15 to NEW;
set newname for datafile 16 to NEW;
set newname for datafile 17 to NEW;
set newname for datafile 18 to NEW;
set newname for datafile 19 to NEW;
set newname for datafile 20 to NEW;
set newname for datafile 21 to NEW;
set newname for datafile 22 to NEW;
set newname for datafile 23 to NEW;
set newname for datafile 24 to NEW;
set newname for datafile 25 to NEW;
set newname for datafile 26 to NEW;
set newname for datafile 27 to NEW;
set newname for datafile 28 to NEW;
set newname for datafile 29 to NEW;
set newname for datafile 30 to NEW;
set newname for datafile 31 to NEW;
restore database;
switch datafile all;
alter database open resetlogs;
}
2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37>
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 21-JUN-11
using channel ORA_DISK_1

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 /apps/oradata/DESTDB/datafile/o1_mf_system_%u_.dbf
channel ORA_DISK_1: restoring datafile 00002 to /apps/oradata/DESTDB/datafile/o1_mf_undotbs_%u_.dbf
channel ORA_DISK_1: restoring datafile 00003 to /apps/oradata/DESTDB/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_DISK_1: restoring datafile 00004 to /apps/oradata/DESTDB/datafile/o1_mf_users_%u_.dbf
channel ORA_DISK_1: restoring datafile 00005 to /apps/oradata/DESTDB/datafile/o1_mf_users_%u_.dbf
channel ORA_DISK_1: restoring datafile 00006 to /apps/oradata/DESTDB/datafile/o1_mf_portal_%u_.dbf
channel ORA_DISK_1: restoring datafile 00007 to /apps/oradata/DESTDB/datafile/o1_mf_portal_d_%u_.dbf
channel ORA_DISK_1: restoring datafile 00008 to /apps/oradata/DESTDB/datafile/o1_mf_portal_i_%u_.dbf
channel ORA_DISK_1: restoring datafile 00009 to /apps/oradata/DESTDB/datafile/o1_mf_portal_l_%u_.dbf
channel ORA_DISK_1: restoring datafile 00010 to /apps/oradata/DESTDB/datafile/o1_mf_ias_meta_%u_.dbf
channel ORA_DISK_1: restoring datafile 00011 to /apps/oradata/DESTDB/datafile/o1_mf_disco_pt_%u_.dbf
channel ORA_DISK_1: restoring datafile 00012 to /apps/oradata/DESTDB/datafile/o1_mf_disco_pt_%u_.dbf
channel ORA_DISK_1: restoring datafile 00013 to /apps/oradata/DESTDB/datafile/o1_mf_dcm_%u_.dbf
channel ORA_DISK_1: restoring datafile 00014 to /apps/oradata/DESTDB/datafile/o1_mf_dsgatewa_%u_.dbf
channel ORA_DISK_1: restoring datafile 00015 to /apps/oradata/DESTDB/datafile/o1_mf_wcrsys_t_%u_.dbf
channel ORA_DISK_1: restoring datafile 00016 to /apps/oradata/DESTDB/datafile/o1_mf_b2b_rt_%u_.dbf
channel ORA_DISK_1: restoring datafile 00017 to /apps/oradata/DESTDB/datafile/o1_mf_b2b_dt_%u_.dbf
channel ORA_DISK_1: restoring datafile 00018 to /apps/oradata/DESTDB/datafile/o1_mf_b2b_idx_%u_.dbf
channel ORA_DISK_1: restoring datafile 00019 to /apps/oradata/DESTDB/datafile/o1_mf_b2b_lob_%u_.dbf
channel ORA_DISK_1: restoring datafile 00020 to /apps/oradata/DESTDB/datafile/o1_mf_orabpel_%u_.dbf
channel ORA_DISK_1: restoring datafile 00021 to /apps/oradata/DESTDB/datafile/o1_mf_bam_%u_.dbf
channel ORA_DISK_1: restoring datafile 00022 to /apps/oradata/DESTDB/datafile/o1_mf_ocats_%u_.dbf
channel ORA_DISK_1: restoring datafile 00023 to /apps/oradata/DESTDB/datafile/o1_mf_uddisys__%u_.dbf
channel ORA_DISK_1: restoring datafile 00024 to /apps/oradata/DESTDB/datafile/o1_mf_olts_att_%u_.dbf
channel ORA_DISK_1: restoring datafile 00025 to /apps/oradata/DESTDB/datafile/o1_mf_olts_bat_%u_.dbf
channel ORA_DISK_1: restoring datafile 00026 to /apps/oradata/DESTDB/datafile/o1_mf_olts_ct__%u_.dbf
channel ORA_DISK_1: restoring datafile 00027 to /apps/oradata/DESTDB/datafile/o1_mf_olts_def_%u_.dbf
channel ORA_DISK_1: restoring datafile 00028 to /apps/oradata/DESTDB/datafile/o1_mf_olts_svr_%u_.dbf
channel ORA_DISK_1: restoring datafile 00029 to /apps/oradata/DESTDB/datafile/o1_mf_c_cust_s_%u_.dbf
channel ORA_DISK_1: restoring datafile 00030 to /apps/oradata/DESTDB/datafile/o1_mf_undotbs__%u_.dbf
channel ORA_DISK_1: restoring datafile 00031 to /apps/oradata/DESTDB/datafile/o1_mf_streams__%u_.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0ajt5ul4_1_1
channel ORA_DISK_1: piece handle=/home/oracle/backup/DESTDB-11g11107Rel-ASM-Single/0ajt5ul4_1_1 tag=DESTDB_SINGLE_11107REL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:06:10
Finished restore at 21-JUN-11

datafile 1 switched to datafile copy
input datafile copy RECID=122 STAMP=754442894 file name=/apps/oradata/DESTDB/datafile/o1_mf_system_7032jdq9_.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=123 STAMP=754442894 file name=/apps/oradata/DESTDB/datafile/o1_mf_undotbs_7032jdq2_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=124 STAMP=754442894 file name=/apps/oradata/DESTDB/datafile/o1_mf_sysaux_7032jdqd_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=125 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_users_7032jdqj_.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=126 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_users_7032jdqm_.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=127 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_portal_7032np1n_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=128 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_portal_d_7032odv6_.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=129 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_portal_i_7032o7vq_.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=130 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_portal_l_7032o8dc_.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=131 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_ias_meta_7032mnm6_.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=132 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_disco_pt_7032omg5_.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=133 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_disco_pt_7032on62_.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=134 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_dcm_7032nynz_.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=135 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_dsgatewa_7032ohcq_.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=136 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_wcrsys_t_7032objh_.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=137 STAMP=754442895 file name=/apps/oradata/DESTDB/datafile/o1_mf_b2b_rt_7032o391_.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=138 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_b2b_dt_7032o3ro_.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=139 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_b2b_idx_7032ofgk_.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=140 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_b2b_lob_7032ogp3_.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=141 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_orabpel_7032nz6r_.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=142 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_bam_7032msql_.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=143 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_ocats_7032ok1w_.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=144 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_uddisys__7032o9xr_.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=145 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_olts_att_7032jdpp_.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=146 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_olts_bat_7032okmz_.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=147 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_olts_ct__7032jdq5_.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=148 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_olts_def_7032lr20_.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=149 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_olts_svr_7032olgo_.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=150 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_c_cust_s_7032lzv5_.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=151 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_undotbs__7032jdpy_.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=152 STAMP=754442896 file name=/apps/oradata/DESTDB/datafile/o1_mf_streams__7032m9d4_.dbf

database opened
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-06553: PLS-801: internal error [56319]

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-06553: PLS-801: internal error [56319]
RMAN-12005: error during channel cleanup
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56319]

RMAN>

下面这个错误是由于32bit和64bit之间不兼容造成的
ORA-06553: PLS-801: internal error [56319]

下面convert from 32bit to 64bit
REF:
How to convert a 32-bit database to 64-bit database on Linux? (Doc ID 341880.1)
Changing between 32-bit and 64-bit Word Sizes (Doc ID 62290.1)

[oracle@adcgdh01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 – Production on Tue Jun 21 23:39:40 2011

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 3691425792 bytes
Fixed Size                  2171152 bytes
Variable Size            1324584688 bytes
Database Buffers         2348810240 bytes
Redo Buffers               15859712 bytes
Database mounted.
Database opened.
SQL>

SQL> begin
  update obj$ set status=5 where obj#=(select obj# from obj$,javasnm$
    where owner#=0 and type#=29 and short(+)=name and
    nvl(longdbcs,name)=’oracle/aurora/rdbms/Compiler’);
  commit;
  declare
    cursor C1 is select
       ‘DROP JAVA DATA "’ || u.name || ‘"."’ || o.name || ‘"’
       from obj$ o,user$ u where o.type#=56 and u.user#=o.owner#;
    ddl_statement varchar2(200);
    iterations number;
    previous_iterations number;
    loop_count number;
    my_err     number;
  begin
    previous_iterations := 10000000;
    loop
      — To make sure we eventually stop, pick a max number of iterations
      select count(*) into iterations from obj$ where type#=56;
      exit when iterations=0 or iterations >= previous_iterations;
      previous_iterations := iterations;
      loop_count := 0;
      open C1;
      loop
        begin
          fetch C1 into ddl_statement;
          exit when C1%NOTFOUND or loop_count > iterations;
        exception when others then
           my_err := sqlcode;
           if my_err = -1555 then — snapshot too old, re-execute fetch query
             exit;
           else
             raise;
           end if;
        end;
        initjvmaux.exec(ddl_statement);
        loop_count := loop_count + 1;
      end loop;
      close C1;
    end loop;
  end;
  commit;
  initjvmaux.drp(‘delete from java$policy$shared$table’);
  update obj$ set status=1 where obj#=(select obj# from obj$,javasnm$
    where owner#=0 and type#=29 and short(+)=name and
    nvl(longdbcs,name)=’oracle/aurora/rdbms/Compiler’);
  commit;
end;
/

create or replace java system
/  2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   42   43   44   45   46   47   48   49   50  begin
*
ERROR at line 1:
ORA-06553: PLS-801: internal error [56319]
#####for this error, there is also some feedback in metalink ,but no update, there is no java used in my system ,so ignore it#####

SQL> SQL>   2 

Java created.

SQL> @$ORACLE_HOME/rdbms/admin/utlirp.sql
……………….
SQL>
SQL> DOC
DOC>#######################################################################
DOC>#######################################################################
DOC>   utlirp.sql completed successfully. All PL/SQL objects in the
DOC>   database have been invalidated.
DOC>
DOC>   Shut down and restart the database in normal mode and run utlrp.sql to
DOC>   recompile invalid objects.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 3691425792 bytes
Fixed Size                  2171152 bytes
Variable Size            1324584688 bytes
Database Buffers         2348810240 bytes
Redo Buffers               15859712 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/utlrp.sql

………………….

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

Total System Global Area 3691425792 bytes
Fixed Size                  2171152 bytes
Variable Size            1324584688 bytes
Database Buffers         2348810240 bytes
Redo Buffers               15859712 bytes
Database mounted.
Database opened.

检查 alertlog, 没有问题。

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

full backup.

end.

发表评论

电子邮件地址不会被公开。 必填项已用*标注