Search This Blog

Total Pageviews

Monday, 4 July 2011

Oracle RMAN Create RMAN catalog on oracle 11g

Create rman catalog




Create 11g rman catalog

create tablespace rman datafile '/opt/app/oracle/oradata/orcl/rman.dbf' size 50m;

create user rman identified by rman DEFAULT TABLESPACE rman QUOTA UNLIMITED ON rman;


SQL> create tablespace rman datafile '/opt/app/oracle/oradata/orcl/rman.dbf' size 50m;

Tablespace created.


SQL> create user rman identified by rman DEFAULT TABLESPACE rman QUOTA UNLIMITED ON rman;

User created.



SQL> GRANT RECOVERY_CATALOG_OWNER TO rman ;

Grant succeeded.


on same server

oracle@apt-amd-02:~> rman catalog rman/rman

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jul 4 12:09:51 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to recovery catalog database



RMAN> CREATE CATALOG;

recovery catalog created


or


oracle@apt-amd-02:/opt/app/oracle/product/11.2/network/admin> rman catalog rman/rman@anuj

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jul 4 12:23:02 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to recovery catalog database

RMAN>




Recovery Manager complete.
oracle@apt-amd-02:/opt/app/oracle/product/11.2/network/admin> rman target / catalog rman/rman@anuj

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jul 4 12:25:16 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1267852645)
connected to recovery catalog database




RMAN> REGISTER DATABASE;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/home/oracle/RMAN/%U';

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/home/oracle/RMAN/%U';
new RMAN configuration parameters are successfully stored


RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN> backup database plus archivelog;

RMAN> backup database plus archivelog DELETE ALL INPUT;

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 4;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored


RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 4
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=53 device type=DISK
no obsolete backups found

No comments:

Oracle DBA

anuj blog Archive