Topic: Backup & Recovery >> RMAN Configuration Steps
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: RMAN Configuration Steps |
| uadmin |
Posted: Feb 22, 2003 09:50:00 AM |
Total Post: 6
Joined: Jan, 2003
|
Hi Everybody,
Can you please send me some quick steps for RMAN configuration?
Thanks,
Rob
|
|
|
 saurav |
| Posted: Feb 22, 2003 11:03:00 AM |  |
|
Total Post: 13
Joined: Jan, 2003
|
Hi Rob,
Here are the steps for RMAN configuration. I am assuming you have a separate instance for RMAN catalog. It is safe and more efficient to have it.
You can also find these steps in DBAPOOL tips section under Archives 2001, Month Sep.
--------------------------------Start------------------------------
Tip of the month Sep, 2001
How to take Backup using RMAN
RMAN is an Oracle tool for taking the backup and recovering the databases. You can copy, restore, and recover datafiles, control files and archived redo logs. It has command line utility as well as GUI-based Enterprise Manager Backup. Here we are discussing the command line utility.
For example, we have TEST and PROD databases. Here TEST is the catalog database and PROD is the target database for which the backup has to be taken. You may loose your backup if you have your catalog and target databases on the same box and the box crashes .So it is always advisable to keep a separate database for RMAN catalog .
Create two databases. One for RMAN catalog(Test) and one target(PROD). Both the Databases should be archive log mode.
In catalog database (test)
create a tablespace 'CATALOG'
create a user rman/rman and give the connect , resource, recovery_catalog_owner
Also give unlimited quota on CATALOG tablespace.
Create recovery catalog
c:\rman catalog rman/rman@test log = create_rmanlog.log
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06008: connected to recovery catalog database
RMAN-06428: recovery catalog is not installed
RMAN>
RMAN> create catalog tablespace 'RCVCAT';
RMAN> create catalog tablespace 'CATALOG';
RMAN-06431: recovery catalog created
RMAN>
Register the database.
c:\>rman catalog rman/rman@test target internal/oracle@prod
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06005: connected to target database: PROD (DBID=4145212838)
RMAN-06008: connected to recovery catalog database
RMAN> register database;
RMAN-03022: compiling command: register
RMAN-03023: executing command: register
RMAN-08006: database registered in recovery catalog
RMAN-03023: executing command: full resync
RMAN-08002: starting full resync of recovery catalog
RMAN-08004: full resync complete
Backup the datafile
RMAN> run{
Allocate channel c1 type disk;
Backup datafile ‘c:\orawin_815\oradata\prod\system01.dbf’ format ‘c:\backup\temp01.dbf’;
}
You can change the backup fine format including the destination. In this example, this backup file is created on the local drive of the system.
------------------------------End------------------------------
Hope it helps.
Regards,
Vigyan Kaushik
Oracle DBA
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 387 |
| Vinoth Kumar | 379 |
| Gopu Gopi | 350 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
