暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

NBU测试记录

原创 t_heik 2022-07-25
542


1、修改oraparam.ini文件

  到install目录中找到oraparam.ini文件,添加如下内容:

[Certified Versions]  #You can customise error message shown for failure, provide value

for

CERTIFIED_VERSION_FAILURE_MESSAGE  #Windows=5.0,5.1,5.2,6.0    #这里前面部分内容有的,只添加6.0

 

2、$ORACLE_BASE\admin\orcl\bdump\alter_实例名;  排错日志;

$ORACLE_HOME:  C:\oracle\product\10.2.0\db_1

$ORACLE_BASE: C:\oracle\product\10.2.0

 

 

C:\Users\Administrator>sqlplus

 

SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 10 09:37:10 2013

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

Enter user-name:

C:\Users\Administrator>netca

 

Oracle Net Services 配置:

正在配置监听程序:LISTENER

默认本地命名配置完成。

监听程序配置完成。

Oracle Net 监听程序启动:

正在运行监听程序控制:

      C:\oracle\product\10.2.0\db_1\bin\lsnrctl start LISTENER

   监听程序控制完成。

监听程序已成功启动。

正在设置监听程序服务以便自动启动。

成功完成 Oracle Net Services 配置。退出代码是0

C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\   监听的配置文件:

listener.ora 监听端口:默认1521

tnsnames.ora    tnsping

 

 

 

C:\Users\Administrator>sqlplus sys/oracle@orcl as sysdba     网络方式登录;

 

SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 10 09:39:28 2013

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

 

 

Enter user-name:

C:\Users\Administrator>netca    //dbca  配置数据库

 

Oracle Net Services 配置:

默认本地命名配置完成。

已创建的 Net 服务名: orcl

成功完成 Oracle Net Services 配置。退出代码是0

 

 

 

 

C:\Users\Administrator>tnsping orcl

 

TNS Ping Utility for 64-bit Windows: Version 10.2.0.4.0 - Production on 10-MAY-2

013 09:40:53

 

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

 

Used parameter files:

C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)

(HOST = 192.168.1.123)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))

OK (0 msec)

 

C:\Users\Administrator>sqlplus sys/oracle@orcl as sysdba

 

SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 10 09:41:31 2013

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

 

???:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> select status from v$instance;

 

STATUS

------------

OPEN

 

SQL> select open_mode from v$database;

 

OPEN_MODE

----------

READ WRITE

 

SQL> arcive log list;

SP2-0734: ??????? "arcive log..." - ????????

SQL> archive log list;

???????             ?????

????             ??

????            USE_DB_RECOVERY_FILE_DEST

?????????     1

??????           2

SQL> shudown immedate

SP2-0734: ??????? "shudown im..." - ????????

SQL> shutdowm immediate

SP2-0734: ??????? "shutdowm i..." - ????????

SQL> shutdown immediate

????????

????????

ORACLE ???????

SQL> startup mount;

ORA-12514: TNS:listener does not currently know of service requested in connect

descriptor

SQL> quit

? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options ??

 

 

C:\Users\Administrator>sqlplus "/as sysdba"

 

SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 10 09:44:10 2013

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

Connected to an idle instance.

 

SQL> startup mount;

ORACLE instance started.

 

Total System Global Area 1258291200 bytes

Fixed Size                  2065408 bytes

Variable Size             318770176 bytes

Database Buffers          922746880 bytes

Redo Buffers               14708736 bytes

????????

SQL> alter database archivelog;

 

???????

 

SQL> alter database open;

 

Shutdown immediate 后,可用dbca删除数据库;

查看当前实例名称: select instance_name from v$instance;

 

 

4、 nbu支持linux:redhat、suse,以及redhat演变来的,以rpm方式安装的;

Unix:特别注意兼容性;   官网、安装包内install_win,release,有兼容列表;sort.symantec.com/

5、策略名称通用:

Policy: pl_sql_full

Pl_sql_tranlog

Pl_orcl_db

Pl_orcl_archlog

Storage units: stu_sql

Stu_orcl

Client scripts: c:\program files\Veritas\db_scripts\

6、policy schedules: type of backup:Automatic Backup启动备份,连接客户端,备份计划时间

Application Backup:调用备份脚本,开始备份操作;保留备份时间以这个为准;

7、查看客户端日志;  <install_path>\VERITAS\NetBackup\logs\

8、先有完整备份,才能单独备 translog、archivelog等归档日志;

 

 

9、Windows 下oracle备份:

开归档日志;

拷贝备份模版:C:\Program Files\Veritas\NetBackup\DbExt\Oracle\Samples\rman\hot_database_backup到db_scripts

编辑: @set ORACLE_HOME=C:\oracle\product\10.2.0\db_1

@set ORACLE_SID=orcl ;配置实例名称

@set TARGET_CONNECT_STR=/ ;设置登录账户,/表示系统账户登录,一般sys 和system 有备份权限;可用rman target /(或用户名密码) 测试能否登录进去;

Windows下| 不能把内容丢给后面的rman命令? 将run{}部分做成一个与bat同名的后缀rman文件吧; 排错:用rman 连进去后,运行run{} ;

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论