Oracle 学习笔记: RMAN常用命令
1 . set database to archivelog mode
Sql代码
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 251658240 bytes
Fixed Size 1248356 bytes
Variable Size 83887004 bytes
Database Buffers 159383552 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1319
Next log sequence to archive 1321
Current log sequence 13
相关文档：
1. use database as archive log mode and set archive dest location
alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION=/u04/arch/orcl' scope=spfile;
2. configuration retention days/size/distination
ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=43200; --30 days
ALTER SYSTEM SET db_recovery_file_dest_ ......
一.按英文字母排序:
select * from table order by nlssort(name,'NLS_SORT=schinese_pinyin_M');
二. 写一个SQL语句，查询选修了5门课程的学生学号和姓名（9分钟）
答：SQL语句如下：
select stu.sno, stu.sname
from student stu
where (select count(*) from s ......
4、对象依赖性
CREATE OR REPLACE TYPE Obj1 AS OBJECT (
f1 NUMBER,
f2 VARCHAR2(10),
f3 DATE
);
/
CREATE OR REPLACE TYPE Obj2 AS OBJECT (
f1 DATE,
f2 CHAR(1)
);
/
CREATE OR REPLACE TYPE Obj3 AS OBJECT (
a Obj1,
b Obj2
);
/
OBJ3依赖于OBJ ......
7、对象类型继承
对象类型实现允许我们创建一个基类型，或叫父类型，这种类型的属性或方法可以被另一个对象类型继承。然后可以创建一个子类型，或叫孩子类型，直接使用继承过来的属性或方法，或者用自己的属性和方法重写父类型的属性或方法。
INSTANTIABLE关键字表示我们可以从该类型中实例化或者创建对� ......
