Вы здесь

Activities calendar

12 декабря 2013

Все что есть у пользователя

Select * from DBA_users u where U.USERNAME = :OneObjectName order by username

Холодный бекап

BACKUP_DIR=C:\ORA_BACKUP\NOVADWH
RMAN_FILE=D:\oracle\rman\cold_backup.rman
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Dec 12 06:30:00 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: NOVADWH (DBID=2113033022)
using target database control file instead of recovery catalog
RMAN> # Cold Backup NOVADWH
2> shutdown immediate;
3> startup nomount;
4> sql 'alter database mount';
5> allocate channel for maintenance type disk;
6> crosscheck backup;