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{} ;




