从SEED种子数据库还原出其他库

最新推荐文章于 2024-03-17 21:33:15 发布
最新推荐文章于 2024-03-17 21:33:15 发布
阅读量258 收藏
点赞数
文章标签： 数据库 网络

--准备参数文件，还原后的库名称为gz
[root@RAC1 ~]# su - oracle
[oracle@RAC1 ~]$cd $ORACLE_HOME/dbs
[oracle@RAC1 dbs]$ cat init.ora | grep -v ^# | grep -v ^$ > initgz.ora
 [oracle@RAC1 dbs]$ vi initgz.ora
db_name='gz'
sga_target=500m
processes = 150
audit_file_dest='/u01/app/oracle/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
                                                                     
[oracle@RAC1 dbs]$ export ORACLE_SID=gz
[oracle@RAC1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 04:50:33 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> exit
Disconnected

--修改控制文件位置
 [oracle@RAC1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 04:50:44 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2229944 bytes
Variable Size             159385928 bytes
Database Buffers          352321536 bytes
Redo Buffers                7999488 bytes
SQL> show parameter control

NAME                                           TYPE                     VALUE
------------------------------------         ----------------------  ------------------------------
control_file_record_keep_time        integer                    7
control_files                                 string                       /u01/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control1, 
                                                                                 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control2
control_management_pack_access   string                     DIAGNOSTIC+TUNING

SQL> alter system set control_files='/u01/app/oracle/oradata/gz/control01.ctl' scope=spfile;

System altered.

SQL> shutdown abort;
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

--从dbca模板复制control文件
[oracle@RAC1 dbs]$ cd $ORACLE_HOME/assistants/dbca/templates/
[oracle@RAC1 templates]$ ls
Data_Warehouse.dbc   New_Database.dbt   Seed_Database.dfb  example01.dfb
General_Purpose.dbc  Seed_Database.ctl  example.dmp
[oracle@RAC1 templates]$ mkdir -p /u01/app/oracle/oradata/gz
[oracle@RAC1 templates]$ cp Seed_Database.ctl /u01/app/oracle/oradata/gz/control01.ctl
[oracle@RAC1 templates]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 04:54:01 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup mount;
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2229944 bytes
Variable Size             159385928 bytes
Database Buffers          352321536 bytes
Redo Buffers                7999488 bytes
ORA-01103: database name 'SEEDDATA' in control file is not 'GZ'

SQL> create pfile from spfile;

File created.

SQL> shutdown abort;
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

--修改数据库名为SEEDDATA
[oracle@RAC1 templates]$ cd $ORACLE_HOME/dbs
[oracle@RAC1 dbs]$ cp initgz.ora initSEEDDATA.ora
[oracle@RAC1 dbs]$ vi initSEEDDATA.ora
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0'
*.control_files='/u01/app/oracle/oradata/gz/control01.ctl'
*.db_block_size=8192
*.db_name='SEEDDATA'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2G
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=500m
*.undo_tablespace='UNDOTBS1'
[oracle@RAC1 dbs]$ export ORACLE_SID=SEEDDATA
[oracle@RAC1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 04:56:23 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> exit
Disconnected
                                                               
[oracle@RAC1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 04:57:48 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup mount;
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2229944 bytes
Variable Size             159385928 bytes
Database Buffers          352321536 bytes
Redo Buffers                7999488 bytes
Database mounted.
SQL> select file#,name from v$datafile;

     FILE# NAME
---------- ----------------------------------------
         1 /ade/b/385031636/oracle/oradata/seeddata/system01.dbf
         2 /ade/b/385031636/oracle/oradata/seeddata/sysaux01.dbf
         3 /ade/b/385031636/oracle/oradata/seeddata/undotbs01.dbf
         4 /ade/b/385031636/oracle/oradata/seeddata/users01.dbf

--修改redo log文件位置
SQL> select * from v$logfile;

    GROUP# STATUS         TYPE             MEMBER                                                IS_REC
---------- -------------- --------------  ------------------------------------------------------ ------
         1                ONLINE          /ade/b/385031636/oracle/oradata/seeddata/redo01.log     NO
         2                ONLINE          /ade/b/385031636/oracle/oradata/seeddata/redo02.log     NO
         3                ONLINE          /ade/b/385031636/oracle/oradata/seeddata/redo03.log     NO

SQL> alter database rename file '/ade/b/385031636/oracle/oradata/seeddata/redo01.log' to '/u01/app/oracle/oradata/gz/redo01.log';

Database altered.

SQL> alter database rename file '/ade/b/385031636/oracle/oradata/seeddata/redo02.log' to '/u01/app/oracle/oradata/gz/redo02.log';

Database altered.

SQL> alter database rename file '/ade/b/385031636/oracle/oradata/seeddata/redo03.log' to '/u01/app/oracle/oradata/gz/redo03.log';

Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

--注册SEED备份片并还原
[oracle@RAC1 dbs]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jul 20 05:09:21 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SEEDDATA (DBID=4090761500, not open)

RMAN> catalog start with '/u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb';

searching for all files that match the pattern /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb

List of Files Unknown to the Database
=====================================
File Name: /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb


--还原并恢复
RMAN> run
2> {set newname for datafile 1 to '/u01/app/oracle/oradata/gz/system01.dbf';
3> set newname for datafile 2 to '/u01/app/oracle/oradata/gz/sysaux01.dbf';
4> set newname for datafile 3 to '/u01/app/oracle/oradata/gz/undotbs01.dbf';
5> set newname for datafile 4 to '/u01/app/oracle/oradata/gz/user01.dbf';
6> restore database;
7> switch datafile all;
8> recover database;
9> }

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 20-JUL-13
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/gz/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/gz/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/gz/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/gz/user01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb
channel ORA_DISK_1: piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb tag=NULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 20-JUL-13

datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=821253781 file name=/u01/app/oracle/oradata/gz/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=821253782 file name=/u01/app/oracle/oradata/gz/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=821253782 file name=/u01/app/oracle/oradata/gz/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=821253782 file name=/u01/app/oracle/oradata/gz/user01.dbf

Starting recover at 20-JUL-13
using channel ORA_DISK_1

starting media recovery

RMAN-08187: WARNING: media recovery until SCN 995547 complete
Finished recover at 20-JUL-13

RMAN> exit

Recovery Manager complete.


--打开数据库,增加临时表空间
[oracle@RAC1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 06:03:20 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database open resetlogs;

Database altered.


--增加临时表空间
SQL> select name from v$tempfile;

NAME
----------------------------------------
/ade/b/385031636/oracle/oradata/seeddata/temp01.dbf


SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS

SQL> create temporary tablespace temp01 tempfile '/u01/app/oracle/oradata/gz/temp01.dbf' size 100m;

Tablespace created.

SQL> alter database default temporary tablespace temp01;

Database altered.

SQL> drop tablespace temp including contents and datafiles;

Tablespace dropped.

SQL> create pfile from spfile;

File created.

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


--数据库改名为gz
SQL> startup mount;
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2229944 bytes
Variable Size             159385928 bytes
Database Buffers          352321536 bytes
Redo Buffers                7999488 bytes
Database mounted.
SQL> !nid target=sys/oracle dbname=gz

DBNEWID: Release 11.2.0.3.0 - Production on Sat Jul 20 06:07:50 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to database SEEDDATA (DBID=4090761500)

Connected to server version 11.2.0

Control Files in database:
    /u01/app/oracle/oradata/gz/control01.ctl

Change database ID and database name SEEDDATA to GZ? (Y/[N]) => y

Proceeding with operation
Changing database ID from 4090761500 to 3321831351
Changing database name from SEEDDATA to GZ
    Control File /u01/app/oracle/oradata/gz/control01.ctl - modified
    Datafile /u01/app/oracle/oradata/gz/system01.db - dbid changed, wrote new name
    Datafile /u01/app/oracle/oradata/gz/sysaux01.db - dbid changed, wrote new name
    Datafile /u01/app/oracle/oradata/gz/undotbs01.db - dbid changed, wrote new name
    Datafile /u01/app/oracle/oradata/gz/user01.db - dbid changed, wrote new name
    Datafile /u01/app/oracle/oradata/gz/temp01.db - dbid changed, wrote new name
    Control File /u01/app/oracle/oradata/gz/control01.ctl - dbid changed, wrote new name
    Instance shut down

Database name changed to GZ.
Modify parameter file and generate a new password file before restarting.
Database ID for database GZ changed to 3321831351.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

--修改参数文件,将库名改为gz
[oracle@RAC1 ~]$ cd $ORACLE_HOME/dbs
[oracle@RAC1 dbs]$ cp initSEEDDATA.ora initgz.ora
[oracle@RAC1 dbs]$ vi initgz.ora
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0'
*.control_files='/u01/app/oracle/oradata/gz/control01.ctl'
*.db_block_size=8192
*.db_name='gz'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2G
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=500m
*.undo_tablespace='UNDOTBS1'
[oracle@RAC1 dbs]$ export ORACLE_SID=gz


--检查数据库改名是否成功
[oracle@RAC1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 06:09:43 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initgz.ora';
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2229944 bytes
Variable Size             159385928 bytes
Database Buffers          352321536 bytes
Redo Buffers                7999488 bytes
SQL> set line 120
SQL> show parameter name

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
db_file_name_convert                 string
db_name                              string                 gz
db_unique_name                       string                 gz
global_names                         boolean                FALSE
instance_name                        string                 gz
lock_name_space                      string
log_file_name_convert                string
processor_group_name                 string
service_names                        string                 gz
SQL> alter database mount;

Database altered.

SQL> alter database open resetlogs;

Database altered.

SQL> col name for a50
SQL> select name,status from v$datafile;

NAME                                               STATUS
-------------------------------------------------- --------------
/u01/app/oracle/oradata/gz/system01.dbf            SYSTEM
/u01/app/oracle/oradata/gz/sysaux01.dbf            ONLINE
/u01/app/oracle/oradata/gz/undotbs01.dbf           ONLINE
/u01/app/oracle/oradata/gz/user01.dbf              ONLINE

SQL> select name,status from v$tempfile;

NAME                                               STATUS
-------------------------------------------------- --------------
/u01/app/oracle/oradata/gz/temp01.dbf              ONLINE

SQL> create spfile from pfile;

File created.

至此，已经通过SEED种子数据库还原出库gz。

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

转载于:http://blog.itpub.net/429786/viewspace-776255/

cuiwu7783
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
【脑机接口】利用MNE进行EEG数据预处理（SEED数据集）
Bug仓库
05-16 3215
简单写下毕设里用到的预处理步骤
学习札记——seed方法构建初始数据库
weixin_33918114的博客
04-17 275
首先在ruby on rails 工程中db目录下的seeds.rb文件中写入如下代码require 'active_record/fixtures'require 'yaml'require 'erb'require 'zlib'YAML::ENGINE.yamler= 'syck'Dir.foreach("#{Rails.root}/db/fixtures/").each...
SEED数据集
最新发布
Hvhvhvjvhvhv的博客
03-17 1022
SEED数据集中ExtractedFeatures_4s与ExtractedFeatures_1s文件夹中一些数据的解释（这里大多以1_20131027.mat文件为例）1、数组文件名称（试验者名字 + 电影片段序列）以1_20131027.mat文件为例，这是第一个数据，采集于2013年10月27日。2、单个数组名称（大多采用“预处理方法 + 过滤方法 + 影片序号”）(1)psd：提取功率谱密度(2)asm：不对称(3)Dasm：微分不对称(4)Dcau：微分因果性(5)Rasm：有理不对称。
学习札记——seed方法构建初始数据库（脚本改进版）
weixin_33834075的博客
05-15 240
前些日子，写了个关于构建大量数据的rake脚本，但是同事们反映，每次都全部重新构建很老火，能不能有单个表单构建呢？有demand就有市场，今天突然来了性子，我的基本思路就是想办法获取到seed后面参数，于是按这个思路，网上google一把，寻得一法子链接http://stackoverflow.com/questions/14450434/can-i-pass-an-argu...
SEED：基于SEED数据集的理解
qq_49288362的博客
03-16 1701
研究影响情绪关键频段和信道，选择了4、6、9、12个通道进行实验。1.与积极、中性和消极情绪相关的神经特征确实存在，并且他们在不同个体之间存在共性。2.30次实验，即在两次不同的时间进行实验。研究情绪识别中的脑电图稳定性。1.调查了三种情绪的稳定神经模式。2.在研究情绪识别任务中，还应该考虑性别、年龄和种族等重要因素。
firestore-seed：Cloud Firestore的种子数据库
02-05
firestore-seed将初始种子数据插入。 根本没有测试。 自行使用。 入门 将firestore-seed添加到您的项目。 $ yarn add firestore-seed 创建一个简单的种子程序。 const admin = require ( "firebase-admin" ) ; /...
seed_seed_种子蔓延法%2_
09-30
在这个场景中，"seed_seed_种子蔓延法%2_"的标题可能指的是用户在其他平台上找到了一个种子蔓延算法的实现，但该实现可能未进行优化，导致在洪水模拟中运行效率低下。他们希望有经验的开发者能提供改进意见或指导。 ...
seed:种子项目的存储库
07-18
6. **测试框架**：为了确保代码质量，种子项目可能集成了JUnit或其他测试框架，以及Mockito等模拟库，便于编写单元测试和集成测试。 7. **持续集成/持续部署(CI/CD)**：种子项目可能已经配置了Jenkins、GitLab CI/...
SeedDatabase:植物种子数据库
06-09
《构建与应用：Java驱动的SeedDatabase植物种子数据库》 在信息技术日新月异的今天，数据管理成为了各个领域不可或缺的一部分。特别是在生物学、生态学等领域，对于植物种子的研究与保存，一个高效、全面的数据库...
安卓操作系统下SEED分布式数据库在大数据中的应用.docx
05-06
【正文】 ...借助SEED的强大硬件性能和广泛的市场适应性，以及SQLite数据库的易用性和高效性，我们能够在智能家居和其他嵌入式设备中实现大数据的有效管理和应用，推动智能移动设备和物联网的发展。
EEG代码实践：SEED数据集解读与批量读取
SashiMoore的博客
08-11 4436
SJTU 情感脑电数据集（SEED）是由BCMI实验室提供的EEG数据集的集合
详解SEED数据服务平台(5)：批改与批注
manfukeji的博客
08-05 1143
上一期内容中，我们介绍了标注工作流中，如何通过编辑与修改标注对象，以提升整体数据准确率： 详解SEED数据服务平台(4)：修改与编辑 SEED数据服务平台默认提供三层工作流模式：标注-审核-质检。在标注流程中，平台提供如上文所述的修改与编辑功能，协助标注员完成标注结果自检与更正。 而在审核与质检工作流中，SEED数据服务平台则提供批改与批注功能，协助审核员与质检员完成内容审核及校对，同时在工作流协同中实现对校对结果的实时同步更新。 一.批改基础设置 在项目发布执行前，可在SEED数据服务平台内完成批改规则相
一文详细介绍情绪识别常用的数据集
丶夜未央丶的博客
10-27 1万+
一文详细介绍情绪识别常用的数据集SEED 本文详细介绍了脑机接口情绪识别常用的数据集，主要有SEED, SEED-IV, SEED-V, DEAP, CIAIC。 SEED SEED数据集下载地址 SEED数据集不开放给个人使用，若想使用必须写申请。 ...
上海交大情感脑电数据集(SJTU Emotion EEG Dataset，SEED)
热门推荐
脑机接口社区
05-05 1万+
目录SEED数据集介绍1、刺激与实验2、受试者（subjects）3、数据集摘要 SJTU 情感脑电数据集（SEED）是由BCMI实验室提供的EEG数据集的集合，该实验室由路宝良教授领导 。 SEED数据集介绍 SEED数据集包含对象观看电影剪辑时的脑电信号。仔细选择影片剪辑，以引起不同类型的情感，包括积极（positive），消极（negative）和中性(neutral)的情感。 1、刺激与...
用PDB$SEED创建pdb数据库
qq_37837054的博客
03-10 877
用PDB$SEED创建pdb数据库
ORA-27037--重建控制文件的时候报错
diaoyuxuan1161的博客
05-15 1732
<txt>ORA-00210: cannot open the specified control fileORA-00202: control file: &apos;/u01/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control02.ctl&apos;ORA-27037: unable to obtain ...
oracle 手动配置库,Oracle手动建库安装部署超详细教程
weixin_31545685的博客
04-03 295
手动创建PROD数据库步骤1 指定SIDOracle_SID是用于区别数据库实例的环境变量。ORACLE_SID=prodexport ORACLE_SID步骤2 确定Oracle环境的环境变量在操作系统平台下，Oracle_SID和ORACLE_HOME必须指定，建议指定PATH包含ORACLE_HOME/bin目录。环境变量的实际操作如下:创建数据目录和审计目录:[oracle@db1 ora...
oracle 服务基本操作，启动，停止 故障处理
hknaruto的专栏
10-13 2656
oracle 服务基本操作，启动，停止 lsnrctl start lsnrctl stop vncserver license 问题 注册license [sql] view plaincopy     hadoop@master-server:~/VNC-5.0.5-Linux-x86$ sudo ./vnclicense       VNC(R) Licen
介绍一下seed数据库
07-10
Seed数据库通常用于初始化和填充其他数据库，或者作为辅助数据库来支持特定的应用程序或任务。它可以包含各种类型的数据，如用户信息、产品信息、地理位置、时间序列数据等。 Seed数据库的主要目的是提供一个起点，...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值