oracle 日志注册,ALTER DATABASE REGISTER LOGFILE 手工注册日志测试

ALTER DATABASE REGISTER LOGFILE 手工注册日志测试[@more@]

不设置 log2

手工同步arc

ALTER DATABASE REGISTER LOGFILE '/trunkbow/oracle/oradata/mmcdb/archive/1_6.dbf';

SQL> create user wrj identified by wrj;

User created.

SQL>

SQL>

SQL> grant dba,connect,resource to wrj;

Grant succeeded.

SQL> grant unlimited tablespace to wrj;

Grant succeeded.

SQL> connect wrj/wrj;

Connected.

SQL> create table test1 as select * from dba_objects;

Table created.

SQL>

SQL>

SQL>

SQL> alter system switch logfile;

System altered.

SQL> connect / as sysdba

Connected.

SQL>

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /trunkbow/oracle/oradata/mmcdb/archive

Oldest online log sequence 5

Next log sequence to archive 7

Current log sequence 7

ftp 172.150.34.17

Connected to 172.150.34.17.

220 MMC-APP-1 FTP server ready.

Name (172.150.34.17:oracle): oracle

331 Password required for oracle.

Password:

230 User oracle logged in.

Remote system type is UNIX.

Using binary mode to transfer files.