oracle学习第五天【RMAN】
启动rman的2种方法
1
C:\Documents and Settings\Administrator>rman
恢复管理器: 版本10.1.0.2.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
RMAN> connect target /
连接到目标数据库: ORCL (DBID=1268391944)
RMAN>
2
C:\Documents and Settings\Administrator>rman target /
恢复管理器: 版本10.1.0.2.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
连接到目标数据库: ORCL (DBID=1268391944)
修改sys和system用户的密码
SQL> conn /as sysdba
已连接。
SQL> alter user system identified by feng ;
用户已更改。
SQL> conn system/feng;
已连接。
SQL> alter user sys identified by feng;
用户已更改。
3连接远程数据库
C:\Documents and Settings\Administrator>rman target system/feng@orcl
恢复管理器: 版本10.1.0.2.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
连接到目标数据库: ORCL (DBID=1268391944)
RMAN>
执行操作系统命令
RMAN> host;
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>
执行sql命令
RMAN> sql 'alter system archive log all';
RMAN> backup database;
RMAN> backup database format 'j:\oracle\bak_%u';
RMAN> backup tablespace system;
sql> select file_id,file_name from dba_data_files;
RMAN> backup datafile 'j:\oracle\BAK_0QMDI87G';
RMAN> backup current controlfile;
RMAN> backup archivelog all;
RMAN> backup spfile;
RMAN> backup backupset all;
RMAN> backup backupset n;
RMAN> list backup of database;
RMAN> list backup of tablespace users;
RMAN> delete backupset n;
RMAN> show all;
RMAN> list backup;
RMAN> list backup of controlfile;
RMAN> report need backup;
RMAN> report obsolete;
RMAN> crosscheck archivelog all;
RMAN> crosscheck backup;
RMAN> change backup of tablespace system unavailable;
RMAN>
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步