oracle rman 脚本还原,Oracle 的Rman 极速还原备份自用脚本

不念不忘少年蓝@ 2022-10-21 01:19 195阅读 0赞

shutdown immediate;

startup nomount;

restore controlfile from 'D:\\dbback\\ .CTL';

alter database mount;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK clear;

CONFIGURE CHANNEL DEVICE TYPE DISK clear;

catalog start with 'D:\\dbback';

YES

crosscheck backup;

delete expired backup ;

YES

crosscheck copy;

delete expired copy;

YES

crosscheck archivelog all;

delete expired archivelog all;

YES

report schema;

run \{

set newname for datafile 1 to 'D:\\app\\Administrator\\oradata\\YMS\\SYSTEM01.DBF';

set newname for datafile 2 to 'D:\\app\\Administrator\\oradata\\YMS\\SYSAUX01.DBF';

set newname for datafile 3 to 'D:\\app\\Administrator\\oradata\\YMS\\UNDOTBS01.DBF';

set newname for datafile 4 to 'D:\\app\\Administrator\\oradata\\YMS\\USERS01.DBF';

set newname for datafile 5 to 'D:\\app\\Administrator\\oradata\\YMS\\UNDOTBS02.DBF';

set newname for datafile 6 to 'D:\\app\\Administrator\\oradata\\YMS\\SYSTEM02.DBF';

set newname for datafile 7 to 'D:\\app\\Administrator\\oradata\\YMS\\SYSTEM03.DBF';

set newname for datafile 8 to 'D:\\app\\Administrator\\oradata\\YMS\\SYSAUX02.DBF';

set newname for datafile 9 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_DATA01.DBF';

set newname for datafile 10 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_DATA02.DBF';

set newname for datafile 11 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_DATA03.DBF';

set newname for datafile 12 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_IDX01.DBF';

set newname for datafile 13 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_IDX02.DBF';

set newname for datafile 14 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_DATA04.DBF';

set newname for datafile 15 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_DATA05.DBF';

set newname for datafile 16 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_DATA06.DBF';

set newname for datafile 17 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_DATA07.DBF';

set newname for datafile 18 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_DATA08.DBF';

set newname for datafile 19 to 'D:\\app\\Administrator\\oradata\\YMS\\YMS\_DATA09.DBF';

restore database;

switch datafile all;

recover database;

\--sqlplus:

alter database noarchivelog;

alter system set sessions=1000 scope=spfile;

alter database rename file 'M:\\ORADATA\\YMS\\REDO01.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO01.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO02.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO02.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO03.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO03.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO04.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO04.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO05.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO05.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO06.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO06.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO07.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO07.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO08.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO08.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO08.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO09.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO01B.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO01B.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO02B.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO02B.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO03B.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO03B.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO04B.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO04B.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO05B.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO05B.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO06B.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO06B.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO07B.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO07B.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO08B.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO08B.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\REDO09B.LOG' to 'D:\\app\\Administrator\\oradata\\YMS\\REDO09B.LOG';

alter database rename file 'M:\\ORADATA\\YMS\\TEMP01.DBF' to 'D:\\app\\Administrator\\oradata\\YMS\\TEMP01.DBF';

alter database rename file 'M:\\ORADATA\\YMS\\TEMP02.DBF' to 'D:\\app\\Administrator\\oradata\\YMS\\TEMP02.DBF';

alter database open resetlogs;

\--1.更改用户名密码

update system.sys\_user set userpassword='heavenben' where userid='admin';

\--3.删除配置列表

delete from system.SYS\_UPDATELIST t where Lower(filename)='smartyms.exe.config';

delete from system.SYS\_UPDATELIST t where Lower(filename)='setup.ini';

\--3.提交更改。

commit;

\--4.创建数据库联接dblink

create database link yms16

connect to system identified by ymsoracle

using '(DESCRIPTION =

(ADDRESS\_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 223.223.80.16)(PORT = 1521))

)

(CONNECT\_DATA =

(SERVER = 223.223.80.16)

(SERVICE\_NAME = YMS)

)

)';

oracle rman 脚本还原,Oracle 的Rman 极速还原备份自用脚本

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Oracle 11g EXPDP、RMAN自动备份SHELL脚本

相关 Oracle 11g RMAN multiplexing 备份脚本

相关 linux下的rman自动备份脚本,linux rman 自动备份脚本

相关 oracle rman 冷备,oracle rman冷备shell脚本

相关 oracle rman本地备份,Oracle 11g RMAN备份-基本操作

相关 oracle rman 脚本还原,Oracle 的Rman 极速还原备份自用脚本

相关 Oracle RMAN 增量备份

相关 Oracle数据库RMAN的自动备份脚本

相关 Oracle rman 自动备份脚本

相关 RMAN Oracle数据库备份