Schema Backup Q
Hello Rob-
–a couple housekeeping chores before launching rman backup scripts…
–change location of DATAFILE to %ORACLE_HOME%\ORADATA
– Create tablepsace to hold repository
CREATE TABLESPACE “RMAN”
DATAFILE ‘C:\ORACLE\ORADATA\W2K1\RMAN01.DBF’ SIZE 6208K REUSE
AUTOEXTEND ON NEXT 64K MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
– Create rman schema owner
CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman;
GRANT connect, resource, recovery_catalog_owner TO rman;
now you can login as RMAN user and have access to rman tablespace
Norm/Roger did i miss anything?
Martin
…standard caveats apply…
Just a note – you do not have to create an rman repository to use rman
– it will work (with less features/capabilities) without – it works
off the control files then …