oracle10g的undrop功能一点实践

overmars

1、是在ftp.oracle.com/otn/beta/10上面下载，不过现在上去看没有了。

2、目前还不清楚什么参数能控制被删除的对象能在回收站呆多久。

coolbid

呵呵，好功能

忍者神龟

怎么设置才能使flashback_on 为yes
alter system set db_recovery_file_dest='d:\oracle\recover' scope=both;
alter system set db_recovery_file_dest='d:\oracle\recover' scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST


alter database flashback on
ora-38709 recovery area is not enabled ?

Fenng

最初由 prada_gu 发布
[B]一个表可以在回收站中保留多长时间,由retain的参数值来决定吗? [/B]

空间不够的时候就不能保留

xzh2000

SQL> alter table RB$$8074$TABLE$0 rename to emp2;

Table altered.

----------------------
如果我直接:
SQL>rename RB$$8074$TABLE$0 to emp2
是不是效果是一样的？

Fenng

最初由 xzh2000 发布
[B]SQL> alter table RB$$8074$TABLE$0 rename to emp2;

Table altered.

----------------------
如果我直接:
SQL>rename RB$$8074$TABLE$0 to emp2
是不是效果是一样的？ [/B]

你这个是已经Undrop的表。

如果是Drop掉的表，你那么操作是不允许的

Fenng

http://www.dbanotes.net/Oracle/Oracle-10G-RecycleBin.htm

在这里偶作了一点演示

忍者神龟

Oracle10i Database Administrator’s Guide Release 1 (10.1) - BETA
Part No. B10739-01
刚才搜索了半天，一直没有找到，包括otn,metalink等，
这个谁能发一份给我，万分感谢！

shengui@itpub.net
or
solaris8@tom.com.cn

starhqking

我也想要.cc一份给我可好。
hqinside@yahoo.com

顺便发个刚找到的简单的10g新特性：

[B]Automated Storage Management (ASM)[/B]
There is no need for a logical volume manager or file system when using 10g. This feature allows the SA to publish a list of raw devices and Oracle will completely manage the storage on them. Oracle will stripe and mirror across the disks. As space requirements increase, the DBA can bring in new disks in to the group and Oracle will rebalance the database across those disks. If we have over allocated, then Oracle can remove disks from the group and rebalance the I/O across the remaining disk.

[B]Native cluster manager[/B]
Oracle has licensed the Compaq/DEC Tru64 cluster manager software. The cluster manager is now part of the Oracle code. There is no need to purchase Veritas Clustering software, Sun Cluster, or other vendors add on cluster software when using RAC. RAC will now work the same on Sun, HP, Windows and other platforms.

[B]Improved backups[/B]
Oracle allows the DBA to define a backup destination and the database will manage disk backups to this directory. The DBA will take one and only one full backup. As incremental backups are taken, the changed blocks will overlay the full backup. Therefore, when a restore is required, the updated full backup will eliminate the need of applying multiple incremental backups. The database will also allow the definition of a retention window, which I would assume would mean that we could do point in time recovery with in the window. Also, the incremental backups will be faster than current incremental backups. Oracle has a bit map which tracks all blocks that have been changed since the last incremental backup. So a backup of a 2 TB data warehouse that has only had 1 GB of changes would only have to read the 1 GB of changed blocks and not scan the entire 1 TB like it does prior to 10g.

[B]htmlDB[/B]
Available now a http://marvel.oracle.com
This is part of the base database. Allows for rapid application development without the need to know SQL. It is marketed as a replacement for MS Access for end users to develop their own applications. It is a point and click html based development environment. In one demo, they created a table by cutting and pasting a block from excel where the first row had the column named and the other rows had the data.

[B]OEM[/B]
Enterprise manager will be html based and part of the base database, there is still a management server available. They showed managing a database from a PocketPC using Internet explorer. Events are triggered from the database and not polled from the management server. The database tracks patches and software configurations. The OEM main page will show any critical patches from metalink that have not been installed. A report can be run to show any changes to the database from a previous time. Reports can be run to show differences between dev, test, and prod. Both software installs and configuration parameters. The database has a repository of statistics. V$ stats are stored and trend reports can be run. Statspack is automated. The database will automatically run analysis on the statistics and make recommendations based on the stats.

[B]Sysaux tablespace[/B]
There is now a minimum of two tablespaces for all databases. Sysaux is new required tablespace. All non-sys owned objects will go in sysaux. ie. outln, ordsys, mdsys, etc.

[B]Flashback[/B]
You can now undo a dropped table. There is a recycle bin in the database now. When a table is dropped, it is renamed to an internal object name. The drop can now be undone. This will restore the table, constraints, triggers, and grants. Flashback database, the database can be rolled back to a point in time. Basically it uses the redologs to undo the committed changes. If developers need to repeat a test on the same set of data, then just flashback the database to a point in time prior to the test starting.

[B]transportable tablespaces[/B]
You can now transport a tablespace across platforms. You can unplug a Sun tablepace and plug it into a windows database. Using Oracle streams you can even apply the changes that take place in the tablespace while it is being transported.[B]Automated Storage Management (ASM)[/B]

lywei123

这个回收站能直接清空么？