UNIX下RMAN复制数据库

最新推荐文章于 2024-09-09 09:47:53 发布
最新推荐文章于 2024-09-09 09:47:53 发布
阅读量135 收藏
点赞数
文章标签： 数据库 网络 操作系统

UNIX下RMAN复制数据库

数据库 9.2.0.6
操作系统 AIX 5304

原数据库：QHSIT[归档模式]  （找了个最小的数据库做测试，也80G:-( ，机器性能一般，所以比较慢，数据文件实在太多了，多余的地方就用…省略了）
目标数据库：QHTEST
蓝色字体为输入命令
步骤：

1：创建用户
原数据库操作系统用户为oraqhsit，在同一台主机上建立新用户，如qhtest，dba组。

2：配置新数据库软件
将原数据库的数据库软件拷贝到新路径下，之后修改env文件和init文件，将路径改为目标数据库路径，并保证新路径存在且有权限。将SID改为QHTEST，将TNS里的SID以及端口号都改为目标SID。
原数据库：
oraqhsit:/home/oraqhsit >echo $ORACLE_HOME
/datavg15/qhsit/qhsitdb/9.2.0
目标数据库：
qhtest:/home/qhtest >echo $ORACLE_HOME
/datavg45/qhbak/qhtestdb/9.2.0

3：配置原数据库TNS
原数据库的TNS里加入目标数据库的TNS，如：
oraqhsit:/datavg15/qhsit/qhsitdb/9.2.0/network/admin/QHSIT_misdev6 >cat tnsnames.ora
#
# $Header: ad8itns.ora 115.4 2004/04/01 12:57:26 rsanders ship $
#
# ###############################################################
#
# This file is automatically generated by AutoConfig.  It will be read and
# overwritten.  If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink document
# 165195.1 for assistance.
#
# ###############################################################

#

#
# Net8 definition for the database
#

QHSIT = (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=MISDEV6)(PORT=11701))
                (CONNECT_DATA=(SID=QHSIT))
            )

QHTEST = (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=MISDEV6)(PORT=11501))
                (CONNECT_DATA=(SID=QHTEST))
            )
...

4：密码文件获取
在目标数据库执行
orapwd file=$ORACLE_HOME/dbs/orapw password=manager entries=30
执行后将目标数据库起到nomount状态
qhtest:/home/qhtest >sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Jul 8 19:36:11 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  766478528 bytes
Fixed Size                   743616 bytes
Variable Size             218103808 bytes
Database Buffers          536870912 bytes
Redo Buffers               10760192 bytes
SQL>

5：在原数据库尝试连接目标数据库
oraqhsit:/home/oraqhsit >rman target / auxiliary sys/manager@qhtest

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: QHSIT (DBID=2864491865)
connected to auxiliary database: QHTEST (not mounted)

RMAN>
连接成功

6：配置RMAN
将原环境的RMAN备份路径配置为本地磁盘（至于带库、磁带等未测试）
RMAN> configure controlfile autobackup format for device type disk to '/datavg45/qhbak/rmanqhbak/%F';

using target database controlfile instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/datavg45/qhbak/rmanqhbak/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/datavg45/qhbak/rmanqhbak/%F';
new RMAN configuration parameters are successfully stored

RMAN> configure channel device type disk format '/datavg45/qhbak/rmanqhbak/db_%u';

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/datavg45/qhbak/rmanqhbak/db_%u';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/datavg45/qhbak/rmanqhbak/db_%u';
new RMAN configuration parameters are successfully stored

7:备份原数据库
oraqhsit:/home/oraqhsit >rman target /

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: QHSIT (DBID=2864491865)

RMAN> list backup;

using target database controlfile instead of recovery catalog

RMAN> run {
2> sql 'alter system switch logfile';
backup current controlfile;
backup3>  full database;
backup a4> rchivelog all;
}5> 6>

sql statement: alter system switch logfile

Starting backup at 08-JUL-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=46 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current controlfile in backupset
channel ORA_DISK_1: starting piece 1 at 08-JUL-09
channel ORA_DISK_1: finished piece 1 at 08-JUL-09
piece handle=/datavg45/qhbak/rmanqhbak/db_17kjlfgs comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-JUL-09

Starting backup at 08-JUL-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00289 name=/datavg15/qhsit/qhsitdata/applsysd02.dbf
input datafile fno=00352 name=/datavg15/qhsit/qhsitdata/system08.dbf
input datafile fno=00099 name=/datavg15/qhsit/qhsitdata/fad01.dbf
…
…
…
input datafile fno=00364 name=/datavg15/qhsit/qhsitdata/domx01.dbf
input datafile fno=00377 name=/datavg15/qhsit/qhsitdata/qrmd01.dbf
input datafile fno=00390 name=/datavg15/qhsit/qhsitdata/edrx01.dbf
input datafile fno=00409 name=/datavg15/qhsit/qhsitdata/xnbd01.dbf
channel ORA_DISK_1: starting piece 1 at 08-JUL-09
channel ORA_DISK_1: finished piece 1 at 08-JUL-09
piece handle=/datavg45/qhbak/rmanqhbak/db_1ekjlfu8 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:06
Finished backup at 08-JUL-09

Starting backup at 08-JUL-09
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=642 recid=17 stamp=691715425
input archive log thread=1 sequence=650 recid=18 stamp=691715431
input archive log thread=1 sequence=651 recid=19 stamp=691715611
input archive log thread=1 sequence=652 recid=20 stamp=691716107
channel ORA_DISK_1: starting piece 1 at 08-JUL-09
channel ORA_DISK_1: finished piece 1 at 08-JUL-09
piece handle=/datavg45/qhbak/rmanqhbak/db_1fkjlg0b comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 08-JUL-09

RMAN>

8：起目标数据库
将目标数据库起到nomount状态
qhtest:/home/qhtest >sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Jul 8 23:24:29 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  766478528 bytes
Fixed Size                   743616 bytes
Variable Size             218103808 bytes
Database Buffers          536870912 bytes
Redo Buffers               10760192 bytes

将目标数据库监听起来
qhtest:/home/qhtest >lsnrctl start qhtest

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production on 08-JUL-2009 23:24:19

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Starting /datavg45/qhbak/qhtestdb/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
Log messages written to /datavg45/qhbak/qhtestdb/9.2.0/network/admin/qhtest.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCQHTEST)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=misdev6)(PORT=11501)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCQHTEST))
STATUS of the LISTENER
------------------------
Alias                     qhtest
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
Start Date                08-JUL-2009 23:24:19
Uptime                    0 days 0 hr. 0 min. 2 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Log File         /datavg45/qhbak/qhtestdb/9.2.0/network/admin/qhtest.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCQHTEST)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=misdev6)(PORT=11501)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "QHTEST" has 1 instance(s).
  Instance "QHTEST", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

9：查找原数据库数据文件信息
用’select file#,name from v$datafile;’查出原数据库数据文件的文件号和对应名称
如：
FILE# NAME
1    /datavg15/qhsit/qhsitdata/system01.dbf
2    /datavg15/qhsit/qhsitdata/system02.dbf
3    /datavg15/qhsit/qhsitdata/system03.dbf
4    /datavg15/qhsit/qhsitdata/system04.dbf
5    /datavg15/qhsit/qhsitdata/system05.dbf
6    /datavg15/qhsit/qhsitdata/rbs01.dbf
…
…
之后将路径全部替换为目标数据库数据文件路径
如
FILE# NAME
1    /datavg45/qhbak/qhtestdata/system01.dbf
2    /datavg45/qhbak/qhtestdata/system02.dbf
3    /datavg45/qhbak/qhtestdata/system03.dbf
4    /datavg45/qhbak/qhtestdata/system04.dbf
5    /datavg45/qhbak/qhtestdata/system05.dbf
6    /datavg45/qhbak/qhtestdata/rbs01.dbf
…
…
再将每行都改成
set newname for datafile    1   to  '/datavg45/qhbak/qhtestdata/system01.dbf';
set newname for datafile    2   to  '/datavg45/qhbak/qhtestdata/system02.dbf';
set newname for datafile    3   to  '/datavg45/qhbak/qhtestdata/system03.dbf';
set newname for datafile    4   to  '/datavg45/qhbak/qhtestdata/system04.dbf';
set newname for datafile    5   to  '/datavg45/qhbak/qhtestdata/system05.dbf';
set newname for datafile    6   to  '/datavg45/qhbak/qhtestdata/rbs01.dbf';
…
…
改后保存，后面备用。

10：Restore数据文件
从原数据库连接到目标数据库
oraqhsit:/home/oraqhsit >rman target / auxiliary sys/manager@qhtest

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: QHSIT (DBID=2864491865)
connected to auxiliary database: QHTEST (not mounted)
RMAN>

之后恢复数据文件：
RMAN>run{
set newname for datafile    1   to  '/datavg45/qhbak/qhtestdata/system01.dbf';
set newname for datafile    2   to  '/datavg45/qhbak/qhtestdata/system02.dbf';
set newname for datafile    3   to  '/datavg45/qhbak/qhtestdata/system03.dbf';
set newname for datafile    4   to  '/datavg45/qhbak/qhtestdata/system04.dbf';
…
…
…
set newname for datafile    419 to  '/datavg45/qhbak/qhtestdata/interim.dbf';
set newname for datafile    420 to  '/datavg45/qhbak/qhtestdata/applsysd03.dbf';
set newname for datafile    421 to  '/datavg45/qhbak/qhtestdata/pstat01.dbf';
restore
check readonly
clone database
;
}
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 08-JUL-09

using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00010 to /datavg45/qhbak/qhtestdata/abmx01.dbf
restoring datafile 00029 to /datavg45/qhbak/qhtestdata/asod01.dbf
restoring datafile 00034 to /datavg45/qhbak/qhtestdata/axx01.dbf
…
…
…
restoring datafile 00391 to /datavg45/qhbak/qhtestdata/fpad01.dbf
restoring datafile 00401 to /datavg45/qhbak/qhtestdata/mstd01.dbf
restoring datafile 00409 to /datavg45/qhbak/qhtestdata/xnbd01.dbf
restoring datafile 00420 to /datavg45/qhbak/qhtestdata/applsysd03.dbf
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/datavg45/qhbak/rmanqhbak/db_1ekjlfu8 tag=TAG20090708T231333 params=NULL
channel ORA_AUX_DISK_1: restore complete
Finished restore at 08-JUL-09

11：创建controlfile
在原数据库里执行
SQL>alter database backup controlfile to trace;
将创建后的trc文件修改成目标数据库的控制文件，命名为trc.sql
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE SET DATABASE "QHTEST" RESETLOGS  NOARCHIVELOG
--  SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 16
    MAXLOGMEMBERS 5
    MAXDATAFILES 500
    MAXINSTANCES 1
    MAXLOGHISTORY 4537
LOGFILE
  GROUP 1 (
    '/datavg45/qhbak/qhtestdata/log01a.log',
    '/datavg45/qhbak/qhtestdata/log01b.log'
  ) SIZE 200M,
  GROUP 2 (
    '/datavg45/qhbak/qhtestdata/log02a.log',
    '/datavg45/qhbak/qhtestdata/log02b.log'
  ) SIZE 200M,
  GROUP 3 (
    '/datavg45/qhbak/qhtestdata/log03a.log',
    '/datavg45/qhbak/qhtestdata/log03b.log'
  ) SIZE 200M
-- STANDBY LOGFILE
DATAFILE
  '/datavg45/qhbak/qhtestdata/system01.dbf',
  '/datavg45/qhbak/qhtestdata/system02.dbf',
  '/datavg45/qhbak/qhtestdata/system03.dbf',
  '/datavg45/qhbak/qhtestdata/system04.dbf',
  '/datavg45/qhbak/qhtestdata/system05.dbf',
  '/datavg45/qhbak/qhtestdata/rbs01.dbf',
  …
    …
    …
  '/datavg45/qhbak/qhtestdata/zxd01.dbf',
  '/datavg45/qhbak/qhtestdata/zxx01.dbf',
  '/datavg45/qhbak/qhtestdata/interim.dbf',
  '/datavg45/qhbak/qhtestdata/applsysd03.dbf',
  '/datavg45/qhbak/qhtestdata/pstat01.dbf'
CHARACTER SET ZHS16GBK
;
ALTER DATABASE OPEN RESETLOGS;

ALTER TABLESPACE TEMP ADD TEMPFILE '/datavg45/qhbak/qhtestdata/temp03.dbf'
     SIZE 2000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE TEMP ADD TEMPFILE '/datavg45/qhbak/qhtestdata/temp02.dbf'
     SIZE 2000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE TEMP ADD TEMPFILE '/datavg45/qhbak/qhtestdata/temp01.dbf'
     SIZE 2000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE TEMP ADD TEMPFILE '/datavg45/qhbak/qhtestdata/temp04.dbf'
     SIZE 2000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE TEMP ADD TEMPFILE '/datavg45/qhbak/qhtestdata/temp05.dbf'
     SIZE 2000M REUSE AUTOEXTEND OFF;

12:重建目标数据库
root:/ >su - qhtest
[YOU HAVE NEW MAIL]
qhtest:/home/qhtest >ls
sqlnet.log  trc.sql
qhtest:/home/qhtest >sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Jul 8 23:52:57 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> @trc.sql
ORACLE instance started.

Total System Global Area  766478528 bytes
Fixed Size                   743616 bytes
Variable Size             218103808 bytes
Database Buffers          536870912 bytes
Redo Buffers               10760192 bytes

Control file created.

ORA-00279: change 9165762873357 generated at 07/08/2009 23:13:34 needed for
thread 1
ORA-00289: suggestion : /arch/qhprd/arch/1_652.dbf
ORA-00280: change 9165762873357 for thread 1 is in sequence #652


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00279: change 9165762886276 generated at 07/08/2009 23:21:46 needed for
thread 1
ORA-00289: suggestion : /arch/qhprd/arch/1_653.dbf
ORA-00280: change 9165762886276 for thread 1 is in sequence #653
ORA-00278: log file '/arch/qhprd/arch/1_652.dbf' no longer needed for this
recovery


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log '/arch/qhprd/arch/1_653.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

需要recover
SQL> shutdown abort
ORACLE instance shut down.
SQL> @trc.sql
ORACLE instance started.

Total System Global Area  766478528 bytes
Fixed Size                   743616 bytes
Variable Size             218103808 bytes
Database Buffers          536870912 bytes
Redo Buffers               10760192 bytes

Control file created.

ORA-00279: change 9165762886276 generated at 07/08/2009 23:21:46 needed for
thread 1
ORA-00289: suggestion : /arch/qhprd/arch/1_653.dbf
ORA-00280: change 9165762886276 for thread 1 is in sequence #653


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00279: change 9165762964600 generated at 07/08/2009 23:56:21 needed for
thread 1
ORA-00289: suggestion : /arch/qhprd/arch/1_654.dbf
ORA-00280: change 9165762964600 for thread 1 is in sequence #654
ORA-00278: log file '/arch/qhprd/arch/1_653.dbf' no longer needed for this
recovery


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log 'SIZE'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-00279: change 9165762967781 generated at 07/08/2009 23:56:31 needed for
thread 1
ORA-00289: suggestion : /arch/qhprd/arch/1_655.dbf
ORA-00280: change 9165762967781 for thread 1 is in sequence #655
ORA-00278: log file '/arch/qhprd/arch/1_654.dbf' no longer needed for this
recovery


Specify log: {=suggested | filename | AUTO | CANCEL}
/arch/qhprd/arch/1_654.dbf
ORA-00310: archived log contains sequence 654; sequence 655 required
ORA-00334: archived log: '/arch/qhprd/arch/1_654.dbf'

对数据库进行recover
SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

提示需要用control file去recover，再次recover
SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 9165762967781 generated at 07/08/2009 23:56:31 needed for
thread 1
ORA-00289: suggestion : /arch/qhprd/arch/1_655.dbf
ORA-00280: change 9165762967781 for thread 1 is in sequence #655


Specify log: {=suggested | filename | AUTO | CANCEL}
/arch/qhprd/arch/1_654.dbf
ORA-00310: archived log contains sequence 654; sequence 655 required
ORA-00334: archived log: '/arch/qhprd/arch/1_654.dbf'

SQL> alter database open resetlogs;

Database altered.

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

Total System Global Area  766478528 bytes
Fixed Size                   743616 bytes
Variable Size             218103808 bytes
Database Buffers          536870912 bytes
Redo Buffers               10760192 bytes
Database mounted.
Database opened.


至此，数据库恢复完成，登陆检查数据

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13561774/viewspace-608692/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13561774/viewspace-608692/

cp18242360613
关注
RMAN复制目标数据库的理论知识
绿杨
04-09 235
原 RMAN 复制目标数据库的理论知识https://blog.csdn.net/tianlesoftware/article/details/5746812版权声明： https://blog.csdn.net/tianlesoftware/article/details/5746812 一． RMAN 复制的基础 1.1 使用RMAN 复制的原因 RMAN 复制是必须的。 我们可以只将控制文件...
Oracle数据库管理知识及RMAN概念.pptx
02-06
在RMAN中，`COPY`命令用于复制数据库文件，而`BACKUP`命令用于备份整个数据库、特定表空间、控制文件或日志文件。备份数据被组织成备份集（BACKUP SET），每个备份集可以包含多个数据片（BACKUP PIECE）。备份集是一...
转贴：RMAN备份脚本(Unix)
cuixie2370的博客
02-13 111
注意:此文档是本人由网络资料整理而成 备份策略: 星期天 0 级 星期一,二,四,五六 2 级 星期三 1 级 --本地 mkdir /home/oracle/backupmkdir /home/oracle/bac...
unix、linux oracle rman导出脚本
clp9519084的博客
07-29 117
::说明:这个脚本是在oracle监听不可以正常使用的情况下使用。:或者是直接手动备份oracle数据库时使用。==========================================================...
hpunix+rman备份
u012232730的博客
09-29 407
在asm下创建备份目录 alter diskgroup DATA add directory '+DATA/fullback'; alter diskgroup DATA add directory '+DATA/addback'; 切换到grid用户下才可查看目录 1、su - grid 2、asmcmd 3、ls 4、cd DATA 5、ls oracle用户下没有权限执行cron...
Linux基本操作及数据库查询
github_phpnobug的博客
07-18 490
Linux命令文件、目录操作 touch rm -rf mv cp目录： mkdir rm -rf mv cp -r 编辑文件： vim 命令模式 hjkl yy 复制 nyy 复制多行 dd 删除
unix mysql命令大全_mysql命令行常用命令
weixin_39641876的博客
01-19 150
mysql命令行常用命令(转)第一招、mysql服务的启动和停止net stop mysqlnet start mysql第二招、登陆mysql语法如下： mysql -u用户名 -p用户密码键入命令mysql -uroot -p， 回车后提示你输入密码，输入12345，然后回车即可进入到mysql中了，mysql的提示符是：mysql>注意，如果是连接到另外的机器上，则需要加入一个参数-h...
如何在UNIX下自动备份Oracle数据库.doc
10-03
在UNIX环境下自动备份Oracle数据库是一项重要的系统管理任务，旨在确保数据的安全性和可恢复性。以下是一些关于如何实现这一目标的关键知识点： 1. **Oracle Export备份**：Oracle数据库提供了Export工具，它允许...
mysql数据库管理常用命令
weixin_30256505的博客
05-13 349
MySQL数据库管理常用命令root密码管理 设置root用户的密码 mysqladmin -uroot password 'password'修改root用户的密码 mysqladmin -uroot -p password 'password'　数据库，表管理 进入mysql mysql -h hostname -uroot -p创建...
Linux/Unix shell 脚本中调用SQL,RMAN脚本
热门推荐
乐沙弥的世界
09-11 2万+
Linux/Unix shell脚本中调用或执行SQL,RMAN 等为自动化作业以及多次反复执行提供了极大的便利，因此通过Linux/Unix shell来完成Oracle的相关工作，也是DBA必不可少的技能之一。本文针对Linux/Unix shell脚本调用sql, rman 脚本给出了相关示例。 一、由shell脚本调用sql,rman脚本1、shell脚本调用sql脚本 #首先编辑sql
MTK平台下用Socket如何实现HTTP请求
soft_fa的专栏
10-28 3194
MTK平台用Socket实现HTTP请求过程是本文要介绍的内容，主要是来了解并学习MTK平台的应用，通过MTK平台中数据的请求的案例，来学习MTK平台的应用，具体内容的实现来看本文详解。 一、MTK平台Socket联网过程 熟悉PC机编程的人都知道，Socket编程接口分两套：TCP和UDP；TCP和UDP中又有服务器端和客户端的概念，这里讲的是TCP的客户端编程接口。 MTK平
Unix-Linux操作系统中如何在sqlplus-rman中使用方向键
ff55fff的博客
09-04 449
默认情况下在Unix/Linux中使用Oracle的sqlplus/rman是无法使用↑↓←→几个方向键进行操作的，要想达到Windows下使用sqlplus/rman的效果需要安装rlwrap。 rlwrap依赖readline，可以使用rpm -q readline readline-devel 查看系统中是否安装有readline和readline-devel，如果没有的话需要使用yum
spring事务详细讲解-深入浅出
小电玩
09-08 497
Spring 事务是本身就是对数据库的事务的支持，没有数据库的事务 Spring 是本身无法实现事务的。Spring只提供了统一事务管理接口，具体的实现还是由各数据库自己实现。在使用 Spring 事务时，可以通过注解或编程方式将需要进行事务管理的方法和代码块标记为事务性操作，当这些操作被执行时，Spring 会负责开启时根据当前环境中设置的隔离级别，调整数据库隔离级别。
【提效工具】AI工作流的1-10个实际落地场景
最新发布
万物皆有灵
09-09 1138
在这个快速发展的数字时代，人工智能（AI）正在以惊人的速度改变我们的工作方式。无论你是开发者、教育工作者还是内容创作者，AI工作流提示词助手都能为你提供无与伦比的支持。今天，我们将深入探讨，20个实际落地场景，帮助你更好地理解如何利用这些工具提升工作效率和创造力。💡。
jmeter之setUP、tearDown线程组
回家吃月饼的学习交流地
09-07 607
jmeter之setUP、tearDown线程组的使用
问题： java.sql.SQLException：The server time zone value ‘�й���׼ʱ��‘
m0_74293254的博客
09-08 337
译文: Mybatis Plus服务器时区值“h”无法识别或表示多个时区。如果希望利用时区支持，必须配置服务器或JDBC驱动程序(通过serverTimezone配置属性)以使用更具体的时区值。出现上述问题后，一般为数据库连接的url地址配置中，没有配置时区serverTimezone=UTC或配置错误，修改下即可。
基于SpringBoot的旅游管理系统
heye0910032的博客
09-08 474
随着科技的发展，旅游管理系统的信息化成为提升旅游服务效率的关键。本系统采用JSP技术和SpringBoot框架，结合MySQL数据库，旨在实现一个功能全面、操作简便、安全可靠的旅游管理平台。系统通过需求分析、系统设计、功能实现和测试，确保了良好的用户体验和数据处理能力，为旅游业务的现代化管理提供了强有力的技术支持。本研究成功开发了一个基于SpringBoot的旅游管理系统，该系统通过集成多种旅游管理功能，显著提高了旅游服务的效率和质量。系统的用户友好界面和强大的后端功能，使得管理员和用户都能从中受益。
Oracle RMAN详解：数据库备份与恢复工具
COPY命令直接复制数据库文件，而BACKUP命令创建逻辑备份集，这些备份集由一个或多个物理数据片组成。每个数据文件不能跨越备份集，但可以跨越数据片。备份策略的这种设计使得恢复过程更为高效。 RMAN的运行环境可以...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值